APPS.WMS_LPN_LOVS dependencies on RCV_SHIPMENT_LINES

Line 2855: FROM rcv_shipment_lines rsl

2851: START WITH wlpn2.lpn_id = wlpn1.lpn_id
2852: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
2853: INTERSECT
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