APPS.INV_GMI_MIGRATION dependencies on IC_LOCT_MST

Line 1830: FROM ic_loct_mst

1826: END IF;
1827: IF (adetail.location <> G_DEFAULT_LOCT) THEN
1828: BEGIN
1829: SELECT locator_id INTO l_locator_id
1830: FROM ic_loct_mst
1831: WHERE
1832: whse_code = adetail.whse_code AND
1833: location = adetail.location;
1834:

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 (+);