eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_TXN_MATCH dependencies on RCV_SHIPMENT_HEADERS

Line 77: , rcv_shipment_headers rsh

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
81: FROM wms_lpn_contents

Line 123: , rcv_shipment_headers rsh

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
127: AND rsl.shipment_header_id = v_shipment_header_id

Line 175: , rcv_shipment_headers rsh

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
179: FROM wms_lpn_contents

Line 210: , rcv_shipment_headers rsh

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
214: AND rsl.shipment_header_id = v_shipment_header_id

Line 270: , rcv_shipment_headers rsh

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
274: WHERE parent_lpn_id = v_lpn_id) wlc

Line 322: , rcv_shipment_headers rsh

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
326: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 379: , rcv_shipment_headers rsh

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
383: WHERE parent_lpn_id = v_lpn_id) wlc

Line 419: , rcv_shipment_headers rsh

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
423: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 486: , rcv_shipment_headers rsh

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
490: FROM wms_lpn_contents

Line 532: , rcv_shipment_headers rsh

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
536: AND rsl.shipment_header_id = v_shipment_header_id

Line 577: , rcv_shipment_headers rsh

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
581: FROM wms_lpn_contents

Line 612: , rcv_shipment_headers rsh

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
616: AND rsl.shipment_header_id = v_shipment_header_id

Line 665: , rcv_shipment_headers rsh

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
669: WHERE parent_lpn_id = v_lpn_id) wlc

Line 717: , rcv_shipment_headers rsh

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
721: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 767: , rcv_shipment_headers rsh

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
771: WHERE parent_lpn_id = v_lpn_id) wlc

Line 807: , rcv_shipment_headers rsh

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
811: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 868: , rcv_shipment_headers rsh

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
872: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 916: , rcv_shipment_headers rsh

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
920: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)

Line 1087: , rcv_shipment_headers rsh

1083: , rsl.item_description item_description
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

Line 1159: , rcv_shipment_headers rsh

1155: IS
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

Line 1252: , rcv_shipment_headers rsh

1248: , To_char(NULL)
1249: , To_char(NULL)
1250: FROM rcv_supply rsup
1251: , rcv_transactions rt
1252: , rcv_shipment_headers rsh
1253: WHERE rsh.receipt_source_code = 'CUSTOMER'
1254: AND rsup.item_id = v_item_id
1255: AND rsup.oe_order_header_id = v_oe_order_header_id
1256: AND rsup.oe_order_line_id = Nvl(v_oe_order_line_id,Nvl(rsup.oe_order_line_id,-1))

Line 1321: , rcv_shipment_headers rsh

1317: IS
1318: SELECT COUNT(*)
1319: FROM rcv_supply rsup
1320: , rcv_transactions rt
1321: , rcv_shipment_headers rsh
1322: WHERE rsh.receipt_source_code = 'CUSTOMER'
1323: AND rsup.item_id = v_item_id
1324: AND rsup.oe_order_header_id = v_oe_order_header_id
1325: AND rsup.oe_order_line_id = Nvl(v_oe_order_line_id,Nvl(rsup.oe_order_line_id,-1))

Line 1404: , rcv_shipment_headers rsh

1400: , rsl.item_description item_description
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

Line 1481: , rcv_shipment_headers rsh

1477: IS
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

Line 1574: , rcv_shipment_headers rsh

1570: , rsl.item_description item_description
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

Line 1651: , rcv_shipment_headers rsh

1647: IS
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