[Home] [Help]
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
81: FROM wms_lpn_contents
82: WHERE parent_lpn_id = v_lpn_id) wlc
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
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)
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
179: FROM wms_lpn_contents
180: WHERE parent_lpn_id = v_lpn_id) wlc
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
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)
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
274: WHERE parent_lpn_id = v_lpn_id) wlc
275: WHERE rsl.shipment_header_id = rsh.shipment_header_id
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
326: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
327: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
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
383: WHERE parent_lpn_id = v_lpn_id) wlc
384: WHERE rsl.shipment_header_id = rsh.shipment_header_id
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
423: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
424: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_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
490: FROM wms_lpn_contents
491: WHERE parent_lpn_id = v_lpn_id) wlc
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
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)
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
581: FROM wms_lpn_contents
582: WHERE parent_lpn_id = v_lpn_id) wlc
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
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)
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
669: WHERE parent_lpn_id = v_lpn_id) wlc
670: WHERE rsl.shipment_header_id = rsh.shipment_header_id
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
721: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
722: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
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
771: WHERE parent_lpn_id = v_lpn_id) wlc
772: WHERE rsl.shipment_header_id = rsh.shipment_header_id
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
811: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
812: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)
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)
1410: AND rsup.item_id = v_item_id
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)
1487: AND rsup.item_id = v_item_id
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)
1580: AND rsup.item_id = v_item_id
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)
1657: AND rsup.item_id = v_item_id
1728: x_first_trans BOOLEAN := TRUE;
1729: x_sysdate DATE := Sysdate;
1730: current_n BINARY_INTEGER := 0;
1731: insert_into_table BOOLEAN := FALSE;
1732: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%type;
1733: tax_amount_factor NUMBER;
1734: lastrecord BOOLEAN := FALSE;
1735:
1736: po_asn_uom_qty NUMBER;