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