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_DIAGNOSTICS2 dependencies on PO_REQUISITION_LINES_ALL

Line 8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;

4: PROCEDURE receipt_shipment_sql(p_shipment_num IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT
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:

Line 17: ' po_requisition_lines_all prl ' ||

13: BEGIN
14:
15: p_sql(1) := ' SELECT DISTINCT prh.* ' ||
16: ' FROM po_requisition_headers_all prh, ' ||
17: ' po_requisition_lines_all prl ' ||
18: ' WHERE prh.requisition_header_id = prl.requisition_header_id ' ||
19: ' AND prl.source_type_code = ''INVENTORY'' ' ||
20: ' AND requisition_line_id in ' ||
21: ' (SELECT requisition_line_id ' ||

Line 31: ' FROM po_requisition_lines_all prl ' ||

27: ' ) ';
28:
29:
30: p_sql(2) := ' SELECT DISTINCT prl.* ' ||
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 ' ||

Line 47: ' po_requisition_lines_all prl ' ||

43:
44:
45: p_sql(3) := ' SELECT DISTINCT prd.* ' ||
46: ' FROM po_req_distributions_all prd , ' ||
47: ' po_requisition_lines_all prl ' ||
48: ' WHERE prl.requisition_line_id = prd.requisition_line_id ' ||
49: ' AND prl.source_type_code = ''INVENTORY'' ' ||
50: ' AND prl.requisition_line_id in ' ||
51: ' (SELECT requisition_line_id ' ||

Line 63: ' po_requisition_lines_all prl ' ||

59:
60:
61: p_sql(4) := ' SELECT DISTINCT oel.* ' ||
62: ' FROM oe_order_lines_all oel, ' ||
63: ' po_requisition_lines_all prl ' ||
64: ' WHERE oel.source_document_type_id = 10 ' ||
65: ' AND oel.source_document_line_id = prl.requisition_line_id ' ||
66: ' AND prl.requisition_line_id in ' ||
67: ' (SELECT requisition_line_id ' ||

Line 84: ' po_requisition_lines_all prl , ' ||

80: ' FROM wsh_delivery_details wsh , ' ||
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 ||

Line 100: ' po_requisition_lines_all prl , ' ||

96: ' UNION ALL ' ||
97: ' SELECT DISTINCT wsh.* ' ||
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 || '''' ||

Line 213: ' po_requisition_lines_all prl ' ||

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 ||
216: ' AND rsh.receipt_source_code = ''INTERNAL ORDER'' ' ||
217: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 228: ' po_requisition_lines_all prl ' ||

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 ||
231: ' AND rsh.receipt_source_code = ''INTERNAL ORDER'' ' ||
232: ' AND rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 241: ' po_requisition_lines_all prl, ' ||

237:
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 || '''' ||

Line 258: ' po_requisition_lines_all prl , ' ||

254:
255:
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 || '''' ||

Line 271: ' po_requisition_lines_all prl , ' ||

267: ' AND mmtt.rcv_transaction_id = rt.transaction_id ' ||
268: ' UNION ALL' ||
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 || '''' ||

Line 287: ' po_requisition_lines_all prl , ' ||

283:
284:
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 || '''' ||

Line 300: ' po_requisition_lines_all prl , ' ||

296: ' AND mmt.rcv_transaction_id = rt.transaction_id ' ||
297: ' UNION ALL' ||
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 || '''' ||

Line 317: ' po_requisition_lines_all prl , ' ||

313:
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 ||

Line 332: ' po_requisition_lines_all prl , ' ||

328: ' UNION ALL ' ||
329: ' SELECT DISTINCT mr.* ' ||
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 || '''' ||

Line 350: ' po_requisition_lines_all prl , ' ||

346:
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 ||

Line 365: ' po_requisition_lines_all prl , ' ||

361: ' UNION ALL ' ||
362: ' SELECT DISTINCT md.* ' ||
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 || '''' ||

Line 383: ' po_requisition_lines_all prl , ' ||

379:
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 || '''' ||

Line 398: ' po_requisition_lines_all prl , ' ||

394: ' UNION ALL' ||
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 || '''' ||

Line 449: ' from po_requisition_lines_all prl, ' ||

445: ' and msi.serial_number_control_code <> 1' ||
446: ' and msi.lot_control_code <> 1' ||
447: ' UNION ALL' ||
448: ' select DISTINCT msnt.*' ||
449: ' from po_requisition_lines_all prl, ' ||
450: ' mtl_serial_numbers_temp msnt,' ||
451: ' mtl_system_items msi,' ||
452: ' oe_order_lines_all sol,' ||
453: ' mtl_material_transactions_temp mmtt,' ||

Line 471: ' from po_requisition_lines_all prl,' ||

467: ' and msi.serial_number_control_code <> 1' ||
468: ' and msi.lot_control_code = 1' ||
469: ' UNION ALL' ||
470: ' select DISTINCT msnt.*' ||
471: ' from po_requisition_lines_all prl,' ||
472: ' mtl_serial_numbers_temp msnt,' ||
473: ' mtl_transaction_lots_temp mtlt,' ||
474: ' mtl_system_items msi,' ||
475: ' oe_order_lines_all sol,' ||

Line 497: ' po_requisition_lines_all prl , ' ||

493:
494:
495: p_sql(22) := ' SELECT DISTINCT msni.* ' ||
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 ' ||

Line 516: ' po_requisition_lines_all prl , ' ||

512: ' and msi.lot_control_code = 1' ||
513: ' UNION ALL' ||
514: ' SELECT DISTINCT msni.* ' ||
515: ' FROM mtl_transactions_interface mti , ' ||
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, ' ||

Line 539: ' po_requisition_lines_all prl , ' ||

535:
536:
537: p_sql(23) := ' select distinct mut.* ' ||
538: ' from mtl_material_transactions mmt , ' ||
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, ' ||

Line 560: ' po_requisition_lines_all prl ,' ||

556: ' and msi.lot_control_code = 1 ' ||
557: ' union all ' ||
558: ' select distinct mut.*' ||
559: ' from mtl_material_transactions mmt ,' ||
560: ' po_requisition_lines_all prl ,' ||
561: ' mtl_unit_transactions mut , ' ||
562: ' mtl_system_items msi , ' ||
563: ' rcv_transactions rt , ' ||
564: ' mtl_transaction_lot_numbers mtln,' ||

Line 583: ' po_requisition_lines_all prl , ' ||

579: ' and msi.lot_control_code <> 1' ||
580: ' union all' ||
581: ' select distinct mut.* ' ||
582: ' from mtl_material_transactions mmt , ' ||
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, ' ||

Line 605: ' po_requisition_lines_all prl , ' ||

601: ' and msi.lot_control_code = 1' ||
602: ' union all' ||
603: ' select distinct mut.*' ||
604: ' from mtl_material_transactions mmt , ' ||
605: ' po_requisition_lines_all prl , ' ||
606: ' mtl_unit_transactions mut , ' ||
607: ' mtl_system_items msi , ' ||
608: ' oe_order_lines_all sol , ' ||
609: ' mtl_transaction_lot_numbers mtln,' ||

Line 673: ' po_requisition_lines_all prl , ' ||

669: p_sql(27) := ' select distinct mln.* ' ||
670: ' from mtl_lot_numbers mln , ' ||
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 || '''' ||

Line 693: ' po_requisition_lines_all prl , ' ||

689: ' select distinct mln.* ' ||
690: ' from mtl_lot_numbers mln , ' ||
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 || '''' ||

Line 714: ' po_requisition_lines_all prl , ' ||

710:
711: p_sql(28) := ' select distinct mtln.* ' ||
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 || '''' ||

Line 730: ' po_requisition_lines_all prl , ' ||

726: ' UNION ALL' ||
727: ' select distinct mtln.* ' ||
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 || '''' ||

Line 750: ' po_requisition_lines_all prl , ' ||

746:
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 ||

Line 764: ' po_requisition_lines_all prl , ' ||

760: ' UNION ALL' ||
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 ||

Line 781: ' po_requisition_lines_all prl , ' ||

777:
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 ||

Line 795: ' po_requisition_lines_all prl , ' ||

791: ' UNION ALL' ||
792: ' select distinct mtlt.* ' ||
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 || '''' ||

Line 837: ' po_requisition_lines_all prl ,' ||

833: p_sql(33) := ' SELECT DISTINCT rli.* ' ||
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 ||

Line 869: ' po_requisition_lines_all prl , ' ||

865: ' mtt.user_defined_flag , ' ||
866: ' mtt.disable_date ' ||
867: ' from mtl_transaction_types mtt , ' ||
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 ' ||

Line 891: ' po_requisition_lines_all prl , ' ||

887: ' mtt.user_defined_flag , ' ||
888: ' mtt.disable_date ' ||
889: ' from mtl_transaction_types mtt , ' ||
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 ' ||

Line 920: ' po_requisition_lines_all prl ,' ||

916:
917:
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 ||

Line 950: ' FROM po_requisition_lines_all prl , ' ||

946: p_sql(39) := ' SELECT DISTINCT rp.* ' ||
947: ' FROM rcv_parameters rp ' ||
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 ||

Line 1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);

1036: PROCEDURE req_line_receipt_shipment_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_line_num IN NUMBER, 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;

Line 1054: ' po_requisition_lines_all prl ' ||

1050:
1051:
1052: p_sql(1) := ' SELECT prh.* ' ||
1053: ' FROM po_requisition_headers_all prh, ' ||
1054: ' po_requisition_lines_all prl ' ||
1055: ' where prh.segment1 = ' || '''' || l_req_num || '''' ||
1056: ' and prh.org_id = ' || l_ou_id ||
1057: ' AND prl.requisition_header_id = prh.requisition_header_id ' ||
1058: ' AND prl.source_type_code = ''INVENTORY'' ';

Line 1067: ' po_requisition_lines_all prl, ' ||

1063:
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 ||

Line 1088: ' po_requisition_lines_all prl, ' ||

1084:
1085:
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 || '''' ||

Line 1109: ' po_requisition_lines_all prl, ' ||

1105:
1106:
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 || '''' ||

Line 1131: ' po_requisition_lines_all prl , ' ||

1127: ' FROM wsh_delivery_details wsh , ' ||
1128: ' wsh_delivery_assignments wda , ' ||
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 || '''' ||

Line 1152: ' po_requisition_lines_all prl , ' ||

1148: ' UNION ALL ' ||
1149: ' SELECT wsh.* ' ||
1150: ' FROM wsh_delivery_details wsh , ' ||
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 ' ||

Line 1202: ' po_requisition_lines_all prl ' ||

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 || '''' ||
1204: ' and rsh.ship_to_org_id = ' || l_org_id ||
1205: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1206: ' and prh.org_id = ' || l_ou_id ||

Line 1220: ' po_requisition_lines_all prl ' ||

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 || '''' ||
1222: ' and rsh.ship_to_org_id = ' || l_org_id ||
1223: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1224: ' and prh.org_id = ' || l_ou_id ||

Line 1235: ' po_requisition_lines_all prl ,' ||

1231:
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 ||

Line 1253: ' po_requisition_lines_all prl ,' ||

1249:
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 ||

Line 1275: ' po_requisition_lines_all prl,' ||

1271:
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 ||

Line 1294: ' po_requisition_lines_all prl ' ||

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 || '''' ||
1296: ' and rsh.ship_to_org_id = '|| l_org_id ||
1297: ' and prh.segment1 = '|| '''' || l_req_num || '''' ||
1298: ' and prh.org_id = '|| l_ou_id ||

Line 1315: ' po_requisition_lines_all prl ' ||

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 || '''' ||
1317: ' and rsh.ship_to_org_id = ' || l_org_id ||
1318: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||
1319: ' and prh.org_id = ' || l_ou_id ||

Line 1331: ' PO_REQUISITION_LINES_ALL PRL, ' ||

1327: ' AND rsl.source_document_code = ''REQ'' '; */
1328:
1329: p_sql(15) := ' SELECT MTI.* ' ||
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 ' ||

Line 1352: ' po_requisition_lines_all prl , ' ||

1348: ' AND MTI.SOURCE_CODE = ''ORDER ENTRY'' ';
1349:
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 ' ||

Line 1374: ' po_requisition_lines_all prl , ' ||

1370: ' and mmtt.rcv_transaction_id = rt.transaction_id ' ||
1371: ' UNION ALL' ||
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 ' ||

Line 1398: ' po_requisition_lines_all prl , ' ||

1394:
1395:
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 ' ||

Line 1419: ' po_requisition_lines_all prl , ' ||

1415: ' and mmt.rcv_transaction_id = rt.transaction_id ' ||
1416: ' UNION ALL' ||
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 ' ||

Line 1443: ' po_requisition_lines_all prl , ' ||

1439:
1440: p_sql(18) := ' SELECT mr.* ' ||
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 || '''' ||

Line 1463: ' po_requisition_lines_all prl , ' ||

1459: ' UNION ALL ' ||
1460: ' SELECT mr.* ' ||
1461: ' FROM mtl_reservations mr , ' ||
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 ' ||

Line 1484: ' po_requisition_lines_all prl , ' ||

1480:
1481: p_sql(19) := ' SELECT md.* ' ||
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 || '''' ||

Line 1505: ' po_requisition_lines_all prl , ' ||

1501: ' UNION ALL ' ||
1502: ' SELECT md.* ' ||
1503: ' FROM mtl_demand md , ' ||
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 ' ||

Line 1532: ' po_requisition_lines_all prl , ' ||

1528:
1529: p_sql(20) := ' select distinct msn.* ' ||
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' ||

Line 1553: ' po_requisition_lines_all prl , ' ||

1549: ' UNION ALL' ||
1550: ' select distinct msn.* ' ||
1551: ' from mtl_serial_numbers msn , ' ||
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 ' ||

Line 1575: ' from po_requisition_lines_all prl ,' ||

1571: ' and mmt.transaction_id = msn.last_transaction_id ';
1572:
1573:
1574: p_sql(21) := ' select DISTINCT msnt.*' ||
1575: ' from po_requisition_lines_all prl ,' ||
1576: ' po_requisition_headers_all prh ,' ||
1577: ' mtl_serial_numbers_temp msnt ,' ||
1578: ' mtl_system_items msi,' ||
1579: ' rcv_transactions_interface rti,' ||

Line 1601: ' from po_requisition_lines_all prl ,' ||

1597: ' and msi.serial_number_control_code <> 1' ||
1598: ' and msi.lot_control_code = 1' ||
1599: ' UNION ALL' ||
1600: ' select DISTINCT msnt.*' ||
1601: ' from po_requisition_lines_all prl ,' ||
1602: ' po_requisition_headers_all prh ,' ||
1603: ' mtl_serial_numbers_temp msnt ,' ||
1604: ' mtl_transaction_lots_temp mtlt,' ||
1605: ' mtl_system_items msi,' ||

Line 1629: ' from po_requisition_lines_all prl,' ||

1625: ' and msi.serial_number_control_code <> 1' ||
1626: ' and msi.lot_control_code <> 1' ||
1627: ' UNION ALL' ||
1628: ' select DISTINCT msnt.*' ||
1629: ' from po_requisition_lines_all prl,' ||
1630: ' po_requisition_headers_all prh,' ||
1631: ' mtl_serial_numbers_temp msnt,' ||
1632: ' mtl_system_items msi,' ||
1633: ' oe_order_lines_all sol,' ||

Line 1656: ' from po_requisition_lines_all prl,' ||

1652: ' and msi.serial_number_control_code <> 1' ||
1653: ' and msi.lot_control_code = 1' ||
1654: ' UNION ALL' ||
1655: ' select DISTINCT msnt.*' ||
1656: ' from po_requisition_lines_all prl,' ||
1657: ' po_requisition_headers_all prh,' ||
1658: ' mtl_serial_numbers_temp msnt,' ||
1659: ' mtl_transaction_lots_temp mtlt,' ||
1660: ' mtl_system_items msi,' ||

Line 1688: ' po_requisition_lines_all prl , ' ||

1684:
1685:
1686: p_sql(22) := ' select distinct msni.* ' ||
1687: ' from rcv_transactions_interface rti ,' ||
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, ' ||

Line 1714: ' po_requisition_lines_all prl , ' ||

1710: ' and msi.lot_control_code = 1' ||
1711: ' UNION ALL' ||
1712: ' select distinct msni.* ' ||
1713: ' from rcv_transactions_interface rti ,' ||
1714: ' po_requisition_lines_all prl , ' ||
1715: ' po_requisition_headers_all prh , ' ||
1716: ' mtl_serial_numbers_interface msni ,' ||
1717: ' mtl_transaction_lots_interface mtli,' ||
1718: ' mtl_system_items msi,' ||

Line 1743: ' po_requisition_lines_all prl , ' ||

1739:
1740:
1741: p_sql(23) := ' select distinct mut.* ' ||
1742: ' from mtl_material_transactions mmt , ' ||
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, ' ||

Line 1765: ' po_requisition_lines_all prl , ' ||

1761: ' and msi.lot_control_code = 1 ' ||
1762: ' union all ' ||
1763: ' select distinct mut.* ' ||
1764: ' from mtl_material_transactions mmt , ' ||
1765: ' po_requisition_lines_all prl , ' ||
1766: ' mtl_unit_transactions mut , ' ||
1767: ' mtl_system_items msi , ' ||
1768: ' rcv_transactions rt , ' ||
1769: ' mtl_transaction_lot_numbers mtln, ' ||

Line 1789: ' po_requisition_lines_all prl , ' ||

1785: ' and msi.lot_control_code <> 1 ' ||
1786: ' union all ' ||
1787: ' select distinct mut.* ' ||
1788: ' from mtl_material_transactions mmt , ' ||
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, ' ||

Line 1812: ' po_requisition_lines_all prl , ' ||

1808: ' and msi.lot_control_code = 1 ' ||
1809: ' union all ' ||
1810: ' select distinct mut.* ' ||
1811: ' from mtl_material_transactions mmt , ' ||
1812: ' po_requisition_lines_all prl , ' ||
1813: ' mtl_unit_transactions mut , ' ||
1814: ' mtl_system_items msi , ' ||
1815: ' oe_order_lines_all sol , ' ||
1816: ' mtl_transaction_lot_numbers mtln, ' ||

Line 1844: ' po_requisition_lines_all prl , ' ||

1840: p_sql(24) := ' SELECT rss.* ' ||
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 || '''' ||

Line 1864: ' po_requisition_lines_all prl , ' ||

1860: p_sql(25) := ' SELECT rst.* ' ||
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 || '''' ||

Line 1884: ' po_requisition_lines_all prl , ' ||

1880: p_sql(26) := ' SELECT rsi.* ' ||
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 ||

Line 1909: ' po_requisition_lines_all prl ,' ||

1905: p_sql(27) := ' select distinct mln.* ' ||
1906: ' from mtl_lot_numbers mln ,' ||
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 || '''' ||

Line 1930: ' po_requisition_lines_all prl , ' ||

1926: ' select distinct mln.* ' ||
1927: ' from mtl_lot_numbers mln , ' ||
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 || '''' ||

Line 1952: ' po_requisition_lines_all prl , ' ||

1948:
1949: p_sql(28) := ' select distinct mtln.*' ||
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 || '''' ||

Line 1969: ' po_requisition_lines_all prl , ' ||

1965: ' UNION ALL' ||
1966: ' select distinct mtln.* ' ||
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 || '''' ||

Line 1990: ' po_requisition_lines_all prl , ' ||

1986:
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 ||

Line 2005: ' po_requisition_lines_all prl , ' ||

2001: ' UNION ALL' ||
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 ||

Line 2026: ' po_requisition_lines_all prl , ' ||

2022:
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 ||

Line 2041: ' po_requisition_lines_all prl , ' ||

2037: ' UNION ALL' ||
2038: ' select distinct mtlt.* ' ||
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 || '''' ||

Line 2060: ' po_requisition_lines_all prl , ' ||

2056: p_sql(31) := ' SELECT rls.* ' ||
2057: ' FROM rcv_lots_supply rls , ' ||
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 ||

Line 2084: ' po_requisition_lines_all prl , ' ||

2080: p_sql(32) := ' SELECT rlt.* ' ||
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 || '''' ||

Line 2104: ' po_requisition_lines_all prl ,' ||

2100: p_sql(33) := ' SELECT rli.* ' ||
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 ||

Line 2124: ' po_requisition_lines_all prl, ' ||

2120:
2121:
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 || '''' ||

Line 2149: ' po_requisition_lines_all prl , ' ||

2145: ' mtt.user_defined_flag , ' ||
2146: ' mtt.disable_date ' ||
2147: ' from mtl_transaction_types mtt , ' ||
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 ' ||

Line 2173: ' po_requisition_lines_all prl , ' ||

2169: ' mtt.user_defined_flag , ' ||
2170: ' mtt.disable_date ' ||
2171: ' from mtl_transaction_types mtt , ' ||
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 ' ||

Line 2198: ' po_requisition_lines_all prl , ' ||

2194: ' FROM org_organization_definitions ood ' ||
2195: ' WHERE exists ' ||
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 || '''' ||

Line 2221: ' po_requisition_lines_all prl ,' ||

2217:
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 ||

Line 2242: ' po_requisition_lines_all prl, ' ||

2238: ' FROM mtl_interorg_parameters miop ' ||
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 ||

Line 2264: ' po_requisition_lines_all prl , ' ||

2260: ' FROM rcv_parameters rp ' ||
2261: ' WHERE exists ' ||
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 || '''' ||