APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_ITEM_LOCATIONS

Line 1473: FROM mtl_item_locations

1469: SELECT 'checking for duplicates' dummy
1470: FROM sys.dual
1471: WHERE EXISTS (
1472: SELECT null
1473: FROM mtl_item_locations
1474: WHERE organization_id = p_organization_id
1475: AND inventory_location_id = p_locator_id
1476: AND subinventory_code <> p_subinventory
1477: );

Line 1608: -- combination is found in mtl_item_locations.

1604: -- assigned to the subinventory/location
1605: -- combination If restrict locators is N then
1606: -- check that the locator exists
1607: -- and is assigned to the subinventory and this
1608: -- combination is found in mtl_item_locations.
1609:
1610: IF l_item_loc_restricted = 1 -- Restrict Locators = YES
1611: THEN
1612: -- Check for restrict Locators YES

Line 1618: FROM mtl_item_locations mil,

1614: Error_Handler.Write_Debug ('Before Checking for restrict Locators Yes. ' );
1615: END IF;
1616: SELECT 'Valid'
1617: INTO l_dummy
1618: FROM mtl_item_locations mil,
1619: mtl_secondary_locators msl
1620: WHERE msl.inventory_item_id = p_revised_item_id
1621: AND msl.organization_id = p_organization_id
1622: AND msl.subinventory_code = p_subinventory

Line 1643: FROM mtl_item_locations mil

1639: -- Check for restrict Locators NO
1640:
1641: SELECT 'Valid'
1642: INTO l_dummy
1643: FROM mtl_item_locations mil
1644: WHERE mil.subinventory_code = p_subinventory
1645: AND mil.inventory_location_id = p_locator_id
1646: AND mil.organization_id = p_organization_id
1647: AND NVL(mil.DISABLE_DATE, SYSDATE+1) > SYSDATE;