DBA Data[Home] [Help]

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on MTL_ITEM_LOCATIONS

Line 2447: , mtl_item_locations mil

2443: -- Modified to call common API
2444: /* SELECT 'Y' INTO l_found
2445: FROM
2446: mtl_secondary_locators msl
2447: , mtl_item_locations mil
2448: WHERE msl.inventory_item_id = p_inventory_item_id
2449: AND msl.organization_id = p_organization_id
2450: AND msl.subinventory_code = p_subinventory_code
2451: AND msl.secondary_locator = p_locator_id

Line 2481: FROM mtl_item_locations

2477: (p_item_cache_index)
2478: .restrict_locators_code = 2 THEN
2479: /* BEGIN
2480: SELECT 'Y' INTO l_found
2481: FROM mtl_item_locations
2482: WHERE organization_id = p_organization_id
2483: AND subinventory_code = p_subinventory_code
2484: AND inventory_location_id = p_locator_id
2485: AND (disable_date > sysdate