APPS.GMD_SAMPLES_PUB dependencies on MTL_ITEM_LOCATIONS

Line 1734: FROM mtl_item_locations

1730:
1731: -- Bug 4165704: changed for inventory convergence
1732: CURSOR c_subinventory_loct IS
1733: SELECT 1
1734: FROM mtl_item_locations
1735: WHERE organization_id = p_sample_rec.organization_id
1736: AND inventory_location_id = p_sample_rec.locator_id
1737: AND subinventory_code = p_sample_rec.subinventory;
1738: --FROM ic_loct_mst

Line 1767: -- Check that Location exist in MTL_ITEM_LOCATIONS

1763: RAISE FND_API.G_EXC_ERROR;
1764: END IF;
1765: ELSIF (l_locator_control > 1 ) THEN -- Item is location controlled.
1766: IF (p_sample_rec.locator_id IS NOT NULL) THEN
1767: -- Check that Location exist in MTL_ITEM_LOCATIONS
1768: OPEN c_subinventory_loct;
1769: FETCH c_subinventory_loct INTO l_dummy;
1770: IF (c_subinventory_loct%NOTFOUND) THEN
1771: -- CLOSE c_subinventory_loct;

Line 2634: FROM mtl_item_locations

2630:
2631: -- Bug 4165704: changed for inventory convergence
2632: CURSOR c_subinventory_loct IS
2633: SELECT 1
2634: FROM mtl_item_locations
2635: WHERE organization_id = p_sample_rec.organization_id
2636: AND inventory_location_id = p_sample_rec.locator_id
2637: AND subinventory_code = p_sample_rec.subinventory;
2638: --FROM ic_loct_mst

Line 2707: -- Check that Location exist in MTL_ITEM_LOCATIONS

2703: -- Location cannot be NULL in this case.
2704: GMD_API_PUB.Log_Message('GMD_LOCATION_MUST_NULL');
2705: RAISE FND_API.G_EXC_ERROR;
2706: ELSE
2707: -- Check that Location exist in MTL_ITEM_LOCATIONS
2708: OPEN c_subinventory_loct;
2709: FETCH c_subinventory_loct INTO l_dummy;
2710: IF (c_subinventory_loct%NOTFOUND) THEN
2711: --CLOSE c_subinventory_loct;

Line 2811: FROM mtl_item_locations

2807:
2808: -- Bug 4165704: Updated for inventory convergence
2809: CURSOR c_subinventory_locator IS
2810: SELECT 1
2811: FROM mtl_item_locations
2812: WHERE subinventory_code = p_sample_rec.subinventory
2813: AND organization_id = p_sample_rec.organization_id
2814: AND inventory_location_id = p_sample_rec.locator_id;
2815:

Line 2844: FROM mtl_item_locations

2840:
2841: -- 5283854 rework
2842: CURSOR c_storage_subinventory_locator IS
2843: SELECT 1
2844: FROM mtl_item_locations
2845: WHERE subinventory_code = p_sample_rec.storage_subinventory
2846: AND organization_id = p_sample_rec.storage_organization_id
2847: AND inventory_location_id = p_sample_rec.storage_locator_id;
2848: