DBA Data[Home] [Help]

APPS.INV_MGD_MVT_SO_MDTR dependencies on MTL_SYSTEM_ITEMS

Line 451: , MTL_SYSTEM_ITEMS si

447: , wsh_new_deliveries_ob_grp_v wnd
448: , wsh_delivery_assignments_v wda
449: , HZ_PARTIES rac
450: , HZ_CUST_ACCOUNTS hzc
451: , MTL_SYSTEM_ITEMS si
452: WHERE wnd.delivery_id = wda.delivery_id
453: AND wda.delivery_detail_id = wdd.delivery_detail_id
454: AND ooha.header_id = oola.header_id
455: AND oola.line_id = wdd.source_line_id

Line 749: , mtl_system_items msi

745: , msi.description
746: , msi.primary_uom_code
747: FROM
748: oe_order_lines_all oola
749: , mtl_system_items msi
750: WHERE oola.inventory_item_id = msi.inventory_item_id
751: AND oola.ship_from_org_id = msi.organization_id
752: AND line_id = p_link_to_line_id;
753: BEGIN