DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on MTL_SECONDARY_LOCATORS

Line 1876: -- mtl_secondary_locators if the item is

1872: -- ' item locator is ' ||
1873: -- to_char(l_item_locator_control));
1874:
1875: -- If restrict locators is Y then check in
1876: -- mtl_secondary_locators if the item is
1877: -- assigned to the subinventory/location
1878: -- combination If restrict locators is N then
1879: -- check that the locator exists
1880: -- and is assigned to the subinventory and this

Line 1891: mtl_secondary_locators msl

1887: --** Check for restrict Locators YES**
1888: SELECT 'Valid'
1889: INTO l_dummy
1890: FROM mtl_item_locations mil,
1891: mtl_secondary_locators msl
1892: WHERE msl.inventory_item_id =
1893: g_rev_comp_Unexp_rec.component_item_id
1894: AND msl.organization_id =
1895: g_rev_comp_Unexp_rec.organization_id