APPS.GMD_SAMPLES_PUB dependencies on MTL_ITEM_LOCATIONS

Line 1645: FROM mtl_item_locations

1641:
1642: -- Bug 4165704: changed for inventory convergence
1643: CURSOR c_subinventory_loct IS
1644: SELECT 1
1645: FROM mtl_item_locations
1646: WHERE organization_id = p_sample_rec.organization_id
1647: AND inventory_location_id = p_sample_rec.locator_id
1648: AND subinventory_code = p_sample_rec.subinventory;
1649: --FROM ic_loct_mst

Line 1678: -- Check that Location exist in MTL_ITEM_LOCATIONS

1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1676: ELSIF (l_locator_control > 1 ) THEN -- Item is location controlled.
1677: IF (p_sample_rec.locator_id IS NOT NULL) THEN
1678: -- Check that Location exist in MTL_ITEM_LOCATIONS
1679: OPEN c_subinventory_loct;
1680: FETCH c_subinventory_loct INTO l_dummy;
1681: IF (c_subinventory_loct%NOTFOUND) THEN
1682: -- CLOSE c_subinventory_loct;

Line 2504: FROM mtl_item_locations

2500:
2501: -- Bug 4165704: changed for inventory convergence
2502: CURSOR c_subinventory_loct IS
2503: SELECT 1
2504: FROM mtl_item_locations
2505: WHERE organization_id = p_sample_rec.organization_id
2506: AND inventory_location_id = p_sample_rec.locator_id
2507: AND subinventory_code = p_sample_rec.subinventory;
2508: --FROM ic_loct_mst

Line 2577: -- Check that Location exist in MTL_ITEM_LOCATIONS

2573: -- Location cannot be NULL in this case.
2574: GMD_API_PUB.Log_Message('GMD_LOCATION_MUST_NULL');
2575: RAISE FND_API.G_EXC_ERROR;
2576: ELSE
2577: -- Check that Location exist in MTL_ITEM_LOCATIONS
2578: OPEN c_subinventory_loct;
2579: FETCH c_subinventory_loct INTO l_dummy;
2580: IF (c_subinventory_loct%NOTFOUND) THEN
2581: --CLOSE c_subinventory_loct;

Line 2681: FROM mtl_item_locations

2677:
2678: -- Bug 4165704: Updated for inventory convergence
2679: CURSOR c_subinventory_locator IS
2680: SELECT 1
2681: FROM mtl_item_locations
2682: WHERE subinventory_code = p_sample_rec.subinventory
2683: AND organization_id = p_sample_rec.organization_id
2684: AND inventory_location_id = p_sample_rec.locator_id;
2685:

Line 2714: FROM mtl_item_locations

2710:
2711: -- 5283854 rework
2712: CURSOR c_storage_subinventory_locator IS
2713: SELECT 1
2714: FROM mtl_item_locations
2715: WHERE subinventory_code = p_sample_rec.storage_subinventory
2716: AND organization_id = p_sample_rec.storage_organization_id
2717: AND inventory_location_id = p_sample_rec.storage_locator_id;
2718: