DBA Data[Home] [Help]

APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on MTL_SYSTEM_ITEMS

Line 152: FROM mtl_system_items m, ic_item_mst ic -- 5475003 rework

148: AND (lot_id >0 OR location <> l_IC$DEFAULT_LOCT);
149:
150: CURSOR get_item_details(p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
151: SELECT m.lot_divisible_flag,m.lot_control_code,m.tracking_quantity_ind, ic.NONINV_IND -- 5475003 rework
152: FROM mtl_system_items m, ic_item_mst ic -- 5475003 rework
153: WHERE inventory_item_id = p_item_id and organization_id = p_organization_id
154: AND m.segment1 = ic.item_no; -- 5475003 rework
155:
156: CURSOR get_whse_details(p_whse_code IN VARCHAR2) IS