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_LINES

Line 78: FROM rcv_shipment_lines rsl

74: , poll.line_location_id
75: , pod.po_distribution_id
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

Line 124: FROM rcv_shipment_lines rsl

120: , poll.line_location_id
121: , pod.po_distribution_id
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

Line 178: FROM rcv_shipment_lines rsl

174:
175: --Bug5578552.The COUNT should be outside of UNION.
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

Line 213: FROM rcv_shipment_lines rsl

209: )
210: and (v_task_id is null or pod.task_id = v_task_id)
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

Line 306: FROM rcv_shipment_lines rsl

302: , rsl.item_description item_description
303: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
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

Line 361: FROM rcv_shipment_lines rsl

357: , rsl.item_description item_description
358: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
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

Line 435: FROM rcv_shipment_lines rsl

431:
432: --Bug5578552.The COUNT should be outside of UNION.
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

Line 476: FROM rcv_shipment_lines rsl

472: )
473: AND (NVL(rsl.quantity_received,0)=0 OR NVL(rsl.item_revision, '@@') = NVL(v_item_revision, '@@')) --Bug 13598673
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

Line 558: FROM rcv_shipment_lines rsl

554: , poll.line_location_id
555: , pod.po_distribution_id
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

Line 604: FROM rcv_shipment_lines rsl

600: , poll.line_location_id
601: , pod.po_distribution_id
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

Line 649: FROM rcv_shipment_lines rsl

645:
646: --Bug5578552.The COUNT should be outside of UNION.
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

Line 684: FROM rcv_shipment_lines rsl

680: )
681: and (v_task_id is null or pod.task_id = v_task_id)
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

Line 737: FROM rcv_shipment_lines rsl

733: , poll.line_location_id
734: , To_number(NULL)
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

Line 789: FROM rcv_shipment_lines rsl

785: , poll.line_location_id
786: , To_number(NULL)
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

Line 839: FROM rcv_shipment_lines rsl

835:
836: --Bug5578552.The COUNT should be outside of UNION.
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

Line 879: FROM rcv_shipment_lines rsl

875: and (v_task_id is null or pod.task_id = v_task_id)
876: )
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

Line 944: FROM rcv_shipment_lines rsl

940: , To_number(NULL)
941: , To_number(NULL)
942: , rsl.item_description
943: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
944: FROM rcv_shipment_lines rsl
945: , rcv_shipment_headers rsh
946: , mtl_supply ms
947: WHERE rsl.shipment_header_id = v_shipment_header_id
948: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 1040: FROM rcv_shipment_lines rsl

1036: ,v_req_header_id NUMBER -- 12546176
1037: ) --9651496,9764650
1038: IS
1039: SELECT COUNT(*)
1040: FROM rcv_shipment_lines rsl
1041: , rcv_shipment_headers rsh
1042: , mtl_supply ms
1043: WHERE rsl.shipment_header_id = v_shipment_header_id
1044: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 1260: , rcv_shipment_lines rsl

1256: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
1257: FROM rcv_supply rsup
1258: , rcv_transactions rt
1259: , rcv_shipment_headers rsh
1260: , rcv_shipment_lines rsl
1261: WHERE rsl.shipment_header_id = v_shipment_header_id
1262: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1263: AND rsup.item_id = v_item_id
1264: AND Nvl(rsh.receipt_num,'@@@') = Nvl(v_receipt_num, Nvl(rsh.receipt_num,'@@@'))

Line 1341: , rcv_shipment_lines rsl

1337: SELECT COUNT(*)
1338: FROM rcv_supply rsup
1339: , rcv_transactions rt
1340: , rcv_shipment_headers rsh
1341: , rcv_shipment_lines rsl
1342: WHERE rsl.shipment_header_id = v_shipment_header_id
1343: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)
1344: AND rsup.item_id = v_item_id
1345: AND Nvl(rsh.receipt_num,'@@@') = Nvl(v_receipt_num, Nvl(rsh.receipt_num,'@@@'))

Line 1597: , rcv_shipment_lines rsl

1593: , to_char(null)
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)

Line 1678: , rcv_shipment_lines rsl

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

Line 1772: , rcv_shipment_lines rsl

1768: , to_char(null)
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)

Line 1849: , rcv_shipment_lines rsl

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

Line 1978: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;

1974:
1975: l_patch_j_or_higher VARCHAR2(3) := 'N';
1976: --Bug 12720051
1977: l_rsl_qty NUMBER;
1978: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
1979: l_pre_rcv_flag VARCHAR2(1);
1980:
1981: --Bug 4004656-Added the local variables for the quantity fields.
1982: l_rem_qty_trans_uom NUMBER := 0; -- Remaining quantity to be received in transaction uom

Line 3172: FROM rcv_shipment_lines rsl

3168: IF(x_cascaded_table(n).transaction_type in('RECEIVE','DELIVER')) THEN
3169: IF(l_pre_rcv_flag='Y') THEN
3170: SELECT rsl.quantity_shipped, rsl.unit_of_measure
3171: INTO l_rsl_qty, l_rsl_uom
3172: FROM rcv_shipment_lines rsl
3173: WHERE rsl.shipment_line_id = l_parent_id;
3174: --
3175: IF (l_rsl_qty <> x_cascaded_table(current_n).quantity) THEN
3176: x_cascaded_table(n).error_status := 'E';