DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_SECONDARY_LOCATORS

Line 1603: -- mtl_secondary_locators if the item is

1599: RETURN FALSE;
1600: END IF;
1601:
1602: -- If restrict locators is Y then check in
1603: -- mtl_secondary_locators if the item is
1604: -- assigned to the subinventory/location
1605: -- combination If restrict locators is N then
1606: -- check that the locator exists
1607: -- and is assigned to the subinventory and this

Line 1619: mtl_secondary_locators msl

1615: END IF;
1616: SELECT 'Valid'
1617: INTO l_dummy
1618: FROM mtl_item_locations mil,
1619: mtl_secondary_locators msl
1620: WHERE msl.inventory_item_id = p_revised_item_id
1621: AND msl.organization_id = p_organization_id
1622: AND msl.subinventory_code = p_subinventory
1623: AND msl.secondary_locator = p_locator_id