eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IO_DIAGNOSTICS3 dependencies on PO_REQUISITION_HEADERS_ALL

Line 6: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;

2: /* $Header: INVDIO3B.pls 120.0.12000000.1 2007/08/09 06:48:57 ssadasiv noship $ */
3:
4: PROCEDURE req_receipt_shipment_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_shipment_num IN VARCHAR2, p_receipt_num
5: IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
7: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
10: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;

Line 7: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;

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

Line 18: ' FROM po_requisition_headers_all prh, ' ||

14:
15:
16:
17: p_sql(1) := ' SELECT prh.* ' ||
18: ' FROM po_requisition_headers_all prh, ' ||
19: ' po_requisition_lines_all prl ' ||
20: ' where prh.segment1 = ' || '''' || l_req_num || '''' ||
21: ' and prh.org_id = ' || l_ou_id ||
22: ' AND prl.requisition_header_id = prh.requisition_header_id ' ||

Line 31: ' FROM po_requisition_headers_all prh, ' ||

27:
28:
29:
30: p_sql(2) := ' SELECT prl.* ' ||
31: ' FROM po_requisition_headers_all prh, ' ||
32: ' po_requisition_lines_all prl, ' ||
33: ' rcv_shipment_headers rsh, ' ||
34: ' rcv_shipment_lines rsl ' ||
35: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 52: ' FROM po_requisition_headers_all prh, ' ||

48:
49:
50:
51: p_sql(3) := ' SELECT prd.* ' ||
52: ' FROM po_requisition_headers_all prh, ' ||
53: ' po_requisition_lines_all prl, ' ||
54: ' po_req_distributions_all prd, ' ||
55: ' rcv_shipment_headers rsh, ' ||
56: ' rcv_shipment_lines rsl ' ||

Line 75: ' po_requisition_headers_all prh,' ||

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

Line 97: ' po_requisition_headers_all prh , ' ||

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

Line 118: ' po_requisition_headers_all prh , ' ||

114: ' SELECT wsh.* ' ||
115: ' FROM wsh_delivery_details wsh , ' ||
116: ' mtl_transactions_interface mti , ' ||
117: ' po_requisition_lines_all prl , ' ||
118: ' po_requisition_headers_all prh , ' ||
119: ' oe_order_lines_all sol, ' ||
120: ' rcv_shipment_headers rsh, ' ||
121: ' rcv_shipment_lines rsl ' ||
122: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 171: ' po_requisition_headers_all prh , ' ||

167:
168: p_sql(9) := ' SELECT DISTINCT rsh.* ' ||
169: ' FROM rcv_shipment_headers rsh , ' ||
170: ' rcv_shipment_lines rsl , ' ||
171: ' po_requisition_headers_all prh , ' ||
172: ' po_requisition_lines_all prl ' ||
173: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
174: ' and rsh.ship_to_org_id = ' || l_org_id ||
175: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 189: ' po_requisition_headers_all prh , ' ||

185:
186: p_sql(10) := ' SELECT rsl.* ' ||
187: ' FROM rcv_shipment_headers rsh, ' ||
188: ' rcv_shipment_lines rsl , ' ||
189: ' po_requisition_headers_all prh , ' ||
190: ' po_requisition_lines_all prl ' ||
191: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
192: ' and rsh.ship_to_org_id = ' || l_org_id ||
193: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 204: ' po_requisition_headers_all prh , ' ||

200: ' AND rsl.source_document_code = ''REQ'' ';
201:
202: p_sql(11) := ' SELECT rt.* ' ||
203: ' FROM rcv_transactions rt , ' ||
204: ' po_requisition_headers_all prh , ' ||
205: ' po_requisition_lines_all prl ,' ||
206: ' rcv_shipment_headers rsh, ' ||
207: ' rcv_shipment_lines rsl ' ||
208: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 222: ' po_requisition_headers_all prh , ' ||

218: ' AND rt.shipment_line_id = rsl.shipment_line_id ';
219:
220: p_sql(12) := ' SELECT ms.* ' ||
221: ' FROM mtl_supply ms , ' ||
222: ' po_requisition_headers_all prh , ' ||
223: ' po_requisition_lines_all prl ,' ||
224: ' rcv_shipment_headers rsh, ' ||
225: ' rcv_shipment_lines rsl ' ||
226: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 244: ' po_requisition_headers_all prh ,' ||

240:
241:
242: p_sql(13) := ' SELECT rs.* ' ||
243: ' FROM rcv_supply rs , ' ||
244: ' po_requisition_headers_all prh ,' ||
245: ' po_requisition_lines_all prl,' ||
246: ' rcv_shipment_headers rsh, ' ||
247: ' rcv_shipment_lines rsl ' ||
248: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 263: ' po_requisition_headers_all prh, ' ||

259: p_sql(14) := ' SELECT mtrl.* ' ||
260: ' FROM mtl_txn_request_lines mtrl, ' ||
261: ' rcv_shipment_headers rsh, ' ||
262: ' rcv_shipment_lines rsl, ' ||
263: ' po_requisition_headers_all prh, ' ||
264: ' po_requisition_lines_all prl ' ||
265: ' WHERE rsh.shipment_num = '|| '''' || l_shipment_num || '''' ||
266: ' and rsh.ship_to_org_id = l_org_id ' ||
267: ' and prh.segment1 = '|| '''' || l_req_num || '''' ||

Line 283: ' po_requisition_headers_all prh, ' ||

279: /*' SELECT mtrl.* ' ||
280: ' FROM mtl_txn_request_lines mtrl, ' ||
281: ' rcv_shipment_headers rsh, ' ||
282: ' rcv_shipment_lines rsl, ' ||
283: ' po_requisition_headers_all prh, ' ||
284: ' po_requisition_lines_all prl ' ||
285: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
286: ' and rsh.ship_to_org_id = ' || l_org_id ||
287: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 300: ' PO_REQUISITION_HEADERS_ALL PRH, ' ||

296:
297: p_sql(15) := ' SELECT MTI.* ' ||
298: ' FROM MTL_TRANSACTIONS_INTERFACE MTI, ' ||
299: ' PO_REQUISITION_LINES_ALL PRL, ' ||
300: ' PO_REQUISITION_HEADERS_ALL PRH, ' ||
301: ' OE_ORDER_LINES_ALL SOL, ' ||
302: ' RCV_SHIPMENT_HEADERS RSH, ' ||
303: ' RCV_SHIPMENT_LINES RSL ' ||
304: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 321: ' po_requisition_headers_all prh, ' ||

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

Line 343: ' po_requisition_headers_all prh, ' ||

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

Line 367: ' po_requisition_headers_all prh, ' ||

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

Line 388: ' po_requisition_headers_all prh, ' ||

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

Line 412: ' po_requisition_headers_all prh, ' ||

408: p_sql(18) := ' SELECT mr.* ' ||
409: ' FROM mtl_reservations mr , ' ||
410: ' oe_order_lines_all sol , ' ||
411: ' po_requisition_lines_all prl , ' ||
412: ' po_requisition_headers_all prh, ' ||
413: ' rcv_shipment_headers rsh, ' ||
414: ' rcv_shipment_lines rsl ' ||
415: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
416: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 432: ' po_requisition_headers_all prh , ' ||

428: ' SELECT mr.* ' ||
429: ' FROM mtl_reservations mr , ' ||
430: ' mtl_transactions_interface mti , ' ||
431: ' po_requisition_lines_all prl , ' ||
432: ' po_requisition_headers_all prh , ' ||
433: ' oe_order_lines_all sol ,' ||
434: ' rcv_shipment_headers rsh, ' ||
435: ' rcv_shipment_lines rsl ' ||
436: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 453: ' po_requisition_headers_all prh , ' ||

449: p_sql(19) := ' SELECT md.* ' ||
450: ' FROM mtl_demand md , ' ||
451: ' oe_order_lines_all sol , ' ||
452: ' po_requisition_lines_all prl , ' ||
453: ' po_requisition_headers_all prh , ' ||
454: ' rcv_shipment_headers rsh, ' ||
455: ' rcv_shipment_lines rsl ' ||
456: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
457: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 474: ' po_requisition_headers_all prh , ' ||

470: ' SELECT md.* ' ||
471: ' FROM mtl_demand md , ' ||
472: ' mtl_transactions_interface mti , ' ||
473: ' po_requisition_lines_all prl , ' ||
474: ' po_requisition_headers_all prh , ' ||
475: ' oe_order_lines_all sol , ' ||
476: ' rcv_shipment_headers rsh, ' ||
477: ' rcv_shipment_lines rsl ' ||
478: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 501: ' po_requisition_headers_all prh ,' ||

497: p_sql(20) := ' select distinct msn.* ' ||
498: ' from mtl_serial_numbers msn , ' ||
499: ' mtl_material_transactions mmt , ' ||
500: ' po_requisition_lines_all prl , ' ||
501: ' po_requisition_headers_all prh ,' ||
502: ' rcv_shipment_headers rsh, ' ||
503: ' rcv_shipment_lines rsl ,' ||
504: ' rcv_transactions rt' ||
505: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 522: ' po_requisition_headers_all prh ,' ||

518: ' select distinct msn.* ' ||
519: ' from mtl_serial_numbers msn , ' ||
520: ' mtl_material_transactions mmt , ' ||
521: ' po_requisition_lines_all prl , ' ||
522: ' po_requisition_headers_all prh ,' ||
523: ' oe_order_lines_all sol,' ||
524: ' rcv_shipment_headers rsh, ' ||
525: ' rcv_shipment_lines rsl ' ||
526: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 544: ' po_requisition_headers_all prh ,' ||

540:
541:
542: p_sql(21) := ' select DISTINCT msnt.*' ||
543: ' from po_requisition_lines_all prl ,' ||
544: ' po_requisition_headers_all prh ,' ||
545: ' mtl_serial_numbers_temp msnt ,' ||
546: ' mtl_system_items msi,' ||
547: ' rcv_transactions_interface rti,' ||
548: ' rcv_shipment_headers rsh, ' ||

Line 570: ' po_requisition_headers_all prh ,' ||

566: ' and msi.lot_control_code = 1' ||
567: ' UNION ALL' ||
568: ' select DISTINCT msnt.*' ||
569: ' from po_requisition_lines_all prl ,' ||
570: ' po_requisition_headers_all prh ,' ||
571: ' mtl_serial_numbers_temp msnt ,' ||
572: ' mtl_transaction_lots_temp mtlt,' ||
573: ' mtl_system_items msi,' ||
574: ' rcv_transactions_interface rti,' ||

Line 598: ' po_requisition_headers_all prh,' ||

594: ' and msi.lot_control_code <> 1' ||
595: ' UNION ALL' ||
596: ' select DISTINCT msnt.*' ||
597: ' from po_requisition_lines_all prl,' ||
598: ' po_requisition_headers_all prh,' ||
599: ' mtl_serial_numbers_temp msnt,' ||
600: ' mtl_system_items msi,' ||
601: ' oe_order_lines_all sol,' ||
602: ' mtl_material_transactions_temp mmtt,' ||

Line 625: ' po_requisition_headers_all prh,' ||

621: ' and msi.lot_control_code = 1' ||
622: ' UNION ALL' ||
623: ' select DISTINCT msnt.*' ||
624: ' from po_requisition_lines_all prl,' ||
625: ' po_requisition_headers_all prh,' ||
626: ' mtl_serial_numbers_temp msnt,' ||
627: ' mtl_transaction_lots_temp mtlt,' ||
628: ' mtl_system_items msi,' ||
629: ' oe_order_lines_all sol,' ||

Line 657: ' po_requisition_headers_all prh , ' ||

653:
654: p_sql(22) := ' select distinct msni.* ' ||
655: ' from rcv_transactions_interface rti ,' ||
656: ' po_requisition_lines_all prl , ' ||
657: ' po_requisition_headers_all prh , ' ||
658: ' mtl_serial_numbers_interface msni ,' ||
659: ' mtl_system_items msi,' ||
660: ' rcv_shipment_headers rsh, ' ||
661: ' rcv_shipment_lines rsl ' ||

Line 683: ' po_requisition_headers_all prh , ' ||

679: ' UNION ALL' ||
680: ' select distinct msni.* ' ||
681: ' from rcv_transactions_interface rti ,' ||
682: ' po_requisition_lines_all prl , ' ||
683: ' po_requisition_headers_all prh , ' ||
684: ' mtl_serial_numbers_interface msni ,' ||
685: ' mtl_transaction_lots_interface mtli,' ||
686: ' mtl_system_items msi,' ||
687: ' rcv_shipment_headers rsh, ' ||

Line 811: ' po_requisition_headers_all prh , ' ||

807:
808: p_sql(24) := ' SELECT rss.* ' ||
809: ' FROM rcv_serials_supply rss , ' ||
810: ' rcv_shipment_lines rsl , ' ||
811: ' po_requisition_headers_all prh , ' ||
812: ' po_requisition_lines_all prl , ' ||
813: ' rcv_shipment_headers rsh ' ||
814: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
815: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 831: ' po_requisition_headers_all prh , ' ||

827:
828: p_sql(25) := ' SELECT rst.* ' ||
829: ' FROM rcv_serial_transactions rst , ' ||
830: ' rcv_shipment_lines rsl , ' ||
831: ' po_requisition_headers_all prh , ' ||
832: ' po_requisition_lines_all prl , ' ||
833: ' rcv_shipment_headers rsh ' ||
834: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
835: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 851: ' po_requisition_headers_all prh , ' ||

847:
848: p_sql(26) := ' SELECT rsi.* ' ||
849: ' FROM rcv_serials_interface rsi , ' ||
850: ' rcv_shipment_lines rsl , ' ||
851: ' po_requisition_headers_all prh , ' ||
852: ' po_requisition_lines_all prl , ' ||
853: ' rcv_shipment_headers rsh ,' ||
854: ' rcv_transactions_interface rti' ||
855: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1027: ' po_requisition_headers_all prh , ' ||

1023:
1024: p_sql(31) := ' SELECT rls.* ' ||
1025: ' FROM rcv_lots_supply rls , ' ||
1026: ' rcv_shipment_lines rsl , ' ||
1027: ' po_requisition_headers_all prh , ' ||
1028: ' po_requisition_lines_all prl , ' ||
1029: ' oe_order_lines_all sol , ' ||
1030: ' rcv_shipment_headers rsh ' ||
1031: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1051: ' po_requisition_headers_all prh , ' ||

1047:
1048: p_sql(32) := ' SELECT rlt.* ' ||
1049: ' FROM rcv_lot_transactions rlt , ' ||
1050: ' rcv_shipment_lines rsl , ' ||
1051: ' po_requisition_headers_all prh , ' ||
1052: ' po_requisition_lines_all prl , ' ||
1053: ' rcv_shipment_headers rsh ' ||
1054: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1055: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1071: ' po_requisition_headers_all prh , ' ||

1067:
1068: p_sql(33) := ' SELECT rli.* ' ||
1069: ' FROM rcv_lots_interface rli , ' ||
1070: ' rcv_transactions_interface rti , ' ||
1071: ' po_requisition_headers_all prh , ' ||
1072: ' po_requisition_lines_all prl ,' ||
1073: ' rcv_shipment_headers rsh,' ||
1074: ' rcv_shipment_lines rsl' ||
1075: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1091: ' FROM po_requisition_headers_all prh, ' ||

1087:
1088:
1089:
1090: p_sql(34) := ' SELECT DISTINCT msi.* ' ||
1091: ' FROM po_requisition_headers_all prh, ' ||
1092: ' po_requisition_lines_all prl, ' ||
1093: ' mtl_system_items msi, ' ||
1094: ' rcv_shipment_headers rsh, ' ||
1095: ' rcv_shipment_lines rsl ' ||

Line 1118: ' po_requisition_headers_all prh ,' ||

1114: ' mtt.disable_date ' ||
1115: ' from mtl_transaction_types mtt , ' ||
1116: ' mtl_material_transactions mmt , ' ||
1117: ' po_requisition_lines_all prl , ' ||
1118: ' po_requisition_headers_all prh ,' ||
1119: ' rcv_transactions rt,' ||
1120: ' rcv_shipment_headers rsh, ' ||
1121: ' rcv_shipment_lines rsl ' ||
1122: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1142: ' po_requisition_headers_all prh,' ||

1138: ' mtt.disable_date ' ||
1139: ' from mtl_transaction_types mtt , ' ||
1140: ' mtl_material_transactions mmt , ' ||
1141: ' po_requisition_lines_all prl , ' ||
1142: ' po_requisition_headers_all prh,' ||
1143: ' oe_order_lines_all sol,' ||
1144: ' rcv_shipment_headers rsh, ' ||
1145: ' rcv_shipment_lines rsl ' ||
1146: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1165: ' FROM po_requisition_headers_all prh , ' ||

1161: p_sql(36) := ' SELECT ood.* ' ||
1162: ' FROM org_organization_definitions ood ' ||
1163: ' WHERE exists ' ||
1164: ' (SELECT 1 ' ||
1165: ' FROM po_requisition_headers_all prh , ' ||
1166: ' po_requisition_lines_all prl , ' ||
1167: ' financials_system_params_all fsp , ' ||
1168: ' rcv_shipment_headers rsh, ' ||
1169: ' rcv_shipment_lines rsl ' ||

Line 1188: ' po_requisition_headers_all prh , ' ||

1184:
1185:
1186: p_sql(37) := ' SELECT DISTINCT mp.* ' ||
1187: ' FROM mtl_parameters mp , ' ||
1188: ' po_requisition_headers_all prh , ' ||
1189: ' po_requisition_lines_all prl ,' ||
1190: ' rcv_shipment_headers rsh, ' ||
1191: ' rcv_shipment_lines rsl ' ||
1192: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1209: ' FROM po_requisition_headers_all prh , ' ||

1205: p_sql(38) := ' SELECT miop.* ' ||
1206: ' FROM mtl_interorg_parameters miop ' ||
1207: ' WHERE exists ' ||
1208: ' (SELECT 1 ' ||
1209: ' FROM po_requisition_headers_all prh , ' ||
1210: ' po_requisition_lines_all prl, ' ||
1211: ' rcv_shipment_headers rsh, ' ||
1212: ' rcv_shipment_lines rsl ' ||
1213: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1231: ' FROM po_requisition_headers_all prh , ' ||

1227: p_sql(39) := ' SELECT rp.* ' ||
1228: ' FROM rcv_parameters rp ' ||
1229: ' WHERE exists ' ||
1230: ' (SELECT 1 ' ||
1231: ' FROM po_requisition_headers_all prh , ' ||
1232: ' po_requisition_lines_all prl , ' ||
1233: ' financials_system_params_all fsp, ' ||
1234: ' rcv_shipment_headers rsh, ' ||
1235: ' rcv_shipment_lines rsl ' ||