DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on MTL_SECONDARY_LOCATORS

Line 1868: -- mtl_secondary_locators if the item is

1864: -- ' item locator is ' ||
1865: -- to_char(l_item_locator_control));
1866:
1867: -- If restrict locators is Y then check in
1868: -- mtl_secondary_locators if the item is
1869: -- assigned to the subinventory/location
1870: -- combination If restrict locators is N then
1871: -- check that the locator exists
1872: -- and is assigned to the subinventory and this

Line 1883: mtl_secondary_locators msl

1879: --** Check for restrict Locators YES**
1880: SELECT 'Valid'
1881: INTO l_dummy
1882: FROM mtl_item_locations mil,
1883: mtl_secondary_locators msl
1884: WHERE msl.inventory_item_id =
1885: g_rev_comp_Unexp_rec.component_item_id
1886: AND msl.organization_id =
1887: g_rev_comp_Unexp_rec.organization_id