DBA Data[Home] [Help]

APPS.GMI_OM_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 49: FROM ic_item_mst iim, mtl_system_items msi

45: err_msg VARCHAR2(100);
46:
47: CURSOR item_dtl IS
48: SELECT iim.lot_ctl, iim.dualum_ind
49: FROM ic_item_mst iim, mtl_system_items msi
50: WHERE msi.inventory_item_id = p_reference_line_rec.inventory_item_id
51: AND msi.organization_id = p_reference_line_rec.ship_from_org_id
52: AND msi.segment1 = iim.item_no;
53: