DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 397: FROM rcv_transactions_interface rti

393: AND milk.organization_id = mil.organization_id
394: AND milk.subinventory_code = wlpn.subinventory_code
395: AND nvl(milk.inventory_location_type, 3) NOT IN (g_loc_type_dock_door)
396: AND NOT EXISTS (SELECT 1
397: FROM rcv_transactions_interface rti
398: WHERE rti.transfer_lpn_id = wlpn.lpn_id
399: AND rti.to_organization_id = wlpn.organization_id
400: AND rti.transaction_status_code <> 'ERROR') -- BUG#11769042(Concurrency Issue)
401: ORDER BY nvl(milk.inventory_location_type, 3), mil.picking_order;