[Home] [Help]
72: , poll.line_location_id
73: , pod.po_distribution_id
74: , rsl.item_description
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
118: , poll.line_location_id
119: , pod.po_distribution_id
120: , rsl.item_description
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
170:
171: --Bug5578552.The COUNT should be outside of UNION.
172: SELECT COUNT(*) FROM
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
205: )
206: and (v_task_id is null or pod.task_id = v_task_id)
207: UNION ALL
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
265: , poll.line_location_id
266: , To_number(NULL)
267: , rsl.item_description
268: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
269: FROM rcv_shipment_lines rsl
270: , rcv_shipment_headers rsh
271: , po_line_locations poll
272: , (SELECT DISTINCT source_line_id
273: FROM wms_lpn_contents
317: , poll.line_location_id
318: , To_number(NULL)
319: , rsl.item_description
320: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
321: FROM rcv_shipment_lines rsl
322: , rcv_shipment_headers rsh
323: , po_line_locations poll
324: WHERE rsl.shipment_header_id = rsh.shipment_header_id
325: AND rsl.shipment_header_id = v_shipment_header_id
374:
375: --Bug5578552.The COUNT should be outside of UNION.
376: SELECT COUNT(*) FROM
377: ( SELECT 1
378: FROM rcv_shipment_lines rsl
379: , rcv_shipment_headers rsh
380: , po_line_locations poll
381: , (SELECT DISTINCT source_line_id
382: FROM wms_lpn_contents
414: and (v_task_id is null or pod.task_id = v_task_id)
415: )
416: UNION ALL
417: SELECT 1
418: FROM rcv_shipment_lines rsl
419: , rcv_shipment_headers rsh
420: , po_line_locations poll
421: WHERE rsl.shipment_header_id = rsh.shipment_header_id
422: AND rsl.shipment_header_id = v_shipment_header_id
481: , poll.line_location_id
482: , pod.po_distribution_id
483: , rsl.item_description
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
527: , poll.line_location_id
528: , pod.po_distribution_id
529: , rsl.item_description
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
572:
573: --Bug5578552.The COUNT should be outside of UNION.
574: SELECT COUNT(*) FROM
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
607: )
608: and (v_task_id is null or pod.task_id = v_task_id)
609: UNION ALL
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
660: , poll.line_location_id
661: , To_number(NULL)
662: , rsl.item_description
663: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
664: FROM rcv_shipment_lines rsl
665: , rcv_shipment_headers rsh
666: , po_line_locations poll
667: , (SELECT DISTINCT source_line_id
668: FROM wms_lpn_contents
712: , poll.line_location_id
713: , To_number(NULL)
714: , rsl.item_description
715: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
716: FROM rcv_shipment_lines rsl
717: , rcv_shipment_headers rsh
718: , po_line_locations poll
719: WHERE rsl.shipment_header_id = rsh.shipment_header_id
720: AND rsl.shipment_header_id = v_shipment_header_id
762:
763: --Bug5578552.The COUNT should be outside of UNION.
764: SELECT COUNT(*) FROM
765: ( SELECT 1
766: FROM rcv_shipment_lines rsl
767: , rcv_shipment_headers rsh
768: , po_line_locations poll
769: , (SELECT DISTINCT source_line_id
770: FROM wms_lpn_contents
802: and (v_task_id is null or pod.task_id = v_task_id)
803: )
804: UNION ALL
805: SELECT 1
806: FROM rcv_shipment_lines rsl
807: , rcv_shipment_headers rsh
808: , po_line_locations poll
809: WHERE rsl.shipment_header_id = rsh.shipment_header_id
810: AND rsl.shipment_header_id = v_shipment_header_id
863: , To_number(NULL)
864: , To_number(NULL)
865: , rsl.item_description
866: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
867: FROM rcv_shipment_lines rsl
868: , rcv_shipment_headers rsh
869: , mtl_supply ms
870: WHERE rsl.shipment_header_id = v_shipment_header_id
871: AND rsh.shipment_header_id = rsl.shipment_header_id
911: ,v_task_id NUMBER
912: ,v_lpn_id NUMBER )
913: IS
914: SELECT COUNT(*)
915: FROM rcv_shipment_lines rsl
916: , rcv_shipment_headers rsh
917: , mtl_supply ms
918: WHERE rsl.shipment_header_id = v_shipment_header_id
919: AND rsh.shipment_header_id = rsl.shipment_header_id
1084: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
1085: FROM rcv_supply rsup
1086: , rcv_transactions rt
1087: , rcv_shipment_headers rsh
1088: , rcv_shipment_lines rsl
1089: WHERE rsl.shipment_header_id = v_shipment_header_id
1090: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1091: AND rsup.item_id = v_item_id
1092: AND Nvl(rsh.receipt_num,'@@@') = Nvl(v_receipt_num, Nvl(rsh.receipt_num,'@@@'))
1156: SELECT COUNT(*)
1157: FROM rcv_supply rsup
1158: , rcv_transactions rt
1159: , rcv_shipment_headers rsh
1160: , rcv_shipment_lines rsl
1161: WHERE rsl.shipment_header_id = v_shipment_header_id
1162: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1163: AND rsup.item_id = v_item_id
1164: AND Nvl(rsh.receipt_num,'@@@') = Nvl(v_receipt_num, Nvl(rsh.receipt_num,'@@@'))
1401: , to_char(null)
1402: FROM rcv_supply rsup
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)
1478: SELECT COUNT(*)
1479: FROM rcv_supply rsup
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)
1571: , to_char(null)
1572: FROM rcv_supply rsup
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)
1648: SELECT COUNT(*)
1649: FROM rcv_supply rsup
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)