DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3478: FROM mtl_item_locations_kfv ml

3474:
3475: IF (x_locator_id_record.subinventory IS NULL) THEN
3476: SELECT MAX(ml.inventory_location_id)
3477: INTO x_locator_id_record.locator_id
3478: FROM mtl_item_locations_kfv ml
3479: WHERE ml.concatenated_segments = x_locator_id_record.LOCATOR
3480: AND ( ml.disable_date > SYSDATE
3481: OR ml.disable_date IS NULL)
3482: AND ml.subinventory_code IS NULL;

Line 3486: FROM mtl_item_locations_kfv ml

3482: AND ml.subinventory_code IS NULL;
3483: ELSE
3484: SELECT MAX(ml.inventory_location_id)
3485: INTO x_locator_id_record.locator_id
3486: FROM mtl_item_locations_kfv ml
3487: WHERE ml.concatenated_segments = x_locator_id_record.LOCATOR
3488: AND ( ml.disable_date > SYSDATE
3489: OR ml.disable_date IS NULL)
3490: AND ml.subinventory_code = x_locator_id_record.subinventory;