APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1436: FROM mtl_item_locations_kfv ml

1432: END IF;
1433:
1434: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')
1435: INTO x_locator
1436: FROM mtl_item_locations_kfv ml
1437: WHERE ml.inventory_location_id = x_locator_record.locator_id
1438: AND ( ml.disable_date > SYSDATE
1439: OR ml.disable_date IS NULL)
1440: AND NVL(ml.subinventory_code, 'z') = NVL(x_locator_record.subinventory, 'z')

Line 1453: FROM mtl_item_locations_kfv ml

1449: END IF;
1450:
1451: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')
1452: INTO x_locator
1453: FROM mtl_item_locations_kfv ml
1454: WHERE ml.inventory_location_id = x_locator_record.locator_id
1455: AND ( ml.disable_date > SYSDATE
1456: OR ml.disable_date IS NULL)
1457: AND NVL(ml.subinventory_code, 'z') = NVL(x_locator_record.subinventory, 'z')