APPS.GME_POST_MIGRATION dependencies on MTL_ITEM_LOCATIONS

Line 1830: FROM ic_loct_mst i, mtl_item_locations m

1826: x_locator_id OUT NOCOPY NUMBER,
1827: x_subinventory OUT NOCOPY VARCHAR2) IS
1828: CURSOR Cur_ic_loct_mst IS
1829: SELECT i.locator_id, m.organization_id, m.subinventory_code
1830: FROM ic_loct_mst i, mtl_item_locations m
1831: WHERE i.location = p_location
1832: AND i.whse_code = p_whse_code
1833: AND m.inventory_location_id = i.locator_id;
1834: CURSOR Cur_mtl_locs IS

Line 1836: FROM mtl_item_locations m

1832: AND i.whse_code = p_whse_code
1833: AND m.inventory_location_id = i.locator_id;
1834: CURSOR Cur_mtl_locs IS
1835: SELECT m.inventory_location_id locator_id, m.organization_id, m.subinventory_code
1836: FROM mtl_item_locations m
1837: WHERE m.segment1 = p_location
1838: AND m.subinventory_code = x_subinventory;
1839: l_api_name VARCHAR2(30) := 'get_locator';
1840: BEGIN

Line 2872: FROM mtl_item_locations m

2868: WHERE i.organization_id = v_organization_id
2869: AND i.inventory_item_id = v_inventory_item_id;
2870: CURSOR Cur_new_loc(v_organization_id NUMBER, v_subinventory VARCHAR2, v_location VARCHAR2) IS
2871: SELECT m.inventory_location_id locator_id
2872: FROM mtl_item_locations m
2873: WHERE m.segment1 = v_location
2874: AND m.organization_id = v_organization_id
2875: AND m.subinventory_code = v_subinventory;
2876: CURSOR Cur_get_org_params(v_org_id NUMBER) IS