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 PO_LINE_LOCATIONS

Line 80: , po_line_locations poll

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

Line 126: , po_line_locations poll

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

Line 180: , po_line_locations poll

176: SELECT COUNT(*) FROM
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

Line 215: , po_line_locations poll

211: UNION ALL
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)

Line 308: , po_line_locations poll

304: , (rsl.QUANTITY_SHIPPED - nvl(rsl.quantity_received, 0)) quantity_received --Bug 13598673
305: , decode(nvl(rsl.item_revision,'@@'), nvl(v_item_revision, '@@'),0,1) revision --Bug 13598673
306: FROM rcv_shipment_lines rsl
307: , rcv_shipment_headers rsh
308: , po_line_locations poll
309: , (SELECT DISTINCT source_line_id
310: FROM wms_lpn_contents
311: WHERE parent_lpn_id = v_lpn_id) wlc
312: WHERE rsl.shipment_header_id = rsh.shipment_header_id

Line 363: , po_line_locations poll

359: , (rsl.QUANTITY_SHIPPED - nvl(rsl.quantity_received, 0)) quantity_received --Bug 13598673
360: , decode(nvl(rsl.item_revision,'@@'), nvl(v_item_revision, '@@'),0,1) revision --Bug 13598673
361: FROM rcv_shipment_lines rsl
362: , rcv_shipment_headers rsh
363: , po_line_locations poll
364: WHERE rsl.shipment_header_id = rsh.shipment_header_id
365: AND rsl.shipment_header_id = v_shipment_header_id
366: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
367: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)

Line 437: , po_line_locations poll

433: SELECT COUNT(*) FROM
434: ( SELECT 1
435: FROM rcv_shipment_lines rsl
436: , rcv_shipment_headers rsh
437: , po_line_locations poll
438: , (SELECT DISTINCT source_line_id
439: FROM wms_lpn_contents
440: WHERE parent_lpn_id = v_lpn_id) wlc
441: WHERE rsl.shipment_header_id = rsh.shipment_header_id

Line 478: , po_line_locations poll

474: UNION ALL
475: SELECT 1
476: FROM rcv_shipment_lines rsl
477: , rcv_shipment_headers rsh
478: , po_line_locations poll
479: WHERE rsl.shipment_header_id = rsh.shipment_header_id
480: AND rsl.shipment_header_id = v_shipment_header_id
481: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
482: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)

Line 560: , po_line_locations poll

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

Line 606: , po_line_locations poll

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

Line 651: , po_line_locations poll

647: SELECT COUNT(*) FROM
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

Line 686: , po_line_locations poll

682: UNION ALL
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)

Line 739: , po_line_locations poll

735: , rsl.item_description
736: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
737: FROM rcv_shipment_lines rsl
738: , rcv_shipment_headers rsh
739: , po_line_locations poll
740: , (SELECT DISTINCT source_line_id
741: FROM wms_lpn_contents
742: WHERE parent_lpn_id = v_lpn_id) wlc
743: WHERE rsl.shipment_header_id = rsh.shipment_header_id

Line 791: , po_line_locations poll

787: , rsl.item_description
788: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
789: FROM rcv_shipment_lines rsl
790: , rcv_shipment_headers rsh
791: , po_line_locations poll
792: WHERE rsl.shipment_header_id = rsh.shipment_header_id
793: AND rsl.shipment_header_id = v_shipment_header_id
794: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
795: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)

Line 841: , po_line_locations poll

837: SELECT COUNT(*) FROM
838: ( SELECT 1
839: FROM rcv_shipment_lines rsl
840: , rcv_shipment_headers rsh
841: , po_line_locations poll
842: , (SELECT DISTINCT source_line_id
843: FROM wms_lpn_contents
844: WHERE parent_lpn_id = v_lpn_id) wlc
845: WHERE rsl.shipment_header_id = rsh.shipment_header_id

Line 881: , po_line_locations poll

877: UNION ALL
878: SELECT 1
879: FROM rcv_shipment_lines rsl
880: , rcv_shipment_headers rsh
881: , po_line_locations poll
882: WHERE rsl.shipment_header_id = rsh.shipment_header_id
883: AND rsl.shipment_header_id = v_shipment_header_id
884: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
885: AND poll.po_header_id = Nvl(v_po_header_id, poll.po_header_id)

Line 1598: , po_line_locations poll

1594: FROM rcv_supply rsup
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

Line 1679: , po_line_locations poll

1675: FROM rcv_supply rsup
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

Line 1773: , po_line_locations poll

1769: FROM rcv_supply rsup
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

Line 1850: , po_line_locations poll

1846: FROM rcv_supply rsup
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

Line 1929: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%type;

1925: x_first_trans BOOLEAN := TRUE;
1926: x_sysdate DATE := Sysdate;
1927: current_n BINARY_INTEGER := 0;
1928: insert_into_table BOOLEAN := FALSE;
1929: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%type;
1930: tax_amount_factor NUMBER;
1931: lastrecord BOOLEAN := FALSE;
1932:
1933: po_asn_uom_qty NUMBER;