DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1444: FROM mtl_item_locations_kfv ml

1440: END IF;
1441:
1442: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')
1443: INTO x_locator
1444: FROM mtl_item_locations_kfv ml
1445: WHERE ml.inventory_location_id = x_locator_record.locator_id
1446: AND ( ml.disable_date > SYSDATE
1447: OR ml.disable_date IS NULL)
1448: AND NVL(ml.subinventory_code, 'z') = NVL(x_locator_record.subinventory, 'z')

Line 1461: FROM mtl_item_locations_kfv ml

1457: END IF;
1458:
1459: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')
1460: INTO x_locator
1461: FROM mtl_item_locations_kfv ml
1462: WHERE ml.inventory_location_id = x_locator_record.locator_id
1463: AND ( ml.disable_date > SYSDATE
1464: OR ml.disable_date IS NULL)
1465: AND NVL(ml.subinventory_code, 'z') = NVL(x_locator_record.subinventory, 'z')