DBA Data[Home] [Help]

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on MTL_ITEM_LOCATIONS

Line 2323: , mtl_item_locations mil

2319: -- Modified to call common API
2320: /* SELECT 'Y' INTO l_found
2321: FROM
2322: mtl_secondary_locators msl
2323: , mtl_item_locations mil
2324: WHERE msl.inventory_item_id = p_inventory_item_id
2325: AND msl.organization_id = p_organization_id
2326: AND msl.subinventory_code = p_subinventory_code
2327: AND msl.secondary_locator = p_locator_id

Line 2357: FROM mtl_item_locations

2353: (p_item_cache_index)
2354: .restrict_locators_code = 2 THEN
2355: /* BEGIN
2356: SELECT 'Y' INTO l_found
2357: FROM mtl_item_locations
2358: WHERE organization_id = p_organization_id
2359: AND subinventory_code = p_subinventory_code
2360: AND inventory_location_id = p_locator_id
2361: AND (disable_date > sysdate