APPS.WMS_LPN_LOVS dependencies on RCV_SHIPMENT_LINES

Line 2856: FROM rcv_shipment_lines rsl

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