APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_ITEM_LOCATIONS

Line 1538: FROM mtl_item_locations

1534: SELECT 'checking for duplicates' dummy
1535: FROM sys.dual
1536: WHERE EXISTS (
1537: SELECT null
1538: FROM mtl_item_locations
1539: WHERE organization_id = p_organization_id
1540: AND inventory_location_id = p_locator_id
1541: AND subinventory_code <> p_subinventory
1542: );

Line 1676: -- combination is found in mtl_item_locations.

1672: -- assigned to the subinventory/location
1673: -- combination If restrict locators is N then
1674: -- check that the locator exists
1675: -- and is assigned to the subinventory and this
1676: -- combination is found in mtl_item_locations.
1677:
1678: IF l_item_loc_restricted = 1 -- Restrict Locators = YES
1679: THEN
1680: -- Check for restrict Locators YES

Line 1686: FROM mtl_item_locations mil,

1682: Error_Handler.Write_Debug ('Before Checking for restrict Locators Yes. ' );
1683: END IF;
1684: SELECT 'Valid'
1685: INTO l_dummy
1686: FROM mtl_item_locations mil,
1687: mtl_secondary_locators msl
1688: WHERE msl.inventory_item_id = p_revised_item_id
1689: AND msl.organization_id = p_organization_id
1690: AND msl.subinventory_code = p_subinventory

Line 1711: FROM mtl_item_locations mil

1707: -- Check for restrict Locators NO
1708:
1709: SELECT 'Valid'
1710: INTO l_dummy
1711: FROM mtl_item_locations mil
1712: WHERE mil.subinventory_code = p_subinventory
1713: AND mil.inventory_location_id = p_locator_id
1714: AND mil.organization_id = p_organization_id
1715: AND NVL(mil.DISABLE_DATE, SYSDATE+1) > SYSDATE;