Answer / venkat kolla

we can link using inventory_item_id , ship_from_org_id from
oe_order_ines_all table to mtl_system_items_b table.

We can using move_order_line_id from wsh_new_deliveries
table mtl_material_transactions or
mtl_material_transactions_temp tables.

there are some more..

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers   Tech Mahindra,

---

what is lexical parameter?

3 Answers   TCS,

---

in procedure how to return a value

2 Answers   Wipro,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,

---

How to print multi currency,multi language in xml?

1 Answers  

---

what is organization id

3 Answers  

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,

---

How can a process be deployed in soa?

0 Answers  

---