77: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
78: FROM rcv_shipment_lines rsl
79: , rcv_shipment_headers rsh
80: , po_line_locations poll
81: , po_distributions pod
82: , (SELECT DISTINCT source_line_id
83: FROM wms_lpn_contents
84: WHERE parent_lpn_id = v_lpn_id) wlc
85: WHERE rsl.shipment_header_id = rsh.shipment_header_id
123: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
124: FROM rcv_shipment_lines rsl
125: , rcv_shipment_headers rsh
126: , po_line_locations poll
127: , po_distributions pod
128: WHERE rsl.shipment_header_id = rsh.shipment_header_id
129: AND rsl.shipment_header_id = v_shipment_header_id
130: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
131: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
177: ( SELECT 1
178: FROM rcv_shipment_lines rsl
179: , rcv_shipment_headers rsh
180: , po_line_locations poll
181: , po_distributions pod
182: , (SELECT DISTINCT source_line_id
183: FROM wms_lpn_contents
184: WHERE parent_lpn_id = v_lpn_id) wlc
185: WHERE rsl.shipment_header_id = rsh.shipment_header_id
212: SELECT 1
213: FROM rcv_shipment_lines rsl
214: , rcv_shipment_headers rsh
215: , po_line_locations poll
216: , po_distributions pod
217: WHERE rsl.shipment_header_id = rsh.shipment_header_id
218: AND rsl.shipment_header_id = v_shipment_header_id
219: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
220: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
332: -- bug 2752051
333: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
334: AND exists
335: ( select '1'
336: from po_distributions_all pod
337: where pod.line_location_id = poll.line_location_id
338: and (v_project_id is null or
339: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
340: pod.project_id = v_project_id
402: )
403: )
404: AND exists
405: ( select '1'
406: from po_distributions_all pod
407: where pod.line_location_id = poll.line_location_id
408: and (v_project_id is null or
409: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
410: pod.project_id = v_project_id
461: -- bug 2752051
462: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
463: AND exists
464: ( select '1'
465: from po_distributions_all pod
466: where pod.line_location_id = poll.line_location_id
467: and (v_project_id is null or
468: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
469: pod.project_id = v_project_id
517: )
518: )
519: AND exists
520: ( select '1'
521: from po_distributions_all pod
522: where pod.line_location_id = poll.line_location_id
523: and (v_project_id is null or
524: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
525: pod.project_id = v_project_id
557: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
558: FROM rcv_shipment_lines rsl
559: , rcv_shipment_headers rsh
560: , po_line_locations poll
561: , po_distributions pod
562: , (SELECT DISTINCT source_line_id
563: FROM wms_lpn_contents
564: WHERE parent_lpn_id = v_lpn_id) wlc
565: WHERE rsl.shipment_header_id = rsh.shipment_header_id
603: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
604: FROM rcv_shipment_lines rsl
605: , rcv_shipment_headers rsh
606: , po_line_locations poll
607: , po_distributions pod
608: WHERE rsl.shipment_header_id = rsh.shipment_header_id
609: AND rsl.shipment_header_id = v_shipment_header_id
610: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
611: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
648: ( SELECT 1
649: FROM rcv_shipment_lines rsl
650: , rcv_shipment_headers rsh
651: , po_line_locations poll
652: , po_distributions pod
653: , (SELECT DISTINCT source_line_id
654: FROM wms_lpn_contents
655: WHERE parent_lpn_id = v_lpn_id) wlc
656: WHERE rsl.shipment_header_id = rsh.shipment_header_id
683: SELECT 1
684: FROM rcv_shipment_lines rsl
685: , rcv_shipment_headers rsh
686: , po_line_locations poll
687: , po_distributions pod
688: WHERE rsl.shipment_header_id = rsh.shipment_header_id
689: AND rsl.shipment_header_id = v_shipment_header_id
690: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
691: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
763: -- bug 2752051
764: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
765: AND exists
766: ( select '1'
767: from po_distributions_all pod
768: where pod.line_location_id = poll.line_location_id
769: and (v_project_id is null or
770: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
771: pod.project_id = v_project_id
810: -- bug 2752051
811: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
812: AND exists
813: ( select '1'
814: from po_distributions_all pod
815: where pod.line_location_id = poll.line_location_id
816: and (v_project_id is null or
817: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
818: pod.project_id = v_project_id
865: -- bug 2752051
866: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
867: AND exists
868: ( select '1'
869: from po_distributions_all pod
870: where pod.line_location_id = poll.line_location_id
871: and (v_project_id is null or
872: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
873: pod.project_id = v_project_id
900: -- bug 2752051
901: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
902: AND exists
903: ( select '1'
904: from po_distributions_all pod
905: where pod.line_location_id = poll.line_location_id
906: and (v_project_id is null or
907: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
908: pod.project_id = v_project_id
1595: , rcv_transactions rt
1596: , rcv_shipment_headers rsh
1597: , rcv_shipment_lines rsl
1598: , po_line_locations poll
1599: , po_distributions pod
1600: WHERE rsl.shipment_header_id = v_shipment_header_id
1601: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1602: AND rsup.item_id = v_item_id
1603: AND rsup.po_header_id = pod.po_header_id
1676: , rcv_transactions rt
1677: , rcv_shipment_headers rsh
1678: , rcv_shipment_lines rsl
1679: , po_line_locations poll
1680: , po_distributions pod
1681: WHERE rsl.shipment_header_id = v_shipment_header_id
1682: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1683: AND rsup.item_id = v_item_id
1684: AND rsup.po_header_id = pod.po_header_id
1770: , rcv_transactions rt
1771: , rcv_shipment_headers rsh
1772: , rcv_shipment_lines rsl
1773: , po_line_locations poll
1774: , po_distributions pod
1775: WHERE rsl.shipment_header_id = v_shipment_header_id
1776: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1777: AND rsup.item_id = v_item_id
1778: AND rsup.po_header_id = pod.po_header_id
1847: , rcv_transactions rt
1848: , rcv_shipment_headers rsh
1849: , rcv_shipment_lines rsl
1850: , po_line_locations poll
1851: , po_distributions pod
1852: WHERE rsl.shipment_header_id = v_shipment_header_id
1853: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1854: AND rsup.item_id = v_item_id
1855: AND rsup.po_header_id = pod.po_header_id