How to link between inventory and OrderManagement.

Answer Posted / 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..

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2584


Plz anybody send me Technical specification for AP Interface

2148


Can we create tables in apps schema?

722


In hierarchical structure of a database? we have write query from where we should start?

1795


tell my any difficult situtation you solved in your experience in your company?

1960






What is oracle soa suite and what are its different components?

742


Tell me how to find the custom directory in front end?

742


where to define interorganization transaction charges and what are the different options?

2040


What is count(*) from po_vendors(any table)?

730


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1859


what are the different transaction clauses in AR?

1694


What is oracle soa suite?

861


What do you understand by soa and what are the benefits of using this architecture?

707


Can you differentiate between mediator and osb?

730


What is a value set? List its various types.

736