[Home] [Help]
75: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
76: FROM rcv_shipment_lines rsl
77: , rcv_shipment_headers rsh
78: , po_line_locations poll
79: , po_distributions pod
80: , (SELECT DISTINCT source_line_id
81: FROM wms_lpn_contents
82: WHERE parent_lpn_id = v_lpn_id) wlc
83: WHERE rsl.shipment_header_id = rsh.shipment_header_id
121: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
122: FROM rcv_shipment_lines rsl
123: , rcv_shipment_headers rsh
124: , po_line_locations poll
125: , po_distributions pod
126: WHERE rsl.shipment_header_id = rsh.shipment_header_id
127: AND rsl.shipment_header_id = v_shipment_header_id
128: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
129: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
173: ( SELECT 1
174: FROM rcv_shipment_lines rsl
175: , rcv_shipment_headers rsh
176: , po_line_locations poll
177: , po_distributions pod
178: , (SELECT DISTINCT source_line_id
179: FROM wms_lpn_contents
180: WHERE parent_lpn_id = v_lpn_id) wlc
181: WHERE rsl.shipment_header_id = rsh.shipment_header_id
208: SELECT 1
209: FROM rcv_shipment_lines rsl
210: , rcv_shipment_headers rsh
211: , po_line_locations poll
212: , po_distributions pod
213: WHERE rsl.shipment_header_id = rsh.shipment_header_id
214: AND rsl.shipment_header_id = v_shipment_header_id
215: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
216: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
295: -- bug 2752051
296: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
297: AND exists
298: ( select '1'
299: from po_distributions_all pod
300: where pod.line_location_id = poll.line_location_id
301: and (v_project_id is null or
302: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
303: pod.project_id = v_project_id
349: -- bug 2752051
350: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
351: AND exists
352: ( select '1'
353: from po_distributions_all pod
354: where pod.line_location_id = poll.line_location_id
355: and (v_project_id is null or
356: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
357: pod.project_id = v_project_id
404: -- bug 2752051
405: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
406: AND exists
407: ( select '1'
408: from po_distributions_all pod
409: where pod.line_location_id = poll.line_location_id
410: and (v_project_id is null or
411: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
412: pod.project_id = v_project_id
446: -- bug 2752051
447: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
448: AND exists
449: ( select '1'
450: from po_distributions_all pod
451: where pod.line_location_id = poll.line_location_id
452: and (v_project_id is null or
453: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
454: pod.project_id = v_project_id
484: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
485: FROM rcv_shipment_lines rsl
486: , rcv_shipment_headers rsh
487: , po_line_locations poll
488: , po_distributions pod
489: , (SELECT DISTINCT source_line_id
490: FROM wms_lpn_contents
491: WHERE parent_lpn_id = v_lpn_id) wlc
492: WHERE rsl.shipment_header_id = rsh.shipment_header_id
530: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
531: FROM rcv_shipment_lines rsl
532: , rcv_shipment_headers rsh
533: , po_line_locations poll
534: , po_distributions pod
535: WHERE rsl.shipment_header_id = rsh.shipment_header_id
536: AND rsl.shipment_header_id = v_shipment_header_id
537: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
538: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
575: ( SELECT 1
576: FROM rcv_shipment_lines rsl
577: , rcv_shipment_headers rsh
578: , po_line_locations poll
579: , po_distributions pod
580: , (SELECT DISTINCT source_line_id
581: FROM wms_lpn_contents
582: WHERE parent_lpn_id = v_lpn_id) wlc
583: WHERE rsl.shipment_header_id = rsh.shipment_header_id
610: SELECT 1
611: FROM rcv_shipment_lines rsl
612: , rcv_shipment_headers rsh
613: , po_line_locations poll
614: , po_distributions pod
615: WHERE rsl.shipment_header_id = rsh.shipment_header_id
616: AND rsl.shipment_header_id = v_shipment_header_id
617: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
618: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
690: -- bug 2752051
691: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
692: AND exists
693: ( select '1'
694: from po_distributions_all pod
695: where pod.line_location_id = poll.line_location_id
696: and (v_project_id is null or
697: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
698: pod.project_id = v_project_id
737: -- bug 2752051
738: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
739: AND exists
740: ( select '1'
741: from po_distributions_all pod
742: where pod.line_location_id = poll.line_location_id
743: and (v_project_id is null or
744: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
745: pod.project_id = v_project_id
792: -- bug 2752051
793: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
794: AND exists
795: ( select '1'
796: from po_distributions_all pod
797: where pod.line_location_id = poll.line_location_id
798: and (v_project_id is null or
799: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
800: pod.project_id = v_project_id
827: -- bug 2752051
828: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
829: AND exists
830: ( select '1'
831: from po_distributions_all pod
832: where pod.line_location_id = poll.line_location_id
833: and (v_project_id is null or
834: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
835: pod.project_id = v_project_id
1403: , rcv_transactions rt
1404: , rcv_shipment_headers rsh
1405: , rcv_shipment_lines rsl
1406: , po_line_locations poll
1407: , po_distributions pod
1408: WHERE rsl.shipment_header_id = v_shipment_header_id
1409: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1410: AND rsup.item_id = v_item_id
1411: AND rsup.po_header_id = pod.po_header_id
1480: , rcv_transactions rt
1481: , rcv_shipment_headers rsh
1482: , rcv_shipment_lines rsl
1483: , po_line_locations poll
1484: , po_distributions pod
1485: WHERE rsl.shipment_header_id = v_shipment_header_id
1486: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1487: AND rsup.item_id = v_item_id
1488: AND rsup.po_header_id = pod.po_header_id
1573: , rcv_transactions rt
1574: , rcv_shipment_headers rsh
1575: , rcv_shipment_lines rsl
1576: , po_line_locations poll
1577: , po_distributions pod
1578: WHERE rsl.shipment_header_id = v_shipment_header_id
1579: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1580: AND rsup.item_id = v_item_id
1581: AND rsup.po_header_id = pod.po_header_id
1650: , rcv_transactions rt
1651: , rcv_shipment_headers rsh
1652: , rcv_shipment_lines rsl
1653: , po_line_locations poll
1654: , po_distributions pod
1655: WHERE rsl.shipment_header_id = v_shipment_header_id
1656: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1657: AND rsup.item_id = v_item_id
1658: AND rsup.po_header_id = pod.po_header_id