DBA Data[Home] [Help]

APPS.INV_MGD_MVT_SO_MDTR dependencies on MTL_SYSTEM_ITEMS

Line 441: , MTL_SYSTEM_ITEMS si

437: , wsh_new_deliveries_ob_grp_v wnd
438: , wsh_delivery_assignments_v wda
439: , HZ_PARTIES rac
440: , HZ_CUST_ACCOUNTS hzc
441: , MTL_SYSTEM_ITEMS si
442: WHERE wnd.delivery_id = wda.delivery_id
443: AND wda.delivery_detail_id = wdd.delivery_detail_id
444: AND ooha.header_id = oola.header_id
445: AND oola.line_id = wdd.source_line_id

Line 710: , mtl_system_items msi

706: , msi.description
707: , msi.primary_uom_code
708: FROM
709: oe_order_lines_all oola
710: , mtl_system_items msi
711: WHERE oola.inventory_item_id = msi.inventory_item_id
712: AND oola.ship_from_org_id = msi.organization_id
713: AND line_id = p_link_to_line_id;
714: BEGIN