APPS.INV_DIAG_RCV_IPROC dependencies on JTF_DIAGNOSTIC_COREAPI

Line 109: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

199: and prh.segment1=l_req_number
200: AND prh.org_id=l_operating_id;
201: IF l_count = 0 THEN
202: statusStr := 'FAILURE';
203: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
204: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');
205: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
206: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
207: RETURN;

Line 204: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');

200: AND prh.org_id=l_operating_id;
201: IF l_count = 0 THEN
202: statusStr := 'FAILURE';
203: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
204: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');
205: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
206: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
207: RETURN;
208: END IF;

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

217: AND rsh.receipt_num=l_receipt_num
218: AND rsh.ship_to_org_id=l_org_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 Receipt number and Organization 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 Receipt number and Organization id.');

218: AND rsh.ship_to_org_id=l_org_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 Receipt number and Organization id.');
223: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
224: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
225: RETURN;
226: END IF;

Line 265: JTF_DIAGNOSTIC_COREAPI.insert_html(''||'

261: INV_DIAG_RCV_RCV_COMMON.build_lookup_codes(po_sql);
262: -----------------------------------------
263: -- Code to Build the Index of HTML tables
264: -----------------------------------------
265: JTF_DIAGNOSTIC_COREAPI.insert_html('

'||'
266: '||'
267: '||'
268: '||'
269: '||'

Line 352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');

348:
349: -------------------
350: -- Execute the Sqls
351: -------------------
352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');
353: sql_text := po_sql(1);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');
356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 354: JTF_DIAGNOSTIC_COREAPI.insert_html('');

350: -- Execute the Sqls
351: -------------------
352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');
353: sql_text := po_sql(1);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');
356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:

Line 355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');

351: -------------------
352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');
353: sql_text := po_sql(1);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');
356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);

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

352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');
353: sql_text := po_sql(1);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');
356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 357: JTF_DIAGNOSTIC_COREAPI.BRPrint;

353: sql_text := po_sql(1);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');
356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');

Line 360: JTF_DIAGNOSTIC_COREAPI.insert_html('');

356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');
362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:

Line 361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');

357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');
362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);

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

358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');
362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 363: JTF_DIAGNOSTIC_COREAPI.BRPrint;

359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');
362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');

Line 366: JTF_DIAGNOSTIC_COREAPI.insert_html('');

362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');
368: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:

Line 367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');

363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');
368: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:
371: sql_text := po_sql(4);

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

364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');
368: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:
371: sql_text := po_sql(4);
372:

Line 369: JTF_DIAGNOSTIC_COREAPI.BRPrint;

365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');
368: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:
371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');

Line 373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');

369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:
371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');
374: JTF_DIAGNOSTIC_COREAPI.insert_html('');
375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
377: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 374: JTF_DIAGNOSTIC_COREAPI.insert_html('');

370:
371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');
374: JTF_DIAGNOSTIC_COREAPI.insert_html('');
375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
377: JTF_DIAGNOSTIC_COREAPI.BRPrint;
378:

Line 375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');

371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');
374: JTF_DIAGNOSTIC_COREAPI.insert_html('');
375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
377: JTF_DIAGNOSTIC_COREAPI.BRPrint;
378:
379: sql_text := po_sql(5);

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

372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

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

Line 377: JTF_DIAGNOSTIC_COREAPI.BRPrint;

373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

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

Line 380: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

377: JTF_DIAGNOSTIC_COREAPI.BRPrint;
378:
379: sql_text := po_sql(5);
380: JTF_DIAGNOSTIC_COREAPI.insert_html('');
381: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
382: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
383: JTF_DIAGNOSTIC_COREAPI.BRPrint;
384:
385: sql_text := po_sql(6);

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

378:
379: sql_text := po_sql(5);
380: JTF_DIAGNOSTIC_COREAPI.insert_html('');
381: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
382: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
383: JTF_DIAGNOSTIC_COREAPI.BRPrint;
384:
385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 383: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 386: JTF_DIAGNOSTIC_COREAPI.insert_html('');

382: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
383: JTF_DIAGNOSTIC_COREAPI.BRPrint;
384:
385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');
387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:

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

383: JTF_DIAGNOSTIC_COREAPI.BRPrint;
384:
385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');
387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);

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

384:
385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');
387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 389: JTF_DIAGNOSTIC_COREAPI.BRPrint;

385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');
387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');

Line 392: JTF_DIAGNOSTIC_COREAPI.insert_html('');

388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
394: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:

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

389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
394: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:
397: sql_text := po_sql(8);

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

390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
394: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:
397: sql_text := po_sql(8);
398:

Line 395: JTF_DIAGNOSTIC_COREAPI.BRPrint;

391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL  [Top]');
394: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:
397: sql_text := po_sql(8);
398:
399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

');

Line 399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

');

395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:
397: sql_text := po_sql(8);
398:
399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

');
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
402: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
403: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 400: JTF_DIAGNOSTIC_COREAPI.insert_html('');

396:
397: sql_text := po_sql(8);
398:
399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

');
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
402: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
403: JTF_DIAGNOSTIC_COREAPI.BRPrint;
404:

Line 401: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');

397: sql_text := po_sql(8);
398:
399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

');
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
402: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
403: JTF_DIAGNOSTIC_COREAPI.BRPrint;
404:
405: sql_text:= po_sql(9);

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

398:
399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

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

Line 403: JTF_DIAGNOSTIC_COREAPI.BRPrint;

399: JTF_DIAGNOSTIC_COREAPI.insert_html('

Invoice Details

');
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('GL_CODE_COMBINATIONS  [Top]');
402: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
403: JTF_DIAGNOSTIC_COREAPI.BRPrint;
404:
405: sql_text:= po_sql(9);
406: JTF_DIAGNOSTIC_COREAPI.insert_html('');
407: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');

Line 406: JTF_DIAGNOSTIC_COREAPI.insert_html('');

402: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
403: JTF_DIAGNOSTIC_COREAPI.BRPrint;
404:
405: sql_text:= po_sql(9);
406: JTF_DIAGNOSTIC_COREAPI.insert_html('');
407: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
408: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
409: JTF_DIAGNOSTIC_COREAPI.BRPrint;
410:

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

403: JTF_DIAGNOSTIC_COREAPI.BRPrint;
404:
405: sql_text:= po_sql(9);
406: JTF_DIAGNOSTIC_COREAPI.insert_html('');
407: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_RECEIVING_SUB_LEDGER  [Top]');
408: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
409: JTF_DIAGNOSTIC_COREAPI.BRPrint;
410:
411: sql_text := po_sql(10);

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

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

Line 409: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 412: JTF_DIAGNOSTIC_COREAPI.insert_html('');

408: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
409: JTF_DIAGNOSTIC_COREAPI.BRPrint;
410:
411: sql_text := po_sql(10);
412: JTF_DIAGNOSTIC_COREAPI.insert_html('');
413: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');
414: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
415: JTF_DIAGNOSTIC_COREAPI.BRPrint;
416:

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

409: JTF_DIAGNOSTIC_COREAPI.BRPrint;
410:
411: sql_text := po_sql(10);
412: JTF_DIAGNOSTIC_COREAPI.insert_html('');
413: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_ALL  [Top]');
414: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
415: JTF_DIAGNOSTIC_COREAPI.BRPrint;
416:
417: sql_text := po_sql(11);

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

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

Line 415: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 418: JTF_DIAGNOSTIC_COREAPI.insert_html('');

414: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
415: JTF_DIAGNOSTIC_COREAPI.BRPrint;
416:
417: sql_text := po_sql(11);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:

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

415: JTF_DIAGNOSTIC_COREAPI.BRPrint;
416:
417: sql_text := po_sql(11);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_ALL  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423: sql_text := po_sql(12);

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

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

Line 421: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 424: JTF_DIAGNOSTIC_COREAPI.insert_html('');

420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423: sql_text := po_sql(12);
424: JTF_DIAGNOSTIC_COREAPI.insert_html('');
425: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
426: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
427: JTF_DIAGNOSTIC_COREAPI.BRPrint;
428:

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

421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423: sql_text := po_sql(12);
424: JTF_DIAGNOSTIC_COREAPI.insert_html('');
425: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
426: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
427: JTF_DIAGNOSTIC_COREAPI.BRPrint;
428:
429: sql_text:= po_sql(13);

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

422:
423: sql_text := po_sql(12);
424: JTF_DIAGNOSTIC_COREAPI.insert_html('');
425: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
426: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
427: JTF_DIAGNOSTIC_COREAPI.BRPrint;
428:
429: sql_text:= po_sql(13);
430: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 427: JTF_DIAGNOSTIC_COREAPI.BRPrint;

423: sql_text := po_sql(12);
424: JTF_DIAGNOSTIC_COREAPI.insert_html('');
425: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICE_LINES_INTERFACE  [Top]');
426: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
427: JTF_DIAGNOSTIC_COREAPI.BRPrint;
428:
429: sql_text:= po_sql(13);
430: JTF_DIAGNOSTIC_COREAPI.insert_html('');
431: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');

Line 430: JTF_DIAGNOSTIC_COREAPI.insert_html('');

426: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
427: JTF_DIAGNOSTIC_COREAPI.BRPrint;
428:
429: sql_text:= po_sql(13);
430: JTF_DIAGNOSTIC_COREAPI.insert_html('');
431: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
432: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
433: JTF_DIAGNOSTIC_COREAPI.BRPrint;
434:

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

427: JTF_DIAGNOSTIC_COREAPI.BRPrint;
428:
429: sql_text:= po_sql(13);
430: JTF_DIAGNOSTIC_COREAPI.insert_html('');
431: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
432: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
433: JTF_DIAGNOSTIC_COREAPI.BRPrint;
434:
435: sql_text:= po_sql(14);

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

428:
429: sql_text:= po_sql(13);
430: JTF_DIAGNOSTIC_COREAPI.insert_html('');
431: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
432: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
433: JTF_DIAGNOSTIC_COREAPI.BRPrint;
434:
435: sql_text:= po_sql(14);
436:

Line 433: JTF_DIAGNOSTIC_COREAPI.BRPrint;

429: sql_text:= po_sql(13);
430: JTF_DIAGNOSTIC_COREAPI.insert_html('');
431: JTF_DIAGNOSTIC_COREAPI.insert_html('AP_INVOICES_INTERFACE  [Top]');
432: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
433: JTF_DIAGNOSTIC_COREAPI.BRPrint;
434:
435: sql_text:= po_sql(14);
436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

');

Line 437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

');

433: JTF_DIAGNOSTIC_COREAPI.BRPrint;
434:
435: sql_text:= po_sql(14);
436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 438: JTF_DIAGNOSTIC_COREAPI.insert_html('');

434:
435: sql_text:= po_sql(14);
436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:

Line 439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');

435: sql_text:= po_sql(14);
436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= po_sql(15);

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

436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

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

Line 441: JTF_DIAGNOSTIC_COREAPI.BRPrint;

437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= po_sql(15);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

Line 444: JTF_DIAGNOSTIC_COREAPI.insert_html('');

440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= po_sql(15);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:

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

441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= po_sql(15);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= po_sql(16);

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

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

Line 447: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 450: JTF_DIAGNOSTIC_COREAPI.insert_html('');

446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= po_sql(16);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:

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

447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= po_sql(16);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= po_sql(17);

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

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

Line 453: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 456: JTF_DIAGNOSTIC_COREAPI.insert_html('');

452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= po_sql(17);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
458: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
459: JTF_DIAGNOSTIC_COREAPI.BRPrint;
460:

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

453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= po_sql(17);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
458: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
459: JTF_DIAGNOSTIC_COREAPI.BRPrint;
460:
461: sql_text:= po_sql(18);

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

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

Line 459: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 462: JTF_DIAGNOSTIC_COREAPI.insert_html('');

458: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
459: JTF_DIAGNOSTIC_COREAPI.BRPrint;
460:
461: sql_text:= po_sql(18);
462: JTF_DIAGNOSTIC_COREAPI.insert_html('');
463: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
464: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
465: JTF_DIAGNOSTIC_COREAPI.BRPrint;
466:

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

459: JTF_DIAGNOSTIC_COREAPI.BRPrint;
460:
461: sql_text:= po_sql(18);
462: JTF_DIAGNOSTIC_COREAPI.insert_html('');
463: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
464: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
465: JTF_DIAGNOSTIC_COREAPI.BRPrint;
466:
467: sql_text:= po_sql(19);

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

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

Line 465: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 468: JTF_DIAGNOSTIC_COREAPI.insert_html('');

464: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
465: JTF_DIAGNOSTIC_COREAPI.BRPrint;
466:
467: sql_text:= po_sql(19);
468: JTF_DIAGNOSTIC_COREAPI.insert_html('');
469: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
470: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
471: JTF_DIAGNOSTIC_COREAPI.BRPrint;
472:

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

465: JTF_DIAGNOSTIC_COREAPI.BRPrint;
466:
467: sql_text:= po_sql(19);
468: JTF_DIAGNOSTIC_COREAPI.insert_html('');
469: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
470: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
471: JTF_DIAGNOSTIC_COREAPI.BRPrint;
472:
473: sql_text:= po_sql(20);

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

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

Line 471: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 474: JTF_DIAGNOSTIC_COREAPI.insert_html('');

470: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
471: JTF_DIAGNOSTIC_COREAPI.BRPrint;
472:
473: sql_text:= po_sql(20);
474: JTF_DIAGNOSTIC_COREAPI.insert_html('');
475: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
476: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
477: JTF_DIAGNOSTIC_COREAPI.BRPrint;
478:

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

471: JTF_DIAGNOSTIC_COREAPI.BRPrint;
472:
473: sql_text:= po_sql(20);
474: JTF_DIAGNOSTIC_COREAPI.insert_html('');
475: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
476: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
477: JTF_DIAGNOSTIC_COREAPI.BRPrint;
478:
479: sql_text:= po_sql(21);

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

472:
473: sql_text:= po_sql(20);
474: JTF_DIAGNOSTIC_COREAPI.insert_html('');
475: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
476: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
477: JTF_DIAGNOSTIC_COREAPI.BRPrint;
478:
479: sql_text:= po_sql(21);
480: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 477: JTF_DIAGNOSTIC_COREAPI.BRPrint;

473: sql_text:= po_sql(20);
474: JTF_DIAGNOSTIC_COREAPI.insert_html('');
475: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
476: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
477: JTF_DIAGNOSTIC_COREAPI.BRPrint;
478:
479: sql_text:= po_sql(21);
480: JTF_DIAGNOSTIC_COREAPI.insert_html('');
481: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

Line 480: JTF_DIAGNOSTIC_COREAPI.insert_html('');

476: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
477: JTF_DIAGNOSTIC_COREAPI.BRPrint;
478:
479: sql_text:= po_sql(21);
480: JTF_DIAGNOSTIC_COREAPI.insert_html('');
481: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
482: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
483: JTF_DIAGNOSTIC_COREAPI.BRPrint;
484:

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

477: JTF_DIAGNOSTIC_COREAPI.BRPrint;
478:
479: sql_text:= po_sql(21);
480: JTF_DIAGNOSTIC_COREAPI.insert_html('');
481: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
482: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
483: JTF_DIAGNOSTIC_COREAPI.BRPrint;
484:
485: sql_text:= po_sql(22);

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

478:
479: sql_text:= po_sql(21);
480: JTF_DIAGNOSTIC_COREAPI.insert_html('');
481: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
482: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
483: JTF_DIAGNOSTIC_COREAPI.BRPrint;
484:
485: sql_text:= po_sql(22);
486:

Line 483: JTF_DIAGNOSTIC_COREAPI.BRPrint;

479: sql_text:= po_sql(21);
480: JTF_DIAGNOSTIC_COREAPI.insert_html('');
481: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
482: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
483: JTF_DIAGNOSTIC_COREAPI.BRPrint;
484:
485: sql_text:= po_sql(22);
486:
487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

');

Line 487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

');

483: JTF_DIAGNOSTIC_COREAPI.BRPrint;
484:
485: sql_text:= po_sql(22);
486:
487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

');
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 488: JTF_DIAGNOSTIC_COREAPI.insert_html('');

484:
485: sql_text:= po_sql(22);
486:
487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

');
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:

Line 489: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');

485: sql_text:= po_sql(22);
486:
487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

');
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= po_sql(23);

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

486:
487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

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

Line 491: JTF_DIAGNOSTIC_COREAPI.BRPrint;

487: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

');
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= po_sql(23);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');

Line 494: JTF_DIAGNOSTIC_COREAPI.insert_html('');

490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= po_sql(23);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
496: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
497: JTF_DIAGNOSTIC_COREAPI.BRPrint;
498:

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

491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= po_sql(23);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
496: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
497: JTF_DIAGNOSTIC_COREAPI.BRPrint;
498:
499: sql_text:= po_sql(24);

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

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

Line 497: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 500: JTF_DIAGNOSTIC_COREAPI.insert_html('');

496: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
497: JTF_DIAGNOSTIC_COREAPI.BRPrint;
498:
499: sql_text:= po_sql(24);
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
502: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
503: JTF_DIAGNOSTIC_COREAPI.BRPrint;
504:

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

497: JTF_DIAGNOSTIC_COREAPI.BRPrint;
498:
499: sql_text:= po_sql(24);
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
502: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
503: JTF_DIAGNOSTIC_COREAPI.BRPrint;
504:
505: sql_text:= po_sql(25);

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

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

Line 503: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 506: JTF_DIAGNOSTIC_COREAPI.insert_html('');

502: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
503: JTF_DIAGNOSTIC_COREAPI.BRPrint;
504:
505: sql_text:= po_sql(25);
506: JTF_DIAGNOSTIC_COREAPI.insert_html('');
507: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
508: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
509: JTF_DIAGNOSTIC_COREAPI.BRPrint;
510:

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

503: JTF_DIAGNOSTIC_COREAPI.BRPrint;
504:
505: sql_text:= po_sql(25);
506: JTF_DIAGNOSTIC_COREAPI.insert_html('');
507: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
508: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
509: JTF_DIAGNOSTIC_COREAPI.BRPrint;
510:
511: sql_text:= po_sql(26);

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

504:
505: sql_text:= po_sql(25);
506: JTF_DIAGNOSTIC_COREAPI.insert_html('');
507: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
508: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
509: JTF_DIAGNOSTIC_COREAPI.BRPrint;
510:
511: sql_text:= po_sql(26);
512: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 509: JTF_DIAGNOSTIC_COREAPI.BRPrint;

505: sql_text:= po_sql(25);
506: JTF_DIAGNOSTIC_COREAPI.insert_html('');
507: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TXN_REQUEST_LINES  [Top]');
508: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
509: JTF_DIAGNOSTIC_COREAPI.BRPrint;
510:
511: sql_text:= po_sql(26);
512: JTF_DIAGNOSTIC_COREAPI.insert_html('');
513: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');

Line 512: JTF_DIAGNOSTIC_COREAPI.insert_html('');

508: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
509: JTF_DIAGNOSTIC_COREAPI.BRPrint;
510:
511: sql_text:= po_sql(26);
512: JTF_DIAGNOSTIC_COREAPI.insert_html('');
513: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
514: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
515: JTF_DIAGNOSTIC_COREAPI.BRPrint;
516:

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

509: JTF_DIAGNOSTIC_COREAPI.BRPrint;
510:
511: sql_text:= po_sql(26);
512: JTF_DIAGNOSTIC_COREAPI.insert_html('');
513: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
514: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
515: JTF_DIAGNOSTIC_COREAPI.BRPrint;
516:
517: sql_text:= po_sql(27);

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

510:
511: sql_text:= po_sql(26);
512: JTF_DIAGNOSTIC_COREAPI.insert_html('');
513: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
514: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
515: JTF_DIAGNOSTIC_COREAPI.BRPrint;
516:
517: sql_text:= po_sql(27);
518:

Line 515: JTF_DIAGNOSTIC_COREAPI.BRPrint;

511: sql_text:= po_sql(26);
512: JTF_DIAGNOSTIC_COREAPI.insert_html('');
513: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
514: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
515: JTF_DIAGNOSTIC_COREAPI.BRPrint;
516:
517: sql_text:= po_sql(27);
518:
519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

');

Line 519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

');

515: JTF_DIAGNOSTIC_COREAPI.BRPrint;
516:
517: sql_text:= po_sql(27);
518:
519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

');
520: JTF_DIAGNOSTIC_COREAPI.insert_html('');
521: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
522: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
523: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 520: JTF_DIAGNOSTIC_COREAPI.insert_html('');

516:
517: sql_text:= po_sql(27);
518:
519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

');
520: JTF_DIAGNOSTIC_COREAPI.insert_html('');
521: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
522: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
523: JTF_DIAGNOSTIC_COREAPI.BRPrint;
524:

Line 521: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');

517: sql_text:= po_sql(27);
518:
519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

');
520: JTF_DIAGNOSTIC_COREAPI.insert_html('');
521: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
522: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
523: JTF_DIAGNOSTIC_COREAPI.BRPrint;
524:
525: sql_text:= po_sql(28);

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

518:
519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

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

Line 523: JTF_DIAGNOSTIC_COREAPI.BRPrint;

519: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

');
520: JTF_DIAGNOSTIC_COREAPI.insert_html('');
521: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
522: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
523: JTF_DIAGNOSTIC_COREAPI.BRPrint;
524:
525: sql_text:= po_sql(28);
526: JTF_DIAGNOSTIC_COREAPI.insert_html('');
527: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');

Line 526: JTF_DIAGNOSTIC_COREAPI.insert_html('');

522: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
523: JTF_DIAGNOSTIC_COREAPI.BRPrint;
524:
525: sql_text:= po_sql(28);
526: JTF_DIAGNOSTIC_COREAPI.insert_html('');
527: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
528: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
529: JTF_DIAGNOSTIC_COREAPI.BRPrint;
530:

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

523: JTF_DIAGNOSTIC_COREAPI.BRPrint;
524:
525: sql_text:= po_sql(28);
526: JTF_DIAGNOSTIC_COREAPI.insert_html('');
527: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
528: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
529: JTF_DIAGNOSTIC_COREAPI.BRPrint;
530:
531: sql_text:= po_sql(29);

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

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

Line 529: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 532: JTF_DIAGNOSTIC_COREAPI.insert_html('');

528: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
529: JTF_DIAGNOSTIC_COREAPI.BRPrint;
530:
531: sql_text:= po_sql(29);
532: JTF_DIAGNOSTIC_COREAPI.insert_html('');
533: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
534: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
535: JTF_DIAGNOSTIC_COREAPI.BRPrint;
536:

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

529: JTF_DIAGNOSTIC_COREAPI.BRPrint;
530:
531: sql_text:= po_sql(29);
532: JTF_DIAGNOSTIC_COREAPI.insert_html('');
533: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
534: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
535: JTF_DIAGNOSTIC_COREAPI.BRPrint;
536:
537: sql_text:= po_sql(30);

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

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

Line 535: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 538: JTF_DIAGNOSTIC_COREAPI.insert_html('');

534: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
535: JTF_DIAGNOSTIC_COREAPI.BRPrint;
536:
537: sql_text:= po_sql(30);
538: JTF_DIAGNOSTIC_COREAPI.insert_html('');
539: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
540: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
541: JTF_DIAGNOSTIC_COREAPI.BRPrint;
542:

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

535: JTF_DIAGNOSTIC_COREAPI.BRPrint;
536:
537: sql_text:= po_sql(30);
538: JTF_DIAGNOSTIC_COREAPI.insert_html('');
539: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
540: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
541: JTF_DIAGNOSTIC_COREAPI.BRPrint;
542:
543: sql_text:= po_sql(31);

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

536:
537: sql_text:= po_sql(30);
538: JTF_DIAGNOSTIC_COREAPI.insert_html('');
539: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
540: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
541: JTF_DIAGNOSTIC_COREAPI.BRPrint;
542:
543: sql_text:= po_sql(31);
544: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 541: JTF_DIAGNOSTIC_COREAPI.BRPrint;

537: sql_text:= po_sql(30);
538: JTF_DIAGNOSTIC_COREAPI.insert_html('');
539: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
540: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
541: JTF_DIAGNOSTIC_COREAPI.BRPrint;
542:
543: sql_text:= po_sql(31);
544: JTF_DIAGNOSTIC_COREAPI.insert_html('');
545: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');

Line 544: JTF_DIAGNOSTIC_COREAPI.insert_html('');

540: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
541: JTF_DIAGNOSTIC_COREAPI.BRPrint;
542:
543: sql_text:= po_sql(31);
544: JTF_DIAGNOSTIC_COREAPI.insert_html('');
545: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
546: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
547: JTF_DIAGNOSTIC_COREAPI.BRPrint;
548:

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

541: JTF_DIAGNOSTIC_COREAPI.BRPrint;
542:
543: sql_text:= po_sql(31);
544: JTF_DIAGNOSTIC_COREAPI.insert_html('');
545: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
546: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
547: JTF_DIAGNOSTIC_COREAPI.BRPrint;
548:
549: sql_text:= po_sql(32);

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

542:
543: sql_text:= po_sql(31);
544: JTF_DIAGNOSTIC_COREAPI.insert_html('');
545: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
546: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
547: JTF_DIAGNOSTIC_COREAPI.BRPrint;
548:
549: sql_text:= po_sql(32);
550:

Line 547: JTF_DIAGNOSTIC_COREAPI.BRPrint;

543: sql_text:= po_sql(31);
544: JTF_DIAGNOSTIC_COREAPI.insert_html('');
545: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIALS_SYSTEM_PARAMS_ALL  [Top]');
546: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
547: JTF_DIAGNOSTIC_COREAPI.BRPrint;
548:
549: sql_text:= po_sql(32);
550:
551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

');

Line 551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

');

547: JTF_DIAGNOSTIC_COREAPI.BRPrint;
548:
549: sql_text:= po_sql(32);
550:
551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

');
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 552: JTF_DIAGNOSTIC_COREAPI.insert_html('');

548:
549: sql_text:= po_sql(32);
550:
551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

');
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:

Line 553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');

549: sql_text:= po_sql(32);
550:
551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

');
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= po_sql(33);

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

550:
551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

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

Line 555: JTF_DIAGNOSTIC_COREAPI.BRPrint;

551: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

');
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= po_sql(33);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

Line 558: JTF_DIAGNOSTIC_COREAPI.insert_html('');

554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= po_sql(33);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:

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

555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= po_sql(33);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= po_sql(34);

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

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

Line 561: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 564: JTF_DIAGNOSTIC_COREAPI.insert_html('');

560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= po_sql(34);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
566: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:

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

561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= po_sql(34);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
566: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= po_sql(35);

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

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

Line 567: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 570: JTF_DIAGNOSTIC_COREAPI.insert_html('');

566: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= po_sql(35);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
572: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:

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

567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= po_sql(35);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
572: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= po_sql(36);

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

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

Line 573: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 576: JTF_DIAGNOSTIC_COREAPI.insert_html('');

572: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= po_sql(36);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:

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

573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= po_sql(36);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: sql_text:= po_sql(37);

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

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

Line 579: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 582: JTF_DIAGNOSTIC_COREAPI.insert_html('');

578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: sql_text:= po_sql(37);
582: JTF_DIAGNOSTIC_COREAPI.insert_html('');
583: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
584: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
585: JTF_DIAGNOSTIC_COREAPI.BRPrint;
586:

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

579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: sql_text:= po_sql(37);
582: JTF_DIAGNOSTIC_COREAPI.insert_html('');
583: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
584: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
585: JTF_DIAGNOSTIC_COREAPI.BRPrint;
586:
587: sql_text:= po_sql(38);

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

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

Line 585: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 588: JTF_DIAGNOSTIC_COREAPI.insert_html('');

584: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
585: JTF_DIAGNOSTIC_COREAPI.BRPrint;
586:
587: sql_text:= po_sql(38);
588: JTF_DIAGNOSTIC_COREAPI.insert_html('');
589: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
590: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
591: JTF_DIAGNOSTIC_COREAPI.BRPrint;
592:

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

585: JTF_DIAGNOSTIC_COREAPI.BRPrint;
586:
587: sql_text:= po_sql(38);
588: JTF_DIAGNOSTIC_COREAPI.insert_html('');
589: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
590: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
591: JTF_DIAGNOSTIC_COREAPI.BRPrint;
592:
593: sql_text:= po_sql(39);

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

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

Line 591: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 594: JTF_DIAGNOSTIC_COREAPI.insert_html('');

590: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
591: JTF_DIAGNOSTIC_COREAPI.BRPrint;
592:
593: sql_text:= po_sql(39);
594: JTF_DIAGNOSTIC_COREAPI.insert_html('');
595: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
596: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
597: JTF_DIAGNOSTIC_COREAPI.BRPrint;
598:

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

591: JTF_DIAGNOSTIC_COREAPI.BRPrint;
592:
593: sql_text:= po_sql(39);
594: JTF_DIAGNOSTIC_COREAPI.insert_html('');
595: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
596: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
597: JTF_DIAGNOSTIC_COREAPI.BRPrint;
598:
599: sql_text:= po_sql(40);

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

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

Line 597: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 600: JTF_DIAGNOSTIC_COREAPI.insert_html('');

596: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
597: JTF_DIAGNOSTIC_COREAPI.BRPrint;
598:
599: sql_text:= po_sql(40);
600: JTF_DIAGNOSTIC_COREAPI.insert_html('');
601: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
602: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
603: JTF_DIAGNOSTIC_COREAPI.BRPrint;
604:

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

597: JTF_DIAGNOSTIC_COREAPI.BRPrint;
598:
599: sql_text:= po_sql(40);
600: JTF_DIAGNOSTIC_COREAPI.insert_html('');
601: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
602: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
603: JTF_DIAGNOSTIC_COREAPI.BRPrint;
604:
605: sql_text:= po_sql(41);

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

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

Line 603: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 606: JTF_DIAGNOSTIC_COREAPI.insert_html('');

602: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
603: JTF_DIAGNOSTIC_COREAPI.BRPrint;
604:
605: sql_text:= po_sql(41);
606: JTF_DIAGNOSTIC_COREAPI.insert_html('');
607: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
608: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
609: JTF_DIAGNOSTIC_COREAPI.BRPrint;
610:

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

603: JTF_DIAGNOSTIC_COREAPI.BRPrint;
604:
605: sql_text:= po_sql(41);
606: JTF_DIAGNOSTIC_COREAPI.insert_html('');
607: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
608: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
609: JTF_DIAGNOSTIC_COREAPI.BRPrint;
610:
611: sql_text:= po_sql(42);

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

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

Line 609: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 612: JTF_DIAGNOSTIC_COREAPI.insert_html('');

608: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
609: JTF_DIAGNOSTIC_COREAPI.BRPrint;
610:
611: sql_text:= po_sql(42);
612: JTF_DIAGNOSTIC_COREAPI.insert_html('');
613: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
614: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
615: JTF_DIAGNOSTIC_COREAPI.BRPrint;
616:

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

609: JTF_DIAGNOSTIC_COREAPI.BRPrint;
610:
611: sql_text:= po_sql(42);
612: JTF_DIAGNOSTIC_COREAPI.insert_html('');
613: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
614: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
615: JTF_DIAGNOSTIC_COREAPI.BRPrint;
616:
617: sql_text:= po_sql(43);

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

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

Line 615: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 618: JTF_DIAGNOSTIC_COREAPI.insert_html('');

614: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
615: JTF_DIAGNOSTIC_COREAPI.BRPrint;
616:
617: sql_text:= po_sql(43);
618: JTF_DIAGNOSTIC_COREAPI.insert_html('');
619: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
620: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
621: JTF_DIAGNOSTIC_COREAPI.BRPrint;
622:

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

615: JTF_DIAGNOSTIC_COREAPI.BRPrint;
616:
617: sql_text:= po_sql(43);
618: JTF_DIAGNOSTIC_COREAPI.insert_html('');
619: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
620: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
621: JTF_DIAGNOSTIC_COREAPI.BRPrint;
622:
623: sql_text:= po_sql(44);

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

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

Line 621: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 624: JTF_DIAGNOSTIC_COREAPI.insert_html('');

620: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
621: JTF_DIAGNOSTIC_COREAPI.BRPrint;
622:
623: sql_text:= po_sql(44);
624: JTF_DIAGNOSTIC_COREAPI.insert_html('');
625: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
626: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
627: JTF_DIAGNOSTIC_COREAPI.BRPrint;
628:

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

621: JTF_DIAGNOSTIC_COREAPI.BRPrint;
622:
623: sql_text:= po_sql(44);
624: JTF_DIAGNOSTIC_COREAPI.insert_html('');
625: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
626: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
627: JTF_DIAGNOSTIC_COREAPI.BRPrint;
628:
629: sql_text:= po_sql(45);

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

622:
623: sql_text:= po_sql(44);
624: JTF_DIAGNOSTIC_COREAPI.insert_html('');
625: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
626: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
627: JTF_DIAGNOSTIC_COREAPI.BRPrint;
628:
629: sql_text:= po_sql(45);
630: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 627: JTF_DIAGNOSTIC_COREAPI.BRPrint;

623: sql_text:= po_sql(44);
624: JTF_DIAGNOSTIC_COREAPI.insert_html('');
625: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
626: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
627: JTF_DIAGNOSTIC_COREAPI.BRPrint;
628:
629: sql_text:= po_sql(45);
630: JTF_DIAGNOSTIC_COREAPI.insert_html('');
631: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');

Line 630: JTF_DIAGNOSTIC_COREAPI.insert_html('');

626: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
627: JTF_DIAGNOSTIC_COREAPI.BRPrint;
628:
629: sql_text:= po_sql(45);
630: JTF_DIAGNOSTIC_COREAPI.insert_html('');
631: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
632: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
633: JTF_DIAGNOSTIC_COREAPI.BRPrint;
634:

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

627: JTF_DIAGNOSTIC_COREAPI.BRPrint;
628:
629: sql_text:= po_sql(45);
630: JTF_DIAGNOSTIC_COREAPI.insert_html('');
631: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
632: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
633: JTF_DIAGNOSTIC_COREAPI.BRPrint;
634:
635:

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

628:
629: sql_text:= po_sql(45);
630: JTF_DIAGNOSTIC_COREAPI.insert_html('');
631: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
632: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
633: JTF_DIAGNOSTIC_COREAPI.BRPrint;
634:
635:
636: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 633: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Lookup Codes

');

Line 636: JTF_DIAGNOSTIC_COREAPI.insert_html('');

632: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
633: JTF_DIAGNOSTIC_COREAPI.BRPrint;
634:
635:
636: JTF_DIAGNOSTIC_COREAPI.insert_html('');
637: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
638: sql_text:= po_sql(100);
639: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 637: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');

633: JTF_DIAGNOSTIC_COREAPI.BRPrint;
634:
635:
636: JTF_DIAGNOSTIC_COREAPI.insert_html('');
637: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
638: sql_text:= po_sql(100);
639: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 639: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

635:
636: JTF_DIAGNOSTIC_COREAPI.insert_html('');
637: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
638: sql_text:= po_sql(100);
639: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= po_sql(101);

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

636: JTF_DIAGNOSTIC_COREAPI.insert_html('');
637: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
638: sql_text:= po_sql(100);
639: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= po_sql(101);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

Line 641: JTF_DIAGNOSTIC_COREAPI.BRPrint;

637: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
638: sql_text:= po_sql(100);
639: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= po_sql(101);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
645: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 644: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= po_sql(101);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
645: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
646: JTF_DIAGNOSTIC_COREAPI.BRPrint;
647:
648: sql_text:= po_sql(102);

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

641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= po_sql(101);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
645: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
646: JTF_DIAGNOSTIC_COREAPI.BRPrint;
647:
648: sql_text:= po_sql(102);
649: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

Line 646: JTF_DIAGNOSTIC_COREAPI.BRPrint;

642:
643: sql_text:= po_sql(101);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
645: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
646: JTF_DIAGNOSTIC_COREAPI.BRPrint;
647:
648: sql_text:= po_sql(102);
649: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
650: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

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

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

646: JTF_DIAGNOSTIC_COREAPI.BRPrint;
647:
648: sql_text:= po_sql(102);
649: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
650: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
651: JTF_DIAGNOSTIC_COREAPI.BRPrint;
652:
653: sql_text:= po_sql(103);
654: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

Line 651: JTF_DIAGNOSTIC_COREAPI.BRPrint;

647:
648: sql_text:= po_sql(102);
649: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
650: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
651: JTF_DIAGNOSTIC_COREAPI.BRPrint;
652:
653: sql_text:= po_sql(103);
654: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
655: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

650: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
651: JTF_DIAGNOSTIC_COREAPI.BRPrint;
652:
653: sql_text:= po_sql(103);
654: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
655: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
656: JTF_DIAGNOSTIC_COREAPI.BRPrint;
657:
658: sql_text:= po_sql(104);

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

651: JTF_DIAGNOSTIC_COREAPI.BRPrint;
652:
653: sql_text:= po_sql(103);
654: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
655: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
656: JTF_DIAGNOSTIC_COREAPI.BRPrint;
657:
658: sql_text:= po_sql(104);
659: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

Line 656: JTF_DIAGNOSTIC_COREAPI.BRPrint;

652:
653: sql_text:= po_sql(103);
654: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
655: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
656: JTF_DIAGNOSTIC_COREAPI.BRPrint;
657:
658: sql_text:= po_sql(104);
659: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
660: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

655: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
656: JTF_DIAGNOSTIC_COREAPI.BRPrint;
657:
658: sql_text:= po_sql(104);
659: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
660: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
661: JTF_DIAGNOSTIC_COREAPI.BRPrint;
662:
663: sql_text:= po_sql(105);

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

656: JTF_DIAGNOSTIC_COREAPI.BRPrint;
657:
658: sql_text:= po_sql(104);
659: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
660: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
661: JTF_DIAGNOSTIC_COREAPI.BRPrint;
662:
663: sql_text:= po_sql(105);
664: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

Line 661: JTF_DIAGNOSTIC_COREAPI.BRPrint;

657:
658: sql_text:= po_sql(104);
659: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
660: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
661: JTF_DIAGNOSTIC_COREAPI.BRPrint;
662:
663: sql_text:= po_sql(105);
664: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

660: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
661: JTF_DIAGNOSTIC_COREAPI.BRPrint;
662:
663: sql_text:= po_sql(105);
664: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= po_sql(106);

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

661: JTF_DIAGNOSTIC_COREAPI.BRPrint;
662:
663: sql_text:= po_sql(105);
664: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= po_sql(106);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

Line 666: JTF_DIAGNOSTIC_COREAPI.BRPrint;

662:
663: sql_text:= po_sql(105);
664: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= po_sql(106);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
670: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= po_sql(106);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
670: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
671: JTF_DIAGNOSTIC_COREAPI.BRPrint;
672:
673: -- Test Completed successfully.

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

666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= po_sql(106);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
670: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
671: JTF_DIAGNOSTIC_COREAPI.BRPrint;
672:
673: -- Test Completed successfully.
674: statusStr := 'SUCCESS';

Line 671: JTF_DIAGNOSTIC_COREAPI.BRPrint;

667:
668: sql_text:= po_sql(106);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
670: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
671: JTF_DIAGNOSTIC_COREAPI.BRPrint;
672:
673: -- Test Completed successfully.
674: statusStr := 'SUCCESS';
675: isFatal := 'FALSE';

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

677: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
678:
679: EXCEPTION
680: when others then
681: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
682: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
683: statusStr := 'FAILURE';
684: errStr := sqlerrm ||' occurred in script Exception handled';
685: fixInfo := 'Unexpected Exception in INVREQ1B.pls';

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

678:
679: EXCEPTION
680: when others then
681: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
682: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
683: statusStr := 'FAILURE';
684: errStr := sqlerrm ||' occurred in script Exception handled';
685: fixInfo := 'Unexpected Exception in INVREQ1B.pls';
686: isFatal := 'FALSE';

INDEX OF QUERIES