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

APPS.INV_DIAG_RCV_IPROC_COMMON dependencies on PO_REQUISITION_HEADERS_ALL

Line 12: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;

8: p_line_num IN NUMBER,
9: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)
10: IS
11: -- Initialize Local Variables.
12: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
13: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;
14: l_line_num VARCHAR2(1000) := p_line_num;
15:
16: BEGIN

Line 13: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;

9: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)
10: IS
11: -- Initialize Local Variables.
12: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
13: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;
14: l_line_num VARCHAR2(1000) := p_line_num;
15:
16: BEGIN
17:

Line 24: ' from po_requisition_headers_all prh,' ||

20: l_line_num := ' prl.line_num ';
21: END IF;
22:
23: p_sql(1) := ' select distinct prh.*' ||
24: ' from po_requisition_headers_all prh,' ||
25: ' po_requisition_lines_all prl' ||
26: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
27: ' and prh.segment1 = '||''''||l_req_number||''''||
28: ' and prh.org_id = '||l_operating_id||

Line 35: ' po_requisition_headers_all prh ' ||

31: ' and prl.source_type_code = ''VENDOR'' ';
32:
33: p_sql(2) := ' select distinct prl.*' ||
34: ' from po_requisition_lines_all prl,' ||
35: ' po_requisition_headers_all prh ' ||
36: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
37: ' and prh.segment1 = '||''''||l_req_number||''''||
38: ' and prh.org_id = '||l_operating_id||
39: ' and prl.line_num='||l_line_num||

Line 47: ' po_requisition_headers_all prh' ||

43:
44: p_sql(3) := ' select distinct prd.*' ||
45: ' from po_req_distributions_all prd ,' ||
46: ' po_requisition_lines_all prl ,' ||
47: ' po_requisition_headers_all prh' ||
48: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
49: ' and prh.requisition_header_id = prl.requisition_header_id' ||
50: ' and prl.requisition_line_id = prd.requisition_line_id' ||
51: ' and prl.source_type_code = ''VENDOR''' ||

Line 62: ' po_requisition_headers_all prh' ||

58: ' from po_headers_all ph,' ||
59: ' po_distributions_all pd,' ||
60: ' po_req_distributions_all prd ,' ||
61: ' po_requisition_lines_all prl ,' ||
62: ' po_requisition_headers_all prh' ||
63: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
64: ' and prh.requisition_header_id = prl.requisition_header_id' ||
65: ' and prl.requisition_line_id = prd.requisition_line_id' ||
66: ' and prl.source_type_code = ''VENDOR''' ||

Line 80: ' po_requisition_headers_all prh' ||

76: ' po_headers_all ph,' ||
77: ' po_distributions_all pd,' ||
78: ' po_req_distributions_all prd ,' ||
79: ' po_requisition_lines_all prl ,' ||
80: ' po_requisition_headers_all prh' ||
81: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
82: ' and prh.requisition_header_id = prl.requisition_header_id' ||
83: ' and prl.requisition_line_id = prd.requisition_line_id' ||
84: ' and prl.source_type_code = ''VENDOR''' ||

Line 107: ' po_requisition_headers_all prh' ||

103: ' po_headers_all ph,' ||
104: ' po_distributions_all pd,' ||
105: ' po_req_distributions_all prd ,' ||
106: ' po_requisition_lines_all prl ,' ||
107: ' po_requisition_headers_all prh' ||
108: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
109: ' and prh.requisition_header_id = prl.requisition_header_id' ||
110: ' and prl.requisition_line_id = prd.requisition_line_id' ||
111: ' and prl.source_type_code = ''VENDOR''' ||

Line 130: ' po_requisition_headers_all prh ' ||

126: ' po_headers_all ph , ' ||
127: ' po_distributions_all pd,' ||
128: ' po_req_distributions_all prd ,' ||
129: ' po_requisition_lines_all prl ,' ||
130: ' po_requisition_headers_all prh ' ||
131: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
132: ' and prh.requisition_header_id = prl.requisition_header_id' ||
133: ' and prl.requisition_line_id = prd.requisition_line_id' ||
134: ' and prl.source_type_code = ''VENDOR''' ||

Line 153: ' po_requisition_headers_all prh' ||

149: ' po_headers_all ph , ' ||
150: ' po_distributions_all pd,' ||
151: ' po_req_distributions_all prd ,' ||
152: ' po_requisition_lines_all prl ,' ||
153: ' po_requisition_headers_all prh' ||
154: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
155: ' and prh.requisition_header_id = prl.requisition_header_id' ||
156: ' and prl.requisition_line_id = prd.requisition_line_id' ||
157: ' and prl.source_type_code = ''VENDOR''' ||

Line 179: ' po_requisition_headers_all prh' ||

175: ' po_line_locations_all pll , ' ||--Bug#6882986
176: ' po_distributions_all pd,' ||
177: ' po_req_distributions_all prd ,' ||
178: ' po_requisition_lines_all prl ,' ||
179: ' po_requisition_headers_all prh' ||
180: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
181: ' and prh.requisition_header_id = prl.requisition_header_id' ||
182: ' and prl.requisition_line_id = prd.requisition_line_id' ||
183: ' and prl.source_type_code = ''VENDOR''' ||

Line 203: ' po_requisition_headers_all prh ' ||

199: ' po_headers_all ph , ' ||
200: ' po_distributions_all pd,' ||
201: ' po_req_distributions_all prd ,' ||
202: ' po_requisition_lines_all prl ,' ||
203: ' po_requisition_headers_all prh ' ||
204: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
205: ' and prh.requisition_header_id = prl.requisition_header_id' ||
206: ' and prl.requisition_line_id = prd.requisition_line_id' ||
207: ' and prl.source_type_code = ''VENDOR''' ||

Line 227: ' po_requisition_headers_all prh ' ||

223: ' po_headers_all ph , ' ||
224: ' po_distributions_all pd,' ||
225: ' po_req_distributions_all prd ,' ||
226: ' po_requisition_lines_all prl ,' ||
227: ' po_requisition_headers_all prh ' ||
228: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
229: ' and prh.requisition_header_id = prl.requisition_header_id' ||
230: ' and prl.requisition_line_id = prd.requisition_line_id' ||
231: ' and prl.source_type_code = ''VENDOR''' ||

Line 253: ' po_requisition_headers_all prh ' ||

249: ' po_headers_all ph , ' ||
250: ' po_distributions_all pd,' ||
251: ' po_req_distributions_all prd ,' ||
252: ' po_requisition_lines_all prl ,' ||
253: ' po_requisition_headers_all prh ' ||
254: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
255: ' and prh.requisition_header_id = prl.requisition_header_id' ||
256: ' and prl.requisition_line_id = prd.requisition_line_id' ||
257: ' and prl.source_type_code = ''VENDOR''' ||

Line 278: ' po_requisition_headers_all prh ' ||

274: ' po_headers_all ph , ' ||
275: ' po_distributions_all pd,' ||
276: ' po_req_distributions_all prd ,' ||
277: ' po_requisition_lines_all prl ,' ||
278: ' po_requisition_headers_all prh ' ||
279: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
280: ' and prh.requisition_header_id = prl.requisition_header_id' ||
281: ' and prl.requisition_line_id = prd.requisition_line_id' ||
282: ' and prl.source_type_code = ''VENDOR''' ||

Line 304: ' po_requisition_headers_all prh ' ||

300: ' po_headers_all ph , ' ||
301: ' po_distributions_all pd,' ||
302: ' po_req_distributions_all prd ,' ||
303: ' po_requisition_lines_all prl ,' ||
304: ' po_requisition_headers_all prh ' ||
305: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
306: ' and prh.requisition_header_id = prl.requisition_header_id' ||
307: ' and prl.requisition_line_id = prd.requisition_line_id' ||
308: ' and prl.source_type_code = ''VENDOR''' ||

Line 328: ' po_requisition_headers_all prh ' ||

324: ' po_line_locations_all pll , ' ||
325: ' po_distributions_all pd,' ||
326: ' po_req_distributions_all prd ,' ||
327: ' po_requisition_lines_all prl ,' ||
328: ' po_requisition_headers_all prh ' ||
329: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
330: ' and prh.requisition_header_id = prl.requisition_header_id' ||
331: ' and prl.requisition_line_id = prd.requisition_line_id' ||
332: ' and prl.source_type_code = ''VENDOR''' ||

Line 348: ' po_requisition_headers_all prh ' ||

344: ' po_line_locations_all pll , ' ||
345: ' po_distributions_all pd,' ||
346: ' po_req_distributions_all prd ,' ||
347: ' po_requisition_lines_all prl ,' ||
348: ' po_requisition_headers_all prh ' ||
349: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
350: ' and prh.requisition_header_id = prl.requisition_header_id' ||
351: ' and prl.requisition_line_id = prd.requisition_line_id' ||
352: ' and prl.source_type_code = ''VENDOR''' ||

Line 368: ' po_requisition_headers_all prh ' ||

364: ' po_line_locations_all pll , ' ||
365: ' po_distributions_all pd,' ||
366: ' po_req_distributions_all prd ,' ||
367: ' po_requisition_lines_all prl ,' ||
368: ' po_requisition_headers_all prh ' ||
369: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
370: ' and prh.requisition_header_id = prl.requisition_header_id' ||
371: ' and prl.requisition_line_id = prd.requisition_line_id' ||
372: ' and prl.source_type_code = ''VENDOR''' ||

Line 388: ' po_requisition_headers_all prh ' ||

384: ' po_line_locations_all pll , ' ||
385: ' po_distributions_all pd,' ||
386: ' po_req_distributions_all prd ,' ||
387: ' po_requisition_lines_all prl ,' ||
388: ' po_requisition_headers_all prh ' ||
389: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
390: ' and prh.requisition_header_id = prl.requisition_header_id' ||
391: ' and prl.requisition_line_id = prd.requisition_line_id' ||
392: ' and prl.source_type_code = ''VENDOR''' ||

Line 406: ' po_requisition_headers_all prh ' ||

402: ' po_line_locations_all pll , ' ||
403: ' po_distributions_all pd,' ||
404: ' po_req_distributions_all prd ,' ||
405: ' po_requisition_lines_all prl ,' ||
406: ' po_requisition_headers_all prh ' ||
407: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
408: ' and prh.requisition_header_id = prl.requisition_header_id' ||
409: ' and prl.requisition_line_id = prd.requisition_line_id' ||
410: ' and prl.source_type_code = ''VENDOR''' ||

Line 428: ' po_requisition_headers_all prh ' ||

424: ' po_line_locations_all pll , ' ||
425: ' po_distributions_all pd,' ||
426: ' po_req_distributions_all prd ,' ||
427: ' po_requisition_lines_all prl ,' ||
428: ' po_requisition_headers_all prh ' ||
429: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
430: ' and prh.requisition_header_id = prl.requisition_header_id' ||
431: ' and prl.requisition_line_id = prd.requisition_line_id' ||
432: ' and prl.source_type_code = ''VENDOR''' ||

Line 454: ' po_requisition_headers_all prh ' ||

450: ' po_headers_all ph , ' ||
451: ' po_distributions_all pd,' ||
452: ' po_req_distributions_all prd ,' ||
453: ' po_requisition_lines_all prl ,' ||
454: ' po_requisition_headers_all prh ' ||
455: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
456: ' and prh.requisition_header_id = prl.requisition_header_id' ||
457: ' and prl.requisition_line_id = prd.requisition_line_id' ||
458: ' and prl.source_type_code = ''VENDOR''' ||

Line 484: ' po_requisition_headers_all prh ' ||

480: ' po_headers_all ph , ' ||
481: ' po_distributions_all pd,' ||
482: ' po_req_distributions_all prd ,' ||
483: ' po_requisition_lines_all prl ,' ||
484: ' po_requisition_headers_all prh ' ||
485: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
486: ' and prh.requisition_header_id = prl.requisition_header_id' ||
487: ' and prl.requisition_line_id = prd.requisition_line_id' ||
488: ' and prl.source_type_code = ''VENDOR''' ||

Line 509: ' po_requisition_headers_all prh ' ||

505: ' po_line_locations_all pll , ' ||
506: ' po_distributions_all pd,' ||
507: ' po_req_distributions_all prd ,' ||
508: ' po_requisition_lines_all prl ,' ||
509: ' po_requisition_headers_all prh ' ||
510: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
511: ' and prh.requisition_header_id = prl.requisition_header_id' ||
512: ' and prl.requisition_line_id = prd.requisition_line_id' ||
513: ' and prl.source_type_code = ''VENDOR''' ||

Line 526: ' po_requisition_headers_all prh,' ||

522: 'pie.interface_line_id = rti.interface_transaction_id)';
523:
524: p_sql(22) := ' select distinct msi.*' ||
525: ' from po_requisition_lines_all prl,' ||
526: ' po_requisition_headers_all prh,' ||
527: ' mtl_system_items msi' ||
528: ' where prh.segment1 = '||''''||l_req_number||''''||
529: ' and prh.org_id = '||l_operating_id||
530: ' and prl.line_num='||l_line_num||

Line 546: ' po_requisition_headers_all prh ' ||

542: ' po_distributions_all pd,' ||
543: ' rcv_transactions rt,' ||--Bug#6882986
544: ' po_req_distributions_all prd ,' ||
545: ' po_requisition_lines_all prl ,' ||
546: ' po_requisition_headers_all prh ' ||
547: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
548: ' and prh.requisition_header_id = prl.requisition_header_id' ||
549: ' and prl.requisition_line_id = prd.requisition_line_id' ||
550: ' and prl.source_type_code = ''VENDOR''' ||

Line 582: ' po_requisition_headers_all prh ' ||

578: ' po_distributions_all pd,' ||
579: ' rcv_transactions rt,' ||--Bug#6882986
580: ' po_req_distributions_all prd ,' ||
581: ' po_requisition_lines_all prl ,' ||
582: ' po_requisition_headers_all prh ' ||
583: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
584: ' and prh.requisition_header_id = prl.requisition_header_id' ||
585: ' and prl.requisition_line_id = prd.requisition_line_id' ||
586: ' and prl.source_type_code = ''VENDOR''' ||

Line 612: ' po_requisition_headers_all prh ' ||

608: ' po_distributions_all pd,' ||
609: ' rcv_transactions rt,' ||--Bug#6882986
610: ' po_req_distributions_all prd ,' ||
611: ' po_requisition_lines_all prl ,' ||
612: ' po_requisition_headers_all prh ' ||
613: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
614: ' and prh.requisition_header_id = prl.requisition_header_id' ||
615: ' and prl.requisition_line_id = prd.requisition_line_id' ||
616: ' and prl.source_type_code = ''VENDOR''' ||

Line 642: ' po_requisition_headers_all prh ' ||

638: ' po_line_locations_all pll , ' ||
639: ' po_distributions_all pd,' ||
640: ' po_req_distributions_all prd ,' ||
641: ' po_requisition_lines_all prl ,' ||
642: ' po_requisition_headers_all prh ' ||
643: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
644: ' and prh.requisition_header_id = prl.requisition_header_id' ||
645: ' and prl.requisition_line_id = prd.requisition_line_id' ||
646: ' and prl.source_type_code = ''VENDOR''' ||

Line 666: ' po_requisition_headers_all prh ' ||

662: ' po_line_locations_all pll , ' ||
663: ' po_distributions_all pd,' ||
664: ' po_req_distributions_all prd ,' ||
665: ' po_requisition_lines_all prl ,' ||
666: ' po_requisition_headers_all prh ' ||
667: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
668: ' and prh.requisition_header_id = prl.requisition_header_id' ||
669: ' and prl.requisition_line_id = prd.requisition_line_id' ||
670: ' and prl.source_type_code = ''VENDOR''' ||

Line 693: ' po_requisition_headers_all prh ' ||

689: ' po_distributions_all pd,' ||
690: ' rcv_transactions rt,' ||--Bug#6882986
691: ' po_req_distributions_all prd ,' ||
692: ' po_requisition_lines_all prl ,' ||
693: ' po_requisition_headers_all prh ' ||
694: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
695: ' and prh.requisition_header_id = prl.requisition_header_id' ||
696: ' and prl.requisition_line_id = prd.requisition_line_id' ||
697: ' and prl.source_type_code = ''VENDOR''' ||

Line 723: ' po_requisition_headers_all prh ' ||

719: ' po_headers_all ph , ' ||
720: ' po_distributions_all pd,' ||
721: ' po_req_distributions_all prd ,' ||
722: ' po_requisition_lines_all prl ,' ||
723: ' po_requisition_headers_all prh ' ||
724: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
725: ' and prh.requisition_header_id = prl.requisition_header_id' ||
726: ' and prl.requisition_line_id = prd.requisition_line_id' ||
727: ' and prl.source_type_code = ''VENDOR''' ||

Line 745: ' po_requisition_headers_all prh ' ||

741: p_sql(28) := ' SELECT DISTINCT mp.* ' ||
742: ' from mtl_parameters mp ,' ||
743: ' financials_system_params_all fsp,' ||
744: ' po_requisition_lines_all prl ,' ||
745: ' po_requisition_headers_all prh ' ||
746: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
747: ' and prh.requisition_header_id = prl.requisition_header_id' ||
748: ' and prl.source_type_code = ''VENDOR''' ||
749: ' AND fsp.org_id = prh.org_id ' ||

Line 760: ' po_requisition_headers_all prh ' ||

756: p_sql(29) := ' SELECT DISTINCT rp.* ' ||
757: ' from rcv_parameters rp , ' ||
758: ' financials_system_params_all fsp, ' ||
759: ' po_requisition_lines_all prl ,' ||
760: ' po_requisition_headers_all prh ' ||
761: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
762: ' and prh.requisition_header_id = prl.requisition_header_id' ||
763: ' and prl.source_type_code = ''VENDOR''' ||
764: ' AND fsp.org_id = prh.org_id ' ||

Line 775: ' po_requisition_headers_all prh ' ||

771:
772: p_sql(30) := ' SELECT DISTINCT psp.* ' ||
773: ' from po_system_parameters_all psp, ' ||
774: ' po_requisition_lines_all prl ,' ||
775: ' po_requisition_headers_all prh ' ||
776: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
777: ' and prh.requisition_header_id = prl.requisition_header_id' ||
778: ' and prl.source_type_code = ''VENDOR''' ||
779: ' and psp.org_id = prh.org_id ' ||

Line 788: ' po_requisition_headers_all prh ' ||

784:
785: p_sql(31) := ' SELECT DISTINCT fsp.* ' ||
786: ' from financials_system_params_all fsp, ' ||
787: ' po_requisition_lines_all prl ,' ||
788: ' po_requisition_headers_all prh ' ||
789: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
790: ' and prh.requisition_header_id = prl.requisition_header_id' ||
791: ' and prl.source_type_code = ''VENDOR''' ||
792: ' and fsp.org_id = prh.org_id ' ||

Line 807: ' po_requisition_headers_all prh,' ||

803: ' po_headers_all ph , ' ||
804: ' po_distributions_all pd,' ||
805: ' po_req_distributions_all prd ,' ||
806: ' po_requisition_lines_all prl ,' ||
807: ' po_requisition_headers_all prh,' ||
808: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
809: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
810: ' and prh.requisition_header_id = prl.requisition_header_id' ||
811: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 842: ' po_requisition_headers_all prh, ' ||

838: ' po_headers_all ph , ' ||
839: ' po_distributions_all pd,' ||
840: ' po_req_distributions_all prd ,' ||
841: ' po_requisition_lines_all prl ,' ||
842: ' po_requisition_headers_all prh, ' ||
843: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
844: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
845: ' and prh.requisition_header_id = prl.requisition_header_id' ||
846: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 876: ' po_requisition_headers_all prh ' ||

872: ' po_headers_all ph , ' ||
873: ' po_distributions_all pd,' ||
874: ' po_req_distributions_all prd ,' ||
875: ' po_requisition_lines_all prl ,' ||
876: ' po_requisition_headers_all prh ' ||
877: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
878: ' and prh.requisition_header_id = prl.requisition_header_id' ||
879: ' and prl.requisition_line_id = prd.requisition_line_id' ||
880: ' and prl.source_type_code = ''VENDOR''' ||

Line 903: ' po_requisition_headers_all prh ' ||

899: ' po_headers_all ph , ' ||
900: ' po_distributions_all pd,' ||
901: ' po_req_distributions_all prd ,' ||
902: ' po_requisition_lines_all prl ,' ||
903: ' po_requisition_headers_all prh ' ||
904: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
905: ' and prh.requisition_header_id = prl.requisition_header_id' ||
906: ' and prl.requisition_line_id = prd.requisition_line_id' ||
907: ' and prl.source_type_code = ''VENDOR''' ||

Line 932: ' po_requisition_headers_all prh ' ||

928: ' po_headers_all ph , ' ||
929: ' po_distributions_all pd,' ||
930: ' po_req_distributions_all prd ,' ||
931: ' po_requisition_lines_all prl ,' ||
932: ' po_requisition_headers_all prh ' ||
933: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
934: ' and prh.requisition_header_id = prl.requisition_header_id' ||
935: ' and prl.requisition_line_id = prd.requisition_line_id' ||
936: ' and prl.source_type_code = ''VENDOR''' ||

Line 960: ' po_requisition_headers_all prh, ' ||

956: ' po_headers_all ph , ' ||
957: ' po_distributions_all pd,' ||
958: ' po_req_distributions_all prd ,' ||
959: ' po_requisition_lines_all prl ,' ||
960: ' po_requisition_headers_all prh, ' ||
961: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
962: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
963: ' and prh.requisition_header_id = prl.requisition_header_id' ||
964: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 991: ' po_requisition_headers_all prh, ' ||

987: ' po_headers_all ph , ' ||
988: ' po_distributions_all pd,' ||
989: ' po_req_distributions_all prd ,' ||
990: ' po_requisition_lines_all prl ,' ||
991: ' po_requisition_headers_all prh, ' ||
992: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
993: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
994: ' and prh.requisition_header_id = prl.requisition_header_id' ||
995: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1022: ' po_requisition_headers_all prh, ' ||

1018: ' po_headers_all ph , ' ||
1019: ' po_distributions_all pd,' ||
1020: ' po_req_distributions_all prd ,' ||
1021: ' po_requisition_lines_all prl ,' ||
1022: ' po_requisition_headers_all prh, ' ||
1023: ' rcv_shipment_headers rsh ' ||
1024: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1025: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1026: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1049: ' po_requisition_headers_all prh, ' ||

1045: ' po_headers_all ph , ' ||
1046: ' po_distributions_all pd,' ||
1047: ' po_req_distributions_all prd ,' ||
1048: ' po_requisition_lines_all prl ,' ||
1049: ' po_requisition_headers_all prh, ' ||
1050: ' rcv_shipment_headers rsh ' ||
1051: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1052: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1053: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1079: ' po_requisition_headers_all prh, ' ||

1075: ' po_headers_all ph , ' ||
1076: ' po_distributions_all pd,' ||
1077: ' po_req_distributions_all prd ,' ||
1078: ' po_requisition_lines_all prl ,' ||
1079: ' po_requisition_headers_all prh, ' ||
1080: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
1081: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1082: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1083: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1110: ' po_requisition_headers_all prh, ' ||

1106: ' po_headers_all ph , ' ||
1107: ' po_distributions_all pd,' ||
1108: ' po_req_distributions_all prd ,' ||
1109: ' po_requisition_lines_all prl ,' ||
1110: ' po_requisition_headers_all prh, ' ||
1111: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
1112: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1113: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1114: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1144: ' po_requisition_headers_all prh, ' ||

1140: ' po_headers_all ph , ' ||
1141: ' po_distributions_all pd,' ||
1142: ' po_req_distributions_all prd ,' ||
1143: ' po_requisition_lines_all prl ,' ||
1144: ' po_requisition_headers_all prh, ' ||
1145: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
1146: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1147: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1148: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1177: ' po_requisition_headers_all prh ' ||

1173: ' po_headers_all ph , ' ||
1174: ' po_distributions_all pd,' ||
1175: ' po_req_distributions_all prd ,' ||
1176: ' po_requisition_lines_all prl ,' ||
1177: ' po_requisition_headers_all prh ' ||
1178: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1179: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1180: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1181: ' and prl.source_type_code = ''VENDOR''' ||

Line 1204: ' po_requisition_headers_all prh, ' ||

1200: ' po_headers_all ph , ' ||
1201: ' po_distributions_all pd,' ||
1202: ' po_req_distributions_all prd ,' ||
1203: ' po_requisition_lines_all prl ,' ||
1204: ' po_requisition_headers_all prh, ' ||
1205: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
1206: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1207: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1208: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1234: ' po_requisition_headers_all prh, ' ||

1230: ' po_headers_all ph , ' ||
1231: ' po_distributions_all pd,' ||
1232: ' po_req_distributions_all prd ,' ||
1233: ' po_requisition_lines_all prl ,' ||
1234: ' po_requisition_headers_all prh, ' ||
1235: ' rcv_shipment_headers rsh ' ||
1236: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1237: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1238: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1263: ' po_requisition_headers_all prh, ' ||

1259: ' po_headers_all ph , ' ||
1260: ' po_distributions_all pd,' ||
1261: ' po_req_distributions_all prd ,' ||
1262: ' po_requisition_lines_all prl ,' ||
1263: ' po_requisition_headers_all prh, ' ||
1264: ' rcv_shipment_headers rsh ' ||
1265: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1266: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1267: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1295: ' po_requisition_headers_all prh ' ||

1291: ' po_headers_all ph , ' ||
1292: ' po_distributions_all pd,' ||
1293: ' po_req_distributions_all prd ,' ||
1294: ' po_requisition_lines_all prl ,' ||
1295: ' po_requisition_headers_all prh ' ||
1296: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1297: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1298: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1299: ' and prl.source_type_code = ''VENDOR''' ||

Line 1327: ' from po_requisition_headers_all prh,' ||

1323:
1324: BEGIN
1325:
1326: p_sql(1) := ' select distinct prh.*' ||
1327: ' from po_requisition_headers_all prh,' ||
1328: ' po_requisition_lines_all prl,' ||
1329: ' po_req_distributions_all prd,'||
1330: ' po_line_locations_all pll,po_distributions_all pd,'||
1331: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||

Line 1344: ' from po_requisition_headers_all prh,' ||

1340: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1341: ' AND rsh.ship_to_org_id ='||l_org_id;
1342:
1343: p_sql(2) := ' select distinct prl.*' ||
1344: ' from po_requisition_headers_all prh,' ||
1345: ' po_requisition_lines_all prl,' ||
1346: ' po_req_distributions_all prd,'||
1347: ' po_line_locations_all pll,po_distributions_all pd,'||
1348: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||

Line 1361: ' from po_requisition_headers_all prh,' ||

1357: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1358: ' AND rsh.ship_to_org_id ='||l_org_id;
1359:
1360: p_sql(3) := ' select distinct prd.*' ||
1361: ' from po_requisition_headers_all prh,' ||
1362: ' po_requisition_lines_all prl,' ||
1363: ' po_req_distributions_all prd,'||
1364: ' po_line_locations_all pll,po_distributions_all pd,'||
1365: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||

Line 1914: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;

1910: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)
1911: IS
1912:
1913: -- Initialize Local Variables.
1914: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
1915: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;
1916: l_receipt_number rcv_shipment_headers.receipt_num%TYPE := p_receipt_number;
1917: l_line_num VARCHAR2(1000) := p_line_num;
1918: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;

Line 1915: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;

1911: IS
1912:
1913: -- Initialize Local Variables.
1914: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
1915: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;
1916: l_receipt_number rcv_shipment_headers.receipt_num%TYPE := p_receipt_number;
1917: l_line_num VARCHAR2(1000) := p_line_num;
1918: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
1919:

Line 1928: ' from po_requisition_headers_all prh,' ||

1924: l_line_num := ' prl.line_num ';
1925: END IF;
1926:
1927: p_sql(1) := ' select distinct prh.*' ||
1928: ' from po_requisition_headers_all prh,' ||
1929: ' po_requisition_lines_all prl' ||
1930: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1931: ' and prh.segment1 = '||''''||l_req_number||''''||
1932: ' and prh.org_id = '||l_operating_id||

Line 1939: ' po_requisition_headers_all prh, ' ||

1935: ' and prl.source_type_code = ''VENDOR'' ';
1936:
1937: p_sql(2) := ' select distinct prl.*' ||
1938: ' from po_requisition_lines_all prl,' ||
1939: ' po_requisition_headers_all prh, ' ||
1940: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl,
1941: po_line_locations_all pll ' ||
1942: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1943: ' and pll.line_location_id = prl.line_location_id ' ||

Line 1958: ' po_requisition_headers_all prh,' ||

1954:
1955: p_sql(3) := ' select distinct prd.*' ||
1956: ' from po_req_distributions_all prd ,' ||
1957: ' po_requisition_lines_all prl ,' ||
1958: ' po_requisition_headers_all prh,' ||
1959: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl,
1960: po_line_locations_all pll ' ||
1961: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1962: ' and prh.requisition_header_id = prl.requisition_header_id' ||

Line 1980: ' po_requisition_headers_all prh,' ||

1976: ' from po_headers_all ph,' ||
1977: ' po_distributions_all pd,' ||
1978: ' po_req_distributions_all prd ,' ||
1979: ' po_requisition_lines_all prl ,' ||
1980: ' po_requisition_headers_all prh,' ||
1981: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
1982: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1983: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1984: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2003: ' po_requisition_headers_all prh,' ||

1999: ' po_headers_all ph,' ||
2000: ' po_distributions_all pd,' ||
2001: ' po_req_distributions_all prd ,' ||
2002: ' po_requisition_lines_all prl ,' ||
2003: ' po_requisition_headers_all prh,' ||
2004: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
2005: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2006: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2007: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2028: ' po_requisition_headers_all prh,' ||

2024: ' po_headers_all ph,' ||
2025: ' po_distributions_all pd,' ||
2026: ' po_req_distributions_all prd ,' ||
2027: ' po_requisition_lines_all prl ,' ||
2028: ' po_requisition_headers_all prh,' ||
2029: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
2030: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2031: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2032: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2055: ' po_requisition_headers_all prh ,' ||

2051: ' po_headers_all ph , ' ||
2052: ' po_distributions_all pd,' ||
2053: ' po_req_distributions_all prd ,' ||
2054: ' po_requisition_lines_all prl ,' ||
2055: ' po_requisition_headers_all prh ,' ||
2056: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
2057: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2058: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2059: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2083: ' po_requisition_headers_all prh' ||

2079: ' po_headers_all ph , ' ||
2080: ' po_distributions_all pd,' ||
2081: ' po_req_distributions_all prd ,' ||
2082: ' po_requisition_lines_all prl ,' ||
2083: ' po_requisition_headers_all prh' ||
2084: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2085: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2086: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2087: ' and prl.source_type_code = ''VENDOR''' ||

Line 2110: ' po_requisition_headers_all prh, ' ||

2106: ' po_line_locations_all pll , ' ||--Bug#6882986
2107: ' po_distributions_all pd,' ||
2108: ' po_req_distributions_all prd ,' ||
2109: ' po_requisition_lines_all prl ,' ||
2110: ' po_requisition_headers_all prh, ' ||
2111: ' rcv_shipment_headers rsh ' ||
2112: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2113: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2114: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2138: ' po_requisition_headers_all prh, ' ||

2134: ' po_headers_all ph , ' ||
2135: ' po_distributions_all pd,' ||
2136: ' po_req_distributions_all prd ,' ||
2137: ' po_requisition_lines_all prl ,' ||
2138: ' po_requisition_headers_all prh, ' ||
2139: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2140: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2141: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2142: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2166: ' po_requisition_headers_all prh, ' ||

2162: ' po_headers_all ph , ' ||
2163: ' po_distributions_all pd,' ||
2164: ' po_req_distributions_all prd ,' ||
2165: ' po_requisition_lines_all prl ,' ||
2166: ' po_requisition_headers_all prh, ' ||
2167: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2168: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2169: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2170: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2197: ' po_requisition_headers_all prh, ' ||

2193: ' po_headers_all ph , ' ||
2194: ' po_distributions_all pd,' ||
2195: ' po_req_distributions_all prd ,' ||
2196: ' po_requisition_lines_all prl ,' ||
2197: ' po_requisition_headers_all prh, ' ||
2198: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2199: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2200: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2201: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2226: ' po_requisition_headers_all prh, ' ||

2222: ' po_headers_all ph , ' ||
2223: ' po_distributions_all pd,' ||
2224: ' po_req_distributions_all prd ,' ||
2225: ' po_requisition_lines_all prl ,' ||
2226: ' po_requisition_headers_all prh, ' ||
2227: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2228: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2229: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2230: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2254: ' po_requisition_headers_all prh, ' ||

2250: ' po_headers_all ph , ' ||
2251: ' po_distributions_all pd,' ||
2252: ' po_req_distributions_all prd ,' ||
2253: ' po_requisition_lines_all prl ,' ||
2254: ' po_requisition_headers_all prh, ' ||
2255: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2256: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2257: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2258: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2282: ' po_requisition_headers_all prh ' ||

2278: ' po_line_locations_all pll , ' ||
2279: ' po_distributions_all pd,' ||
2280: ' po_req_distributions_all prd ,' ||
2281: ' po_requisition_lines_all prl ,' ||
2282: ' po_requisition_headers_all prh ' ||
2283: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2284: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2285: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2286: ' and prl.source_type_code = ''VENDOR''' ||

Line 2304: ' po_requisition_headers_all prh ' ||

2300: ' po_line_locations_all pll , ' ||
2301: ' po_distributions_all pd,' ||
2302: ' po_req_distributions_all prd ,' ||
2303: ' po_requisition_lines_all prl ,' ||
2304: ' po_requisition_headers_all prh ' ||
2305: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2306: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2307: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2308: ' and prl.source_type_code = ''VENDOR''' ||

Line 2326: ' po_requisition_headers_all prh ' ||

2322: ' po_line_locations_all pll , ' ||
2323: ' po_distributions_all pd,' ||
2324: ' po_req_distributions_all prd ,' ||
2325: ' po_requisition_lines_all prl ,' ||
2326: ' po_requisition_headers_all prh ' ||
2327: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2328: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2329: ' and rsh.receipt_num = '||''''||l_receipt_number||'''' ||
2330: ' and rsh.ship_to_org_id = '|| l_org_id ||

Line 2348: ' po_requisition_headers_all prh ,' ||

2344: ' po_line_locations_all pll , ' ||
2345: ' po_distributions_all pd,' ||
2346: ' po_req_distributions_all prd ,' ||
2347: ' po_requisition_lines_all prl ,' ||
2348: ' po_requisition_headers_all prh ,' ||
2349: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl'||
2350: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2351: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2352: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2371: ' po_requisition_headers_all prh , rcv_shipment_headers rsh,

2367: ' po_line_locations_all pll , ' ||
2368: ' po_distributions_all pd,' ||
2369: ' po_req_distributions_all prd ,' ||
2370: ' po_requisition_lines_all prl ,' ||
2371: ' po_requisition_headers_all prh , rcv_shipment_headers rsh,
2372: rcv_shipment_lines rsl ' ||
2373: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2374: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2375: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2400: ' po_requisition_headers_all prh ' ||

2396: ' po_headers_all ph , ' ||
2397: ' po_distributions_all pd,' ||
2398: ' po_req_distributions_all prd ,' ||
2399: ' po_requisition_lines_all prl ,' ||
2400: ' po_requisition_headers_all prh ' ||
2401: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2402: ' and prh.requisition_header_id =
2403: prl.requisition_header_id' ||
2404: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2431: ' po_requisition_headers_all prh ' ||

2427: ' po_headers_all ph , ' ||
2428: ' po_distributions_all pd,' ||
2429: ' po_req_distributions_all prd ,' ||
2430: ' po_requisition_lines_all prl ,' ||
2431: ' po_requisition_headers_all prh ' ||
2432: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2433: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2434: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2435: ' and prl.source_type_code = ''VENDOR''' ||

Line 2461: ' po_requisition_headers_all prh ' ||

2457: ' po_headers_all ph , ' ||
2458: ' po_distributions_all pd,' ||
2459: ' po_req_distributions_all prd ,' ||
2460: ' po_requisition_lines_all prl ,' ||
2461: ' po_requisition_headers_all prh ' ||
2462: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2463: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2464: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2465: ' and prl.source_type_code = ''VENDOR''' ||

Line 2491: ' po_requisition_headers_all prh ' ||

2487: ' po_line_locations_all pll , ' ||
2488: ' po_distributions_all pd,' ||
2489: ' po_req_distributions_all prd ,' ||
2490: ' po_requisition_lines_all prl ,' ||
2491: ' po_requisition_headers_all prh ' ||
2492: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2493: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2494: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2495: ' and prl.source_type_code = ''VENDOR''' ||

Line 2508: ' po_requisition_headers_all prh,' ||

2504: 'pie.interface_line_id = rti.interface_transaction_id)';
2505:
2506: p_sql(22) := ' select distinct msi.*' ||
2507: ' from po_requisition_lines_all prl,' ||
2508: ' po_requisition_headers_all prh,' ||
2509: ' mtl_system_items msi , po_line_locations_all pll, rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2510: ' where prh.segment1 = '||''''||l_req_number||''''||
2511: ' and prh.org_id = '||l_operating_id||
2512: ' and prl.line_num='||l_line_num||

Line 2532: ' po_requisition_headers_all prh, ' ||

2528: ' po_headers_all ph , ' ||
2529: ' po_distributions_all pd,' ||
2530: ' po_req_distributions_all prd ,' ||
2531: ' po_requisition_lines_all prl ,' ||
2532: ' po_requisition_headers_all prh, ' ||
2533: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2534: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2535: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2536: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2570: ' po_requisition_headers_all prh, ' ||

2566: ' po_headers_all ph , ' ||
2567: ' po_distributions_all pd,' ||
2568: ' po_req_distributions_all prd ,' ||
2569: ' po_requisition_lines_all prl ,' ||
2570: ' po_requisition_headers_all prh, ' ||
2571: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2572: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2573: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2574: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2603: ' po_requisition_headers_all prh, ' ||

2599: ' po_headers_all ph , ' ||
2600: ' po_distributions_all pd,' ||
2601: ' po_req_distributions_all prd ,' ||
2602: ' po_requisition_lines_all prl ,' ||
2603: ' po_requisition_headers_all prh, ' ||
2604: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2605: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2606: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2607: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2635: ' po_requisition_headers_all prh, ' ||

2631: ' po_line_locations_all pll , ' ||
2632: ' po_distributions_all pd,' ||
2633: ' po_req_distributions_all prd ,' ||
2634: ' po_requisition_lines_all prl ,' ||
2635: ' po_requisition_headers_all prh, ' ||
2636: ' rcv_shipment_headers rsh '||
2637: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2638: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2639: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2665: ' po_requisition_headers_all prh, ' ||

2661: ' po_line_locations_all pll , ' ||
2662: ' po_distributions_all pd,' ||
2663: ' po_req_distributions_all prd ,' ||
2664: ' po_requisition_lines_all prl ,' ||
2665: ' po_requisition_headers_all prh, ' ||
2666: ' rcv_shipment_headers rsh '||
2667: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2668: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2669: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2695: ' po_requisition_headers_all prh, ' ||

2691: ' po_headers_all ph , ' ||
2692: ' po_distributions_all pd,' ||
2693: ' po_req_distributions_all prd ,' ||
2694: ' po_requisition_lines_all prl ,' ||
2695: ' po_requisition_headers_all prh, ' ||
2696: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2697: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2698: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2699: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2726: ' po_requisition_headers_all prh ' ||

2722: ' po_headers_all ph , ' ||
2723: ' po_distributions_all pd,' ||
2724: ' po_req_distributions_all prd ,' ||
2725: ' po_requisition_lines_all prl ,' ||
2726: ' po_requisition_headers_all prh ' ||
2727: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2728: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2729: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2730: ' and prl.source_type_code = ''VENDOR''' ||

Line 2748: ' po_requisition_headers_all prh ' ||

2744: p_sql(28) := ' SELECT DISTINCT mp.* ' ||
2745: ' from mtl_parameters mp ,' ||
2746: ' financials_system_params_all fsp,' ||
2747: ' po_requisition_lines_all prl ,' ||
2748: ' po_requisition_headers_all prh ' ||
2749: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2750: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2751: ' and prl.source_type_code = ''VENDOR''' ||
2752: ' AND fsp.org_id = prh.org_id ' ||

Line 2764: ' po_requisition_headers_all prh ' ||

2760: p_sql(29) := ' SELECT DISTINCT rp.* ' ||
2761: ' from rcv_parameters rp , ' ||
2762: ' financials_system_params_all fsp, ' ||
2763: ' po_requisition_lines_all prl ,' ||
2764: ' po_requisition_headers_all prh ' ||
2765: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2766: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2767: ' and prl.source_type_code = ''VENDOR''' ||
2768: ' AND fsp.org_id = prh.org_id ' ||

Line 2779: ' po_requisition_headers_all prh ' ||

2775:
2776: p_sql(30) := ' SELECT psp.* ' ||
2777: ' from po_system_parameters_all psp, ' ||
2778: ' po_requisition_lines_all prl ,' ||
2779: ' po_requisition_headers_all prh ' ||
2780: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2781: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2782: ' and prl.source_type_code = ''VENDOR''' ||
2783: ' and psp.org_id = prh.org_id ' ||

Line 2792: ' po_requisition_headers_all prh ' ||

2788:
2789: p_sql(31) := ' SELECT fsp.* ' ||
2790: ' from financials_system_params_all fsp, ' ||
2791: ' po_requisition_lines_all prl ,' ||
2792: ' po_requisition_headers_all prh ' ||
2793: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2794: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2795: ' and prl.source_type_code = ''VENDOR''' ||
2796: ' and fsp.org_id = prh.org_id ' ||

Line 2811: ' po_requisition_headers_all prh,' ||

2807: ' po_headers_all ph , ' ||
2808: ' po_distributions_all pd,' ||
2809: ' po_req_distributions_all prd ,' ||
2810: ' po_requisition_lines_all prl ,' ||
2811: ' po_requisition_headers_all prh,' ||
2812: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2813: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2814: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2815: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2847: ' po_requisition_headers_all prh, ' ||

2843: ' po_headers_all ph , ' ||
2844: ' po_distributions_all pd,' ||
2845: ' po_req_distributions_all prd ,' ||
2846: ' po_requisition_lines_all prl ,' ||
2847: ' po_requisition_headers_all prh, ' ||
2848: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2849: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2850: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2851: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2883: ' po_requisition_headers_all prh, ' ||

2879: ' po_headers_all ph , ' ||
2880: ' po_distributions_all pd,' ||
2881: ' po_req_distributions_all prd ,' ||
2882: ' po_requisition_lines_all prl ,' ||
2883: ' po_requisition_headers_all prh, ' ||
2884: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2885: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2886: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2887: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2914: ' po_requisition_headers_all prh ,' ||

2910: ' po_headers_all ph , ' ||
2911: ' po_distributions_all pd,' ||
2912: ' po_req_distributions_all prd ,' ||
2913: ' po_requisition_lines_all prl ,' ||
2914: ' po_requisition_headers_all prh ,' ||
2915: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2916: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2917: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2918: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2948: ' po_requisition_headers_all prh, ' ||

2944: ' po_headers_all ph , ' ||
2945: ' po_distributions_all pd,' ||
2946: ' po_req_distributions_all prd ,' ||
2947: ' po_requisition_lines_all prl ,' ||
2948: ' po_requisition_headers_all prh, ' ||
2949: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl' ||
2950: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2951: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2952: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2980: ' po_requisition_headers_all prh, ' ||

2976: ' po_headers_all ph , ' ||
2977: ' po_distributions_all pd,' ||
2978: ' po_req_distributions_all prd ,' ||
2979: ' po_requisition_lines_all prl ,' ||
2980: ' po_requisition_headers_all prh, ' ||
2981: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2982: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2983: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2984: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3012: ' po_requisition_headers_all prh, ' ||

3008: ' po_headers_all ph , ' ||
3009: ' po_distributions_all pd,' ||
3010: ' po_req_distributions_all prd ,' ||
3011: ' po_requisition_lines_all prl ,' ||
3012: ' po_requisition_headers_all prh, ' ||
3013: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
3014: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3015: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3016: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3044: ' po_requisition_headers_all prh, ' ||

3040: ' po_headers_all ph , ' ||
3041: ' po_distributions_all pd,' ||
3042: ' po_req_distributions_all prd ,' ||
3043: ' po_requisition_lines_all prl ,' ||
3044: ' po_requisition_headers_all prh, ' ||
3045: ' rcv_shipment_headers rsh ' ||
3046: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3047: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3048: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3073: ' po_requisition_headers_all prh, ' ||

3069: ' po_headers_all ph , ' ||
3070: ' po_distributions_all pd,' ||
3071: ' po_req_distributions_all prd ,' ||
3072: ' po_requisition_lines_all prl ,' ||
3073: ' po_requisition_headers_all prh, ' ||
3074: ' rcv_shipment_headers rsh ' ||
3075: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3076: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3077: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3104: ' po_requisition_headers_all prh, ' ||

3100: ' po_headers_all ph , ' ||
3101: ' po_distributions_all pd,' ||
3102: ' po_req_distributions_all prd ,' ||
3103: ' po_requisition_lines_all prl ,' ||
3104: ' po_requisition_headers_all prh, ' ||
3105: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
3106: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3107: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3108: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3137: ' po_requisition_headers_all prh, ' ||

3133: ' po_headers_all ph , ' ||
3134: ' po_distributions_all pd,' ||
3135: ' po_req_distributions_all prd ,' ||
3136: ' po_requisition_lines_all prl ,' ||
3137: ' po_requisition_headers_all prh, ' ||
3138: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
3139: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3140: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3141: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3172: ' po_requisition_headers_all prh, ' ||

3168: ' po_headers_all ph , ' ||
3169: ' po_distributions_all pd,' ||
3170: ' po_req_distributions_all prd ,' ||
3171: ' po_requisition_lines_all prl ,' ||
3172: ' po_requisition_headers_all prh, ' ||
3173: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
3174: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3175: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3176: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3206: ' po_requisition_headers_all prh ' ||

3202: ' po_headers_all ph , ' ||
3203: ' po_distributions_all pd,' ||
3204: ' po_req_distributions_all prd ,' ||
3205: ' po_requisition_lines_all prl ,' ||
3206: ' po_requisition_headers_all prh ' ||
3207: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3208: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3209: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3210: ' and prl.source_type_code = ''VENDOR''' ||

Line 3233: ' po_requisition_headers_all prh, ' ||

3229: ' po_headers_all ph , ' ||
3230: ' po_distributions_all pd,' ||
3231: ' po_req_distributions_all prd ,' ||
3232: ' po_requisition_lines_all prl ,' ||
3233: ' po_requisition_headers_all prh, ' ||
3234: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
3235: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3236: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3237: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3264: ' po_requisition_headers_all prh, ' ||

3260: ' po_headers_all ph , ' ||
3261: ' po_distributions_all pd,' ||
3262: ' po_req_distributions_all prd ,' ||
3263: ' po_requisition_lines_all prl ,' ||
3264: ' po_requisition_headers_all prh, ' ||
3265: ' rcv_shipment_headers rsh ' ||
3266: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3267: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3268: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3295: ' po_requisition_headers_all prh, ' ||

3291: ' po_headers_all ph , ' ||
3292: ' po_distributions_all pd,' ||
3293: ' po_req_distributions_all prd ,' ||
3294: ' po_requisition_lines_all prl ,' ||
3295: ' po_requisition_headers_all prh, ' ||
3296: ' rcv_shipment_headers rsh ' ||
3297: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3298: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3299: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 3329: ' po_requisition_headers_all prh ' ||

3325: ' po_headers_all ph , ' ||
3326: ' po_distributions_all pd,' ||
3327: ' po_req_distributions_all prd ,' ||
3328: ' po_requisition_lines_all prl ,' ||
3329: ' po_requisition_headers_all prh ' ||
3330: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3331: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3332: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3333: ' and prl.source_type_code = ''VENDOR''' ||