DBA Data[Home] [Help]

APPS.PO_GML_DB_COMMON dependencies on MTL_SYSTEM_ITEMS

Line 801: FROM ic_item_mst oi, mtl_system_items ai

797: BEGIN
798: -- lot status: bug 3278027, added l_item_sts_ctl
799: SELECT oi.item_id , oi.noninv_ind, oi.loct_ctl, oi.lot_ctl, oi.status_ctl
800: INTO l_item_id, l_non_inv, l_item_loct_ctl, l_item_lot_ctl, l_item_sts_ctl
801: FROM ic_item_mst oi, mtl_system_items ai
802: WHERE ai.organization_id = l_organization_id
803: AND ai.inventory_item_id = l_ora_item_id
804: AND ai.segment1 = oi.item_no;
805: