APPS.WMS_LPN_LOVS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 2858: FROM rcv_transactions_interface rti

2854: SELECT asn_lpn_id
2855: FROM rcv_shipment_lines rsl
2856: WHERE rsl.shipment_header_id = p_shipment_header_id
2857: AND NOT exists (SELECT 1
2858: FROM rcv_transactions_interface rti
2859: WHERE rti.lpn_id = rsl.asn_lpn_id
2860: AND rti.transfer_lpn_id = rsl.asn_lpn_id
2861: AND rti.to_organization_id = rsl.to_organization_id
2862: AND rti.processing_status_code <> 'ERROR'