APPS.GMD_SPEC_VRS_GRP dependencies on MTL_ITEM_LOCATIONS

Line 323: FROM mtl_item_locations

319: AND organization_id = l_mon_vr.locator_organization_id;
320:
321: CURSOR c_locator IS
322: SELECT 1
323: FROM mtl_item_locations
324: WHERE organization_id = l_mon_vr.locator_organization_id
325: AND inventory_location_id = l_mon_vr.locator_id;
326:
327: cursor c_resources is

Line 484: -- Check that Location exist in MTL_ITEM_LOCATIONS

480: THEN
481: -- Location can be NULL in this case.
482: null;
483: ELSE
484: -- Check that Location exist in MTL_ITEM_LOCATIONS
485: OPEN c_locator;
486: FETCH c_locator INTO dummy;
487: IF (c_locator%NOTFOUND)
488: THEN

Line 962: FROM mtl_item_locations

958: AND organization_id = l_inv_vr.organization_id;
959:
960: CURSOR c_locator IS
961: SELECT 1
962: FROM mtl_item_locations
963: WHERE organization_id = l_inv_vr.organization_id
964: AND inventory_location_id = l_inv_vr.locator_id;
965:
966:

Line 1091: -- Check that Location exist in MTL_ITEM_LOCATIONS

1087: THEN
1088: -- Location can be NULL in this case.
1089: null;
1090: ELSE
1091: -- Check that Location exist in MTL_ITEM_LOCATIONS
1092: OPEN c_locator;
1093: FETCH c_locator INTO dummy;
1094: IF (c_locator%NOTFOUND)
1095: THEN