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_PO dependencies on JTF_DIAGNOSTIC_COREAPI

Line 111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

107:
108: BEGIN
109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));

Line 130: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');

126: ------------------------------------------
127: IF l_po_number IS NULL THEN
128:
129: IF (l_receipt_num IS NULL OR l_org_id IS NULL) THEN
130: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
132: statusStr := 'FAILURE';
133: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
134: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');

127: IF l_po_number IS NULL THEN
128:
129: IF (l_receipt_num IS NULL OR l_org_id IS NULL) THEN
130: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
132: statusStr := 'FAILURE';
133: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
134: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
135: RETURN;

Line 138: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');

134: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
135: RETURN;
136: END IF;
137: ELSIF l_operating_id IS NULL THEN
138: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
139: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
140: statusStr := 'FAILURE';
141: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
142: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 139: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');

135: RETURN;
136: END IF;
137: ELSIF l_operating_id IS NULL THEN
138: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
139: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
140: statusStr := 'FAILURE';
141: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
142: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
143: RETURN;

Line 146: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');

142: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
143: RETURN;
144: ELSE
145: IF (l_receipt_num IS NOT NULL AND l_po_number IS NULL AND l_org_id IS NULL) THEN
146: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
147: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
148: statusStr := 'FAILURE';
149: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
150: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 147: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');

143: RETURN;
144: ELSE
145: IF (l_receipt_num IS NOT NULL AND l_po_number IS NULL AND l_org_id IS NULL) THEN
146: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
147: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
148: statusStr := 'FAILURE';
149: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
150: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
151: RETURN;

Line 182: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');

178: AND rsh.receipt_num=l_receipt_num
179: AND rsh.ship_to_org_id=l_org_id;
180: IF l_count = 0 THEN
181: statusStr := 'FAILURE';
182: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
183: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
184: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
185: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
186: RETURN;

Line 183: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');

179: AND rsh.ship_to_org_id=l_org_id;
180: IF l_count = 0 THEN
181: statusStr := 'FAILURE';
182: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
183: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
184: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
185: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
186: RETURN;
187: END IF;

Line 205: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');

201: AND rsh.receipt_num=l_receipt_num
202: AND rsh.ship_to_org_id=l_org_id;
203: IF l_count = 0 THEN
204: statusStr := 'FAILURE';
205: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number,Operating unit id,Receipt num and Organization_id.');
207: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
208: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
209: RETURN;

Line 206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number,Operating unit id,Receipt num and Organization_id.');

202: AND rsh.ship_to_org_id=l_org_id;
203: IF l_count = 0 THEN
204: statusStr := 'FAILURE';
205: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number,Operating unit id,Receipt num and Organization_id.');
207: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
208: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
209: RETURN;
210: END IF;

Line 221: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');

217: where ph.segment1=l_po_number
218: AND ph.org_id=l_operating_id;
219: IF l_count = 0 THEN
220: statusStr := 'FAILURE';
221: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
222: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number and Operating unit id.');
223: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
224: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
225: RETURN;

Line 222: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number and Operating unit id.');

218: AND ph.org_id=l_operating_id;
219: IF l_count = 0 THEN
220: statusStr := 'FAILURE';
221: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
222: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number and Operating unit id.');
223: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
224: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
225: RETURN;
226: END IF;

Line 238: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');

234: AND rsh.receipt_num=l_receipt_num
235: AND rsh.ship_to_org_id=l_org_id;
236: IF l_count = 0 THEN
237: statusStr := 'FAILURE';
238: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
240: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
241: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
242: RETURN;

Line 239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');

235: AND rsh.ship_to_org_id=l_org_id;
236: IF l_count = 0 THEN
237: statusStr := 'FAILURE';
238: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
240: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
241: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
242: RETURN;
243: END IF;

Line 284: JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
280:
281: -----------------------------------------
282: -- Code to Build the Index of HTML tables
283: -----------------------------------------
284: JTF_DIAGNOSTIC_COREAPI.insert_html('

'||'
285: '||'
286: '||'
287: '||'
288: '||'
Line 363: JTF_DIAGNOSTIC_COREAPI.insert_html('
Purchase Order Details
');
359:
360: -------------------
361: -- Execute the Sqls
362: -------------------
363: JTF_DIAGNOSTIC_COREAPI.insert_html('
Purchase Order Details
');
364: sql_text := po_sql(1);
365: JTF_DIAGNOSTIC_COREAPI.insert_html('');
366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
Line 365: JTF_DIAGNOSTIC_COREAPI.insert_html('');

361: -- Execute the Sqls
362: -------------------
363: JTF_DIAGNOSTIC_COREAPI.insert_html('
Purchase Order Details
');
364: sql_text := po_sql(1);
365: JTF_DIAGNOSTIC_COREAPI.insert_html('');
366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
Line 366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');

362: -------------------
363: JTF_DIAGNOSTIC_COREAPI.insert_html('
Purchase Order Details
');
364: sql_text := po_sql(1);
365: JTF_DIAGNOSTIC_COREAPI.insert_html('');
366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
Line 367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

363: JTF_DIAGNOSTIC_COREAPI.insert_html('
Purchase Order Details
');
364: sql_text := po_sql(1);
365: JTF_DIAGNOSTIC_COREAPI.insert_html('');
366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 368: JTF_DIAGNOSTIC_COREAPI.BRPrint;

364: sql_text := po_sql(1);
365: JTF_DIAGNOSTIC_COREAPI.insert_html('');
366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');

Line 371: JTF_DIAGNOSTIC_COREAPI.insert_html('');

367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:

Line 372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');

368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);

Line 373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 374: JTF_DIAGNOSTIC_COREAPI.BRPrint;

370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');

Line 377: JTF_DIAGNOSTIC_COREAPI.insert_html('');

373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:

Line 378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');

374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:
382: sql_text := po_sql(4);

Line 379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:
382: sql_text := po_sql(4);
383: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 380: JTF_DIAGNOSTIC_COREAPI.BRPrint;

376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:
382: sql_text := po_sql(4);
383: JTF_DIAGNOSTIC_COREAPI.insert_html('');
384: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');

Line 383: JTF_DIAGNOSTIC_COREAPI.insert_html('');

379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:
382: sql_text := po_sql(4);
383: JTF_DIAGNOSTIC_COREAPI.insert_html('');
384: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
385: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
386: JTF_DIAGNOSTIC_COREAPI.BRPrint;
387:

Line 384: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');

380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:
382: sql_text := po_sql(4);
383: JTF_DIAGNOSTIC_COREAPI.insert_html('');
384: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
385: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
386: JTF_DIAGNOSTIC_COREAPI.BRPrint;
387:
388: sql_text := po_sql(5);

Line 385: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

381:
382: sql_text := po_sql(4);
383: JTF_DIAGNOSTIC_COREAPI.insert_html('');
384: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
385: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
386: JTF_DIAGNOSTIC_COREAPI.BRPrint;
387:
388: sql_text := po_sql(5);
389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
Line 386: JTF_DIAGNOSTIC_COREAPI.BRPrint;

382: sql_text := po_sql(4);
383: JTF_DIAGNOSTIC_COREAPI.insert_html('');
384: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
385: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
386: JTF_DIAGNOSTIC_COREAPI.BRPrint;
387:
388: sql_text := po_sql(5);
389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
390: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
385: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
386: JTF_DIAGNOSTIC_COREAPI.BRPrint;
387:
388: sql_text := po_sql(5);
389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
390: JTF_DIAGNOSTIC_COREAPI.insert_html('');
391: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 390: JTF_DIAGNOSTIC_COREAPI.insert_html('');

386: JTF_DIAGNOSTIC_COREAPI.BRPrint;
387:
388: sql_text := po_sql(5);
389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
390: JTF_DIAGNOSTIC_COREAPI.insert_html('');
391: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
394:
Line 391: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');

387:
388: sql_text := po_sql(5);
389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
390: JTF_DIAGNOSTIC_COREAPI.insert_html('');
391: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
394:
395: sql_text:= po_sql(6);
Line 392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

388: sql_text := po_sql(5);
389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
390: JTF_DIAGNOSTIC_COREAPI.insert_html('');
391: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
394:
395: sql_text:= po_sql(6);
396: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 393: JTF_DIAGNOSTIC_COREAPI.BRPrint;

389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Invoice Details
');
390: JTF_DIAGNOSTIC_COREAPI.insert_html('');
391: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
394:
395: sql_text:= po_sql(6);
396: JTF_DIAGNOSTIC_COREAPI.insert_html('');
397: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
Line 396: JTF_DIAGNOSTIC_COREAPI.insert_html('');

392: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
394:
395: sql_text:= po_sql(6);
396: JTF_DIAGNOSTIC_COREAPI.insert_html('');
397: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
398: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
399: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400:

Line 397: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');

393: JTF_DIAGNOSTIC_COREAPI.BRPrint;
394:
395: sql_text:= po_sql(6);
396: JTF_DIAGNOSTIC_COREAPI.insert_html('');
397: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
398: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
399: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400:
401: sql_text := po_sql(7);

Line 398: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

394:
395: sql_text:= po_sql(6);
396: JTF_DIAGNOSTIC_COREAPI.insert_html('');
397: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
398: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
399: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400:
401: sql_text := po_sql(7);
402: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 399: JTF_DIAGNOSTIC_COREAPI.BRPrint;

395: sql_text:= po_sql(6);
396: JTF_DIAGNOSTIC_COREAPI.insert_html('');
397: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
398: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
399: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400:
401: sql_text := po_sql(7);
402: JTF_DIAGNOSTIC_COREAPI.insert_html('');
403: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');

Line 402: JTF_DIAGNOSTIC_COREAPI.insert_html('');

398: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
399: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400:
401: sql_text := po_sql(7);
402: JTF_DIAGNOSTIC_COREAPI.insert_html('');
403: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');
404: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
405: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406:

Line 403: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');

399: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400:
401: sql_text := po_sql(7);
402: JTF_DIAGNOSTIC_COREAPI.insert_html('');
403: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');
404: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
405: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406:
407: sql_text := po_sql(8);

Line 404: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

400:
401: sql_text := po_sql(7);
402: JTF_DIAGNOSTIC_COREAPI.insert_html('');
403: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');
404: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
405: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406:
407: sql_text := po_sql(8);
408: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 405: JTF_DIAGNOSTIC_COREAPI.BRPrint;

401: sql_text := po_sql(7);
402: JTF_DIAGNOSTIC_COREAPI.insert_html('');
403: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');
404: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
405: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406:
407: sql_text := po_sql(8);
408: JTF_DIAGNOSTIC_COREAPI.insert_html('');
409: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');

Line 408: JTF_DIAGNOSTIC_COREAPI.insert_html('');

404: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
405: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406:
407: sql_text := po_sql(8);
408: JTF_DIAGNOSTIC_COREAPI.insert_html('');
409: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');
410: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
411: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412:

Line 409: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');

405: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406:
407: sql_text := po_sql(8);
408: JTF_DIAGNOSTIC_COREAPI.insert_html('');
409: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');
410: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
411: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412:
413: sql_text := po_sql(9);

Line 410: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

406:
407: sql_text := po_sql(8);
408: JTF_DIAGNOSTIC_COREAPI.insert_html('');
409: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');
410: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
411: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412:
413: sql_text := po_sql(9);
414: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 411: JTF_DIAGNOSTIC_COREAPI.BRPrint;

407: sql_text := po_sql(8);
408: JTF_DIAGNOSTIC_COREAPI.insert_html('');
409: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');
410: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
411: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412:
413: sql_text := po_sql(9);
414: JTF_DIAGNOSTIC_COREAPI.insert_html('');
415: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');

Line 414: JTF_DIAGNOSTIC_COREAPI.insert_html('');

410: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
411: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412:
413: sql_text := po_sql(9);
414: JTF_DIAGNOSTIC_COREAPI.insert_html('');
415: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
417: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418:

Line 415: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');

411: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412:
413: sql_text := po_sql(9);
414: JTF_DIAGNOSTIC_COREAPI.insert_html('');
415: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
417: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418:
419: sql_text:= po_sql(10);

Line 416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

412:
413: sql_text := po_sql(9);
414: JTF_DIAGNOSTIC_COREAPI.insert_html('');
415: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
417: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418:
419: sql_text:= po_sql(10);
420: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 417: JTF_DIAGNOSTIC_COREAPI.BRPrint;

413: sql_text := po_sql(9);
414: JTF_DIAGNOSTIC_COREAPI.insert_html('');
415: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
417: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418:
419: sql_text:= po_sql(10);
420: JTF_DIAGNOSTIC_COREAPI.insert_html('');
421: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');

Line 420: JTF_DIAGNOSTIC_COREAPI.insert_html('');

416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
417: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418:
419: sql_text:= po_sql(10);
420: JTF_DIAGNOSTIC_COREAPI.insert_html('');
421: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
422: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
423: JTF_DIAGNOSTIC_COREAPI.BRPrint;
424:

Line 421: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');

417: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418:
419: sql_text:= po_sql(10);
420: JTF_DIAGNOSTIC_COREAPI.insert_html('');
421: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
422: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
423: JTF_DIAGNOSTIC_COREAPI.BRPrint;
424:
425: sql_text:= po_sql(11);

Line 422: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

418:
419: sql_text:= po_sql(10);
420: JTF_DIAGNOSTIC_COREAPI.insert_html('');
421: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
422: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
423: JTF_DIAGNOSTIC_COREAPI.BRPrint;
424:
425: sql_text:= po_sql(11);
426:

Line 423: JTF_DIAGNOSTIC_COREAPI.BRPrint;

419: sql_text:= po_sql(10);
420: JTF_DIAGNOSTIC_COREAPI.insert_html('');
421: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
422: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
423: JTF_DIAGNOSTIC_COREAPI.BRPrint;
424:
425: sql_text:= po_sql(11);
426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
Line 427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
423: JTF_DIAGNOSTIC_COREAPI.BRPrint;
424:
425: sql_text:= po_sql(11);
426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
428: JTF_DIAGNOSTIC_COREAPI.insert_html('');
429: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 428: JTF_DIAGNOSTIC_COREAPI.insert_html('');

424:
425: sql_text:= po_sql(11);
426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
428: JTF_DIAGNOSTIC_COREAPI.insert_html('');
429: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
Line 429: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');

425: sql_text:= po_sql(11);
426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
428: JTF_DIAGNOSTIC_COREAPI.insert_html('');
429: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
Line 430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
428: JTF_DIAGNOSTIC_COREAPI.insert_html('');
429: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 431: JTF_DIAGNOSTIC_COREAPI.BRPrint;

427: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Details
');
428: JTF_DIAGNOSTIC_COREAPI.insert_html('');
429: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
Line 434: JTF_DIAGNOSTIC_COREAPI.insert_html('');

430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:

Line 435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:
439: sql_text:= po_sql(13);

Line 436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:
439: sql_text:= po_sql(13);
440: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 437: JTF_DIAGNOSTIC_COREAPI.BRPrint;

433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:
439: sql_text:= po_sql(13);
440: JTF_DIAGNOSTIC_COREAPI.insert_html('');
441: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');

Line 440: JTF_DIAGNOSTIC_COREAPI.insert_html('');

436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:
439: sql_text:= po_sql(13);
440: JTF_DIAGNOSTIC_COREAPI.insert_html('');
441: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
442: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
443: JTF_DIAGNOSTIC_COREAPI.BRPrint;
444:

Line 441: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');

437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:
439: sql_text:= po_sql(13);
440: JTF_DIAGNOSTIC_COREAPI.insert_html('');
441: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
442: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
443: JTF_DIAGNOSTIC_COREAPI.BRPrint;
444:
445: sql_text:= po_sql(14);

Line 442: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

438:
439: sql_text:= po_sql(13);
440: JTF_DIAGNOSTIC_COREAPI.insert_html('');
441: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
442: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
443: JTF_DIAGNOSTIC_COREAPI.BRPrint;
444:
445: sql_text:= po_sql(14);
446: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 443: JTF_DIAGNOSTIC_COREAPI.BRPrint;

439: sql_text:= po_sql(13);
440: JTF_DIAGNOSTIC_COREAPI.insert_html('');
441: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
442: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
443: JTF_DIAGNOSTIC_COREAPI.BRPrint;
444:
445: sql_text:= po_sql(14);
446: JTF_DIAGNOSTIC_COREAPI.insert_html('');
447: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');

Line 446: JTF_DIAGNOSTIC_COREAPI.insert_html('');

442: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
443: JTF_DIAGNOSTIC_COREAPI.BRPrint;
444:
445: sql_text:= po_sql(14);
446: JTF_DIAGNOSTIC_COREAPI.insert_html('');
447: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:

Line 447: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');

443: JTF_DIAGNOSTIC_COREAPI.BRPrint;
444:
445: sql_text:= po_sql(14);
446: JTF_DIAGNOSTIC_COREAPI.insert_html('');
447: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451: sql_text:= po_sql(15);

Line 448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

444:
445: sql_text:= po_sql(14);
446: JTF_DIAGNOSTIC_COREAPI.insert_html('');
447: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451: sql_text:= po_sql(15);
452: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 449: JTF_DIAGNOSTIC_COREAPI.BRPrint;

445: sql_text:= po_sql(14);
446: JTF_DIAGNOSTIC_COREAPI.insert_html('');
447: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451: sql_text:= po_sql(15);
452: JTF_DIAGNOSTIC_COREAPI.insert_html('');
453: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');

Line 452: JTF_DIAGNOSTIC_COREAPI.insert_html('');

448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451: sql_text:= po_sql(15);
452: JTF_DIAGNOSTIC_COREAPI.insert_html('');
453: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
455: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456:

Line 453: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');

449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451: sql_text:= po_sql(15);
452: JTF_DIAGNOSTIC_COREAPI.insert_html('');
453: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
455: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456:
457: sql_text:= po_sql(16);

Line 454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

450:
451: sql_text:= po_sql(15);
452: JTF_DIAGNOSTIC_COREAPI.insert_html('');
453: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
455: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456:
457: sql_text:= po_sql(16);
458: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 455: JTF_DIAGNOSTIC_COREAPI.BRPrint;

451: sql_text:= po_sql(15);
452: JTF_DIAGNOSTIC_COREAPI.insert_html('');
453: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
455: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456:
457: sql_text:= po_sql(16);
458: JTF_DIAGNOSTIC_COREAPI.insert_html('');
459: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');

Line 458: JTF_DIAGNOSTIC_COREAPI.insert_html('');

454: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
455: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456:
457: sql_text:= po_sql(16);
458: JTF_DIAGNOSTIC_COREAPI.insert_html('');
459: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
461: JTF_DIAGNOSTIC_COREAPI.BRPrint;
462:

Line 459: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');

455: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456:
457: sql_text:= po_sql(16);
458: JTF_DIAGNOSTIC_COREAPI.insert_html('');
459: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
461: JTF_DIAGNOSTIC_COREAPI.BRPrint;
462:
463: sql_text:= po_sql(17);

Line 460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

456:
457: sql_text:= po_sql(16);
458: JTF_DIAGNOSTIC_COREAPI.insert_html('');
459: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
461: JTF_DIAGNOSTIC_COREAPI.BRPrint;
462:
463: sql_text:= po_sql(17);
464: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 461: JTF_DIAGNOSTIC_COREAPI.BRPrint;

457: sql_text:= po_sql(16);
458: JTF_DIAGNOSTIC_COREAPI.insert_html('');
459: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
461: JTF_DIAGNOSTIC_COREAPI.BRPrint;
462:
463: sql_text:= po_sql(17);
464: JTF_DIAGNOSTIC_COREAPI.insert_html('');
465: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');

Line 464: JTF_DIAGNOSTIC_COREAPI.insert_html('');

460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
461: JTF_DIAGNOSTIC_COREAPI.BRPrint;
462:
463: sql_text:= po_sql(17);
464: JTF_DIAGNOSTIC_COREAPI.insert_html('');
465: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:

Line 465: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');

461: JTF_DIAGNOSTIC_COREAPI.BRPrint;
462:
463: sql_text:= po_sql(17);
464: JTF_DIAGNOSTIC_COREAPI.insert_html('');
465: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= po_sql(18);

Line 466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

462:
463: sql_text:= po_sql(17);
464: JTF_DIAGNOSTIC_COREAPI.insert_html('');
465: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= po_sql(18);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 467: JTF_DIAGNOSTIC_COREAPI.BRPrint;

463: sql_text:= po_sql(17);
464: JTF_DIAGNOSTIC_COREAPI.insert_html('');
465: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= po_sql(18);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

Line 470: JTF_DIAGNOSTIC_COREAPI.insert_html('');

466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= po_sql(18);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:

Line 471: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= po_sql(18);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= po_sql(19);

Line 472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

468:
469: sql_text:= po_sql(18);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= po_sql(19);
476:

Line 473: JTF_DIAGNOSTIC_COREAPI.BRPrint;

469: sql_text:= po_sql(18);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= po_sql(19);
476:
477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
Line 477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= po_sql(19);
476:
477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
478: JTF_DIAGNOSTIC_COREAPI.insert_html('');
479: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 478: JTF_DIAGNOSTIC_COREAPI.insert_html('');

474:
475: sql_text:= po_sql(19);
476:
477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
478: JTF_DIAGNOSTIC_COREAPI.insert_html('');
479: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
482:
Line 479: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');

475: sql_text:= po_sql(19);
476:
477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
478: JTF_DIAGNOSTIC_COREAPI.insert_html('');
479: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
482:
483: sql_text:= po_sql(20);
Line 480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

476:
477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
478: JTF_DIAGNOSTIC_COREAPI.insert_html('');
479: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
482:
483: sql_text:= po_sql(20);
484: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 481: JTF_DIAGNOSTIC_COREAPI.BRPrint;

477: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Details
');
478: JTF_DIAGNOSTIC_COREAPI.insert_html('');
479: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
482:
483: sql_text:= po_sql(20);
484: JTF_DIAGNOSTIC_COREAPI.insert_html('');
485: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
Line 484: JTF_DIAGNOSTIC_COREAPI.insert_html('');

480: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
482:
483: sql_text:= po_sql(20);
484: JTF_DIAGNOSTIC_COREAPI.insert_html('');
485: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
486: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
487: JTF_DIAGNOSTIC_COREAPI.BRPrint;
488:

Line 485: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');

481: JTF_DIAGNOSTIC_COREAPI.BRPrint;
482:
483: sql_text:= po_sql(20);
484: JTF_DIAGNOSTIC_COREAPI.insert_html('');
485: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
486: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
487: JTF_DIAGNOSTIC_COREAPI.BRPrint;
488:
489: sql_text:= po_sql(21);

Line 486: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

482:
483: sql_text:= po_sql(20);
484: JTF_DIAGNOSTIC_COREAPI.insert_html('');
485: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
486: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
487: JTF_DIAGNOSTIC_COREAPI.BRPrint;
488:
489: sql_text:= po_sql(21);
490: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 487: JTF_DIAGNOSTIC_COREAPI.BRPrint;

483: sql_text:= po_sql(20);
484: JTF_DIAGNOSTIC_COREAPI.insert_html('');
485: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
486: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
487: JTF_DIAGNOSTIC_COREAPI.BRPrint;
488:
489: sql_text:= po_sql(21);
490: JTF_DIAGNOSTIC_COREAPI.insert_html('');
491: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

Line 490: JTF_DIAGNOSTIC_COREAPI.insert_html('');

486: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
487: JTF_DIAGNOSTIC_COREAPI.BRPrint;
488:
489: sql_text:= po_sql(21);
490: JTF_DIAGNOSTIC_COREAPI.insert_html('');
491: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
492: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
493: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494:

Line 491: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

487: JTF_DIAGNOSTIC_COREAPI.BRPrint;
488:
489: sql_text:= po_sql(21);
490: JTF_DIAGNOSTIC_COREAPI.insert_html('');
491: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
492: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
493: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494:
495: sql_text:= po_sql(22);

Line 492: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

488:
489: sql_text:= po_sql(21);
490: JTF_DIAGNOSTIC_COREAPI.insert_html('');
491: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
492: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
493: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494:
495: sql_text:= po_sql(22);
496: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 493: JTF_DIAGNOSTIC_COREAPI.BRPrint;

489: sql_text:= po_sql(21);
490: JTF_DIAGNOSTIC_COREAPI.insert_html('');
491: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
492: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
493: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494:
495: sql_text:= po_sql(22);
496: JTF_DIAGNOSTIC_COREAPI.insert_html('');
497: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');

Line 496: JTF_DIAGNOSTIC_COREAPI.insert_html('');

492: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
493: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494:
495: sql_text:= po_sql(22);
496: JTF_DIAGNOSTIC_COREAPI.insert_html('');
497: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
498: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
499: JTF_DIAGNOSTIC_COREAPI.BRPrint;
500:

Line 497: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');

493: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494:
495: sql_text:= po_sql(22);
496: JTF_DIAGNOSTIC_COREAPI.insert_html('');
497: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
498: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
499: JTF_DIAGNOSTIC_COREAPI.BRPrint;
500:
501: sql_text:= po_sql(23);

Line 498: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

494:
495: sql_text:= po_sql(22);
496: JTF_DIAGNOSTIC_COREAPI.insert_html('');
497: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
498: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
499: JTF_DIAGNOSTIC_COREAPI.BRPrint;
500:
501: sql_text:= po_sql(23);
502: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 499: JTF_DIAGNOSTIC_COREAPI.BRPrint;

495: sql_text:= po_sql(22);
496: JTF_DIAGNOSTIC_COREAPI.insert_html('');
497: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
498: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
499: JTF_DIAGNOSTIC_COREAPI.BRPrint;
500:
501: sql_text:= po_sql(23);
502: JTF_DIAGNOSTIC_COREAPI.insert_html('');
503: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');

Line 502: JTF_DIAGNOSTIC_COREAPI.insert_html('');

498: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
499: JTF_DIAGNOSTIC_COREAPI.BRPrint;
500:
501: sql_text:= po_sql(23);
502: JTF_DIAGNOSTIC_COREAPI.insert_html('');
503: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
504: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
505: JTF_DIAGNOSTIC_COREAPI.BRPrint;
506:

Line 503: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');

499: JTF_DIAGNOSTIC_COREAPI.BRPrint;
500:
501: sql_text:= po_sql(23);
502: JTF_DIAGNOSTIC_COREAPI.insert_html('');
503: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
504: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
505: JTF_DIAGNOSTIC_COREAPI.BRPrint;
506:
507: sql_text:= po_sql(24);

Line 504: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

500:
501: sql_text:= po_sql(23);
502: JTF_DIAGNOSTIC_COREAPI.insert_html('');
503: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
504: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
505: JTF_DIAGNOSTIC_COREAPI.BRPrint;
506:
507: sql_text:= po_sql(24);
508:

Line 505: JTF_DIAGNOSTIC_COREAPI.BRPrint;

501: sql_text:= po_sql(23);
502: JTF_DIAGNOSTIC_COREAPI.insert_html('');
503: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
504: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
505: JTF_DIAGNOSTIC_COREAPI.BRPrint;
506:
507: sql_text:= po_sql(24);
508:
509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
Line 509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
505: JTF_DIAGNOSTIC_COREAPI.BRPrint;
506:
507: sql_text:= po_sql(24);
508:
509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('');
511: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 510: JTF_DIAGNOSTIC_COREAPI.insert_html('');

506:
507: sql_text:= po_sql(24);
508:
509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('');
511: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514:
Line 511: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');

507: sql_text:= po_sql(24);
508:
509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('');
511: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514:
515: sql_text:= po_sql(25);
Line 512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

508:
509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('');
511: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514:
515: sql_text:= po_sql(25);
516: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 513: JTF_DIAGNOSTIC_COREAPI.BRPrint;

509: JTF_DIAGNOSTIC_COREAPI.insert_html('
Organization Setup Details
');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('');
511: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514:
515: sql_text:= po_sql(25);
516: JTF_DIAGNOSTIC_COREAPI.insert_html('');
517: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
Line 516: JTF_DIAGNOSTIC_COREAPI.insert_html('');

512: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514:
515: sql_text:= po_sql(25);
516: JTF_DIAGNOSTIC_COREAPI.insert_html('');
517: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
518: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
519: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520:

Line 517: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');

513: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514:
515: sql_text:= po_sql(25);
516: JTF_DIAGNOSTIC_COREAPI.insert_html('');
517: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
518: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
519: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520:
521: sql_text:= po_sql(26);

Line 518: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

514:
515: sql_text:= po_sql(25);
516: JTF_DIAGNOSTIC_COREAPI.insert_html('');
517: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
518: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
519: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520:
521: sql_text:= po_sql(26);
522: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 519: JTF_DIAGNOSTIC_COREAPI.BRPrint;

515: sql_text:= po_sql(25);
516: JTF_DIAGNOSTIC_COREAPI.insert_html('');
517: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
518: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
519: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520:
521: sql_text:= po_sql(26);
522: JTF_DIAGNOSTIC_COREAPI.insert_html('');
523: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');

Line 522: JTF_DIAGNOSTIC_COREAPI.insert_html('');

518: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
519: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520:
521: sql_text:= po_sql(26);
522: JTF_DIAGNOSTIC_COREAPI.insert_html('');
523: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
524: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
525: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526:

Line 523: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');

519: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520:
521: sql_text:= po_sql(26);
522: JTF_DIAGNOSTIC_COREAPI.insert_html('');
523: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
524: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
525: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526:
527: sql_text:= po_sql(27);

Line 524: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

520:
521: sql_text:= po_sql(26);
522: JTF_DIAGNOSTIC_COREAPI.insert_html('');
523: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
524: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
525: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526:
527: sql_text:= po_sql(27);
528: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 525: JTF_DIAGNOSTIC_COREAPI.BRPrint;

521: sql_text:= po_sql(26);
522: JTF_DIAGNOSTIC_COREAPI.insert_html('');
523: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
524: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
525: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526:
527: sql_text:= po_sql(27);
528: JTF_DIAGNOSTIC_COREAPI.insert_html('');
529: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');

Line 528: JTF_DIAGNOSTIC_COREAPI.insert_html('');

524: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
525: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526:
527: sql_text:= po_sql(27);
528: JTF_DIAGNOSTIC_COREAPI.insert_html('');
529: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
530: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
531: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532:

Line 529: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');

525: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526:
527: sql_text:= po_sql(27);
528: JTF_DIAGNOSTIC_COREAPI.insert_html('');
529: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
530: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
531: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532:
533: sql_text:= po_sql(28);

Line 530: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

526:
527: sql_text:= po_sql(27);
528: JTF_DIAGNOSTIC_COREAPI.insert_html('');
529: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
530: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
531: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532:
533: sql_text:= po_sql(28);
534: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 531: JTF_DIAGNOSTIC_COREAPI.BRPrint;

527: sql_text:= po_sql(27);
528: JTF_DIAGNOSTIC_COREAPI.insert_html('');
529: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
530: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
531: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532:
533: sql_text:= po_sql(28);
534: JTF_DIAGNOSTIC_COREAPI.insert_html('');
535: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');

Line 534: JTF_DIAGNOSTIC_COREAPI.insert_html('');

530: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
531: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532:
533: sql_text:= po_sql(28);
534: JTF_DIAGNOSTIC_COREAPI.insert_html('');
535: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:

Line 535: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');

531: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532:
533: sql_text:= po_sql(28);
534: JTF_DIAGNOSTIC_COREAPI.insert_html('');
535: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= po_sql(29);

Line 536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

532:
533: sql_text:= po_sql(28);
534: JTF_DIAGNOSTIC_COREAPI.insert_html('');
535: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= po_sql(29);
540:

Line 537: JTF_DIAGNOSTIC_COREAPI.BRPrint;

533: sql_text:= po_sql(28);
534: JTF_DIAGNOSTIC_COREAPI.insert_html('');
535: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= po_sql(29);
540:
541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
Line 541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= po_sql(29);
540:
541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
542: JTF_DIAGNOSTIC_COREAPI.insert_html('');
543: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 542: JTF_DIAGNOSTIC_COREAPI.insert_html('');

538:
539: sql_text:= po_sql(29);
540:
541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
542: JTF_DIAGNOSTIC_COREAPI.insert_html('');
543: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
546:
Line 543: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');

539: sql_text:= po_sql(29);
540:
541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
542: JTF_DIAGNOSTIC_COREAPI.insert_html('');
543: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
546:
547: sql_text:= po_sql(30);
Line 544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

540:
541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
542: JTF_DIAGNOSTIC_COREAPI.insert_html('');
543: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
546:
547: sql_text:= po_sql(30);
548: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 545: JTF_DIAGNOSTIC_COREAPI.BRPrint;

541: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lot and Serial Transaction Details
');
542: JTF_DIAGNOSTIC_COREAPI.insert_html('');
543: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
546:
547: sql_text:= po_sql(30);
548: JTF_DIAGNOSTIC_COREAPI.insert_html('');
549: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
Line 548: JTF_DIAGNOSTIC_COREAPI.insert_html('');

544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
546:
547: sql_text:= po_sql(30);
548: JTF_DIAGNOSTIC_COREAPI.insert_html('');
549: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
550: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
551: JTF_DIAGNOSTIC_COREAPI.BRPrint;
552:

Line 549: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

545: JTF_DIAGNOSTIC_COREAPI.BRPrint;
546:
547: sql_text:= po_sql(30);
548: JTF_DIAGNOSTIC_COREAPI.insert_html('');
549: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
550: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
551: JTF_DIAGNOSTIC_COREAPI.BRPrint;
552:
553: sql_text:= po_sql(31);

Line 550: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

546:
547: sql_text:= po_sql(30);
548: JTF_DIAGNOSTIC_COREAPI.insert_html('');
549: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
550: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
551: JTF_DIAGNOSTIC_COREAPI.BRPrint;
552:
553: sql_text:= po_sql(31);
554: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 551: JTF_DIAGNOSTIC_COREAPI.BRPrint;

547: sql_text:= po_sql(30);
548: JTF_DIAGNOSTIC_COREAPI.insert_html('');
549: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
550: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
551: JTF_DIAGNOSTIC_COREAPI.BRPrint;
552:
553: sql_text:= po_sql(31);
554: JTF_DIAGNOSTIC_COREAPI.insert_html('');
555: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');

Line 554: JTF_DIAGNOSTIC_COREAPI.insert_html('');

550: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
551: JTF_DIAGNOSTIC_COREAPI.BRPrint;
552:
553: sql_text:= po_sql(31);
554: JTF_DIAGNOSTIC_COREAPI.insert_html('');
555: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
556: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
557: JTF_DIAGNOSTIC_COREAPI.BRPrint;
558:

Line 555: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');

551: JTF_DIAGNOSTIC_COREAPI.BRPrint;
552:
553: sql_text:= po_sql(31);
554: JTF_DIAGNOSTIC_COREAPI.insert_html('');
555: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
556: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
557: JTF_DIAGNOSTIC_COREAPI.BRPrint;
558:
559: sql_text:= po_sql(32);

Line 556: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

552:
553: sql_text:= po_sql(31);
554: JTF_DIAGNOSTIC_COREAPI.insert_html('');
555: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
556: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
557: JTF_DIAGNOSTIC_COREAPI.BRPrint;
558:
559: sql_text:= po_sql(32);
560: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 557: JTF_DIAGNOSTIC_COREAPI.BRPrint;

553: sql_text:= po_sql(31);
554: JTF_DIAGNOSTIC_COREAPI.insert_html('');
555: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
556: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
557: JTF_DIAGNOSTIC_COREAPI.BRPrint;
558:
559: sql_text:= po_sql(32);
560: JTF_DIAGNOSTIC_COREAPI.insert_html('');
561: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

Line 560: JTF_DIAGNOSTIC_COREAPI.insert_html('');

556: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
557: JTF_DIAGNOSTIC_COREAPI.BRPrint;
558:
559: sql_text:= po_sql(32);
560: JTF_DIAGNOSTIC_COREAPI.insert_html('');
561: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
562: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
563: JTF_DIAGNOSTIC_COREAPI.BRPrint;
564:

Line 561: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

557: JTF_DIAGNOSTIC_COREAPI.BRPrint;
558:
559: sql_text:= po_sql(32);
560: JTF_DIAGNOSTIC_COREAPI.insert_html('');
561: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
562: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
563: JTF_DIAGNOSTIC_COREAPI.BRPrint;
564:
565: sql_text:= po_sql(33);

Line 562: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

558:
559: sql_text:= po_sql(32);
560: JTF_DIAGNOSTIC_COREAPI.insert_html('');
561: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
562: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
563: JTF_DIAGNOSTIC_COREAPI.BRPrint;
564:
565: sql_text:= po_sql(33);
566: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 563: JTF_DIAGNOSTIC_COREAPI.BRPrint;

559: sql_text:= po_sql(32);
560: JTF_DIAGNOSTIC_COREAPI.insert_html('');
561: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
562: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
563: JTF_DIAGNOSTIC_COREAPI.BRPrint;
564:
565: sql_text:= po_sql(33);
566: JTF_DIAGNOSTIC_COREAPI.insert_html('');
567: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');

Line 566: JTF_DIAGNOSTIC_COREAPI.insert_html('');

562: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
563: JTF_DIAGNOSTIC_COREAPI.BRPrint;
564:
565: sql_text:= po_sql(33);
566: JTF_DIAGNOSTIC_COREAPI.insert_html('');
567: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
568: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
569: JTF_DIAGNOSTIC_COREAPI.BRPrint;
570:

Line 567: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');

563: JTF_DIAGNOSTIC_COREAPI.BRPrint;
564:
565: sql_text:= po_sql(33);
566: JTF_DIAGNOSTIC_COREAPI.insert_html('');
567: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
568: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
569: JTF_DIAGNOSTIC_COREAPI.BRPrint;
570:
571: sql_text:= po_sql(34);

Line 568: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

564:
565: sql_text:= po_sql(33);
566: JTF_DIAGNOSTIC_COREAPI.insert_html('');
567: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
568: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
569: JTF_DIAGNOSTIC_COREAPI.BRPrint;
570:
571: sql_text:= po_sql(34);
572: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 569: JTF_DIAGNOSTIC_COREAPI.BRPrint;

565: sql_text:= po_sql(33);
566: JTF_DIAGNOSTIC_COREAPI.insert_html('');
567: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
568: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
569: JTF_DIAGNOSTIC_COREAPI.BRPrint;
570:
571: sql_text:= po_sql(34);
572: JTF_DIAGNOSTIC_COREAPI.insert_html('');
573: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

Line 572: JTF_DIAGNOSTIC_COREAPI.insert_html('');

568: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
569: JTF_DIAGNOSTIC_COREAPI.BRPrint;
570:
571: sql_text:= po_sql(34);
572: JTF_DIAGNOSTIC_COREAPI.insert_html('');
573: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
574: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
575: JTF_DIAGNOSTIC_COREAPI.BRPrint;
576:

Line 573: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

569: JTF_DIAGNOSTIC_COREAPI.BRPrint;
570:
571: sql_text:= po_sql(34);
572: JTF_DIAGNOSTIC_COREAPI.insert_html('');
573: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
574: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
575: JTF_DIAGNOSTIC_COREAPI.BRPrint;
576:
577: sql_text:= po_sql(35);

Line 574: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

570:
571: sql_text:= po_sql(34);
572: JTF_DIAGNOSTIC_COREAPI.insert_html('');
573: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
574: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
575: JTF_DIAGNOSTIC_COREAPI.BRPrint;
576:
577: sql_text:= po_sql(35);
578: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 575: JTF_DIAGNOSTIC_COREAPI.BRPrint;

571: sql_text:= po_sql(34);
572: JTF_DIAGNOSTIC_COREAPI.insert_html('');
573: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
574: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
575: JTF_DIAGNOSTIC_COREAPI.BRPrint;
576:
577: sql_text:= po_sql(35);
578: JTF_DIAGNOSTIC_COREAPI.insert_html('');
579: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');

Line 578: JTF_DIAGNOSTIC_COREAPI.insert_html('');

574: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
575: JTF_DIAGNOSTIC_COREAPI.BRPrint;
576:
577: sql_text:= po_sql(35);
578: JTF_DIAGNOSTIC_COREAPI.insert_html('');
579: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
580: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
581: JTF_DIAGNOSTIC_COREAPI.BRPrint;
582:

Line 579: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');

575: JTF_DIAGNOSTIC_COREAPI.BRPrint;
576:
577: sql_text:= po_sql(35);
578: JTF_DIAGNOSTIC_COREAPI.insert_html('');
579: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
580: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
581: JTF_DIAGNOSTIC_COREAPI.BRPrint;
582:
583: sql_text:= po_sql(36);

Line 580: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

576:
577: sql_text:= po_sql(35);
578: JTF_DIAGNOSTIC_COREAPI.insert_html('');
579: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
580: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
581: JTF_DIAGNOSTIC_COREAPI.BRPrint;
582:
583: sql_text:= po_sql(36);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 581: JTF_DIAGNOSTIC_COREAPI.BRPrint;

577: sql_text:= po_sql(35);
578: JTF_DIAGNOSTIC_COREAPI.insert_html('');
579: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
580: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
581: JTF_DIAGNOSTIC_COREAPI.BRPrint;
582:
583: sql_text:= po_sql(36);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

Line 584: JTF_DIAGNOSTIC_COREAPI.insert_html('');

580: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
581: JTF_DIAGNOSTIC_COREAPI.BRPrint;
582:
583: sql_text:= po_sql(36);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:

Line 585: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

581: JTF_DIAGNOSTIC_COREAPI.BRPrint;
582:
583: sql_text:= po_sql(36);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= po_sql(37);

Line 586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

582:
583: sql_text:= po_sql(36);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= po_sql(37);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 587: JTF_DIAGNOSTIC_COREAPI.BRPrint;

583: sql_text:= po_sql(36);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= po_sql(37);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');

Line 590: JTF_DIAGNOSTIC_COREAPI.insert_html('');

586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= po_sql(37);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:

Line 591: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');

587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= po_sql(37);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= po_sql(38);

Line 592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

588:
589: sql_text:= po_sql(37);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= po_sql(38);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 593: JTF_DIAGNOSTIC_COREAPI.BRPrint;

589: sql_text:= po_sql(37);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= po_sql(38);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');

Line 596: JTF_DIAGNOSTIC_COREAPI.insert_html('');

592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= po_sql(38);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:

Line 597: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');

593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= po_sql(38);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= po_sql(39);

Line 598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

594:
595: sql_text:= po_sql(38);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= po_sql(39);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 599: JTF_DIAGNOSTIC_COREAPI.BRPrint;

595: sql_text:= po_sql(38);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= po_sql(39);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

Line 602: JTF_DIAGNOSTIC_COREAPI.insert_html('');

598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= po_sql(39);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:

Line 603: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= po_sql(39);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607: sql_text:= po_sql(40);

Line 604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

600:
601: sql_text:= po_sql(39);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607: sql_text:= po_sql(40);
608: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 605: JTF_DIAGNOSTIC_COREAPI.BRPrint;

601: sql_text:= po_sql(39);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607: sql_text:= po_sql(40);
608: JTF_DIAGNOSTIC_COREAPI.insert_html('');
609: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');

Line 608: JTF_DIAGNOSTIC_COREAPI.insert_html('');

604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607: sql_text:= po_sql(40);
608: JTF_DIAGNOSTIC_COREAPI.insert_html('');
609: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
610: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
611: JTF_DIAGNOSTIC_COREAPI.BRPrint;
612:

Line 609: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');

605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607: sql_text:= po_sql(40);
608: JTF_DIAGNOSTIC_COREAPI.insert_html('');
609: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
610: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
611: JTF_DIAGNOSTIC_COREAPI.BRPrint;
612:
613: sql_text:= po_sql(41);

Line 610: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

606:
607: sql_text:= po_sql(40);
608: JTF_DIAGNOSTIC_COREAPI.insert_html('');
609: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
610: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
611: JTF_DIAGNOSTIC_COREAPI.BRPrint;
612:
613: sql_text:= po_sql(41);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 611: JTF_DIAGNOSTIC_COREAPI.BRPrint;

607: sql_text:= po_sql(40);
608: JTF_DIAGNOSTIC_COREAPI.insert_html('');
609: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
610: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
611: JTF_DIAGNOSTIC_COREAPI.BRPrint;
612:
613: sql_text:= po_sql(41);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');
615: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

Line 614: JTF_DIAGNOSTIC_COREAPI.insert_html('');

610: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
611: JTF_DIAGNOSTIC_COREAPI.BRPrint;
612:
613: sql_text:= po_sql(41);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');
615: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:

Line 615: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

611: JTF_DIAGNOSTIC_COREAPI.BRPrint;
612:
613: sql_text:= po_sql(41);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');
615: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= po_sql(42);

Line 616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

612:
613: sql_text:= po_sql(41);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');
615: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= po_sql(42);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 617: JTF_DIAGNOSTIC_COREAPI.BRPrint;

613: sql_text:= po_sql(41);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');
615: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= po_sql(42);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');

Line 620: JTF_DIAGNOSTIC_COREAPI.insert_html('');

616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= po_sql(42);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:

Line 621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');

617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= po_sql(42);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

618:
619: sql_text:= po_sql(42);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: JTF_DIAGNOSTIC_COREAPI.insert_html('');
626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
Line 623: JTF_DIAGNOSTIC_COREAPI.BRPrint;

619: sql_text:= po_sql(42);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: JTF_DIAGNOSTIC_COREAPI.insert_html('');
626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
627: sql_text:= po_sql(100);
Line 625: JTF_DIAGNOSTIC_COREAPI.insert_html('');

621: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: JTF_DIAGNOSTIC_COREAPI.insert_html('');
626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
627: sql_text:= po_sql(100);
628: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
Line 626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: JTF_DIAGNOSTIC_COREAPI.insert_html('');
626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
627: sql_text:= po_sql(100);
628: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
630: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 628: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

624:
625: JTF_DIAGNOSTIC_COREAPI.insert_html('');
626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
627: sql_text:= po_sql(100);
628: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
630: JTF_DIAGNOSTIC_COREAPI.BRPrint;
631:
632: sql_text:= po_sql(101);
Line 629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

625: JTF_DIAGNOSTIC_COREAPI.insert_html('');
626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
627: sql_text:= po_sql(100);
628: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
630: JTF_DIAGNOSTIC_COREAPI.BRPrint;
631:
632: sql_text:= po_sql(101);
633: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
Line 630: JTF_DIAGNOSTIC_COREAPI.BRPrint;

626: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
627: sql_text:= po_sql(100);
628: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
630: JTF_DIAGNOSTIC_COREAPI.BRPrint;
631:
632: sql_text:= po_sql(101);
633: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
Line 633: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

629: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
630: JTF_DIAGNOSTIC_COREAPI.BRPrint;
631:
632: sql_text:= po_sql(101);
633: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= po_sql(102);

Line 634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

630: JTF_DIAGNOSTIC_COREAPI.BRPrint;
631:
632: sql_text:= po_sql(101);
633: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= po_sql(102);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

Line 635: JTF_DIAGNOSTIC_COREAPI.BRPrint;

631:
632: sql_text:= po_sql(101);
633: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= po_sql(102);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
639: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 638: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= po_sql(102);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
639: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
640: JTF_DIAGNOSTIC_COREAPI.BRPrint;
641:
642: sql_text:= po_sql(103);

Line 639: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= po_sql(102);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
639: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
640: JTF_DIAGNOSTIC_COREAPI.BRPrint;
641:
642: sql_text:= po_sql(103);
643: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

Line 640: JTF_DIAGNOSTIC_COREAPI.BRPrint;

636:
637: sql_text:= po_sql(102);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
639: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
640: JTF_DIAGNOSTIC_COREAPI.BRPrint;
641:
642: sql_text:= po_sql(103);
643: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
644: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 643: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

639: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
640: JTF_DIAGNOSTIC_COREAPI.BRPrint;
641:
642: sql_text:= po_sql(103);
643: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
644: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
645: JTF_DIAGNOSTIC_COREAPI.BRPrint;
646:
647: sql_text:= po_sql(104);

Line 644: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

640: JTF_DIAGNOSTIC_COREAPI.BRPrint;
641:
642: sql_text:= po_sql(103);
643: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
644: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
645: JTF_DIAGNOSTIC_COREAPI.BRPrint;
646:
647: sql_text:= po_sql(104);
648: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

Line 645: JTF_DIAGNOSTIC_COREAPI.BRPrint;

641:
642: sql_text:= po_sql(103);
643: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
644: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
645: JTF_DIAGNOSTIC_COREAPI.BRPrint;
646:
647: sql_text:= po_sql(104);
648: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 648: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

644: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
645: JTF_DIAGNOSTIC_COREAPI.BRPrint;
646:
647: sql_text:= po_sql(104);
648: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
650: JTF_DIAGNOSTIC_COREAPI.BRPrint;
651:
652: sql_text:= po_sql(105);

Line 649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

645: JTF_DIAGNOSTIC_COREAPI.BRPrint;
646:
647: sql_text:= po_sql(104);
648: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
650: JTF_DIAGNOSTIC_COREAPI.BRPrint;
651:
652: sql_text:= po_sql(105);
653: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

Line 650: JTF_DIAGNOSTIC_COREAPI.BRPrint;

646:
647: sql_text:= po_sql(104);
648: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
650: JTF_DIAGNOSTIC_COREAPI.BRPrint;
651:
652: sql_text:= po_sql(105);
653: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
654: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 653: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
650: JTF_DIAGNOSTIC_COREAPI.BRPrint;
651:
652: sql_text:= po_sql(105);
653: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
654: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
655: JTF_DIAGNOSTIC_COREAPI.BRPrint;
656:
657: sql_text:= po_sql(106);

Line 654: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

650: JTF_DIAGNOSTIC_COREAPI.BRPrint;
651:
652: sql_text:= po_sql(105);
653: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
654: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
655: JTF_DIAGNOSTIC_COREAPI.BRPrint;
656:
657: sql_text:= po_sql(106);
658: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

Line 655: JTF_DIAGNOSTIC_COREAPI.BRPrint;

651:
652: sql_text:= po_sql(105);
653: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
654: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
655: JTF_DIAGNOSTIC_COREAPI.BRPrint;
656:
657: sql_text:= po_sql(106);
658: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 658: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

654: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
655: JTF_DIAGNOSTIC_COREAPI.BRPrint;
656:
657: sql_text:= po_sql(106);
658: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
660: JTF_DIAGNOSTIC_COREAPI.BRPrint;
661:
662: -- Test Completed successfully.

Line 659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

655: JTF_DIAGNOSTIC_COREAPI.BRPrint;
656:
657: sql_text:= po_sql(106);
658: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
660: JTF_DIAGNOSTIC_COREAPI.BRPrint;
661:
662: -- Test Completed successfully.
663: statusStr := 'SUCCESS';

Line 660: JTF_DIAGNOSTIC_COREAPI.BRPrint;

656:
657: sql_text:= po_sql(106);
658: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
660: JTF_DIAGNOSTIC_COREAPI.BRPrint;
661:
662: -- Test Completed successfully.
663: statusStr := 'SUCCESS';
664: isFatal := 'FALSE';

Line 670: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

666: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
667:
668: EXCEPTION
669: when others then
670: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
671: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
672: statusStr := 'FAILURE';
673: errStr := sqlerrm ||' occurred in script Exception handled';
674: fixInfo := 'Unexpected Exception in INVDPO1B.pls';

Line 671: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

667:
668: EXCEPTION
669: when others then
670: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
671: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
672: statusStr := 'FAILURE';
673: errStr := sqlerrm ||' occurred in script Exception handled';
674: fixInfo := 'Unexpected Exception in INVDPO1B.pls';
675: isFatal := 'SUCCESS';

INDEX OF QUERIES