APPS.ENG_VALIDATE_REV_COMPONENT dependencies on MTL_SECONDARY_LOCATORS

Line 1122: -- If restrict locators is Y then check in mtl_secondary_locators

1118:
1119: --dbms_output.put_line('Checking when x_control returned 2 and item locator is '
1120: -- || to_char(l_item_locator_control));
1121:
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.

Line 1135: mtl_secondary_locators msl

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 =
1139: g_rev_comp_Unexp_rec.organization_id