APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on MTL_ITEM_LOCATIONS

Line 1736: FROM mtl_item_locations

1732: SELECT 'checking for duplicates' dummy
1733: FROM sys.dual
1734: WHERE EXISTS (
1735: SELECT null
1736: FROM mtl_item_locations
1737: WHERE organization_id =
1738: g_rev_comp_Unexp_rec.organization_id
1739: AND inventory_location_id =
1740: g_rev_comp_Unexp_rec.supply_locator_id

Line 1873: -- combination is found in mtl_item_locations.

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
1873: -- combination is found in mtl_item_locations.
1874:
1875: IF l_item_loc_restricted = 1
1876: -- Restrict Locators = YES
1877: THEN

Line 1882: FROM mtl_item_locations mil,

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

Line 1909: FROM mtl_item_locations mil

1905: -- ('Item restrict locators is NO . . .');
1906:
1907: SELECT 'Valid'
1908: INTO l_dummy
1909: FROM mtl_item_locations mil
1910: WHERE mil.subinventory_code =
1911: g_rev_component_rec.supply_subinventory
1912: AND mil.inventory_location_id =
1913: g_rev_comp_Unexp_rec.supply_locator_id