DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2048: FROM mtl_item_locations_kfv ml

2044: END IF;
2045:
2046: SELECT MAX(ml.inventory_location_id)
2047: INTO x_cascaded_table(n).from_locator_id
2048: FROM mtl_item_locations_kfv ml
2049: WHERE ml.concatenated_segments = x_cascaded_table(n).from_locator
2050: AND ( ml.disable_date > SYSDATE
2051: OR ml.disable_date IS NULL)
2052: AND NVL(ml.subinventory_code, 'z') = NVL(x_cascaded_table(n).from_subinventory, 'z')

Line 2082: FROM mtl_item_locations_kfv ml

2078: END IF;
2079:
2080: SELECT MAX(ml.inventory_location_id)
2081: INTO x_cascaded_table(n).locator_id
2082: FROM mtl_item_locations_kfv ml
2083: WHERE ml.concatenated_segments = x_cascaded_table(n).LOCATOR
2084: AND ( ml.disable_date > SYSDATE
2085: OR ml.disable_date IS NULL)
2086: AND NVL(ml.subinventory_code, 'z') = NVL(x_cascaded_table(n).subinventory, 'z')