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.IO_DIAGNOSTICS3 dependencies on RCV_SHIPMENT_HEADERS

Line 8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;

4: PROCEDURE req_receipt_shipment_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_shipment_num IN VARCHAR2, p_receipt_num
5: IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
7: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
10: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;
11: l_count NUMBER := 0;
12:

Line 9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;

5: IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
7: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
10: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;
11: l_count NUMBER := 0;
12:
13: BEGIN

Line 10: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;

6: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
7: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
10: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;
11: l_count NUMBER := 0;
12:
13: BEGIN
14:

Line 33: ' rcv_shipment_headers rsh, ' ||

29:
30: p_sql(2) := ' SELECT prl.* ' ||
31: ' FROM po_requisition_headers_all prh, ' ||
32: ' po_requisition_lines_all prl, ' ||
33: ' rcv_shipment_headers rsh, ' ||
34: ' rcv_shipment_lines rsl ' ||
35: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
36: ' and rsh.ship_to_org_id = ' || l_org_id ||
37: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 55: ' rcv_shipment_headers rsh, ' ||

51: p_sql(3) := ' SELECT prd.* ' ||
52: ' FROM po_requisition_headers_all prh, ' ||
53: ' po_requisition_lines_all prl, ' ||
54: ' po_req_distributions_all prd, ' ||
55: ' rcv_shipment_headers rsh, ' ||
56: ' rcv_shipment_lines rsl ' ||
57: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
58: ' and rsh.ship_to_org_id = ' || l_org_id ||
59: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 76: ' rcv_shipment_headers rsh, ' ||

72: p_sql(4) := ' SELECT oel.* ' ||
73: ' FROM oe_order_lines_all oel, ' ||
74: ' po_requisition_lines_all prl, ' ||
75: ' po_requisition_headers_all prh,' ||
76: ' rcv_shipment_headers rsh, ' ||
77: ' rcv_shipment_lines rsl ' ||
78: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
79: ' and rsh.ship_to_org_id = ' || l_org_id ||
80: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 98: ' rcv_shipment_headers rsh, ' ||

94: ' wsh_new_deliveries wnd , ' ||
95: ' oe_order_lines_all sol , ' ||
96: ' po_requisition_lines_all prl , ' ||
97: ' po_requisition_headers_all prh , ' ||
98: ' rcv_shipment_headers rsh, ' ||
99: ' rcv_shipment_lines rsl ' ||
100: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
101: ' and rsh.ship_to_org_id = ' || l_org_id ||
102: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 120: ' rcv_shipment_headers rsh, ' ||

116: ' mtl_transactions_interface mti , ' ||
117: ' po_requisition_lines_all prl , ' ||
118: ' po_requisition_headers_all prh , ' ||
119: ' oe_order_lines_all sol, ' ||
120: ' rcv_shipment_headers rsh, ' ||
121: ' rcv_shipment_lines rsl ' ||
122: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
123: ' and rsh.ship_to_org_id = ' || l_org_id ||
124: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 138: ' rcv_shipment_headers rsh ' ||

134:
135:
136: p_sql(6) := ' SELECT rhi.* ' ||
137: ' FROM rcv_headers_interface rhi,' ||
138: ' rcv_shipment_headers rsh ' ||
139: ' WHERE rhi.receipt_header_id = rsh.shipment_header_id ' ||
140: ' and rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
141: ' and rsh.ship_to_org_id = ' || l_org_id ;
142:

Line 169: ' FROM rcv_shipment_headers rsh , ' ||

165:
166:
167:
168: p_sql(9) := ' SELECT DISTINCT rsh.* ' ||
169: ' FROM rcv_shipment_headers rsh , ' ||
170: ' rcv_shipment_lines rsl , ' ||
171: ' po_requisition_headers_all prh , ' ||
172: ' po_requisition_lines_all prl ' ||
173: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 187: ' FROM rcv_shipment_headers rsh, ' ||

183:
184:
185:
186: p_sql(10) := ' SELECT rsl.* ' ||
187: ' FROM rcv_shipment_headers rsh, ' ||
188: ' rcv_shipment_lines rsl , ' ||
189: ' po_requisition_headers_all prh , ' ||
190: ' po_requisition_lines_all prl ' ||
191: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 206: ' rcv_shipment_headers rsh, ' ||

202: p_sql(11) := ' SELECT rt.* ' ||
203: ' FROM rcv_transactions rt , ' ||
204: ' po_requisition_headers_all prh , ' ||
205: ' po_requisition_lines_all prl ,' ||
206: ' rcv_shipment_headers rsh, ' ||
207: ' rcv_shipment_lines rsl ' ||
208: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
209: ' and rsh.ship_to_org_id = ' || l_org_id ||
210: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 224: ' rcv_shipment_headers rsh, ' ||

220: p_sql(12) := ' SELECT ms.* ' ||
221: ' FROM mtl_supply ms , ' ||
222: ' po_requisition_headers_all prh , ' ||
223: ' po_requisition_lines_all prl ,' ||
224: ' rcv_shipment_headers rsh, ' ||
225: ' rcv_shipment_lines rsl ' ||
226: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
227: ' and rsh.ship_to_org_id = ' || l_org_id ||
228: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 246: ' rcv_shipment_headers rsh, ' ||

242: p_sql(13) := ' SELECT rs.* ' ||
243: ' FROM rcv_supply rs , ' ||
244: ' po_requisition_headers_all prh ,' ||
245: ' po_requisition_lines_all prl,' ||
246: ' rcv_shipment_headers rsh, ' ||
247: ' rcv_shipment_lines rsl ' ||
248: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
249: ' and rsh.ship_to_org_id = ' || l_org_id ||
250: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 261: ' rcv_shipment_headers rsh, ' ||

257: ' AND rs.shipment_header_id = rsh.shipment_header_id ';
258:
259: p_sql(14) := ' SELECT mtrl.* ' ||
260: ' FROM mtl_txn_request_lines mtrl, ' ||
261: ' rcv_shipment_headers rsh, ' ||
262: ' rcv_shipment_lines rsl, ' ||
263: ' po_requisition_headers_all prh, ' ||
264: ' po_requisition_lines_all prl ' ||
265: ' WHERE rsh.shipment_num = '|| '''' || l_shipment_num || '''' ||

Line 281: ' rcv_shipment_headers rsh, ' ||

277: ' and mtrl.line_status=7';
278:
279: /*' SELECT mtrl.* ' ||
280: ' FROM mtl_txn_request_lines mtrl, ' ||
281: ' rcv_shipment_headers rsh, ' ||
282: ' rcv_shipment_lines rsl, ' ||
283: ' po_requisition_headers_all prh, ' ||
284: ' po_requisition_lines_all prl ' ||
285: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 302: ' RCV_SHIPMENT_HEADERS RSH, ' ||

298: ' FROM MTL_TRANSACTIONS_INTERFACE MTI, ' ||
299: ' PO_REQUISITION_LINES_ALL PRL, ' ||
300: ' PO_REQUISITION_HEADERS_ALL PRH, ' ||
301: ' OE_ORDER_LINES_ALL SOL, ' ||
302: ' RCV_SHIPMENT_HEADERS RSH, ' ||
303: ' RCV_SHIPMENT_LINES RSL ' ||
304: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
305: ' and rsh.ship_to_org_id = ' || l_org_id ||
306: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 322: ' rcv_shipment_headers rsh, ' ||

318: p_sql(16) := ' SELECT mmtt.* ' ||
319: ' FROM mtl_material_transactions_temp mmtt , ' ||
320: ' po_requisition_lines_all prl , ' ||
321: ' po_requisition_headers_all prh, ' ||
322: ' rcv_shipment_headers rsh, ' ||
323: ' rcv_shipment_lines rsl,' ||
324: ' rcv_transactions rt ' ||
325: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
326: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 344: ' rcv_shipment_headers rsh, ' ||

340: ' SELECT mmtt.* ' ||
341: ' FROM mtl_material_transactions_temp mmtt , ' ||
342: ' po_requisition_lines_all prl , ' ||
343: ' po_requisition_headers_all prh, ' ||
344: ' rcv_shipment_headers rsh, ' ||
345: ' rcv_shipment_lines rsl,' ||
346: ' oe_order_lines_all sol ' ||
347: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
348: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 368: ' rcv_shipment_headers rsh, ' ||

364: p_sql(17) := ' SELECT mmt.* ' ||
365: ' FROM mtl_material_transactions mmt , ' ||
366: ' po_requisition_lines_all prl , ' ||
367: ' po_requisition_headers_all prh, ' ||
368: ' rcv_shipment_headers rsh, ' ||
369: ' rcv_shipment_lines rsl,' ||
370: ' rcv_transactions rt ' ||
371: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
372: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 389: ' rcv_shipment_headers rsh, ' ||

385: ' SELECT mmt.* ' ||
386: ' FROM mtl_material_transactions mmt , ' ||
387: ' po_requisition_lines_all prl , ' ||
388: ' po_requisition_headers_all prh, ' ||
389: ' rcv_shipment_headers rsh, ' ||
390: ' rcv_shipment_lines rsl,' ||
391: ' oe_order_lines_all sol ' ||
392: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
393: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 413: ' rcv_shipment_headers rsh, ' ||

409: ' FROM mtl_reservations mr , ' ||
410: ' oe_order_lines_all sol , ' ||
411: ' po_requisition_lines_all prl , ' ||
412: ' po_requisition_headers_all prh, ' ||
413: ' rcv_shipment_headers rsh, ' ||
414: ' rcv_shipment_lines rsl ' ||
415: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
416: ' and rsh.ship_to_org_id = ' || l_org_id ||
417: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 434: ' rcv_shipment_headers rsh, ' ||

430: ' mtl_transactions_interface mti , ' ||
431: ' po_requisition_lines_all prl , ' ||
432: ' po_requisition_headers_all prh , ' ||
433: ' oe_order_lines_all sol ,' ||
434: ' rcv_shipment_headers rsh, ' ||
435: ' rcv_shipment_lines rsl ' ||
436: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
437: ' and rsh.ship_to_org_id = ' || l_org_id ||
438: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 454: ' rcv_shipment_headers rsh, ' ||

450: ' FROM mtl_demand md , ' ||
451: ' oe_order_lines_all sol , ' ||
452: ' po_requisition_lines_all prl , ' ||
453: ' po_requisition_headers_all prh , ' ||
454: ' rcv_shipment_headers rsh, ' ||
455: ' rcv_shipment_lines rsl ' ||
456: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
457: ' and rsh.ship_to_org_id = ' || l_org_id ||
458: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 476: ' rcv_shipment_headers rsh, ' ||

472: ' mtl_transactions_interface mti , ' ||
473: ' po_requisition_lines_all prl , ' ||
474: ' po_requisition_headers_all prh , ' ||
475: ' oe_order_lines_all sol , ' ||
476: ' rcv_shipment_headers rsh, ' ||
477: ' rcv_shipment_lines rsl ' ||
478: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
479: ' and rsh.ship_to_org_id = ' || l_org_id ||
480: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 502: ' rcv_shipment_headers rsh, ' ||

498: ' from mtl_serial_numbers msn , ' ||
499: ' mtl_material_transactions mmt , ' ||
500: ' po_requisition_lines_all prl , ' ||
501: ' po_requisition_headers_all prh ,' ||
502: ' rcv_shipment_headers rsh, ' ||
503: ' rcv_shipment_lines rsl ,' ||
504: ' rcv_transactions rt' ||
505: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
506: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 524: ' rcv_shipment_headers rsh, ' ||

520: ' mtl_material_transactions mmt , ' ||
521: ' po_requisition_lines_all prl , ' ||
522: ' po_requisition_headers_all prh ,' ||
523: ' oe_order_lines_all sol,' ||
524: ' rcv_shipment_headers rsh, ' ||
525: ' rcv_shipment_lines rsl ' ||
526: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
527: ' and rsh.ship_to_org_id = ' || l_org_id ||
528: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 548: ' rcv_shipment_headers rsh, ' ||

544: ' po_requisition_headers_all prh ,' ||
545: ' mtl_serial_numbers_temp msnt ,' ||
546: ' mtl_system_items msi,' ||
547: ' rcv_transactions_interface rti,' ||
548: ' rcv_shipment_headers rsh, ' ||
549: ' rcv_shipment_lines rsl ' ||
550: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
551: ' and rsh.ship_to_org_id = ' || l_org_id ||
552: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 575: ' rcv_shipment_headers rsh, ' ||

571: ' mtl_serial_numbers_temp msnt ,' ||
572: ' mtl_transaction_lots_temp mtlt,' ||
573: ' mtl_system_items msi,' ||
574: ' rcv_transactions_interface rti,' ||
575: ' rcv_shipment_headers rsh, ' ||
576: ' rcv_shipment_lines rsl ' ||
577: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
578: ' and rsh.ship_to_org_id = ' || l_org_id ||
579: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 603: ' rcv_shipment_headers rsh, ' ||

599: ' mtl_serial_numbers_temp msnt,' ||
600: ' mtl_system_items msi,' ||
601: ' oe_order_lines_all sol,' ||
602: ' mtl_material_transactions_temp mmtt,' ||
603: ' rcv_shipment_headers rsh, ' ||
604: ' rcv_shipment_lines rsl ' ||
605: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
606: ' and rsh.ship_to_org_id = ' || l_org_id ||
607: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 631: ' rcv_shipment_headers rsh, ' ||

627: ' mtl_transaction_lots_temp mtlt,' ||
628: ' mtl_system_items msi,' ||
629: ' oe_order_lines_all sol,' ||
630: ' mtl_material_transactions_temp mmtt,' ||
631: ' rcv_shipment_headers rsh, ' ||
632: ' rcv_shipment_lines rsl ' ||
633: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
634: ' and rsh.ship_to_org_id = ' || l_org_id ||
635: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 660: ' rcv_shipment_headers rsh, ' ||

656: ' po_requisition_lines_all prl , ' ||
657: ' po_requisition_headers_all prh , ' ||
658: ' mtl_serial_numbers_interface msni ,' ||
659: ' mtl_system_items msi,' ||
660: ' rcv_shipment_headers rsh, ' ||
661: ' rcv_shipment_lines rsl ' ||
662: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
663: ' and rsh.ship_to_org_id = ' || l_org_id ||
664: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 687: ' rcv_shipment_headers rsh, ' ||

683: ' po_requisition_headers_all prh , ' ||
684: ' mtl_serial_numbers_interface msni ,' ||
685: ' mtl_transaction_lots_interface mtli,' ||
686: ' mtl_system_items msi,' ||
687: ' rcv_shipment_headers rsh, ' ||
688: ' rcv_shipment_lines rsl ' ||
689: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
690: ' and rsh.ship_to_org_id = ' || l_org_id ||
691: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 715: ' rcv_shipment_headers rsh, ' ||

711: ' po_requisition_lines_all prl , ' ||
712: ' mtl_unit_transactions mut , ' ||
713: ' mtl_system_items msi, ' ||
714: ' rcv_transactions rt, ' ||
715: ' rcv_shipment_headers rsh, ' ||
716: ' rcv_shipment_lines rsl ' ||
717: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
718: ' and rsh.ship_to_org_id = ' || l_org_id ||
719: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 738: ' rcv_shipment_headers rsh, ' ||

734: ' mtl_unit_transactions mut , ' ||
735: ' mtl_system_items msi , ' ||
736: ' rcv_transactions rt , ' ||
737: ' mtl_transaction_lot_numbers mtln, ' ||
738: ' rcv_shipment_headers rsh, ' ||
739: ' rcv_shipment_lines rsl ' ||
740: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
741: ' and rsh.ship_to_org_id = ' || l_org_id ||
742: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 761: ' rcv_shipment_headers rsh, ' ||

757: ' po_requisition_lines_all prl , ' ||
758: ' mtl_unit_transactions mut , ' ||
759: ' mtl_system_items msi , ' ||
760: ' oe_order_lines_all sol, ' ||
761: ' rcv_shipment_headers rsh, ' ||
762: ' rcv_shipment_lines rsl ' ||
763: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
764: ' and rsh.ship_to_org_id = ' || l_org_id ||
765: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 785: ' rcv_shipment_headers rsh, ' ||

781: ' mtl_unit_transactions mut , ' ||
782: ' mtl_system_items msi , ' ||
783: ' oe_order_lines_all sol , ' ||
784: ' mtl_transaction_lot_numbers mtln, ' ||
785: ' rcv_shipment_headers rsh, ' ||
786: ' rcv_shipment_lines rsl ' ||
787: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
788: ' and rsh.ship_to_org_id = ' || l_org_id ||
789: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 813: ' rcv_shipment_headers rsh ' ||

809: ' FROM rcv_serials_supply rss , ' ||
810: ' rcv_shipment_lines rsl , ' ||
811: ' po_requisition_headers_all prh , ' ||
812: ' po_requisition_lines_all prl , ' ||
813: ' rcv_shipment_headers rsh ' ||
814: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
815: ' and rsh.ship_to_org_id = ' || l_org_id ||
816: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
817: ' and prh.org_id = ' || l_ou_id ||

Line 833: ' rcv_shipment_headers rsh ' ||

829: ' FROM rcv_serial_transactions rst , ' ||
830: ' rcv_shipment_lines rsl , ' ||
831: ' po_requisition_headers_all prh , ' ||
832: ' po_requisition_lines_all prl , ' ||
833: ' rcv_shipment_headers rsh ' ||
834: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
835: ' and rsh.ship_to_org_id = ' || l_org_id ||
836: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
837: ' and prh.org_id = ' || l_ou_id ||

Line 853: ' rcv_shipment_headers rsh ,' ||

849: ' FROM rcv_serials_interface rsi , ' ||
850: ' rcv_shipment_lines rsl , ' ||
851: ' po_requisition_headers_all prh , ' ||
852: ' po_requisition_lines_all prl , ' ||
853: ' rcv_shipment_headers rsh ,' ||
854: ' rcv_transactions_interface rti' ||
855: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
856: ' and rsh.ship_to_org_id = ' || l_org_id ||
857: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 879: ' rcv_shipment_headers rsh,' ||

875: ' mtl_transaction_lot_numbers mtln ,' ||
876: ' mtl_material_transactions mmt ,' ||
877: ' po_requisition_lines_all prl ,' ||
878: ' rcv_transactions rt,' ||
879: ' rcv_shipment_headers rsh,' ||
880: ' rcv_shipment_lines rsl ' ||
881: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
882: ' and rsh.ship_to_org_id = ' || '''' || l_org_id || '''' ||
883: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 900: ' rcv_shipment_headers rsh, ' ||

896: ' mtl_transaction_lot_numbers mtln ,' ||
897: ' mtl_material_transactions mmt , ' ||
898: ' po_requisition_lines_all prl , ' ||
899: ' oe_order_lines_all sol,' ||
900: ' rcv_shipment_headers rsh, ' ||
901: ' rcv_shipment_lines rsl ' ||
902: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
903: ' and rsh.ship_to_org_id = ' || '''' || l_org_id || '''' ||
904: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 922: ' rcv_shipment_headers rsh, ' ||

918: ' from mtl_transaction_lot_numbers mtln ,' ||
919: ' mtl_material_transactions mmt , ' ||
920: ' po_requisition_lines_all prl , ' ||
921: ' rcv_transactions rt,' ||
922: ' rcv_shipment_headers rsh, ' ||
923: ' rcv_shipment_lines rsl ' ||
924: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
925: ' and rsh.ship_to_org_id = ' || l_org_id ||
926: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 939: ' rcv_shipment_headers rsh, ' ||

935: ' from mtl_transaction_lot_numbers mtln , ' ||
936: ' mtl_material_transactions mmt , ' ||
937: ' po_requisition_lines_all prl , ' ||
938: ' oe_order_lines_all sol,' ||
939: ' rcv_shipment_headers rsh, ' ||
940: ' rcv_shipment_lines rsl ' ||
941: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
942: ' and rsh.ship_to_org_id = ' || l_org_id ||
943: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 959: ' rcv_shipment_headers rsh, ' ||

955: p_sql(29) := ' select distinct mtli.* ' ||
956: ' from mtl_transaction_lots_interface mtli , ' ||
957: ' mtl_transactions_interface mti , ' ||
958: ' po_requisition_lines_all prl , ' ||
959: ' rcv_shipment_headers rsh, ' ||
960: ' rcv_shipment_lines rsl ' ||
961: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
962: ' and rsh.ship_to_org_id = ' || l_org_id ||
963: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 974: ' rcv_shipment_headers rsh, ' ||

970: ' select distinct mtli.* ' ||
971: ' from mtl_transaction_lots_interface mtli , ' ||
972: ' rcv_transactions_interface rti , ' ||
973: ' po_requisition_lines_all prl , ' ||
974: ' rcv_shipment_headers rsh, ' ||
975: ' rcv_shipment_lines rsl ' ||
976: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
977: ' and rsh.ship_to_org_id = ' || l_org_id ||
978: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 995: ' rcv_shipment_headers rsh, ' ||

991: p_sql(30) := ' select distinct mtlt.* ' ||
992: ' from mtl_transaction_lots_temp mtlt ,' ||
993: ' rcv_transactions_interface rti, ' ||
994: ' po_requisition_lines_all prl , ' ||
995: ' rcv_shipment_headers rsh, ' ||
996: ' rcv_shipment_lines rsl ' ||
997: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
998: ' and rsh.ship_to_org_id = ' || l_org_id ||
999: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1011: ' rcv_shipment_headers rsh, ' ||

1007: ' from mtl_transaction_lots_temp mtlt ,' ||
1008: ' mtl_material_transactions_temp mmtt, ' ||
1009: ' po_requisition_lines_all prl , ' ||
1010: ' oe_order_lines_all sol,' ||
1011: ' rcv_shipment_headers rsh, ' ||
1012: ' rcv_shipment_lines rsl ' ||
1013: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1014: ' and rsh.ship_to_org_id = ' || l_org_id ||
1015: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1030: ' rcv_shipment_headers rsh ' ||

1026: ' rcv_shipment_lines rsl , ' ||
1027: ' po_requisition_headers_all prh , ' ||
1028: ' po_requisition_lines_all prl , ' ||
1029: ' oe_order_lines_all sol , ' ||
1030: ' rcv_shipment_headers rsh ' ||
1031: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1032: ' and rsh.ship_to_org_id = ' || l_org_id ||
1033: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1034: ' and prh.org_id = ' || l_ou_id ||

Line 1053: ' rcv_shipment_headers rsh ' ||

1049: ' FROM rcv_lot_transactions rlt , ' ||
1050: ' rcv_shipment_lines rsl , ' ||
1051: ' po_requisition_headers_all prh , ' ||
1052: ' po_requisition_lines_all prl , ' ||
1053: ' rcv_shipment_headers rsh ' ||
1054: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1055: ' and rsh.ship_to_org_id = ' || l_org_id ||
1056: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1057: ' and prh.org_id = ' || l_ou_id ||

Line 1073: ' rcv_shipment_headers rsh,' ||

1069: ' FROM rcv_lots_interface rli , ' ||
1070: ' rcv_transactions_interface rti , ' ||
1071: ' po_requisition_headers_all prh , ' ||
1072: ' po_requisition_lines_all prl ,' ||
1073: ' rcv_shipment_headers rsh,' ||
1074: ' rcv_shipment_lines rsl' ||
1075: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1076: ' and rsh.ship_to_org_id = ' || l_org_id ||
1077: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1094: ' rcv_shipment_headers rsh, ' ||

1090: p_sql(34) := ' SELECT DISTINCT msi.* ' ||
1091: ' FROM po_requisition_headers_all prh, ' ||
1092: ' po_requisition_lines_all prl, ' ||
1093: ' mtl_system_items msi, ' ||
1094: ' rcv_shipment_headers rsh, ' ||
1095: ' rcv_shipment_lines rsl ' ||
1096: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1097: ' and rsh.ship_to_org_id = ' || l_org_id ||
1098: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1120: ' rcv_shipment_headers rsh, ' ||

1116: ' mtl_material_transactions mmt , ' ||
1117: ' po_requisition_lines_all prl , ' ||
1118: ' po_requisition_headers_all prh ,' ||
1119: ' rcv_transactions rt,' ||
1120: ' rcv_shipment_headers rsh, ' ||
1121: ' rcv_shipment_lines rsl ' ||
1122: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1123: ' and rsh.ship_to_org_id = ' || l_org_id ||
1124: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1144: ' rcv_shipment_headers rsh, ' ||

1140: ' mtl_material_transactions mmt , ' ||
1141: ' po_requisition_lines_all prl , ' ||
1142: ' po_requisition_headers_all prh,' ||
1143: ' oe_order_lines_all sol,' ||
1144: ' rcv_shipment_headers rsh, ' ||
1145: ' rcv_shipment_lines rsl ' ||
1146: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1147: ' and rsh.ship_to_org_id = ' || l_org_id ||
1148: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1168: ' rcv_shipment_headers rsh, ' ||

1164: ' (SELECT 1 ' ||
1165: ' FROM po_requisition_headers_all prh , ' ||
1166: ' po_requisition_lines_all prl , ' ||
1167: ' financials_system_params_all fsp , ' ||
1168: ' rcv_shipment_headers rsh, ' ||
1169: ' rcv_shipment_lines rsl ' ||
1170: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1171: ' and rsh.ship_to_org_id = ' || l_org_id ||
1172: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1190: ' rcv_shipment_headers rsh, ' ||

1186: p_sql(37) := ' SELECT DISTINCT mp.* ' ||
1187: ' FROM mtl_parameters mp , ' ||
1188: ' po_requisition_headers_all prh , ' ||
1189: ' po_requisition_lines_all prl ,' ||
1190: ' rcv_shipment_headers rsh, ' ||
1191: ' rcv_shipment_lines rsl ' ||
1192: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1193: ' and rsh.ship_to_org_id = ' || l_org_id ||
1194: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1211: ' rcv_shipment_headers rsh, ' ||

1207: ' WHERE exists ' ||
1208: ' (SELECT 1 ' ||
1209: ' FROM po_requisition_headers_all prh , ' ||
1210: ' po_requisition_lines_all prl, ' ||
1211: ' rcv_shipment_headers rsh, ' ||
1212: ' rcv_shipment_lines rsl ' ||
1213: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1214: ' and rsh.ship_to_org_id = ' || l_org_id ||
1215: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1234: ' rcv_shipment_headers rsh, ' ||

1230: ' (SELECT 1 ' ||
1231: ' FROM po_requisition_headers_all prh , ' ||
1232: ' po_requisition_lines_all prl , ' ||
1233: ' financials_system_params_all fsp, ' ||
1234: ' rcv_shipment_headers rsh, ' ||
1235: ' rcv_shipment_lines rsl ' ||
1236: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1237: ' and rsh.ship_to_org_id = ' || l_org_id ||
1238: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||