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

APPS.INV_DIAG_RCV_IOT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

102:
103: BEGIN
104: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
105: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
107:
108: -- accept input
109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
110: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));

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

113:
114:
115: IF (l_shipment_num is NULL AND l_receipt_num is NULL AND l_shipment_line_num IS NULL AND l_org_id is NULL ) THEN
116:
117: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
118: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
119: test');
120: statusStr := 'FAILURE';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 118: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

114:
115: IF (l_shipment_num is NULL AND l_receipt_num is NULL AND l_shipment_line_num IS NULL AND l_org_id is NULL ) THEN
116:
117: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
118: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
119: test');
120: statusStr := 'FAILURE';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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

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

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

138: END IF;
139:
140:
141: IF (l_shipment_num is NOT NULL and l_org_id is NULL) THEN
142: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
143: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
144: test');
145: statusStr := 'FAILURE';
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 143: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

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

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

151:
152:
153: IF (l_receipt_num is NOT NULL and l_org_id is NULL) THEN
154:
155: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
157: test');
158: statusStr := 'FAILURE';
159: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 156: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

152:
153: IF (l_receipt_num is NOT NULL and l_org_id is NULL) THEN
154:
155: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
157: test');
158: statusStr := 'FAILURE';
159: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

163: END IF;
164:
165:
166: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_org_id is NOT NULL) THEN
167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
169: test');
170: statusStr := 'FAILURE';
171: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

164:
165:
166: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_org_id is NOT NULL) THEN
167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
169: test');
170: statusStr := 'FAILURE';
171: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
172: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

175: END IF;
176:
177:
178: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_shipment_line_num is NOT NULL) THEN
179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
181: test');
182: statusStr := 'FAILURE';
183: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

176:
177:
178: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_shipment_line_num is NOT NULL) THEN
179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
181: test');
182: statusStr := 'FAILURE';
183: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
184: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

268:
269:
270: IF (l_count = 0) THEN
271: statusStr := 'FAILURE';
272: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
273: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid combination of data');
274: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
275: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
276: RETURN;

Line 273: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid combination of data');

269:
270: IF (l_count = 0) THEN
271: statusStr := 'FAILURE';
272: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
273: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid combination of data');
274: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
275: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
276: RETURN;
277: END IF;

Line 328: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

324: IF (l_shipment_num is NOT NULL AND l_shipment_line_num is NOT NULL) THEN
325: iot_diagnostics.shipment_line_num_sql(l_org_id,l_shipment_num,l_shipment_line_num,l_receipt_num,iot1_sql);
326: END IF;
327:
328: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
329: JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
330: '||'
331: '||'
332: '||'
Line 329: JTF_DIAGNOSTIC_COREAPI.insert_html('
INDEX OF QUERIES

'||'
325: iot_diagnostics.shipment_line_num_sql(l_org_id,l_shipment_num,l_shipment_line_num,l_receipt_num,iot1_sql);
326: END IF;
327:
328: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
329: JTF_DIAGNOSTIC_COREAPI.insert_html('

'||'
330: '||'
331: '||'
332: '||'
333: '||'
Line 389: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');
385:
'||'
386: '||'
387:
INDEX OF QUERIES
LOOKUP CODES
');
388:
389: JTF_DIAGNOSTIC_COREAPI.insert_html('

INDEX OF QUERIES
LOOKUP CODES

Receipt Information

');
390: sql_text := iot1_sql(1);
391: JTF_DIAGNOSTIC_COREAPI.insert_html('');
392: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
393: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 391: JTF_DIAGNOSTIC_COREAPI.insert_html('');

387: ');
388:
389: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
390: sql_text := iot1_sql(1);
391: JTF_DIAGNOSTIC_COREAPI.insert_html('');
392: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
393: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
394: JTF_DIAGNOSTIC_COREAPI.BRPrint;
395:

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

388:
389: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
390: sql_text := iot1_sql(1);
391: JTF_DIAGNOSTIC_COREAPI.insert_html('');
392: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
393: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
394: JTF_DIAGNOSTIC_COREAPI.BRPrint;
395:
396: sql_text := iot1_sql(2);

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

389: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
390: sql_text := iot1_sql(1);
391: JTF_DIAGNOSTIC_COREAPI.insert_html('');
392: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
393: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
394: JTF_DIAGNOSTIC_COREAPI.BRPrint;
395:
396: sql_text := iot1_sql(2);
397: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 394: JTF_DIAGNOSTIC_COREAPI.BRPrint;

390: sql_text := iot1_sql(1);
391: JTF_DIAGNOSTIC_COREAPI.insert_html('');
392: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
393: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
394: JTF_DIAGNOSTIC_COREAPI.BRPrint;
395:
396: sql_text := iot1_sql(2);
397: JTF_DIAGNOSTIC_COREAPI.insert_html('');
398: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE ');

393: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
394: JTF_DIAGNOSTIC_COREAPI.BRPrint;
395:
396: sql_text := iot1_sql(2);
397: JTF_DIAGNOSTIC_COREAPI.insert_html('');
398: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE [Top]');
400: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
401: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

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

396: sql_text := iot1_sql(2);
397: JTF_DIAGNOSTIC_COREAPI.insert_html('');
398: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
400: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
401: JTF_DIAGNOSTIC_COREAPI.BRPrint;
402:
403: sql_text := iot1_sql(3);
404: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 401: JTF_DIAGNOSTIC_COREAPI.BRPrint;

397: JTF_DIAGNOSTIC_COREAPI.insert_html('');
398: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
400: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
401: JTF_DIAGNOSTIC_COREAPI.BRPrint;
402:
403: sql_text := iot1_sql(3);
404: JTF_DIAGNOSTIC_COREAPI.insert_html('');
405: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

Line 404: JTF_DIAGNOSTIC_COREAPI.insert_html('');

400: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
401: JTF_DIAGNOSTIC_COREAPI.BRPrint;
402:
403: sql_text := iot1_sql(3);
404: JTF_DIAGNOSTIC_COREAPI.insert_html('');
405: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
406: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
407: JTF_DIAGNOSTIC_COREAPI.BRPrint;
408:

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

401: JTF_DIAGNOSTIC_COREAPI.BRPrint;
402:
403: sql_text := iot1_sql(3);
404: JTF_DIAGNOSTIC_COREAPI.insert_html('');
405: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
406: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
407: JTF_DIAGNOSTIC_COREAPI.BRPrint;
408:
409:

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

402:
403: sql_text := iot1_sql(3);
404: JTF_DIAGNOSTIC_COREAPI.insert_html('');
405: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
406: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
407: JTF_DIAGNOSTIC_COREAPI.BRPrint;
408:
409:
410: sql_text := iot1_sql(4);

Line 407: JTF_DIAGNOSTIC_COREAPI.BRPrint;

403: sql_text := iot1_sql(3);
404: JTF_DIAGNOSTIC_COREAPI.insert_html('');
405: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
406: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
407: JTF_DIAGNOSTIC_COREAPI.BRPrint;
408:
409:
410: sql_text := iot1_sql(4);
411: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 411: JTF_DIAGNOSTIC_COREAPI.insert_html('');

407: JTF_DIAGNOSTIC_COREAPI.BRPrint;
408:
409:
410: sql_text := iot1_sql(4);
411: JTF_DIAGNOSTIC_COREAPI.insert_html('');
412: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
414: JTF_DIAGNOSTIC_COREAPI.BRPrint;
415:

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

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

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

409:
410: sql_text := iot1_sql(4);
411: JTF_DIAGNOSTIC_COREAPI.insert_html('');
412: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
414: JTF_DIAGNOSTIC_COREAPI.BRPrint;
415:
416:
417: sql_text := iot1_sql(5);

Line 414: JTF_DIAGNOSTIC_COREAPI.BRPrint;

410: sql_text := iot1_sql(4);
411: JTF_DIAGNOSTIC_COREAPI.insert_html('');
412: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
414: JTF_DIAGNOSTIC_COREAPI.BRPrint;
415:
416:
417: sql_text := iot1_sql(5);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 418: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

415:
416:
417: sql_text := iot1_sql(5);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423:

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

416:
417: sql_text := iot1_sql(5);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423:
424: sql_text:= iot1_sql(6);

Line 421: JTF_DIAGNOSTIC_COREAPI.BRPrint;

417: sql_text := iot1_sql(5);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423:
424: sql_text:= iot1_sql(6);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 425: JTF_DIAGNOSTIC_COREAPI.insert_html('');

421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423:
424: sql_text:= iot1_sql(6);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
428: JTF_DIAGNOSTIC_COREAPI.BRPrint;
429:

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

422:
423:
424: sql_text:= iot1_sql(6);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
428: JTF_DIAGNOSTIC_COREAPI.BRPrint;
429:
430: sql_text := iot1_sql(7);

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

423:
424: sql_text:= iot1_sql(6);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
428: JTF_DIAGNOSTIC_COREAPI.BRPrint;
429:
430: sql_text := iot1_sql(7);
431: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 428: JTF_DIAGNOSTIC_COREAPI.BRPrint;

424: sql_text:= iot1_sql(6);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
428: JTF_DIAGNOSTIC_COREAPI.BRPrint;
429:
430: sql_text := iot1_sql(7);
431: JTF_DIAGNOSTIC_COREAPI.insert_html('');
432: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');

Line 431: JTF_DIAGNOSTIC_COREAPI.insert_html('');

427: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
428: JTF_DIAGNOSTIC_COREAPI.BRPrint;
429:
430: sql_text := iot1_sql(7);
431: JTF_DIAGNOSTIC_COREAPI.insert_html('');
432: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
433: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
434: JTF_DIAGNOSTIC_COREAPI.BRPrint;
435:

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

428: JTF_DIAGNOSTIC_COREAPI.BRPrint;
429:
430: sql_text := iot1_sql(7);
431: JTF_DIAGNOSTIC_COREAPI.insert_html('');
432: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
433: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
434: JTF_DIAGNOSTIC_COREAPI.BRPrint;
435:
436: sql_text := iot1_sql(8);

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

429:
430: sql_text := iot1_sql(7);
431: JTF_DIAGNOSTIC_COREAPI.insert_html('');
432: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
433: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
434: JTF_DIAGNOSTIC_COREAPI.BRPrint;
435:
436: sql_text := iot1_sql(8);
437: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 434: JTF_DIAGNOSTIC_COREAPI.BRPrint;

430: sql_text := iot1_sql(7);
431: JTF_DIAGNOSTIC_COREAPI.insert_html('');
432: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
433: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
434: JTF_DIAGNOSTIC_COREAPI.BRPrint;
435:
436: sql_text := iot1_sql(8);
437: JTF_DIAGNOSTIC_COREAPI.insert_html('');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');

Line 437: JTF_DIAGNOSTIC_COREAPI.insert_html('');

433: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
434: JTF_DIAGNOSTIC_COREAPI.BRPrint;
435:
436: sql_text := iot1_sql(8);
437: JTF_DIAGNOSTIC_COREAPI.insert_html('');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');
440: JTF_DIAGNOSTIC_COREAPI.BRPrint;
441:

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

434: JTF_DIAGNOSTIC_COREAPI.BRPrint;
435:
436: sql_text := iot1_sql(8);
437: JTF_DIAGNOSTIC_COREAPI.insert_html('');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');
440: JTF_DIAGNOSTIC_COREAPI.BRPrint;
441:
442:

Line 439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');

435:
436: sql_text := iot1_sql(8);
437: JTF_DIAGNOSTIC_COREAPI.insert_html('');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');
440: JTF_DIAGNOSTIC_COREAPI.BRPrint;
441:
442:
443: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');

Line 440: JTF_DIAGNOSTIC_COREAPI.BRPrint;

436: sql_text := iot1_sql(8);
437: JTF_DIAGNOSTIC_COREAPI.insert_html('');
438: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');
440: JTF_DIAGNOSTIC_COREAPI.BRPrint;
441:
442:
443: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
444: sql_text := iot1_sql(9);

Line 443: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');

439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');
440: JTF_DIAGNOSTIC_COREAPI.BRPrint;
441:
442:
443: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');
444: sql_text := iot1_sql(9);
445: JTF_DIAGNOSTIC_COREAPI.insert_html('');
446: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');

Line 445: JTF_DIAGNOSTIC_COREAPI.insert_html('');

441:
442:
443: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
444: sql_text := iot1_sql(9);
445: JTF_DIAGNOSTIC_COREAPI.insert_html('');
446: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 446: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  ');
446: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:

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

444: sql_text := iot1_sql(9);
445: JTF_DIAGNOSTIC_COREAPI.insert_html('');
446: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451:
452: sql_text:= iot1_sql(10);

Line 449: JTF_DIAGNOSTIC_COREAPI.BRPrint;

445: JTF_DIAGNOSTIC_COREAPI.insert_html('');
446: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
448: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451:
452: sql_text:= iot1_sql(10);
453: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 453: JTF_DIAGNOSTIC_COREAPI.insert_html('');

449: JTF_DIAGNOSTIC_COREAPI.BRPrint;
450:
451:
452: sql_text:= iot1_sql(10);
453: JTF_DIAGNOSTIC_COREAPI.insert_html('');
454: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
455: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
456: JTF_DIAGNOSTIC_COREAPI.BRPrint;
457:

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

450:
451:
452: sql_text:= iot1_sql(10);
453: JTF_DIAGNOSTIC_COREAPI.insert_html('');
454: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
455: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
456: JTF_DIAGNOSTIC_COREAPI.BRPrint;
457:
458: sql_text:= iot1_sql(11);

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

451:
452: sql_text:= iot1_sql(10);
453: JTF_DIAGNOSTIC_COREAPI.insert_html('');
454: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
455: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
456: JTF_DIAGNOSTIC_COREAPI.BRPrint;
457:
458: sql_text:= iot1_sql(11);
459: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 456: JTF_DIAGNOSTIC_COREAPI.BRPrint;

452: sql_text:= iot1_sql(10);
453: JTF_DIAGNOSTIC_COREAPI.insert_html('');
454: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
455: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
456: JTF_DIAGNOSTIC_COREAPI.BRPrint;
457:
458: sql_text:= iot1_sql(11);
459: JTF_DIAGNOSTIC_COREAPI.insert_html('');
460: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

Line 459: JTF_DIAGNOSTIC_COREAPI.insert_html('');

455: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
456: JTF_DIAGNOSTIC_COREAPI.BRPrint;
457:
458: sql_text:= iot1_sql(11);
459: JTF_DIAGNOSTIC_COREAPI.insert_html('');
460: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
462: JTF_DIAGNOSTIC_COREAPI.BRPrint;
463:

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

456: JTF_DIAGNOSTIC_COREAPI.BRPrint;
457:
458: sql_text:= iot1_sql(11);
459: JTF_DIAGNOSTIC_COREAPI.insert_html('');
460: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
462: JTF_DIAGNOSTIC_COREAPI.BRPrint;
463:
464: sql_text:= iot1_sql(12);

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

457:
458: sql_text:= iot1_sql(11);
459: JTF_DIAGNOSTIC_COREAPI.insert_html('');
460: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
462: JTF_DIAGNOSTIC_COREAPI.BRPrint;
463:
464: sql_text:= iot1_sql(12);
465: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 462: JTF_DIAGNOSTIC_COREAPI.BRPrint;

458: sql_text:= iot1_sql(11);
459: JTF_DIAGNOSTIC_COREAPI.insert_html('');
460: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
462: JTF_DIAGNOSTIC_COREAPI.BRPrint;
463:
464: sql_text:= iot1_sql(12);
465: JTF_DIAGNOSTIC_COREAPI.insert_html('');
466: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  ');

461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
462: JTF_DIAGNOSTIC_COREAPI.BRPrint;
463:
464: sql_text:= iot1_sql(12);
465: JTF_DIAGNOSTIC_COREAPI.insert_html('');
466: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
468: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
469: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 466: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  ');
466: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
468: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
469: JTF_DIAGNOSTIC_COREAPI.BRPrint;
470:

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

464: sql_text:= iot1_sql(12);
465: JTF_DIAGNOSTIC_COREAPI.insert_html('');
466: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
468: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
469: JTF_DIAGNOSTIC_COREAPI.BRPrint;
470:
471: sql_text:= iot1_sql(13);
472: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 469: JTF_DIAGNOSTIC_COREAPI.BRPrint;

465: JTF_DIAGNOSTIC_COREAPI.insert_html('');
466: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
468: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
469: JTF_DIAGNOSTIC_COREAPI.BRPrint;
470:
471: sql_text:= iot1_sql(13);
472: JTF_DIAGNOSTIC_COREAPI.insert_html('');
473: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  ');

468: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
469: JTF_DIAGNOSTIC_COREAPI.BRPrint;
470:
471: sql_text:= iot1_sql(13);
472: JTF_DIAGNOSTIC_COREAPI.insert_html('');
473: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
475: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
476: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 473: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  ');
473: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
475: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
476: JTF_DIAGNOSTIC_COREAPI.BRPrint;
477:

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

471: sql_text:= iot1_sql(13);
472: JTF_DIAGNOSTIC_COREAPI.insert_html('');
473: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
475: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
476: JTF_DIAGNOSTIC_COREAPI.BRPrint;
477:
478: sql_text:= iot1_sql(14);
479: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 476: JTF_DIAGNOSTIC_COREAPI.BRPrint;

472: JTF_DIAGNOSTIC_COREAPI.insert_html('');
473: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
475: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
476: JTF_DIAGNOSTIC_COREAPI.BRPrint;
477:
478: sql_text:= iot1_sql(14);
479: JTF_DIAGNOSTIC_COREAPI.insert_html('');
480: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

Line 479: JTF_DIAGNOSTIC_COREAPI.insert_html('');

475: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
476: JTF_DIAGNOSTIC_COREAPI.BRPrint;
477:
478: sql_text:= iot1_sql(14);
479: JTF_DIAGNOSTIC_COREAPI.insert_html('');
480: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
481: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
482: JTF_DIAGNOSTIC_COREAPI.BRPrint;
483:

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

476: JTF_DIAGNOSTIC_COREAPI.BRPrint;
477:
478: sql_text:= iot1_sql(14);
479: JTF_DIAGNOSTIC_COREAPI.insert_html('');
480: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
481: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
482: JTF_DIAGNOSTIC_COREAPI.BRPrint;
483:
484: sql_text:= iot1_sql(15);

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

477:
478: sql_text:= iot1_sql(14);
479: JTF_DIAGNOSTIC_COREAPI.insert_html('');
480: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
481: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
482: JTF_DIAGNOSTIC_COREAPI.BRPrint;
483:
484: sql_text:= iot1_sql(15);
485: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 482: JTF_DIAGNOSTIC_COREAPI.BRPrint;

478: sql_text:= iot1_sql(14);
479: JTF_DIAGNOSTIC_COREAPI.insert_html('');
480: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
481: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
482: JTF_DIAGNOSTIC_COREAPI.BRPrint;
483:
484: sql_text:= iot1_sql(15);
485: JTF_DIAGNOSTIC_COREAPI.insert_html('');
486: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');

Line 485: JTF_DIAGNOSTIC_COREAPI.insert_html('');

481: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
482: JTF_DIAGNOSTIC_COREAPI.BRPrint;
483:
484: sql_text:= iot1_sql(15);
485: JTF_DIAGNOSTIC_COREAPI.insert_html('');
486: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
487: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
488: JTF_DIAGNOSTIC_COREAPI.BRPrint;
489:

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

482: JTF_DIAGNOSTIC_COREAPI.BRPrint;
483:
484: sql_text:= iot1_sql(15);
485: JTF_DIAGNOSTIC_COREAPI.insert_html('');
486: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
487: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
488: JTF_DIAGNOSTIC_COREAPI.BRPrint;
489:
490: sql_text:= iot1_sql(16);

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

483:
484: sql_text:= iot1_sql(15);
485: JTF_DIAGNOSTIC_COREAPI.insert_html('');
486: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
487: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
488: JTF_DIAGNOSTIC_COREAPI.BRPrint;
489:
490: sql_text:= iot1_sql(16);
491: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 488: JTF_DIAGNOSTIC_COREAPI.BRPrint;

484: sql_text:= iot1_sql(15);
485: JTF_DIAGNOSTIC_COREAPI.insert_html('');
486: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
487: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
488: JTF_DIAGNOSTIC_COREAPI.BRPrint;
489:
490: sql_text:= iot1_sql(16);
491: JTF_DIAGNOSTIC_COREAPI.insert_html('');
492: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

Line 491: JTF_DIAGNOSTIC_COREAPI.insert_html('');

487: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
488: JTF_DIAGNOSTIC_COREAPI.BRPrint;
489:
490: sql_text:= iot1_sql(16);
491: JTF_DIAGNOSTIC_COREAPI.insert_html('');
492: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
493: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
494: JTF_DIAGNOSTIC_COREAPI.BRPrint;
495:

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

488: JTF_DIAGNOSTIC_COREAPI.BRPrint;
489:
490: sql_text:= iot1_sql(16);
491: JTF_DIAGNOSTIC_COREAPI.insert_html('');
492: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
493: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
494: JTF_DIAGNOSTIC_COREAPI.BRPrint;
495:
496: sql_text:= iot1_sql(17);

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

489:
490: sql_text:= iot1_sql(16);
491: JTF_DIAGNOSTIC_COREAPI.insert_html('');
492: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
493: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
494: JTF_DIAGNOSTIC_COREAPI.BRPrint;
495:
496: sql_text:= iot1_sql(17);
497: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 494: JTF_DIAGNOSTIC_COREAPI.BRPrint;

490: sql_text:= iot1_sql(16);
491: JTF_DIAGNOSTIC_COREAPI.insert_html('');
492: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
493: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
494: JTF_DIAGNOSTIC_COREAPI.BRPrint;
495:
496: sql_text:= iot1_sql(17);
497: JTF_DIAGNOSTIC_COREAPI.insert_html('');
498: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');

Line 497: JTF_DIAGNOSTIC_COREAPI.insert_html('');

493: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
494: JTF_DIAGNOSTIC_COREAPI.BRPrint;
495:
496: sql_text:= iot1_sql(17);
497: JTF_DIAGNOSTIC_COREAPI.insert_html('');
498: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
500: JTF_DIAGNOSTIC_COREAPI.BRPrint;
501:

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

494: JTF_DIAGNOSTIC_COREAPI.BRPrint;
495:
496: sql_text:= iot1_sql(17);
497: JTF_DIAGNOSTIC_COREAPI.insert_html('');
498: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
500: JTF_DIAGNOSTIC_COREAPI.BRPrint;
501:
502: sql_text:= iot1_sql(18);

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

495:
496: sql_text:= iot1_sql(17);
497: JTF_DIAGNOSTIC_COREAPI.insert_html('');
498: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
500: JTF_DIAGNOSTIC_COREAPI.BRPrint;
501:
502: sql_text:= iot1_sql(18);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 500: JTF_DIAGNOSTIC_COREAPI.BRPrint;

496: sql_text:= iot1_sql(17);
497: JTF_DIAGNOSTIC_COREAPI.insert_html('');
498: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
500: JTF_DIAGNOSTIC_COREAPI.BRPrint;
501:
502: sql_text:= iot1_sql(18);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY  [Top]');

Line 503: JTF_DIAGNOSTIC_COREAPI.insert_html('');

499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
500: JTF_DIAGNOSTIC_COREAPI.BRPrint;
501:
502: sql_text:= iot1_sql(18);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:

Line 504: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY  [Top]');

500: JTF_DIAGNOSTIC_COREAPI.BRPrint;
501:
502: sql_text:= iot1_sql(18);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= iot1_sql(19);

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

501:
502: sql_text:= iot1_sql(18);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= iot1_sql(19);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 506: JTF_DIAGNOSTIC_COREAPI.BRPrint;

502: sql_text:= iot1_sql(18);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= iot1_sql(19);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

Line 509: JTF_DIAGNOSTIC_COREAPI.insert_html('');

505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= iot1_sql(19);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:

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

506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= iot1_sql(19);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= iot1_sql(20);

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

507:
508: sql_text:= iot1_sql(19);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= iot1_sql(20);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 512: JTF_DIAGNOSTIC_COREAPI.BRPrint;

508: sql_text:= iot1_sql(19);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= iot1_sql(20);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');

Line 515: JTF_DIAGNOSTIC_COREAPI.insert_html('');

511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= iot1_sql(20);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:

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

512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= iot1_sql(20);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= iot1_sql(21);

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

513:
514: sql_text:= iot1_sql(20);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= iot1_sql(21);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 518: JTF_DIAGNOSTIC_COREAPI.BRPrint;

514: sql_text:= iot1_sql(20);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= iot1_sql(21);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');

Line 521: JTF_DIAGNOSTIC_COREAPI.insert_html('');

517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= iot1_sql(21);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:

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

518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= iot1_sql(21);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= iot1_sql(22);

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

519:
520: sql_text:= iot1_sql(21);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= iot1_sql(22);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 524: JTF_DIAGNOSTIC_COREAPI.BRPrint;

520: sql_text:= iot1_sql(21);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= iot1_sql(22);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

Line 527: JTF_DIAGNOSTIC_COREAPI.insert_html('');

523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= iot1_sql(22);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:

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

524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= iot1_sql(22);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= iot1_sql(23);

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

525:
526: sql_text:= iot1_sql(22);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= iot1_sql(23);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 530: JTF_DIAGNOSTIC_COREAPI.BRPrint;

526: sql_text:= iot1_sql(22);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= iot1_sql(23);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  ');

529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= iot1_sql(23);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 534: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  ');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:

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

532: sql_text:= iot1_sql(23);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= iot1_sql(24);
540: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 537: JTF_DIAGNOSTIC_COREAPI.BRPrint;

533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= iot1_sql(24);
540: JTF_DIAGNOSTIC_COREAPI.insert_html('');
541: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

Line 540: JTF_DIAGNOSTIC_COREAPI.insert_html('');

536: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= iot1_sql(24);
540: JTF_DIAGNOSTIC_COREAPI.insert_html('');
541: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
542: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
543: JTF_DIAGNOSTIC_COREAPI.BRPrint;
544:

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

537: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538:
539: sql_text:= iot1_sql(24);
540: JTF_DIAGNOSTIC_COREAPI.insert_html('');
541: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
542: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
543: JTF_DIAGNOSTIC_COREAPI.BRPrint;
544:
545: sql_text:= iot1_sql(25);

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

538:
539: sql_text:= iot1_sql(24);
540: JTF_DIAGNOSTIC_COREAPI.insert_html('');
541: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
542: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
543: JTF_DIAGNOSTIC_COREAPI.BRPrint;
544:
545: sql_text:= iot1_sql(25);
546: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 543: JTF_DIAGNOSTIC_COREAPI.BRPrint;

539: sql_text:= iot1_sql(24);
540: JTF_DIAGNOSTIC_COREAPI.insert_html('');
541: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
542: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
543: JTF_DIAGNOSTIC_COREAPI.BRPrint;
544:
545: sql_text:= iot1_sql(25);
546: JTF_DIAGNOSTIC_COREAPI.insert_html('');
547: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');

Line 546: JTF_DIAGNOSTIC_COREAPI.insert_html('');

542: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
543: JTF_DIAGNOSTIC_COREAPI.BRPrint;
544:
545: sql_text:= iot1_sql(25);
546: JTF_DIAGNOSTIC_COREAPI.insert_html('');
547: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
549: JTF_DIAGNOSTIC_COREAPI.BRPrint;
550:

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

543: JTF_DIAGNOSTIC_COREAPI.BRPrint;
544:
545: sql_text:= iot1_sql(25);
546: JTF_DIAGNOSTIC_COREAPI.insert_html('');
547: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
549: JTF_DIAGNOSTIC_COREAPI.BRPrint;
550:
551: sql_text:= iot1_sql(26);

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

544:
545: sql_text:= iot1_sql(25);
546: JTF_DIAGNOSTIC_COREAPI.insert_html('');
547: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
549: JTF_DIAGNOSTIC_COREAPI.BRPrint;
550:
551: sql_text:= iot1_sql(26);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 549: JTF_DIAGNOSTIC_COREAPI.BRPrint;

545: sql_text:= iot1_sql(25);
546: JTF_DIAGNOSTIC_COREAPI.insert_html('');
547: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
549: JTF_DIAGNOSTIC_COREAPI.BRPrint;
550:
551: sql_text:= iot1_sql(26);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

Line 552: JTF_DIAGNOSTIC_COREAPI.insert_html('');

548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
549: JTF_DIAGNOSTIC_COREAPI.BRPrint;
550:
551: sql_text:= iot1_sql(26);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [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_TRANSACTION_TYPES  [Top]');

549: JTF_DIAGNOSTIC_COREAPI.BRPrint;
550:
551: sql_text:= iot1_sql(26);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= iot1_sql(27);

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

550:
551: sql_text:= iot1_sql(26);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= iot1_sql(27);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 555: JTF_DIAGNOSTIC_COREAPI.BRPrint;

551: sql_text:= iot1_sql(26);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= iot1_sql(27);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [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:= iot1_sql(27);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:

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

555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text:= iot1_sql(27);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= iot1_sql(28);

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

556:
557: sql_text:= iot1_sql(27);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= iot1_sql(28);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 561: JTF_DIAGNOSTIC_COREAPI.BRPrint;

557: sql_text:= iot1_sql(27);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= iot1_sql(28);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [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:= iot1_sql(28);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [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_INTERORG_PARAMETERS  [Top]');

561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: sql_text:= iot1_sql(28);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
566: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= iot1_sql(29);

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

562:
563: sql_text:= iot1_sql(28);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
566: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= iot1_sql(29);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 567: JTF_DIAGNOSTIC_COREAPI.BRPrint;

563: sql_text:= iot1_sql(28);
564: JTF_DIAGNOSTIC_COREAPI.insert_html('');
565: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
566: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= iot1_sql(29);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [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:= iot1_sql(29);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [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_PARAMETERS  [Top]');

567: JTF_DIAGNOSTIC_COREAPI.BRPrint;
568:
569: sql_text:= iot1_sql(29);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
572: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= iot1_sql(30);

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

568:
569: sql_text:= iot1_sql(29);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
572: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= iot1_sql(30);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 573: JTF_DIAGNOSTIC_COREAPI.BRPrint;

569: sql_text:= iot1_sql(29);
570: JTF_DIAGNOSTIC_COREAPI.insert_html('');
571: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
572: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= iot1_sql(30);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [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:= iot1_sql(30);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [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_PARAMETERS  [Top]');

573: JTF_DIAGNOSTIC_COREAPI.BRPrint;
574:
575: sql_text:= iot1_sql(30);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

574:
575: sql_text:= iot1_sql(30);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: JTF_DIAGNOSTIC_COREAPI.insert_html('');
582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');

Line 579: JTF_DIAGNOSTIC_COREAPI.BRPrint;

575: sql_text:= iot1_sql(30);
576: JTF_DIAGNOSTIC_COREAPI.insert_html('');
577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: JTF_DIAGNOSTIC_COREAPI.insert_html('');
582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
583: sql_text:= iot1_sql(31);

Line 581: JTF_DIAGNOSTIC_COREAPI.insert_html('');

577: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: JTF_DIAGNOSTIC_COREAPI.insert_html('');
582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
583: sql_text:= iot1_sql(31);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

Line 582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');

578: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
579: JTF_DIAGNOSTIC_COREAPI.BRPrint;
580:
581: JTF_DIAGNOSTIC_COREAPI.insert_html('');
582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
583: sql_text:= iot1_sql(31);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 584: JTF_DIAGNOSTIC_COREAPI.insert_html('');

580:
581: JTF_DIAGNOSTIC_COREAPI.insert_html('');
582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
583: sql_text:= iot1_sql(31);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:

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

581: JTF_DIAGNOSTIC_COREAPI.insert_html('');
582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
583: sql_text:= iot1_sql(31);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= iot1_sql(32);

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

582: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
583: sql_text:= iot1_sql(31);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= iot1_sql(32);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 587: JTF_DIAGNOSTIC_COREAPI.BRPrint;

583: sql_text:= iot1_sql(31);
584: JTF_DIAGNOSTIC_COREAPI.insert_html('');
585: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= iot1_sql(32);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

Line 590: JTF_DIAGNOSTIC_COREAPI.insert_html('');

586: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= iot1_sql(32);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:

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

587: JTF_DIAGNOSTIC_COREAPI.BRPrint;
588:
589: sql_text:= iot1_sql(32);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= iot1_sql(33);

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

588:
589: sql_text:= iot1_sql(32);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= iot1_sql(33);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 593: JTF_DIAGNOSTIC_COREAPI.BRPrint;

589: sql_text:= iot1_sql(32);
590: JTF_DIAGNOSTIC_COREAPI.insert_html('');
591: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= iot1_sql(33);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

Line 596: JTF_DIAGNOSTIC_COREAPI.insert_html('');

592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= iot1_sql(33);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:

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

593: JTF_DIAGNOSTIC_COREAPI.BRPrint;
594:
595: sql_text:= iot1_sql(33);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= iot1_sql(34);

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

594:
595: sql_text:= iot1_sql(33);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= iot1_sql(34);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 599: JTF_DIAGNOSTIC_COREAPI.BRPrint;

595: sql_text:= iot1_sql(33);
596: JTF_DIAGNOSTIC_COREAPI.insert_html('');
597: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= iot1_sql(34);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

Line 602: JTF_DIAGNOSTIC_COREAPI.insert_html('');

598: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= iot1_sql(34);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:

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

599: JTF_DIAGNOSTIC_COREAPI.BRPrint;
600:
601: sql_text:= iot1_sql(34);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607:

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

600:
601: sql_text:= iot1_sql(34);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607:
608: sql_text:= iot1_sql(35);

Line 605: JTF_DIAGNOSTIC_COREAPI.BRPrint;

601: sql_text:= iot1_sql(34);
602: JTF_DIAGNOSTIC_COREAPI.insert_html('');
603: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
604: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607:
608: sql_text:= iot1_sql(35);
609: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 609: JTF_DIAGNOSTIC_COREAPI.insert_html('');

605: JTF_DIAGNOSTIC_COREAPI.BRPrint;
606:
607:
608: sql_text:= iot1_sql(35);
609: JTF_DIAGNOSTIC_COREAPI.insert_html('');
610: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
611: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
612: JTF_DIAGNOSTIC_COREAPI.BRPrint;
613:

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

606:
607:
608: sql_text:= iot1_sql(35);
609: JTF_DIAGNOSTIC_COREAPI.insert_html('');
610: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
611: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
612: JTF_DIAGNOSTIC_COREAPI.BRPrint;
613:
614:

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

607:
608: sql_text:= iot1_sql(35);
609: JTF_DIAGNOSTIC_COREAPI.insert_html('');
610: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
611: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
612: JTF_DIAGNOSTIC_COREAPI.BRPrint;
613:
614:
615: sql_text:= iot1_sql(36);

Line 612: JTF_DIAGNOSTIC_COREAPI.BRPrint;

608: sql_text:= iot1_sql(35);
609: JTF_DIAGNOSTIC_COREAPI.insert_html('');
610: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
611: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
612: JTF_DIAGNOSTIC_COREAPI.BRPrint;
613:
614:
615: sql_text:= iot1_sql(36);
616: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 616: JTF_DIAGNOSTIC_COREAPI.insert_html('');

612: JTF_DIAGNOSTIC_COREAPI.BRPrint;
613:
614:
615: sql_text:= iot1_sql(36);
616: JTF_DIAGNOSTIC_COREAPI.insert_html('');
617: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
618: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
619: JTF_DIAGNOSTIC_COREAPI.BRPrint;
620:

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

613:
614:
615: sql_text:= iot1_sql(36);
616: JTF_DIAGNOSTIC_COREAPI.insert_html('');
617: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
618: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
619: JTF_DIAGNOSTIC_COREAPI.BRPrint;
620:
621: sql_text:= iot1_sql(37);

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

614:
615: sql_text:= iot1_sql(36);
616: JTF_DIAGNOSTIC_COREAPI.insert_html('');
617: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
618: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
619: JTF_DIAGNOSTIC_COREAPI.BRPrint;
620:
621: sql_text:= iot1_sql(37);
622: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 619: JTF_DIAGNOSTIC_COREAPI.BRPrint;

615: sql_text:= iot1_sql(36);
616: JTF_DIAGNOSTIC_COREAPI.insert_html('');
617: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
618: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
619: JTF_DIAGNOSTIC_COREAPI.BRPrint;
620:
621: sql_text:= iot1_sql(37);
622: JTF_DIAGNOSTIC_COREAPI.insert_html('');
623: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

Line 622: JTF_DIAGNOSTIC_COREAPI.insert_html('');

618: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
619: JTF_DIAGNOSTIC_COREAPI.BRPrint;
620:
621: sql_text:= iot1_sql(37);
622: JTF_DIAGNOSTIC_COREAPI.insert_html('');
623: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
624: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
625: JTF_DIAGNOSTIC_COREAPI.BRPrint;
626:

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

619: JTF_DIAGNOSTIC_COREAPI.BRPrint;
620:
621: sql_text:= iot1_sql(37);
622: JTF_DIAGNOSTIC_COREAPI.insert_html('');
623: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
624: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
625: JTF_DIAGNOSTIC_COREAPI.BRPrint;
626:
627:

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

620:
621: sql_text:= iot1_sql(37);
622: JTF_DIAGNOSTIC_COREAPI.insert_html('');
623: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
624: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
625: JTF_DIAGNOSTIC_COREAPI.BRPrint;
626:
627:
628: END IF;

Line 625: JTF_DIAGNOSTIC_COREAPI.BRPrint;

621: sql_text:= iot1_sql(37);
622: JTF_DIAGNOSTIC_COREAPI.insert_html('');
623: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
624: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
625: JTF_DIAGNOSTIC_COREAPI.BRPrint;
626:
627:
628: END IF;
629:

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

635: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
636:
637: EXCEPTION
638: when others then
639: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
640: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
641: statusStr := 'FAILURE';
642: errStr := sqlerrm ||' occurred in script Exception handled';
643: fixInfo := 'Unexpected Exception in INVDR01B.pls';

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

636:
637: EXCEPTION
638: when others then
639: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
640: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
641: statusStr := 'FAILURE';
642: errStr := sqlerrm ||' occurred in script Exception handled';
643: fixInfo := 'Unexpected Exception in INVDR01B.pls';
644: isFatal := 'FALSE';

APPS.INV_DIAG_RCV_IOT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

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

Line 118: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

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

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

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

Line 143: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

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

Line 156: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

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

Line 168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

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

Line 180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

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

Line 273: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid combination of data');

Line 328: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line 329: JTF_DIAGNOSTIC_COREAPI.insert_html('

Line 389: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

Receipt Information

Line 391: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Receipt Information

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

Receipt Information

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

Receipt Information

Line 394: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 401: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 404: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 407: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 411: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 414: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 418: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 421: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 425: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 428: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 431: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 434: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 437: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

Line 439: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'RCV_SUPPLY','Y','Y');

Inventory Information

Line 440: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Inventory Information

Line 443: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

Inventory Information

Line 445: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Inventory Information

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

Line 449: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 453: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 456: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 459: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 462: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 469: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

Line 476: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 479: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

Line 482: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 485: JTF_DIAGNOSTIC_COREAPI.insert_html('');