APPS.RCV_ROI_TRANSACTION dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2530: FROM mtl_item_locations_kfv ml

2526: END IF;
2527:
2528: SELECT MAX(ml.inventory_location_id)
2529: INTO x_cascaded_table(n).from_locator_id
2530: FROM mtl_item_locations_kfv ml
2531: WHERE ml.concatenated_segments = x_cascaded_table(n).from_locator
2532: AND ( ml.disable_date > SYSDATE
2533: OR ml.disable_date IS NULL)
2534: AND NVL(ml.subinventory_code, 'z') = NVL(x_cascaded_table(n).from_subinventory, 'z')

Line 2564: FROM mtl_item_locations_kfv ml

2560: END IF;
2561:
2562: SELECT MAX(ml.inventory_location_id)
2563: INTO x_cascaded_table(n).locator_id
2564: FROM mtl_item_locations_kfv ml
2565: WHERE ml.concatenated_segments = x_cascaded_table(n).LOCATOR
2566: AND ( ml.disable_date > SYSDATE
2567: OR ml.disable_date IS NULL)
2568: AND NVL(ml.subinventory_code, 'z') = NVL(x_cascaded_table(n).subinventory, 'z')