DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_HEADER dependencies on MTL_SECONDARY_LOCATORS

Line 1117: -- mtl_secondary_locators if the item is

1113: l_locator_control := 4;
1114: RETURN FALSE;
1115: END IF;
1116: -- If restrict locators is Y then check in
1117: -- mtl_secondary_locators if the item is
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

Line 1133: mtl_secondary_locators msl

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
1137: AND msl.secondary_locator = p_locator_id