APPS.IO_DIAGNOSTICS2 dependencies on RCV_SHIPMENT_HEADERS

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

5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := NULL;
7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;
8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
9: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
10: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
11: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
12:
13: BEGIN

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

6: l_ou_id po_requisition_headers_all.org_id%TYPE := NULL;
7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;
8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
9: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
10: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
11: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
12:
13: BEGIN
14:

Line 11: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;

7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;
8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
9: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
10: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
11: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
12:
13: BEGIN
14:
15: p_sql(1) := ' SELECT DISTINCT prh.* ' ||

Line 23: ' rcv_shipment_headers rsh ' ||

19: ' AND prl.source_type_code = ''INVENTORY'' ' ||
20: ' AND requisition_line_id in ' ||
21: ' (SELECT requisition_line_id ' ||
22: ' FROM rcv_shipment_lines rsl, ' ||
23: ' rcv_shipment_headers rsh ' ||
24: ' WHERE rsh.shipment_header_id = rsl.shipment_header_id ' ||
25: ' and rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
26: ' and rsh.ship_to_org_id = ' || l_org_id ||
27: ' ) ';

Line 35: ' rcv_shipment_headers rsh ' ||

31: ' FROM po_requisition_lines_all prl ' ||
32: ' WHERE prl.requisition_line_id in ' ||
33: ' (SELECT requisition_line_id ' ||
34: ' FROM rcv_shipment_lines rsl, ' ||
35: ' rcv_shipment_headers rsh ' ||
36: ' WHERE rsh.shipment_header_id = rsl.shipment_header_id ' ||
37: ' and rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
38: ' and rsh.ship_to_org_id = ' || l_org_id ||
39: ' ) ' ||

Line 53: ' rcv_shipment_headers rsh ' ||

49: ' AND prl.source_type_code = ''INVENTORY'' ' ||
50: ' AND prl.requisition_line_id in ' ||
51: ' (SELECT requisition_line_id ' ||
52: ' FROM rcv_shipment_lines rsl, ' ||
53: ' rcv_shipment_headers rsh ' ||
54: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
55: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
56: ' and rsh.ship_to_org_id = ' || l_org_id ||
57: ' ) ';

Line 69: ' rcv_shipment_headers rsh ' ||

65: ' AND oel.source_document_line_id = prl.requisition_line_id ' ||
66: ' AND prl.requisition_line_id in ' ||
67: ' (SELECT requisition_line_id ' ||
68: ' FROM rcv_shipment_lines rsl, ' ||
69: ' rcv_shipment_headers rsh ' ||
70: ' WHERE rsh.shipment_header_id = rsl.shipment_header_id ' ||
71: ' and rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
72: ' and rsh.ship_to_org_id = ' || l_org_id ||
73: ' )' ||

Line 85: ' rcv_shipment_headers rsh, ' ||

81: ' wsh_delivery_assignments wda , ' ||
82: ' wsh_new_deliveries wnd , ' ||
83: ' oe_order_lines_all sol , ' ||
84: ' po_requisition_lines_all prl , ' ||
85: ' rcv_shipment_headers rsh, ' ||
86: ' rcv_shipment_lines rsl ' ||
87: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
88: ' and rsh.ship_to_org_id = ' || l_org_id ||
89: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 102: ' rcv_shipment_headers rsh, ' ||

98: ' FROM wsh_delivery_details wsh , ' ||
99: ' mtl_transactions_interface mti , ' ||
100: ' po_requisition_lines_all prl , ' ||
101: ' oe_order_lines_all sol, ' ||
102: ' rcv_shipment_headers rsh, ' ||
103: ' rcv_shipment_lines rsl ' ||
104: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
105: ' and rsh.ship_to_org_id = ' || l_org_id ||
106: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 117: ' rcv_shipment_headers rsh ' ||

113:
114:
115: p_sql(6) := ' SELECT DISTINCT rhi.* ' ||
116: ' FROM rcv_headers_interface rhi,' ||
117: ' rcv_shipment_headers rsh ' ||
118: ' WHERE rhi.receipt_header_id = rsh.shipment_header_id ' ||
119: ' and rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
120: ' and rsh.ship_to_org_id = ' || l_org_id ||
121: ' UNION ALL' ||

Line 152: ' FROM rcv_shipment_headers rsh ' ||

148:
149:
150:
151: p_sql(9) := ' SELECT DISTINCT rsh.* ' ||
152: ' FROM rcv_shipment_headers rsh ' ||
153: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
154: ' and rsh.ship_to_org_id = ' || l_org_id ;
155:
156:

Line 161: ' FROM rcv_shipment_headers rsh, ' ||

157:
158:
159:
160: p_sql(10) := ' SELECT DISTINCT rsl.*' ||
161: ' FROM rcv_shipment_headers rsh, ' ||
162: ' rcv_shipment_lines rsl ' ||
163: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
164: ' and rsh.ship_to_org_id = ' || l_org_id ||
165: ' AND rsh.shipment_header_id = rsl.shipment_header_id ';

Line 171: ' FROM rcv_shipment_headers rsh, ' ||

167:
168:
169:
170: p_sql(11) := ' SELECT DISTINCT rt.* ' ||
171: ' FROM rcv_shipment_headers rsh, ' ||
172: ' rcv_shipment_lines rsl, ' ||
173: ' rcv_transactions rt ' ||
174: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
175: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 185: ' rcv_shipment_headers rsh, ' ||

181:
182:
183: p_sql(12) := ' SELECT DISTINCT ms.* ' ||
184: ' FROM mtl_supply ms , ' ||
185: ' rcv_shipment_headers rsh, ' ||
186: ' rcv_shipment_lines rsl ' ||
187: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
188: ' and rsh.ship_to_org_id = ' || l_org_id ||
189: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 199: ' rcv_shipment_headers rsh, ' ||

195:
196:
197: p_sql(13) := ' SELECT DISTINCT rs.* ' ||
198: ' FROM rcv_supply rs , ' ||
199: ' rcv_shipment_headers rsh, ' ||
200: ' rcv_shipment_lines rsl ' ||
201: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
202: ' and rsh.ship_to_org_id = ' || l_org_id ||
203: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 211: ' rcv_shipment_headers rsh, ' ||

207:
208:
209: p_sql(14) := ' SELECT DISTINCT mtrl.* ' ||
210: ' FROM mtl_txn_request_lines mtrl, ' ||
211: ' rcv_shipment_headers rsh, ' ||
212: ' rcv_shipment_lines rsl, ' ||
213: ' po_requisition_lines_all prl ' ||
214: ' where rsh.shipment_num = '|| '''' || l_shipment_num || '''' ||
215: ' and rsh.ship_to_org_id = '|| l_org_id ||

Line 226: ' rcv_shipment_headers rsh, ' ||

222: ' and mtrl.line_status=7';
223:
224: /* ' SELECT DISTINCT mtrl.* ' ||
225: ' FROM mtl_txn_request_lines mtrl, ' ||
226: ' rcv_shipment_headers rsh, ' ||
227: ' rcv_shipment_lines rsl, ' ||
228: ' po_requisition_lines_all prl ' ||
229: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
230: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 242: ' rcv_shipment_headers rsh, ' ||

238:
239: p_sql(15) := ' SELECT DISTINCT mti.* ' ||
240: ' FROM mtl_transactions_interface mti, ' ||
241: ' po_requisition_lines_all prl, ' ||
242: ' rcv_shipment_headers rsh, ' ||
243: ' rcv_shipment_lines rsl, ' ||
244: ' oe_order_lines_all sol ' ||
245: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
246: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 260: ' rcv_shipment_headers rsh,' ||

256: p_sql(16) := ' SELECT DISTINCT mmtt.* ' ||
257: ' FROM mtl_material_transactions_temp mmtt , ' ||
258: ' po_requisition_lines_all prl , ' ||
259: ' rcv_shipment_lines rsl, ' ||
260: ' rcv_shipment_headers rsh,' ||
261: ' rcv_transactions rt' ||
262: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
263: ' and rsh.ship_to_org_id = ' || l_org_id ||
264: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 273: ' rcv_shipment_headers rsh,' ||

269: ' SELECT DISTINCT mmtt.* ' ||
270: ' FROM mtl_material_transactions_temp mmtt , ' ||
271: ' po_requisition_lines_all prl , ' ||
272: ' rcv_shipment_lines rsl, ' ||
273: ' rcv_shipment_headers rsh,' ||
274: ' oe_order_lines_all sol' ||
275: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
276: ' and rsh.ship_to_org_id = ' || l_org_id ||
277: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 289: ' rcv_shipment_headers rsh,' ||

285: p_sql(17) := ' SELECT DISTINCT mmt.* ' ||
286: ' FROM mtl_material_transactions mmt , ' ||
287: ' po_requisition_lines_all prl , ' ||
288: ' rcv_shipment_lines rsl, ' ||
289: ' rcv_shipment_headers rsh,' ||
290: ' rcv_transactions rt' ||
291: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
292: ' and rsh.ship_to_org_id = ' || l_org_id ||
293: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 302: ' rcv_shipment_headers rsh,' ||

298: ' SELECT DISTINCT mmt.* ' ||
299: ' FROM mtl_material_transactions mmt, ' ||
300: ' po_requisition_lines_all prl , ' ||
301: ' rcv_shipment_lines rsl, ' ||
302: ' rcv_shipment_headers rsh,' ||
303: ' oe_order_lines_all sol' ||
304: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
305: ' and rsh.ship_to_org_id = ' || l_org_id ||
306: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 318: ' rcv_shipment_headers rsh, ' ||

314: p_sql(18) := ' SELECT DISTINCT mr.* ' ||
315: ' FROM mtl_reservations mr , ' ||
316: ' oe_order_lines_all sol , ' ||
317: ' po_requisition_lines_all prl , ' ||
318: ' rcv_shipment_headers rsh, ' ||
319: ' rcv_shipment_lines rsl ' ||
320: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
321: ' and rsh.ship_to_org_id = ' || l_org_id ||
322: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 334: ' rcv_shipment_headers rsh, ' ||

330: ' FROM mtl_reservations mr , ' ||
331: ' mtl_transactions_interface mti , ' ||
332: ' po_requisition_lines_all prl , ' ||
333: ' oe_order_lines_all sol ,' ||
334: ' rcv_shipment_headers rsh, ' ||
335: ' rcv_shipment_lines rsl ' ||
336: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
337: ' and rsh.ship_to_org_id = ' || l_org_id ||
338: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 351: ' rcv_shipment_headers rsh, ' ||

347: p_sql(19) := ' SELECT DISTINCT md.* ' ||
348: ' FROM mtl_demand md , ' ||
349: ' oe_order_lines_all sol , ' ||
350: ' po_requisition_lines_all prl , ' ||
351: ' rcv_shipment_headers rsh, ' ||
352: ' rcv_shipment_lines rsl ' ||
353: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
354: ' and rsh.ship_to_org_id = ' || l_org_id ||
355: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 367: ' rcv_shipment_headers rsh, ' ||

363: ' FROM mtl_demand md , ' ||
364: ' mtl_transactions_interface mti , ' ||
365: ' po_requisition_lines_all prl , ' ||
366: ' oe_order_lines_all sol , ' ||
367: ' rcv_shipment_headers rsh, ' ||
368: ' rcv_shipment_lines rsl ' ||
369: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
370: ' and rsh.ship_to_org_id = ' || l_org_id ||
371: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 384: ' rcv_shipment_headers rsh, ' ||

380: p_sql(20) := ' SELECT DISTINCT msn.* ' ||
381: ' FROM mtl_serial_numbers msn , ' ||
382: ' mtl_material_transactions mmt , ' ||
383: ' po_requisition_lines_all prl , ' ||
384: ' rcv_shipment_headers rsh, ' ||
385: ' rcv_shipment_lines rsl,' ||
386: ' rcv_transactions rt' ||
387: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
388: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 399: ' rcv_shipment_headers rsh, ' ||

395: ' SELECT DISTINCT msn.* ' ||
396: ' FROM mtl_serial_numbers msn , ' ||
397: ' mtl_material_transactions mmt , ' ||
398: ' po_requisition_lines_all prl , ' ||
399: ' rcv_shipment_headers rsh, ' ||
400: ' rcv_shipment_lines rsl,' ||
401: ' oe_order_lines_all sol ' ||
402: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
403: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 417: ' rcv_shipment_headers rsh, ' ||

413: p_sql(21) := ' select DISTINCT msnt.*' ||
414: ' from mtl_serial_numbers_temp msnt ,' ||
415: ' mtl_system_items msi,' ||
416: ' rcv_transactions_interface rti, ' ||
417: ' rcv_shipment_headers rsh, ' ||
418: ' rcv_shipment_lines rsl ' ||
419: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
420: ' and rsh.ship_to_org_id = ' || l_org_id ||
421: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 435: ' rcv_shipment_headers rsh, ' ||

431: ' mtl_serial_numbers_temp msnt ,' ||
432: ' mtl_transaction_lots_temp mtlt,' ||
433: ' mtl_system_items msi,' ||
434: ' rcv_transactions_interface rti, ' ||
435: ' rcv_shipment_headers rsh, ' ||
436: ' rcv_shipment_lines rsl ' ||
437: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
438: ' and rsh.ship_to_org_id = ' || l_org_id ||
439: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 454: ' rcv_shipment_headers rsh, ' ||

450: ' mtl_serial_numbers_temp msnt,' ||
451: ' mtl_system_items msi,' ||
452: ' oe_order_lines_all sol,' ||
453: ' mtl_material_transactions_temp mmtt,' ||
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 rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 477: ' rcv_shipment_headers rsh, ' ||

473: ' mtl_transaction_lots_temp mtlt,' ||
474: ' mtl_system_items msi,' ||
475: ' oe_order_lines_all sol,' ||
476: ' mtl_material_transactions_temp mmtt,' ||
477: ' rcv_shipment_headers rsh, ' ||
478: ' rcv_shipment_lines rsl ' ||
479: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
480: ' and rsh.ship_to_org_id = ' || l_org_id ||
481: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 500: ' rcv_shipment_headers rsh, ' ||

496: ' FROM mtl_transactions_interface mti , ' ||
497: ' po_requisition_lines_all prl , ' ||
498: ' mtl_serial_numbers_interface msni , ' ||
499: ' mtl_system_items msi ,' ||
500: ' rcv_shipment_headers rsh, ' ||
501: ' rcv_shipment_lines rsl ' ||
502: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
503: ' and rsh.ship_to_org_id = ' || l_org_id ||
504: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 520: ' rcv_shipment_headers rsh, ' ||

516: ' po_requisition_lines_all prl , ' ||
517: ' mtl_serial_numbers_interface msni , ' ||
518: ' mtl_transaction_lots_interface mtli,' ||
519: ' mtl_system_items msi ,' ||
520: ' rcv_shipment_headers rsh, ' ||
521: ' rcv_shipment_lines rsl ' ||
522: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
523: ' and rsh.ship_to_org_id = ' || l_org_id ||
524: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 543: ' rcv_shipment_headers rsh, ' ||

539: ' po_requisition_lines_all prl , ' ||
540: ' mtl_unit_transactions mut , ' ||
541: ' mtl_system_items msi,' ||
542: ' rcv_transactions rt,' ||
543: ' rcv_shipment_headers rsh, ' ||
544: ' rcv_shipment_lines rsl ' ||
545: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
546: ' and rsh.ship_to_org_id = ' || l_org_id ||
547: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 565: ' rcv_shipment_headers rsh, ' ||

561: ' mtl_unit_transactions mut , ' ||
562: ' mtl_system_items msi , ' ||
563: ' rcv_transactions rt , ' ||
564: ' mtl_transaction_lot_numbers mtln,' ||
565: ' rcv_shipment_headers rsh, ' ||
566: ' rcv_shipment_lines rsl ' ||
567: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
568: ' and rsh.ship_to_org_id = ' || l_org_id ||
569: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 587: ' rcv_shipment_headers rsh, ' ||

583: ' po_requisition_lines_all prl , ' ||
584: ' mtl_unit_transactions mut , ' ||
585: ' mtl_system_items msi , ' ||
586: ' oe_order_lines_all sol,' ||
587: ' rcv_shipment_headers rsh, ' ||
588: ' rcv_shipment_lines rsl ' ||
589: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
590: ' and rsh.ship_to_org_id = ' || l_org_id ||
591: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 610: ' rcv_shipment_headers rsh, ' ||

606: ' mtl_unit_transactions mut , ' ||
607: ' mtl_system_items msi , ' ||
608: ' oe_order_lines_all sol , ' ||
609: ' mtl_transaction_lot_numbers mtln,' ||
610: ' rcv_shipment_headers rsh, ' ||
611: ' rcv_shipment_lines rsl ' ||
612: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
613: ' and rsh.ship_to_org_id = ' || l_org_id ||
614: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 632: ' rcv_shipment_headers rsh ' ||

628:
629: p_sql(24) := ' SELECT DISTINCT rss.* ' ||
630: ' FROM rcv_serials_supply rss , ' ||
631: ' rcv_shipment_lines rsl , ' ||
632: ' rcv_shipment_headers rsh ' ||
633: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
634: ' and rsh.ship_to_org_id = ' || l_org_id ||
635: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
636: ' AND rss.shipment_line_id = rsl.shipment_line_id ' ||

Line 642: ' rcv_shipment_headers rsh, ' ||

638: ' rss.serial_num ';
639:
640: p_sql(25) := ' SELECT DISTINCT rst.* ' ||
641: ' FROM rcv_serial_transactions rst , ' ||
642: ' rcv_shipment_headers rsh, ' ||
643: ' rcv_shipment_lines rsl ' ||
644: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
645: ' and rsh.ship_to_org_id = ' || l_org_id ||
646: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 655: ' rcv_shipment_headers rsh, ' ||

651:
652:
653: p_sql(26) := ' SELECT DISTINCT rsi.* ' ||
654: ' FROM rcv_serials_interface rsi , ' ||
655: ' rcv_shipment_headers rsh, ' ||
656: ' rcv_shipment_lines rsl ,' ||
657: ' rcv_transactions_interface rti' ||
658: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
659: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 675: ' rcv_shipment_headers rsh, ' ||

671: ' mtl_transaction_lot_numbers mtln , ' ||
672: ' mtl_material_transactions mmt , ' ||
673: ' po_requisition_lines_all prl , ' ||
674: ' rcv_transactions rt,' ||
675: ' rcv_shipment_headers rsh, ' ||
676: ' rcv_shipment_lines rsl ' ||
677: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
678: ' and rsh.ship_to_org_id = ' || l_org_id ||
679: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 695: ' rcv_shipment_headers rsh, ' ||

691: ' mtl_transaction_lot_numbers mtln , ' ||
692: ' mtl_material_transactions mmt , ' ||
693: ' po_requisition_lines_all prl , ' ||
694: ' oe_order_lines_all sol,' ||
695: ' rcv_shipment_headers rsh, ' ||
696: ' rcv_shipment_lines rsl ' ||
697: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
698: ' and rsh.ship_to_org_id = ' || l_org_id ||
699: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 716: ' rcv_shipment_headers rsh, ' ||

712: ' from mtl_transaction_lot_numbers mtln , ' ||
713: ' mtl_material_transactions mmt , ' ||
714: ' po_requisition_lines_all prl , ' ||
715: ' rcv_transactions rt,' ||
716: ' rcv_shipment_headers rsh, ' ||
717: ' rcv_shipment_lines rsl ' ||
718: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
719: ' and rsh.ship_to_org_id = ' || l_org_id ||
720: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 732: ' rcv_shipment_headers rsh, ' ||

728: ' from mtl_transaction_lot_numbers mtln , ' ||
729: ' mtl_material_transactions mmt , ' ||
730: ' po_requisition_lines_all prl , ' ||
731: ' oe_order_lines_all sol,' ||
732: ' rcv_shipment_headers rsh, ' ||
733: ' rcv_shipment_lines rsl ' ||
734: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
735: ' and rsh.ship_to_org_id = ' || l_org_id ||
736: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 751: ' rcv_shipment_headers rsh, ' ||

747: p_sql(29) := ' select distinct mtli.* ' ||
748: ' from mtl_transaction_lots_interface mtli , ' ||
749: ' mtl_transactions_interface mti , ' ||
750: ' po_requisition_lines_all prl , ' ||
751: ' rcv_shipment_headers rsh, ' ||
752: ' rcv_shipment_lines rsl ' ||
753: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
754: ' and rsh.ship_to_org_id = ' || l_org_id ||
755: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 765: ' rcv_shipment_headers rsh, ' ||

761: ' select distinct mtli.* ' ||
762: ' from mtl_transaction_lots_interface mtli , ' ||
763: ' rcv_transactions_interface rti , ' ||
764: ' po_requisition_lines_all prl , ' ||
765: ' rcv_shipment_headers rsh, ' ||
766: ' rcv_shipment_lines rsl ' ||
767: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
768: ' and rsh.ship_to_org_id = ' || l_org_id ||
769: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 782: ' rcv_shipment_headers rsh, ' ||

778: p_sql(30) := ' select distinct mtlt.* ' ||
779: ' from mtl_transaction_lots_temp mtlt ,' ||
780: ' rcv_transactions_interface rti, ' ||
781: ' po_requisition_lines_all prl , ' ||
782: ' rcv_shipment_headers rsh, ' ||
783: ' rcv_shipment_lines rsl ' ||
784: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
785: ' and rsh.ship_to_org_id = ' || l_org_id ||
786: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 797: ' rcv_shipment_headers rsh, ' ||

793: ' from mtl_transaction_lots_temp mtlt ,' ||
794: ' mtl_material_transactions_temp mmtt,' ||
795: ' po_requisition_lines_all prl , ' ||
796: ' oe_order_lines_all sol,' ||
797: ' rcv_shipment_headers rsh, ' ||
798: ' rcv_shipment_lines rsl ' ||
799: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
800: ' and rsh.ship_to_org_id = ' || l_org_id ||
801: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 811: ' rcv_shipment_headers rsh, ' ||

807:
808:
809: p_sql(31) := ' SELECT DISTINCT rls.* ' ||
810: ' FROM rcv_lots_supply rls , ' ||
811: ' rcv_shipment_headers rsh, ' ||
812: ' rcv_shipment_lines rsl' ||
813: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
814: ' and rsh.ship_to_org_id = ' || l_org_id ||
815: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 824: ' rcv_shipment_headers rsh, ' ||

820:
821:
822: p_sql(32) := ' SELECT DISTINCT rlt.* ' ||
823: ' FROM rcv_lot_transactions rlt ,' ||
824: ' rcv_shipment_headers rsh, ' ||
825: ' rcv_shipment_lines rsl ' ||
826: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
827: ' and rsh.ship_to_org_id = ' || l_org_id ||
828: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 838: ' rcv_shipment_headers rsh, ' ||

834: ' FROM rcv_lots_interface rli , ' ||
835: ' rcv_transactions_interface rti , ' ||
836: ' po_requisition_headers_all prh , ' ||
837: ' po_requisition_lines_all prl ,' ||
838: ' rcv_shipment_headers rsh, ' ||
839: ' rcv_shipment_lines rsl ' ||
840: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
841: ' and rsh.ship_to_org_id = ' || l_org_id ||
842: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 852: ' rcv_shipment_headers rsh ' ||

848:
849: p_sql(34) := ' SELECT DISTINCT msi.* ' ||
850: ' FROM mtl_system_items msi, ' ||
851: ' rcv_shipment_lines rsl, ' ||
852: ' rcv_shipment_headers rsh ' ||
853: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
854: ' and rsh.ship_to_org_id = ' || l_org_id ||
855: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
856: ' AND rsl.item_id = msi.inventory_item_id ' ||

Line 872: ' rcv_shipment_headers rsh, ' ||

868: ' mtl_material_transactions mmt , ' ||
869: ' po_requisition_lines_all prl , ' ||
870: ' po_requisition_headers_all prh ,' ||
871: ' rcv_transactions rt,' ||
872: ' rcv_shipment_headers rsh, ' ||
873: ' rcv_shipment_lines rsl ' ||
874: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
875: ' and rsh.ship_to_org_id = ' || l_org_id ||
876: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 894: ' rcv_shipment_headers rsh, ' ||

890: ' mtl_material_transactions mmt , ' ||
891: ' po_requisition_lines_all prl , ' ||
892: ' po_requisition_headers_all prh,' ||
893: ' oe_order_lines_all sol,' ||
894: ' rcv_shipment_headers rsh, ' ||
895: ' rcv_shipment_lines rsl ' ||
896: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
897: ' and rsh.ship_to_org_id = ' || l_org_id ||
898: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 910: ' rcv_shipment_headers rsh ' ||

906:
907: p_sql(36) := ' SELECT DISTINCT ood.* ' ||
908: ' FROM org_organization_definitions ood, ' ||
909: ' rcv_shipment_lines rsl, ' ||
910: ' rcv_shipment_headers rsh ' ||
911: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
912: ' and rsh.ship_to_org_id = ' || l_org_id ||
913: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
914: ' AND (rsl.to_organization_id = ood.organization_id ' ||

Line 922: ' rcv_shipment_headers rsh ' ||

918: p_sql(37) := ' SELECT DISTINCT mp.* ' ||
919: ' FROM mtl_parameters mp, ' ||
920: ' po_requisition_lines_all prl ,' ||
921: ' rcv_shipment_lines rsl, ' ||
922: ' rcv_shipment_headers rsh ' ||
923: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
924: ' and rsh.ship_to_org_id = ' || l_org_id ||
925: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
926: ' AND rsl.requisition_line_id = prl.requisition_line_id ' ||

Line 937: ' rcv_shipment_headers rsh ' ||

933: ' FROM mtl_interorg_parameters miop ' ||
934: ' WHERE exists ' ||
935: ' (SELECT DISTINCT 1 ' ||
936: ' FROM rcv_shipment_lines rsl, ' ||
937: ' rcv_shipment_headers rsh ' ||
938: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
939: ' and rsh.ship_to_org_id = ' || l_org_id ||
940: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
941: ' AND rsl.from_organization_id = miop.from_organization_id ' ||

Line 952: ' rcv_shipment_headers rsh ' ||

948: ' WHERE exists ' ||
949: ' (SELECT DISTINCT 1 ' ||
950: ' FROM po_requisition_lines_all prl , ' ||
951: ' rcv_shipment_lines rsl, ' ||
952: ' rcv_shipment_headers rsh ' ||
953: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
954: ' and rsh.ship_to_org_id = ' || l_org_id ||
955: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||
956: ' AND (rsl.to_organization_id = rp.organization_id ' ||

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

1037: IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1038: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);
1041: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
1042: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1043: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;
1044: l_count NUMBER := 0;
1045:

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

1038: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);
1041: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
1042: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1043: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;
1044: l_count NUMBER := 0;
1045:
1046: BEGIN

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

1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);
1041: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
1042: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1043: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;
1044: l_count NUMBER := 0;
1045:
1046: BEGIN
1047:

Line 1068: ' rcv_shipment_headers rsh, ' ||

1064:
1065: p_sql(2) := ' SELECT prl.* ' ||
1066: ' FROM po_requisition_headers_all prh, ' ||
1067: ' po_requisition_lines_all prl, ' ||
1068: ' rcv_shipment_headers rsh, ' ||
1069: ' rcv_shipment_lines rsl ' ||
1070: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1071: ' and rsh.ship_to_org_id = ' || l_org_id ||
1072: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1090: ' rcv_shipment_headers rsh, ' ||

1086: p_sql(3) := ' SELECT prd.* ' ||
1087: ' FROM po_requisition_headers_all prh, ' ||
1088: ' po_requisition_lines_all prl, ' ||
1089: ' po_req_distributions_all prd, ' ||
1090: ' rcv_shipment_headers rsh, ' ||
1091: ' rcv_shipment_lines rsl ' ||
1092: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1093: ' and rsh.ship_to_org_id = ' || l_org_id ||
1094: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1111: ' rcv_shipment_headers rsh, ' ||

1107: p_sql(4) := ' SELECT oel.* ' ||
1108: ' FROM oe_order_lines_all oel, ' ||
1109: ' po_requisition_lines_all prl, ' ||
1110: ' po_requisition_headers_all prh,' ||
1111: ' rcv_shipment_headers rsh, ' ||
1112: ' rcv_shipment_lines rsl ' ||
1113: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1114: ' and rsh.ship_to_org_id = ' || l_org_id ||
1115: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1133: ' rcv_shipment_headers rsh, ' ||

1129: ' wsh_new_deliveries wnd , ' ||
1130: ' oe_order_lines_all sol , ' ||
1131: ' po_requisition_lines_all prl , ' ||
1132: ' po_requisition_headers_all prh , ' ||
1133: ' rcv_shipment_headers rsh, ' ||
1134: ' rcv_shipment_lines rsl ' ||
1135: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1136: ' and rsh.ship_to_org_id = ' || l_org_id ||
1137: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1155: ' rcv_shipment_headers rsh, ' ||

1151: ' mtl_transactions_interface mti , ' ||
1152: ' po_requisition_lines_all prl , ' ||
1153: ' po_requisition_headers_all prh , ' ||
1154: ' oe_order_lines_all sol, ' ||
1155: ' rcv_shipment_headers rsh, ' ||
1156: ' rcv_shipment_lines rsl ' ||
1157: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1158: ' and rsh.ship_to_org_id = ' || l_org_id ||
1159: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1173: ' rcv_shipment_headers rsh ' ||

1169:
1170:
1171: p_sql(6) := ' SELECT rhi.* ' ||
1172: ' FROM rcv_headers_interface rhi,' ||
1173: ' rcv_shipment_headers rsh ' ||
1174: ' WHERE rhi.receipt_header_id = rsh.shipment_header_id ' ||
1175: ' and rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1176: ' and rsh.ship_to_org_id = ' || l_org_id ;
1177:

Line 1199: ' FROM rcv_shipment_headers rsh , ' ||

1195: ' where rti.shipment_num = ' || '''' || l_shipment_num || '''' ||
1196: ' and rti.to_organization_id = ' || l_org_id || '))';
1197:
1198: p_sql(9) := ' SELECT DISTINCT rsh.* ' ||
1199: ' FROM rcv_shipment_headers rsh , ' ||
1200: ' rcv_shipment_lines rsl , ' ||
1201: ' po_requisition_headers_all prh , ' ||
1202: ' po_requisition_lines_all prl ' ||
1203: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1217: ' FROM rcv_shipment_headers rsh, ' ||

1213:
1214:
1215:
1216: p_sql(10) := ' SELECT rsl.* ' ||
1217: ' FROM rcv_shipment_headers rsh, ' ||
1218: ' rcv_shipment_lines rsl , ' ||
1219: ' po_requisition_headers_all prh , ' ||
1220: ' po_requisition_lines_all prl ' ||
1221: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1236: ' rcv_shipment_headers rsh, ' ||

1232: p_sql(11) := ' SELECT rt.* ' ||
1233: ' FROM rcv_transactions rt , ' ||
1234: ' po_requisition_headers_all prh , ' ||
1235: ' po_requisition_lines_all prl ,' ||
1236: ' rcv_shipment_headers rsh, ' ||
1237: ' rcv_shipment_lines rsl ' ||
1238: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1239: ' and rsh.ship_to_org_id = ' || l_org_id ||
1240: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1254: ' rcv_shipment_headers rsh, ' ||

1250: p_sql(12) := ' SELECT ms.* ' ||
1251: ' FROM mtl_supply ms , ' ||
1252: ' po_requisition_headers_all prh , ' ||
1253: ' po_requisition_lines_all prl ,' ||
1254: ' rcv_shipment_headers rsh, ' ||
1255: ' rcv_shipment_lines rsl ' ||
1256: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1257: ' and rsh.ship_to_org_id = ' || l_org_id ||
1258: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1276: ' rcv_shipment_headers rsh, ' ||

1272: p_sql(13) := ' SELECT rs.* ' ||
1273: ' FROM rcv_supply rs , ' ||
1274: ' po_requisition_headers_all prh ,' ||
1275: ' po_requisition_lines_all prl,' ||
1276: ' rcv_shipment_headers rsh, ' ||
1277: ' rcv_shipment_lines rsl ' ||
1278: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1279: ' and rsh.ship_to_org_id = ' || l_org_id ||
1280: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1291: ' rcv_shipment_headers rsh, ' ||

1287: ' AND rs.shipment_header_id = rsh.shipment_header_id ';
1288:
1289: p_sql(14) := ' SELECT mtrl.* ' ||
1290: ' FROM mtl_txn_request_lines mtrl, ' ||
1291: ' rcv_shipment_headers rsh, ' ||
1292: ' rcv_shipment_lines rsl, ' ||
1293: ' po_requisition_headers_all prh, ' ||
1294: ' po_requisition_lines_all prl ' ||
1295: ' WHERE rsh.shipment_num = '|| '''' || l_shipment_num || '''' ||

Line 1312: ' rcv_shipment_headers rsh, ' ||

1308: ' and mtrl.line_status=7';
1309:
1310: /*' SELECT mtrl.* ' ||
1311: ' FROM mtl_txn_request_lines mtrl, ' ||
1312: ' rcv_shipment_headers rsh, ' ||
1313: ' rcv_shipment_lines rsl, ' ||
1314: ' po_requisition_headers_all prh, ' ||
1315: ' po_requisition_lines_all prl ' ||
1316: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1334: ' RCV_SHIPMENT_HEADERS RSH, ' ||

1330: ' FROM MTL_TRANSACTIONS_INTERFACE MTI, ' ||
1331: ' PO_REQUISITION_LINES_ALL PRL, ' ||
1332: ' PO_REQUISITION_HEADERS_ALL PRH, ' ||
1333: ' OE_ORDER_LINES_ALL SOL, ' ||
1334: ' RCV_SHIPMENT_HEADERS RSH, ' ||
1335: ' RCV_SHIPMENT_LINES RSL ' ||
1336: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1337: ' and rsh.ship_to_org_id = ' || l_org_id ||
1338: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1354: ' rcv_shipment_headers rsh, ' ||

1350: p_sql(16) := ' SELECT mmtt.* ' ||
1351: ' FROM mtl_material_transactions_temp mmtt , ' ||
1352: ' po_requisition_lines_all prl , ' ||
1353: ' po_requisition_headers_all prh, ' ||
1354: ' rcv_shipment_headers rsh, ' ||
1355: ' rcv_shipment_lines rsl,' ||
1356: ' rcv_transactions rt ' ||
1357: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1358: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1376: ' rcv_shipment_headers rsh, ' ||

1372: ' SELECT mmtt.* ' ||
1373: ' FROM mtl_material_transactions_temp mmtt , ' ||
1374: ' po_requisition_lines_all prl , ' ||
1375: ' po_requisition_headers_all prh, ' ||
1376: ' rcv_shipment_headers rsh, ' ||
1377: ' rcv_shipment_lines rsl,' ||
1378: ' oe_order_lines_all sol ' ||
1379: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1380: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1400: ' rcv_shipment_headers rsh, ' ||

1396: p_sql(17) := ' SELECT mmt.* ' ||
1397: ' FROM mtl_material_transactions mmt , ' ||
1398: ' po_requisition_lines_all prl , ' ||
1399: ' po_requisition_headers_all prh, ' ||
1400: ' rcv_shipment_headers rsh, ' ||
1401: ' rcv_shipment_lines rsl,' ||
1402: ' rcv_transactions rt ' ||
1403: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1404: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1421: ' rcv_shipment_headers rsh, ' ||

1417: ' SELECT mmt.* ' ||
1418: ' FROM mtl_material_transactions mmt , ' ||
1419: ' po_requisition_lines_all prl , ' ||
1420: ' po_requisition_headers_all prh, ' ||
1421: ' rcv_shipment_headers rsh, ' ||
1422: ' rcv_shipment_lines rsl,' ||
1423: ' oe_order_lines_all sol ' ||
1424: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1425: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1445: ' rcv_shipment_headers rsh, ' ||

1441: ' FROM mtl_reservations mr , ' ||
1442: ' oe_order_lines_all sol , ' ||
1443: ' po_requisition_lines_all prl , ' ||
1444: ' po_requisition_headers_all prh, ' ||
1445: ' rcv_shipment_headers rsh, ' ||
1446: ' rcv_shipment_lines rsl ' ||
1447: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1448: ' and rsh.ship_to_org_id = ' || l_org_id ||
1449: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1466: ' rcv_shipment_headers rsh, ' ||

1462: ' mtl_transactions_interface mti , ' ||
1463: ' po_requisition_lines_all prl , ' ||
1464: ' po_requisition_headers_all prh , ' ||
1465: ' oe_order_lines_all sol ,' ||
1466: ' rcv_shipment_headers rsh, ' ||
1467: ' rcv_shipment_lines rsl ' ||
1468: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1469: ' and rsh.ship_to_org_id = ' || l_org_id ||
1470: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1486: ' rcv_shipment_headers rsh, ' ||

1482: ' FROM mtl_demand md , ' ||
1483: ' oe_order_lines_all sol , ' ||
1484: ' po_requisition_lines_all prl , ' ||
1485: ' po_requisition_headers_all prh , ' ||
1486: ' rcv_shipment_headers rsh, ' ||
1487: ' rcv_shipment_lines rsl ' ||
1488: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1489: ' and rsh.ship_to_org_id = ' || l_org_id ||
1490: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1508: ' rcv_shipment_headers rsh, ' ||

1504: ' mtl_transactions_interface mti , ' ||
1505: ' po_requisition_lines_all prl , ' ||
1506: ' po_requisition_headers_all prh , ' ||
1507: ' oe_order_lines_all sol , ' ||
1508: ' rcv_shipment_headers rsh, ' ||
1509: ' rcv_shipment_lines rsl ' ||
1510: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1511: ' and rsh.ship_to_org_id = ' || l_org_id ||
1512: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1534: ' rcv_shipment_headers rsh, ' ||

1530: ' from mtl_serial_numbers msn , ' ||
1531: ' mtl_material_transactions mmt , ' ||
1532: ' po_requisition_lines_all prl , ' ||
1533: ' po_requisition_headers_all prh ,' ||
1534: ' rcv_shipment_headers rsh, ' ||
1535: ' rcv_shipment_lines rsl ,' ||
1536: ' rcv_transactions rt' ||
1537: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1538: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1556: ' rcv_shipment_headers rsh, ' ||

1552: ' mtl_material_transactions mmt , ' ||
1553: ' po_requisition_lines_all prl , ' ||
1554: ' po_requisition_headers_all prh ,' ||
1555: ' oe_order_lines_all sol,' ||
1556: ' rcv_shipment_headers rsh, ' ||
1557: ' rcv_shipment_lines rsl ' ||
1558: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1559: ' and rsh.ship_to_org_id = ' || l_org_id ||
1560: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1580: ' rcv_shipment_headers rsh, ' ||

1576: ' po_requisition_headers_all prh ,' ||
1577: ' mtl_serial_numbers_temp msnt ,' ||
1578: ' mtl_system_items msi,' ||
1579: ' rcv_transactions_interface rti,' ||
1580: ' rcv_shipment_headers rsh, ' ||
1581: ' rcv_shipment_lines rsl ' ||
1582: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1583: ' and rsh.ship_to_org_id = ' || l_org_id ||
1584: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1607: ' rcv_shipment_headers rsh, ' ||

1603: ' mtl_serial_numbers_temp msnt ,' ||
1604: ' mtl_transaction_lots_temp mtlt,' ||
1605: ' mtl_system_items msi,' ||
1606: ' rcv_transactions_interface rti,' ||
1607: ' rcv_shipment_headers rsh, ' ||
1608: ' rcv_shipment_lines rsl ' ||
1609: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1610: ' and rsh.ship_to_org_id = ' || l_org_id ||
1611: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1635: ' rcv_shipment_headers rsh, ' ||

1631: ' mtl_serial_numbers_temp msnt,' ||
1632: ' mtl_system_items msi,' ||
1633: ' oe_order_lines_all sol,' ||
1634: ' mtl_material_transactions_temp mmtt,' ||
1635: ' rcv_shipment_headers rsh, ' ||
1636: ' rcv_shipment_lines rsl ' ||
1637: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1638: ' and rsh.ship_to_org_id = ' || l_org_id ||
1639: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1663: ' rcv_shipment_headers rsh, ' ||

1659: ' mtl_transaction_lots_temp mtlt,' ||
1660: ' mtl_system_items msi,' ||
1661: ' oe_order_lines_all sol,' ||
1662: ' mtl_material_transactions_temp mmtt,' ||
1663: ' rcv_shipment_headers rsh, ' ||
1664: ' rcv_shipment_lines rsl ' ||
1665: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1666: ' and rsh.ship_to_org_id = ' || l_org_id ||
1667: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1692: ' rcv_shipment_headers rsh, ' ||

1688: ' po_requisition_lines_all prl , ' ||
1689: ' po_requisition_headers_all prh , ' ||
1690: ' mtl_serial_numbers_interface msni ,' ||
1691: ' mtl_system_items msi,' ||
1692: ' rcv_shipment_headers rsh, ' ||
1693: ' rcv_shipment_lines rsl ' ||
1694: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1695: ' and rsh.ship_to_org_id = ' || l_org_id ||
1696: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1719: ' rcv_shipment_headers rsh, ' ||

1715: ' po_requisition_headers_all prh , ' ||
1716: ' mtl_serial_numbers_interface msni ,' ||
1717: ' mtl_transaction_lots_interface mtli,' ||
1718: ' mtl_system_items msi,' ||
1719: ' rcv_shipment_headers rsh, ' ||
1720: ' rcv_shipment_lines rsl ' ||
1721: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1722: ' and rsh.ship_to_org_id = ' || l_org_id ||
1723: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1747: ' rcv_shipment_headers rsh, ' ||

1743: ' po_requisition_lines_all prl , ' ||
1744: ' mtl_unit_transactions mut , ' ||
1745: ' mtl_system_items msi, ' ||
1746: ' rcv_transactions rt, ' ||
1747: ' rcv_shipment_headers rsh, ' ||
1748: ' rcv_shipment_lines rsl ' ||
1749: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1750: ' and rsh.ship_to_org_id = ' || l_org_id ||
1751: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1770: ' rcv_shipment_headers rsh, ' ||

1766: ' mtl_unit_transactions mut , ' ||
1767: ' mtl_system_items msi , ' ||
1768: ' rcv_transactions rt , ' ||
1769: ' mtl_transaction_lot_numbers mtln, ' ||
1770: ' rcv_shipment_headers rsh, ' ||
1771: ' rcv_shipment_lines rsl ' ||
1772: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1773: ' and rsh.ship_to_org_id = ' || l_org_id ||
1774: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1793: ' rcv_shipment_headers rsh, ' ||

1789: ' po_requisition_lines_all prl , ' ||
1790: ' mtl_unit_transactions mut , ' ||
1791: ' mtl_system_items msi , ' ||
1792: ' oe_order_lines_all sol, ' ||
1793: ' rcv_shipment_headers rsh, ' ||
1794: ' rcv_shipment_lines rsl ' ||
1795: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1796: ' and rsh.ship_to_org_id = ' || l_org_id ||
1797: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1817: ' rcv_shipment_headers rsh, ' ||

1813: ' mtl_unit_transactions mut , ' ||
1814: ' mtl_system_items msi , ' ||
1815: ' oe_order_lines_all sol , ' ||
1816: ' mtl_transaction_lot_numbers mtln, ' ||
1817: ' rcv_shipment_headers rsh, ' ||
1818: ' rcv_shipment_lines rsl ' ||
1819: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1820: ' and rsh.ship_to_org_id = ' || l_org_id ||
1821: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1845: ' rcv_shipment_headers rsh ' ||

1841: ' FROM rcv_serials_supply rss , ' ||
1842: ' rcv_shipment_lines rsl , ' ||
1843: ' po_requisition_headers_all prh , ' ||
1844: ' po_requisition_lines_all prl , ' ||
1845: ' rcv_shipment_headers rsh ' ||
1846: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1847: ' and rsh.ship_to_org_id = ' || l_org_id ||
1848: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1849: ' and prh.org_id = ' || l_ou_id ||

Line 1865: ' rcv_shipment_headers rsh ' ||

1861: ' FROM rcv_serial_transactions rst , ' ||
1862: ' rcv_shipment_lines rsl , ' ||
1863: ' po_requisition_headers_all prh , ' ||
1864: ' po_requisition_lines_all prl , ' ||
1865: ' rcv_shipment_headers rsh ' ||
1866: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1867: ' and rsh.ship_to_org_id = ' || l_org_id ||
1868: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1869: ' and prh.org_id = ' || l_ou_id ||

Line 1885: ' rcv_shipment_headers rsh ,' ||

1881: ' FROM rcv_serials_interface rsi , ' ||
1882: ' rcv_shipment_lines rsl , ' ||
1883: ' po_requisition_headers_all prh , ' ||
1884: ' po_requisition_lines_all prl , ' ||
1885: ' rcv_shipment_headers rsh ,' ||
1886: ' rcv_transactions_interface rti' ||
1887: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1888: ' and rsh.ship_to_org_id = ' || l_org_id ||
1889: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1911: ' rcv_shipment_headers rsh,' ||

1907: ' mtl_transaction_lot_numbers mtln ,' ||
1908: ' mtl_material_transactions mmt ,' ||
1909: ' po_requisition_lines_all prl ,' ||
1910: ' rcv_transactions rt,' ||
1911: ' rcv_shipment_headers rsh,' ||
1912: ' rcv_shipment_lines rsl ' ||
1913: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1914: ' and rsh.ship_to_org_id = ' || '''' || l_org_id || '''' ||
1915: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1932: ' rcv_shipment_headers rsh, ' ||

1928: ' mtl_transaction_lot_numbers mtln ,' ||
1929: ' mtl_material_transactions mmt , ' ||
1930: ' po_requisition_lines_all prl , ' ||
1931: ' oe_order_lines_all sol,' ||
1932: ' rcv_shipment_headers rsh, ' ||
1933: ' rcv_shipment_lines rsl ' ||
1934: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1935: ' and rsh.ship_to_org_id = ' || '''' || l_org_id || '''' ||
1936: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1954: ' rcv_shipment_headers rsh, ' ||

1950: ' from mtl_transaction_lot_numbers mtln ,' ||
1951: ' mtl_material_transactions mmt , ' ||
1952: ' po_requisition_lines_all prl , ' ||
1953: ' rcv_transactions rt,' ||
1954: ' rcv_shipment_headers rsh, ' ||
1955: ' rcv_shipment_lines rsl ' ||
1956: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1957: ' and rsh.ship_to_org_id = ' || l_org_id ||
1958: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1971: ' rcv_shipment_headers rsh, ' ||

1967: ' from mtl_transaction_lot_numbers mtln , ' ||
1968: ' mtl_material_transactions mmt , ' ||
1969: ' po_requisition_lines_all prl , ' ||
1970: ' oe_order_lines_all sol,' ||
1971: ' rcv_shipment_headers rsh, ' ||
1972: ' rcv_shipment_lines rsl ' ||
1973: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1974: ' and rsh.ship_to_org_id = ' || l_org_id ||
1975: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1991: ' rcv_shipment_headers rsh, ' ||

1987: p_sql(29) := ' select distinct mtli.* ' ||
1988: ' from mtl_transaction_lots_interface mtli , ' ||
1989: ' mtl_transactions_interface mti , ' ||
1990: ' po_requisition_lines_all prl , ' ||
1991: ' rcv_shipment_headers rsh, ' ||
1992: ' rcv_shipment_lines rsl ' ||
1993: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1994: ' and rsh.ship_to_org_id = ' || l_org_id ||
1995: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 2006: ' rcv_shipment_headers rsh, ' ||

2002: ' select distinct mtli.* ' ||
2003: ' from mtl_transaction_lots_interface mtli , ' ||
2004: ' rcv_transactions_interface rti , ' ||
2005: ' po_requisition_lines_all prl , ' ||
2006: ' rcv_shipment_headers rsh, ' ||
2007: ' rcv_shipment_lines rsl ' ||
2008: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2009: ' and rsh.ship_to_org_id = ' || l_org_id ||
2010: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 2027: ' rcv_shipment_headers rsh, ' ||

2023: p_sql(30) := ' select distinct mtlt.* ' ||
2024: ' from mtl_transaction_lots_temp mtlt ,' ||
2025: ' rcv_transactions_interface rti, ' ||
2026: ' po_requisition_lines_all prl , ' ||
2027: ' rcv_shipment_headers rsh, ' ||
2028: ' rcv_shipment_lines rsl ' ||
2029: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2030: ' and rsh.ship_to_org_id = ' || l_org_id ||
2031: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 2043: ' rcv_shipment_headers rsh, ' ||

2039: ' from mtl_transaction_lots_temp mtlt ,' ||
2040: ' mtl_material_transactions_temp mmtt, ' ||
2041: ' po_requisition_lines_all prl , ' ||
2042: ' oe_order_lines_all sol,' ||
2043: ' rcv_shipment_headers rsh, ' ||
2044: ' rcv_shipment_lines rsl ' ||
2045: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2046: ' and rsh.ship_to_org_id = ' || l_org_id ||
2047: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 2062: ' rcv_shipment_headers rsh ' ||

2058: ' rcv_shipment_lines rsl , ' ||
2059: ' po_requisition_headers_all prh , ' ||
2060: ' po_requisition_lines_all prl , ' ||
2061: ' oe_order_lines_all sol , ' ||
2062: ' rcv_shipment_headers rsh ' ||
2063: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2064: ' and rsh.ship_to_org_id = ' || l_org_id ||
2065: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
2066: ' and prh.org_id = ' || l_ou_id ||

Line 2085: ' rcv_shipment_headers rsh ' ||

2081: ' FROM rcv_lot_transactions rlt , ' ||
2082: ' rcv_shipment_lines rsl , ' ||
2083: ' po_requisition_headers_all prh , ' ||
2084: ' po_requisition_lines_all prl , ' ||
2085: ' rcv_shipment_headers rsh ' ||
2086: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2087: ' and rsh.ship_to_org_id = ' || l_org_id ||
2088: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
2089: ' and prh.org_id = ' || l_ou_id ||

Line 2105: ' rcv_shipment_headers rsh,' ||

2101: ' FROM rcv_lots_interface rli , ' ||
2102: ' rcv_transactions_interface rti , ' ||
2103: ' po_requisition_headers_all prh , ' ||
2104: ' po_requisition_lines_all prl ,' ||
2105: ' rcv_shipment_headers rsh,' ||
2106: ' rcv_shipment_lines rsl' ||
2107: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2108: ' and rsh.ship_to_org_id = ' || l_org_id ||
2109: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2126: ' rcv_shipment_headers rsh, ' ||

2122: p_sql(34) := ' SELECT DISTINCT msi.* ' ||
2123: ' FROM po_requisition_headers_all prh, ' ||
2124: ' po_requisition_lines_all prl, ' ||
2125: ' mtl_system_items msi, ' ||
2126: ' rcv_shipment_headers rsh, ' ||
2127: ' rcv_shipment_lines rsl ' ||
2128: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2129: ' and rsh.ship_to_org_id = ' || l_org_id ||
2130: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2152: ' rcv_shipment_headers rsh, ' ||

2148: ' mtl_material_transactions mmt , ' ||
2149: ' po_requisition_lines_all prl , ' ||
2150: ' po_requisition_headers_all prh ,' ||
2151: ' rcv_transactions rt,' ||
2152: ' rcv_shipment_headers rsh, ' ||
2153: ' rcv_shipment_lines rsl ' ||
2154: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2155: ' and rsh.ship_to_org_id = ' || l_org_id ||
2156: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2176: ' rcv_shipment_headers rsh, ' ||

2172: ' mtl_material_transactions mmt , ' ||
2173: ' po_requisition_lines_all prl , ' ||
2174: ' po_requisition_headers_all prh,' ||
2175: ' oe_order_lines_all sol,' ||
2176: ' rcv_shipment_headers rsh, ' ||
2177: ' rcv_shipment_lines rsl ' ||
2178: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2179: ' and rsh.ship_to_org_id = ' || l_org_id ||
2180: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2200: ' rcv_shipment_headers rsh, ' ||

2196: ' (SELECT 1 ' ||
2197: ' FROM po_requisition_headers_all prh , ' ||
2198: ' po_requisition_lines_all prl , ' ||
2199: ' financials_system_params_all fsp , ' ||
2200: ' rcv_shipment_headers rsh, ' ||
2201: ' rcv_shipment_lines rsl ' ||
2202: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2203: ' and rsh.ship_to_org_id = ' || l_org_id ||
2204: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2222: ' rcv_shipment_headers rsh, ' ||

2218: p_sql(37) := ' SELECT DISTINCT mp.* ' ||
2219: ' FROM mtl_parameters mp , ' ||
2220: ' po_requisition_headers_all prh , ' ||
2221: ' po_requisition_lines_all prl ,' ||
2222: ' rcv_shipment_headers rsh, ' ||
2223: ' rcv_shipment_lines rsl ' ||
2224: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2225: ' and rsh.ship_to_org_id = ' || l_org_id ||
2226: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2243: ' rcv_shipment_headers rsh, ' ||

2239: ' WHERE exists ' ||
2240: ' (SELECT 1 ' ||
2241: ' FROM po_requisition_headers_all prh , ' ||
2242: ' po_requisition_lines_all prl, ' ||
2243: ' rcv_shipment_headers rsh, ' ||
2244: ' rcv_shipment_lines rsl ' ||
2245: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2246: ' and rsh.ship_to_org_id = ' || l_org_id ||
2247: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 2266: ' rcv_shipment_headers rsh, ' ||

2262: ' (SELECT 1 ' ||
2263: ' FROM po_requisition_headers_all prh , ' ||
2264: ' po_requisition_lines_all prl , ' ||
2265: ' financials_system_params_all fsp, ' ||
2266: ' rcv_shipment_headers rsh, ' ||
2267: ' rcv_shipment_lines rsl ' ||
2268: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2269: ' and rsh.ship_to_org_id = ' || l_org_id ||
2270: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||