APPS.INV_GMI_MIGRATION dependencies on MTL_ITEM_LOCATIONS

Line 2318: FROM ic_loct_mst o, mtl_item_locations d

2314:
2315: -- Get the subinventory for the warehouse
2316: CURSOR c_subinventory (p_whse_code VARCHAR2) IS
2317: SELECT subinventory_code, count(*)
2318: FROM ic_loct_mst o, mtl_item_locations d
2319: WHERE o.locator_id = d.inventory_location_id AND
2320: o.whse_code = p_whse_code
2321: GROUP BY whse_code, subinventory_code
2322: ORDER by 2 desc;

Line 2667: /* Fix for Bug#9403348. inventory_location_id is not unique in mtl_item_locations. Added

2663: END IF;
2664: IF ( l_whse_loct_ctl <> 0 and bal.item_loct_ctl <> 0 and
2665: bal.location <> G_DEFAULT_LOCT) THEN
2666: BEGIN
2667: /* Fix for Bug#9403348. inventory_location_id is not unique in mtl_item_locations. Added
2668: organization_id in where clause
2669: */
2670: SELECT ol.locator_id, dl.subinventory_code
2671: INTO l_locator_id, l_subinventory_code

Line 2672: FROM ic_loct_mst ol, mtl_item_locations dl, ic_whse_mst iwm

2668: organization_id in where clause
2669: */
2670: SELECT ol.locator_id, dl.subinventory_code
2671: INTO l_locator_id, l_subinventory_code
2672: FROM ic_loct_mst ol, mtl_item_locations dl, ic_whse_mst iwm
2673: WHERE
2674: ol.whse_code = bal.whse_code AND
2675: ol.location = bal.location AND
2676: ol.whse_code = iwm.whse_code AND