DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_SECONDARY_LOCATORS

Line 1671: -- mtl_secondary_locators if the item is

1667: RETURN FALSE;
1668: END IF;
1669:
1670: -- If restrict locators is Y then check in
1671: -- mtl_secondary_locators if the item is
1672: -- assigned to the subinventory/location
1673: -- combination If restrict locators is N then
1674: -- check that the locator exists
1675: -- and is assigned to the subinventory and this

Line 1687: mtl_secondary_locators msl

1683: END IF;
1684: SELECT 'Valid'
1685: INTO l_dummy
1686: FROM mtl_item_locations mil,
1687: mtl_secondary_locators msl
1688: WHERE msl.inventory_item_id = p_revised_item_id
1689: AND msl.organization_id = p_organization_id
1690: AND msl.subinventory_code = p_subinventory
1691: AND msl.secondary_locator = p_locator_id