APPS.ENG_VALIDATE_REV_COMPONENT dependencies on MTL_ITEM_LOCATIONS

Line 1028: FROM mtl_item_locations

1024: SELECT 'checking for duplicates' dummy
1025: FROM sys.dual
1026: WHERE EXISTS (
1027: SELECT null
1028: FROM mtl_item_locations
1029: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id
1030: AND inventory_location_id = g_rev_comp_Unexp_rec.supply_locator_id
1031: AND subinventory_code <> g_rev_component_rec.supply_subinventory);
1032:

Line 1126: -- found in mtl_item_locations.

1122: -- If restrict locators is Y then check in mtl_secondary_locators
1123: -- if the item is assigned to the subinventory/location combination
1124: -- If restrict locators is N then check that the locator exists
1125: -- and is assigned to the subinventory and this combination is
1126: -- found in mtl_item_locations.
1127:
1128: IF l_item_loc_restricted = 1 -- Restrict Locators = YES
1129: THEN
1130:

Line 1134: FROM mtl_item_locations mil,

1130:
1131: -- **** Check for restrict Locators YES ****
1132: SELECT 'Valid'
1133: INTO l_dummy
1134: FROM mtl_item_locations mil,
1135: mtl_secondary_locators msl
1136: WHERE msl.inventory_item_id =
1137: g_rev_comp_Unexp_rec.component_item_id
1138: AND msl.organization_id =

Line 1156: FROM mtl_item_locations mil

1152: -- **** Check for restrict Locators NO ****
1153: --dbms_output.put_line('Item restrict locators is NO . . .');
1154: SELECT 'Valid'
1155: INTO l_dummy
1156: FROM mtl_item_locations mil
1157: WHERE mil.subinventory_code =
1158: g_rev_component_rec.supply_subinventory
1159: AND mil.inventory_location_id =
1160: g_rev_comp_Unexp_rec.supply_locator_id