APPS.GMD_SPEC_VRS_GRP dependencies on MTL_ITEM_LOCATIONS

Line 312: FROM mtl_item_locations

308: AND organization_id = l_mon_vr.locator_organization_id;
309:
310: CURSOR c_locator IS
311: SELECT 1
312: FROM mtl_item_locations
313: WHERE organization_id = l_mon_vr.locator_organization_id
314: AND inventory_location_id = l_mon_vr.locator_id;
315:
316: cursor c_resources is

Line 473: -- Check that Location exist in MTL_ITEM_LOCATIONS

469: THEN
470: -- Location can be NULL in this case.
471: null;
472: ELSE
473: -- Check that Location exist in MTL_ITEM_LOCATIONS
474: OPEN c_locator;
475: FETCH c_locator INTO dummy;
476: IF (c_locator%NOTFOUND)
477: THEN

Line 951: FROM mtl_item_locations

947: AND organization_id = l_inv_vr.organization_id;
948:
949: CURSOR c_locator IS
950: SELECT 1
951: FROM mtl_item_locations
952: WHERE organization_id = l_inv_vr.organization_id
953: AND inventory_location_id = l_inv_vr.locator_id;
954:
955:

Line 1080: -- Check that Location exist in MTL_ITEM_LOCATIONS

1076: THEN
1077: -- Location can be NULL in this case.
1078: null;
1079: ELSE
1080: -- Check that Location exist in MTL_ITEM_LOCATIONS
1081: OPEN c_locator;
1082: FETCH c_locator INTO dummy;
1083: IF (c_locator%NOTFOUND)
1084: THEN