APPS.BOM_VALIDATE_RTG_HEADER dependencies on MTL_ITEM_LOCATIONS

Line 992: FROM mtl_item_locations

988: SELECT 'checking for duplicates' dummy
989: FROM sys.dual
990: WHERE EXISTS (
991: SELECT null
992: FROM mtl_item_locations
993: WHERE organization_id = p_organization_id
994: AND inventory_location_id = p_locator_id
995: AND subinventory_code <> p_subinventory
996: );

Line 1122: -- combination is found in mtl_item_locations.

1118: -- assigned to the subinventory/location
1119: -- combination If restrict locators is N then
1120: -- check that the locator exists
1121: -- and is assigned to the subinventory and this
1122: -- combination is found in mtl_item_locations.
1123:
1124: IF l_item_loc_restricted = 1 -- Restrict Locators = YES
1125: THEN
1126: -- Check for restrict Locators YES

Line 1132: FROM mtl_item_locations mil,

1128: Error_Handler.Write_Debug ('Before Checking for restrict Locators Yes. ' );
1129: END IF;
1130: SELECT 'Valid'
1131: INTO l_dummy
1132: FROM mtl_item_locations mil,
1133: mtl_secondary_locators msl
1134: WHERE msl.inventory_item_id = p_assembly_item_id
1135: AND msl.organization_id = p_organization_id
1136: AND msl.subinventory_code = p_subinventory

Line 1157: FROM mtl_item_locations mil

1153: -- Check for restrict Locators NO
1154:
1155: SELECT 'Valid'
1156: INTO l_dummy
1157: FROM mtl_item_locations mil
1158: WHERE mil.subinventory_code = p_subinventory
1159: AND mil.inventory_location_id = p_locator_id
1160: AND mil.organization_id = p_organization_id
1161: AND NVL(mil.DISABLE_DATE, SYSDATE+1) > SYSDATE;