APPS.INV_GMI_MIGRATION dependencies on MTL_ITEM_LOCATIONS

Line 2204: FROM ic_loct_mst o, mtl_item_locations d

2200:
2201: -- Get the subinventory for the warehouse
2202: CURSOR c_subinventory (p_whse_code VARCHAR2) IS
2203: SELECT subinventory_code, count(*)
2204: FROM ic_loct_mst o, mtl_item_locations d
2205: WHERE o.locator_id = d.inventory_location_id AND
2206: o.whse_code = p_whse_code
2207: GROUP BY whse_code, subinventory_code
2208: ORDER by 2 desc;

Line 2554: FROM ic_loct_mst ol, mtl_item_locations dl

2550: bal.location <> G_DEFAULT_LOCT) THEN
2551: BEGIN
2552: SELECT ol.locator_id, dl.subinventory_code
2553: INTO l_locator_id, l_subinventory_code
2554: FROM ic_loct_mst ol, mtl_item_locations dl
2555: WHERE
2556: ol.whse_code = bal.whse_code AND
2557: ol.location = bal.location AND
2558: ol.locator_id = dl.inventory_location_id (+);