APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on MTL_ITEM_LOCATIONS

Line 1744: FROM mtl_item_locations

1740: SELECT 'checking for duplicates' dummy
1741: FROM sys.dual
1742: WHERE EXISTS (
1743: SELECT null
1744: FROM mtl_item_locations
1745: WHERE organization_id =
1746: g_rev_comp_Unexp_rec.organization_id
1747: AND inventory_location_id =
1748: g_rev_comp_Unexp_rec.supply_locator_id

Line 1881: -- combination is found in mtl_item_locations.

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
1881: -- combination is found in mtl_item_locations.
1882:
1883: IF l_item_loc_restricted = 1
1884: -- Restrict Locators = YES
1885: THEN

Line 1890: FROM mtl_item_locations mil,

1886:
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 =

Line 1917: FROM mtl_item_locations mil

1913: -- ('Item restrict locators is NO . . .');
1914:
1915: SELECT 'Valid'
1916: INTO l_dummy
1917: FROM mtl_item_locations mil
1918: WHERE mil.subinventory_code =
1919: g_rev_component_rec.supply_subinventory
1920: AND mil.inventory_location_id =
1921: g_rev_comp_Unexp_rec.supply_locator_id