APPS.INV_DIAG_RCV_IO dependencies on JTF_DIAGNOSTIC_COREAPI

Line 111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

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

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

163:
164: IF (l_req_num is NULL and l_ou_id is NULL and l_line_num is NULL AND l_shipment_num is NULL AND l_receipt_num is NULL
165: AND l_org_id is NULL) THEN
166:
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 test.');
169: statusStr := 'FAILURE';
170: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
171: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

164: IF (l_req_num is NULL and l_ou_id is NULL and l_line_num is NULL AND l_shipment_num is NULL AND l_receipt_num is NULL
165: AND l_org_id is NULL) THEN
166:
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 test.');
169: statusStr := 'FAILURE';
170: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
171: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
172: return;

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

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

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

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

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

184: END IF;
185:
186: IF (l_req_num is NULL and l_ou_id is NOT NULL) THEN
187:
188: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
189: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
190: statusStr := 'FAILURE';
191: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
192: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

185:
186: IF (l_req_num is NULL and l_ou_id is NOT NULL) THEN
187:
188: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
189: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
190: statusStr := 'FAILURE';
191: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
192: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
193: return;

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

194: END IF;
195:
196: IF (l_req_num is NULL AND l_ou_id is NULL AND l_line_num IS NOT NULL) THEN
197:
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
200: statusStr := 'FAILURE';
201: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
202: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

195:
196: IF (l_req_num is NULL AND l_ou_id is NULL AND l_line_num IS NOT NULL) THEN
197:
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
200: statusStr := 'FAILURE';
201: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
202: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
203: return;

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

203: return;
204: END IF;
205:
206: IF (l_shipment_num is NOT NULL and l_org_id is NULL) THEN
207: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
208: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
209: statusStr := 'FAILURE';
210: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
211: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

204: END IF;
205:
206: IF (l_shipment_num is NOT NULL and l_org_id is NULL) THEN
207: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
208: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
209: statusStr := 'FAILURE';
210: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
211: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
212: return;

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

213: END IF;
214:
215:
216: IF (l_receipt_num is NOT NULL and l_org_id is NULL) THEN
217: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
218: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
219: statusStr := 'FAILURE';
220: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
221: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

214:
215:
216: IF (l_receipt_num is NOT NULL and l_org_id is NULL) THEN
217: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
218: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
219: statusStr := 'FAILURE';
220: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
221: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
222: return;

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

223: END IF;
224:
225:
226: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_org_id is NOT NULL) THEN
227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
228: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
229: statusStr := 'FAILURE';
230: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
231: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

224:
225:
226: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_org_id is NOT NULL) THEN
227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
228: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
229: statusStr := 'FAILURE';
230: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
231: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
232: return;

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

253: AND prl.requisition_line_id = rsl.requisition_line_id;
254:
255: IF l_count = 0 THEN
256: statusStr := 'FAILURE';
257: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
258: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
259: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
260: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
261: RETURN;

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

254:
255: IF l_count = 0 THEN
256: statusStr := 'FAILURE';
257: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
258: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
259: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
260: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
261: RETURN;
262: END IF;

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

280: AND rsh.receipt_source_code = 'INTERNAL ORDER'
281: AND prl.requisition_line_id = rsl.requisition_line_id;
282: IF l_count = 0 THEN
283: statusStr := 'FAILURE';
284: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
285: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
286: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
287: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
288: RETURN;

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

281: AND prl.requisition_line_id = rsl.requisition_line_id;
282: IF l_count = 0 THEN
283: statusStr := 'FAILURE';
284: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
285: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
286: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
287: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
288: RETURN;
289: END IF;

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

301: AND prl.line_num = l_line_num
302: AND prl.source_type_code = 'INVENTORY';
303: IF l_count = 0 THEN
304: statusStr := 'FAILURE';
305: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
306: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number,Operating unit id and Requisition line number.');
307: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
308: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
309: RETURN;

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

302: AND prl.source_type_code = 'INVENTORY';
303: IF l_count = 0 THEN
304: statusStr := 'FAILURE';
305: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
306: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number,Operating unit id and Requisition line number.');
307: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
308: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
309: RETURN;
310: END IF;

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

321: AND rsh.ship_to_org_id = l_org_id
322: AND rsh.receipt_source_code = 'INTERNAL ORDER';
323: IF l_count = 0 THEN
324: statusStr := 'FAILURE';
325: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
326: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number,Shipment number and Organization id.');
327: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
328: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
329: RETURN;

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

322: AND rsh.receipt_source_code = 'INTERNAL ORDER';
323: IF l_count = 0 THEN
324: statusStr := 'FAILURE';
325: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
326: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number,Shipment number and Organization id.');
327: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
328: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
329: RETURN;
330: END IF;

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

341: AND prh.requisition_header_id = prl.requisition_header_id
342: AND prl.source_type_code = 'INVENTORY';
343: IF l_count = 0 THEN
344: statusStr := 'FAILURE';
345: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
346: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');
347: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
348: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
349: RETURN;

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

342: AND prl.source_type_code = 'INVENTORY';
343: IF l_count = 0 THEN
344: statusStr := 'FAILURE';
345: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
346: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');
347: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
348: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
349: RETURN;
350: END IF;

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

360: AND rsh.ship_to_org_id = l_org_id
361: AND rsh.receipt_source_code = 'INTERNAL ORDER';
362: IF l_count = 0 THEN
363: statusStr := 'FAILURE';
364: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
366: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
367: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
368: RETURN;

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

361: AND rsh.receipt_source_code = 'INTERNAL ORDER';
362: IF l_count = 0 THEN
363: statusStr := 'FAILURE';
364: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
366: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
367: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
368: RETURN;
369: END IF;

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

379: AND rsh.ship_to_org_id = l_org_id
380: AND rsh.receipt_source_code = 'INTERNAL ORDER';
381: IF l_count = 0 THEN
382: statusStr := 'FAILURE';
383: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
384: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Shipment number and Organization id.');
385: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
386: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
387: RETURN;

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

380: AND rsh.receipt_source_code = 'INTERNAL ORDER';
381: IF l_count = 0 THEN
382: statusStr := 'FAILURE';
383: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
384: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Shipment number and Organization id.');
385: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
386: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
387: RETURN;
388: END IF;

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

453:
454: -----------------------------------------
455: -- Code to Build the Index of HTML tables
456: -----------------------------------------
457: JTF_DIAGNOSTIC_COREAPI.insert_html('

'||'
458: '||'
459: '||'
460: '||'
461: '||'

Line 531: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');

527:

'||'
528: '||'
529:

INDEX OF QUERIES
LOOKUP CODES

');
530:
531: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

');
532: sql_text := io1_sql(1);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS  [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 533: JTF_DIAGNOSTIC_COREAPI.insert_html('');

529: ');
530:
531: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

Line 534: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS  [Top]');

530:
531: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

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

531: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

Line 536: JTF_DIAGNOSTIC_COREAPI.BRPrint;

532: sql_text := io1_sql(1);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS  [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text := io1_sql(2);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES  [Top]');

Line 539: JTF_DIAGNOSTIC_COREAPI.insert_html('');

535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text := io1_sql(2);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:

Line 540: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES  [Top]');

536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text := io1_sql(2);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544: sql_text := io1_sql(3);

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

537:
538: sql_text := io1_sql(2);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544: sql_text := io1_sql(3);
545: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 542: JTF_DIAGNOSTIC_COREAPI.BRPrint;

538: sql_text := io1_sql(2);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544: sql_text := io1_sql(3);
545: JTF_DIAGNOSTIC_COREAPI.insert_html('');
546: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS  [Top]');

Line 545: JTF_DIAGNOSTIC_COREAPI.insert_html('');

541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544: sql_text := io1_sql(3);
545: JTF_DIAGNOSTIC_COREAPI.insert_html('');
546: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS  [Top]');
547: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
548: JTF_DIAGNOSTIC_COREAPI.BRPrint;
549:

Line 546: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS  [Top]');

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

Shipping Details

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

543:
544: sql_text := io1_sql(3);
545: JTF_DIAGNOSTIC_COREAPI.insert_html('');
546: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS  [Top]');
547: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
548: JTF_DIAGNOSTIC_COREAPI.BRPrint;
549:
550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

Line 548: JTF_DIAGNOSTIC_COREAPI.BRPrint;

544: sql_text := io1_sql(3);
545: JTF_DIAGNOSTIC_COREAPI.insert_html('');
546: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS  [Top]');
547: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
548: JTF_DIAGNOSTIC_COREAPI.BRPrint;
549:
550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

Line 550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

546: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS  [Top]');
547: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
548: JTF_DIAGNOSTIC_COREAPI.BRPrint;
549:
550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

Line 552: JTF_DIAGNOSTIC_COREAPI.insert_html('');

548: JTF_DIAGNOSTIC_COREAPI.BRPrint;
549:
550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

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

549:
550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

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

550: JTF_DIAGNOSTIC_COREAPI.insert_html('

Shipping Details

Line 555: JTF_DIAGNOSTIC_COREAPI.BRPrint;

551: sql_text := io1_sql(4);
552: JTF_DIAGNOSTIC_COREAPI.insert_html('');
553: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES  [Top]');
554: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text := io1_sql(5);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('WSH_DELIVERY_DETAILS  [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 := io1_sql(5);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('WSH_DELIVERY_DETAILS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:

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

555: JTF_DIAGNOSTIC_COREAPI.BRPrint;
556:
557: sql_text := io1_sql(5);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('WSH_DELIVERY_DETAILS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

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

556:
557: sql_text := io1_sql(5);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('WSH_DELIVERY_DETAILS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

Line 561: JTF_DIAGNOSTIC_COREAPI.BRPrint;

557: sql_text := io1_sql(5);
558: JTF_DIAGNOSTIC_COREAPI.insert_html('');
559: JTF_DIAGNOSTIC_COREAPI.insert_html('WSH_DELIVERY_DETAILS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

Line 563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

559: JTF_DIAGNOSTIC_COREAPI.insert_html('WSH_DELIVERY_DETAILS  [Top]');
560: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

Line 565: JTF_DIAGNOSTIC_COREAPI.insert_html('');

561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

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

562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

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

563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

Line 568: JTF_DIAGNOSTIC_COREAPI.BRPrint;

564: sql_text:= io1_sql(9);
565: JTF_DIAGNOSTIC_COREAPI.insert_html('');
566: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
568: JTF_DIAGNOSTIC_COREAPI.BRPrint;
569:
570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

Line 571: JTF_DIAGNOSTIC_COREAPI.insert_html('');

567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
568: JTF_DIAGNOSTIC_COREAPI.BRPrint;
569:
570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
573: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:

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

568: JTF_DIAGNOSTIC_COREAPI.BRPrint;
569:
570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
573: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:
576: sql_text := io1_sql(11);

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

569:
570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
573: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:
576: sql_text := io1_sql(11);
577: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 574: JTF_DIAGNOSTIC_COREAPI.BRPrint;

570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
573: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:
576: sql_text := io1_sql(11);
577: JTF_DIAGNOSTIC_COREAPI.insert_html('');
578: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');

Line 577: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:
576: sql_text := io1_sql(11);
577: JTF_DIAGNOSTIC_COREAPI.insert_html('');
578: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
579: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
580: JTF_DIAGNOSTIC_COREAPI.BRPrint;
581:
582: sql_text := io1_sql(12);

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

575:
576: sql_text := io1_sql(11);
577: JTF_DIAGNOSTIC_COREAPI.insert_html('');
578: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
579: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
580: JTF_DIAGNOSTIC_COREAPI.BRPrint;
581:
582: sql_text := io1_sql(12);
583: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 580: JTF_DIAGNOSTIC_COREAPI.BRPrint;

576: sql_text := io1_sql(11);
577: JTF_DIAGNOSTIC_COREAPI.insert_html('');
578: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
579: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
580: JTF_DIAGNOSTIC_COREAPI.BRPrint;
581:
582: sql_text := io1_sql(12);
583: JTF_DIAGNOSTIC_COREAPI.insert_html('');
584: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');

Line 583: JTF_DIAGNOSTIC_COREAPI.insert_html('');

579: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
580: JTF_DIAGNOSTIC_COREAPI.BRPrint;
581:
582: sql_text := io1_sql(12);
583: JTF_DIAGNOSTIC_COREAPI.insert_html('');
584: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
586: JTF_DIAGNOSTIC_COREAPI.BRPrint;
587:

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

580: JTF_DIAGNOSTIC_COREAPI.BRPrint;
581:
582: sql_text := io1_sql(12);
583: JTF_DIAGNOSTIC_COREAPI.insert_html('');
584: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
586: JTF_DIAGNOSTIC_COREAPI.BRPrint;
587:
588: sql_text:= io1_sql(13);

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

581:
582: sql_text := io1_sql(12);
583: JTF_DIAGNOSTIC_COREAPI.insert_html('');
584: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
586: JTF_DIAGNOSTIC_COREAPI.BRPrint;
587:
588: sql_text:= io1_sql(13);
589: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 586: JTF_DIAGNOSTIC_COREAPI.BRPrint;

582: sql_text := io1_sql(12);
583: JTF_DIAGNOSTIC_COREAPI.insert_html('');
584: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY  [Top]');
585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
586: JTF_DIAGNOSTIC_COREAPI.BRPrint;
587:
588: sql_text:= io1_sql(13);
589: JTF_DIAGNOSTIC_COREAPI.insert_html('');
590: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');

Line 589: JTF_DIAGNOSTIC_COREAPI.insert_html('');

585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
586: JTF_DIAGNOSTIC_COREAPI.BRPrint;
587:
588: sql_text:= io1_sql(13);
589: JTF_DIAGNOSTIC_COREAPI.insert_html('');
590: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
591: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
592: JTF_DIAGNOSTIC_COREAPI.BRPrint;
593:

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

586: JTF_DIAGNOSTIC_COREAPI.BRPrint;
587:
588: sql_text:= io1_sql(13);
589: JTF_DIAGNOSTIC_COREAPI.insert_html('');
590: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
591: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
592: JTF_DIAGNOSTIC_COREAPI.BRPrint;
593:
594: sql_text:= io1_sql(6);

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

587:
588: sql_text:= io1_sql(13);
589: JTF_DIAGNOSTIC_COREAPI.insert_html('');
590: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
591: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
592: JTF_DIAGNOSTIC_COREAPI.BRPrint;
593:
594: sql_text:= io1_sql(6);
595: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 592: JTF_DIAGNOSTIC_COREAPI.BRPrint;

588: sql_text:= io1_sql(13);
589: JTF_DIAGNOSTIC_COREAPI.insert_html('');
590: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY  [Top]');
591: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
592: JTF_DIAGNOSTIC_COREAPI.BRPrint;
593:
594: sql_text:= io1_sql(6);
595: JTF_DIAGNOSTIC_COREAPI.insert_html('');
596: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');

Line 595: JTF_DIAGNOSTIC_COREAPI.insert_html('');

591: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
592: JTF_DIAGNOSTIC_COREAPI.BRPrint;
593:
594: sql_text:= io1_sql(6);
595: JTF_DIAGNOSTIC_COREAPI.insert_html('');
596: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
597: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
598: JTF_DIAGNOSTIC_COREAPI.BRPrint;
599:

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

592: JTF_DIAGNOSTIC_COREAPI.BRPrint;
593:
594: sql_text:= io1_sql(6);
595: JTF_DIAGNOSTIC_COREAPI.insert_html('');
596: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
597: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
598: JTF_DIAGNOSTIC_COREAPI.BRPrint;
599:
600: sql_text:= io1_sql(7);

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

593:
594: sql_text:= io1_sql(6);
595: JTF_DIAGNOSTIC_COREAPI.insert_html('');
596: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
597: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
598: JTF_DIAGNOSTIC_COREAPI.BRPrint;
599:
600: sql_text:= io1_sql(7);
601: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 598: JTF_DIAGNOSTIC_COREAPI.BRPrint;

594: sql_text:= io1_sql(6);
595: JTF_DIAGNOSTIC_COREAPI.insert_html('');
596: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
597: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
598: JTF_DIAGNOSTIC_COREAPI.BRPrint;
599:
600: sql_text:= io1_sql(7);
601: JTF_DIAGNOSTIC_COREAPI.insert_html('');
602: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');

Line 601: JTF_DIAGNOSTIC_COREAPI.insert_html('');

597: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
598: JTF_DIAGNOSTIC_COREAPI.BRPrint;
599:
600: sql_text:= io1_sql(7);
601: JTF_DIAGNOSTIC_COREAPI.insert_html('');
602: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
603: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
604: JTF_DIAGNOSTIC_COREAPI.BRPrint;
605:

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

598: JTF_DIAGNOSTIC_COREAPI.BRPrint;
599:
600: sql_text:= io1_sql(7);
601: JTF_DIAGNOSTIC_COREAPI.insert_html('');
602: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
603: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
604: JTF_DIAGNOSTIC_COREAPI.BRPrint;
605:
606: sql_text:= io1_sql(8);

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

599:
600: sql_text:= io1_sql(7);
601: JTF_DIAGNOSTIC_COREAPI.insert_html('');
602: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
603: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
604: JTF_DIAGNOSTIC_COREAPI.BRPrint;
605:
606: sql_text:= io1_sql(8);
607: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 604: JTF_DIAGNOSTIC_COREAPI.BRPrint;

600: sql_text:= io1_sql(7);
601: JTF_DIAGNOSTIC_COREAPI.insert_html('');
602: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
603: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
604: JTF_DIAGNOSTIC_COREAPI.BRPrint;
605:
606: sql_text:= io1_sql(8);
607: JTF_DIAGNOSTIC_COREAPI.insert_html('');
608: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

Line 607: JTF_DIAGNOSTIC_COREAPI.insert_html('');

603: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
604: JTF_DIAGNOSTIC_COREAPI.BRPrint;
605:
606: sql_text:= io1_sql(8);
607: JTF_DIAGNOSTIC_COREAPI.insert_html('');
608: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
609: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
610: JTF_DIAGNOSTIC_COREAPI.BRPrint;
611:

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

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

Inventory Details

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

605:
606: sql_text:= io1_sql(8);
607: JTF_DIAGNOSTIC_COREAPI.insert_html('');
608: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
609: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
610: JTF_DIAGNOSTIC_COREAPI.BRPrint;
611:
612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

Line 610: JTF_DIAGNOSTIC_COREAPI.BRPrint;

606: sql_text:= io1_sql(8);
607: JTF_DIAGNOSTIC_COREAPI.insert_html('');
608: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
609: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
610: JTF_DIAGNOSTIC_COREAPI.BRPrint;
611:
612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

Line 612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

608: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
609: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
610: JTF_DIAGNOSTIC_COREAPI.BRPrint;
611:
612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

Line 614: JTF_DIAGNOSTIC_COREAPI.insert_html('');

610: JTF_DIAGNOSTIC_COREAPI.BRPrint;
611:
612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

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

611:
612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

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

612: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Details

Line 617: JTF_DIAGNOSTIC_COREAPI.BRPrint;

613: sql_text:= io1_sql(14);
614: JTF_DIAGNOSTIC_COREAPI.insert_html('');
615: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRX_REQUEST_LINES  [Top]');
616: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= io1_sql(15);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTIONS_INTERFACE  [Top]');

Line 620: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

617: JTF_DIAGNOSTIC_COREAPI.BRPrint;
618:
619: sql_text:= io1_sql(15);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTIONS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: sql_text:= io1_sql(16);

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

618:
619: sql_text:= io1_sql(15);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTIONS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: sql_text:= io1_sql(16);
626: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 623: JTF_DIAGNOSTIC_COREAPI.BRPrint;

619: sql_text:= io1_sql(15);
620: JTF_DIAGNOSTIC_COREAPI.insert_html('');
621: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTIONS_INTERFACE  [Top]');
622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: sql_text:= io1_sql(16);
626: JTF_DIAGNOSTIC_COREAPI.insert_html('');
627: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');

Line 626: JTF_DIAGNOSTIC_COREAPI.insert_html('');

622: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: sql_text:= io1_sql(16);
626: JTF_DIAGNOSTIC_COREAPI.insert_html('');
627: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
628: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
629: JTF_DIAGNOSTIC_COREAPI.BRPrint;
630:

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

623: JTF_DIAGNOSTIC_COREAPI.BRPrint;
624:
625: sql_text:= io1_sql(16);
626: JTF_DIAGNOSTIC_COREAPI.insert_html('');
627: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
628: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
629: JTF_DIAGNOSTIC_COREAPI.BRPrint;
630:
631: sql_text:= io1_sql(17);

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

624:
625: sql_text:= io1_sql(16);
626: JTF_DIAGNOSTIC_COREAPI.insert_html('');
627: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
628: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
629: JTF_DIAGNOSTIC_COREAPI.BRPrint;
630:
631: sql_text:= io1_sql(17);
632: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 629: JTF_DIAGNOSTIC_COREAPI.BRPrint;

625: sql_text:= io1_sql(16);
626: JTF_DIAGNOSTIC_COREAPI.insert_html('');
627: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
628: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
629: JTF_DIAGNOSTIC_COREAPI.BRPrint;
630:
631: sql_text:= io1_sql(17);
632: JTF_DIAGNOSTIC_COREAPI.insert_html('');
633: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');

Line 632: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

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

629: JTF_DIAGNOSTIC_COREAPI.BRPrint;
630:
631: sql_text:= io1_sql(17);
632: JTF_DIAGNOSTIC_COREAPI.insert_html('');
633: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= io1_sql(18);

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

630:
631: sql_text:= io1_sql(17);
632: JTF_DIAGNOSTIC_COREAPI.insert_html('');
633: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= io1_sql(18);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 635: JTF_DIAGNOSTIC_COREAPI.BRPrint;

631: sql_text:= io1_sql(17);
632: JTF_DIAGNOSTIC_COREAPI.insert_html('');
633: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= io1_sql(18);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('');
639: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_RESERVATIONS  [Top]');

Line 638: JTF_DIAGNOSTIC_COREAPI.insert_html('');

634: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= io1_sql(18);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('');
639: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_RESERVATIONS  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:

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

635: JTF_DIAGNOSTIC_COREAPI.BRPrint;
636:
637: sql_text:= io1_sql(18);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('');
639: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_RESERVATIONS  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= io1_sql(19);

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

636:
637: sql_text:= io1_sql(18);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('');
639: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_RESERVATIONS  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= io1_sql(19);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 641: JTF_DIAGNOSTIC_COREAPI.BRPrint;

637: sql_text:= io1_sql(18);
638: JTF_DIAGNOSTIC_COREAPI.insert_html('');
639: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_RESERVATIONS  [Top]');
640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= io1_sql(19);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('');
645: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_DEMAND  [Top]');

Line 644: JTF_DIAGNOSTIC_COREAPI.insert_html('');

640: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= io1_sql(19);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('');
645: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_DEMAND  [Top]');
646: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
647: JTF_DIAGNOSTIC_COREAPI.BRPrint;
648:

Line 645: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_DEMAND  [Top]');

641: JTF_DIAGNOSTIC_COREAPI.BRPrint;
642:
643: sql_text:= io1_sql(19);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('');
645: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_DEMAND  [Top]');
646: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
647: JTF_DIAGNOSTIC_COREAPI.BRPrint;
648:
649: sql_text:= io1_sql(34);

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

642:
643: sql_text:= io1_sql(19);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('');
645: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_DEMAND  [Top]');
646: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
647: JTF_DIAGNOSTIC_COREAPI.BRPrint;
648:
649: sql_text:= io1_sql(34);
650: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 647: JTF_DIAGNOSTIC_COREAPI.BRPrint;

643: sql_text:= io1_sql(19);
644: JTF_DIAGNOSTIC_COREAPI.insert_html('');
645: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_DEMAND  [Top]');
646: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
647: JTF_DIAGNOSTIC_COREAPI.BRPrint;
648:
649: sql_text:= io1_sql(34);
650: JTF_DIAGNOSTIC_COREAPI.insert_html('');
651: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');

Line 650: JTF_DIAGNOSTIC_COREAPI.insert_html('');

646: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
647: JTF_DIAGNOSTIC_COREAPI.BRPrint;
648:
649: sql_text:= io1_sql(34);
650: JTF_DIAGNOSTIC_COREAPI.insert_html('');
651: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
652: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
653: JTF_DIAGNOSTIC_COREAPI.BRPrint;
654:

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

647: JTF_DIAGNOSTIC_COREAPI.BRPrint;
648:
649: sql_text:= io1_sql(34);
650: JTF_DIAGNOSTIC_COREAPI.insert_html('');
651: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
652: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
653: JTF_DIAGNOSTIC_COREAPI.BRPrint;
654:
655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

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

648:
649: sql_text:= io1_sql(34);
650: JTF_DIAGNOSTIC_COREAPI.insert_html('');
651: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
652: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
653: JTF_DIAGNOSTIC_COREAPI.BRPrint;
654:
655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

Line 653: JTF_DIAGNOSTIC_COREAPI.BRPrint;

649: sql_text:= io1_sql(34);
650: JTF_DIAGNOSTIC_COREAPI.insert_html('');
651: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
652: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
653: JTF_DIAGNOSTIC_COREAPI.BRPrint;
654:
655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

Line 655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

651: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
652: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
653: JTF_DIAGNOSTIC_COREAPI.BRPrint;
654:
655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

Line 657: JTF_DIAGNOSTIC_COREAPI.insert_html('');

653: JTF_DIAGNOSTIC_COREAPI.BRPrint;
654:
655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

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

654:
655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

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

655: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lot and Serial Transaction Details

Line 660: JTF_DIAGNOSTIC_COREAPI.BRPrint;

656: sql_text:= io1_sql(20);
657: JTF_DIAGNOSTIC_COREAPI.insert_html('');
658: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
660: JTF_DIAGNOSTIC_COREAPI.BRPrint;
661:
662: sql_text:= io1_sql(21);
663: JTF_DIAGNOSTIC_COREAPI.insert_html('');
664: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

Line 663: JTF_DIAGNOSTIC_COREAPI.insert_html('');

659: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
660: JTF_DIAGNOSTIC_COREAPI.BRPrint;
661:
662: sql_text:= io1_sql(21);
663: JTF_DIAGNOSTIC_COREAPI.insert_html('');
664: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:

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

660: JTF_DIAGNOSTIC_COREAPI.BRPrint;
661:
662: sql_text:= io1_sql(21);
663: JTF_DIAGNOSTIC_COREAPI.insert_html('');
664: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= io1_sql(22);

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

661:
662: sql_text:= io1_sql(21);
663: JTF_DIAGNOSTIC_COREAPI.insert_html('');
664: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= io1_sql(22);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 666: JTF_DIAGNOSTIC_COREAPI.BRPrint;

662: sql_text:= io1_sql(21);
663: JTF_DIAGNOSTIC_COREAPI.insert_html('');
664: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= io1_sql(22);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('');
670: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');

Line 669: JTF_DIAGNOSTIC_COREAPI.insert_html('');

665: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= io1_sql(22);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('');
670: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
671: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
672: JTF_DIAGNOSTIC_COREAPI.BRPrint;
673:

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

666: JTF_DIAGNOSTIC_COREAPI.BRPrint;
667:
668: sql_text:= io1_sql(22);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('');
670: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
671: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
672: JTF_DIAGNOSTIC_COREAPI.BRPrint;
673:
674: sql_text:= io1_sql(23);

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

667:
668: sql_text:= io1_sql(22);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('');
670: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
671: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
672: JTF_DIAGNOSTIC_COREAPI.BRPrint;
673:
674: sql_text:= io1_sql(23);
675: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 672: JTF_DIAGNOSTIC_COREAPI.BRPrint;

668: sql_text:= io1_sql(22);
669: JTF_DIAGNOSTIC_COREAPI.insert_html('');
670: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
671: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
672: JTF_DIAGNOSTIC_COREAPI.BRPrint;
673:
674: sql_text:= io1_sql(23);
675: JTF_DIAGNOSTIC_COREAPI.insert_html('');
676: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

Line 675: JTF_DIAGNOSTIC_COREAPI.insert_html('');

671: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
672: JTF_DIAGNOSTIC_COREAPI.BRPrint;
673:
674: sql_text:= io1_sql(23);
675: JTF_DIAGNOSTIC_COREAPI.insert_html('');
676: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
677: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
678: JTF_DIAGNOSTIC_COREAPI.BRPrint;
679:

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

672: JTF_DIAGNOSTIC_COREAPI.BRPrint;
673:
674: sql_text:= io1_sql(23);
675: JTF_DIAGNOSTIC_COREAPI.insert_html('');
676: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
677: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
678: JTF_DIAGNOSTIC_COREAPI.BRPrint;
679:
680: sql_text:= io1_sql(24);

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

673:
674: sql_text:= io1_sql(23);
675: JTF_DIAGNOSTIC_COREAPI.insert_html('');
676: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
677: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
678: JTF_DIAGNOSTIC_COREAPI.BRPrint;
679:
680: sql_text:= io1_sql(24);
681: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 678: JTF_DIAGNOSTIC_COREAPI.BRPrint;

674: sql_text:= io1_sql(23);
675: JTF_DIAGNOSTIC_COREAPI.insert_html('');
676: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
677: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
678: JTF_DIAGNOSTIC_COREAPI.BRPrint;
679:
680: sql_text:= io1_sql(24);
681: JTF_DIAGNOSTIC_COREAPI.insert_html('');
682: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');

Line 681: JTF_DIAGNOSTIC_COREAPI.insert_html('');

677: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
678: JTF_DIAGNOSTIC_COREAPI.BRPrint;
679:
680: sql_text:= io1_sql(24);
681: JTF_DIAGNOSTIC_COREAPI.insert_html('');
682: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
683: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
684: JTF_DIAGNOSTIC_COREAPI.BRPrint;
685:

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

678: JTF_DIAGNOSTIC_COREAPI.BRPrint;
679:
680: sql_text:= io1_sql(24);
681: JTF_DIAGNOSTIC_COREAPI.insert_html('');
682: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
683: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
684: JTF_DIAGNOSTIC_COREAPI.BRPrint;
685:
686: sql_text:= io1_sql(25);

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

679:
680: sql_text:= io1_sql(24);
681: JTF_DIAGNOSTIC_COREAPI.insert_html('');
682: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
683: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
684: JTF_DIAGNOSTIC_COREAPI.BRPrint;
685:
686: sql_text:= io1_sql(25);
687: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 684: JTF_DIAGNOSTIC_COREAPI.BRPrint;

680: sql_text:= io1_sql(24);
681: JTF_DIAGNOSTIC_COREAPI.insert_html('');
682: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_SUPPLY  [Top]');
683: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
684: JTF_DIAGNOSTIC_COREAPI.BRPrint;
685:
686: sql_text:= io1_sql(25);
687: JTF_DIAGNOSTIC_COREAPI.insert_html('');
688: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

Line 687: JTF_DIAGNOSTIC_COREAPI.insert_html('');

683: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
684: JTF_DIAGNOSTIC_COREAPI.BRPrint;
685:
686: sql_text:= io1_sql(25);
687: JTF_DIAGNOSTIC_COREAPI.insert_html('');
688: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
690: JTF_DIAGNOSTIC_COREAPI.BRPrint;
691:

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

684: JTF_DIAGNOSTIC_COREAPI.BRPrint;
685:
686: sql_text:= io1_sql(25);
687: JTF_DIAGNOSTIC_COREAPI.insert_html('');
688: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
690: JTF_DIAGNOSTIC_COREAPI.BRPrint;
691:
692: sql_text:= io1_sql(26);

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

685:
686: sql_text:= io1_sql(25);
687: JTF_DIAGNOSTIC_COREAPI.insert_html('');
688: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
690: JTF_DIAGNOSTIC_COREAPI.BRPrint;
691:
692: sql_text:= io1_sql(26);
693: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 690: JTF_DIAGNOSTIC_COREAPI.BRPrint;

686: sql_text:= io1_sql(25);
687: JTF_DIAGNOSTIC_COREAPI.insert_html('');
688: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
690: JTF_DIAGNOSTIC_COREAPI.BRPrint;
691:
692: sql_text:= io1_sql(26);
693: JTF_DIAGNOSTIC_COREAPI.insert_html('');
694: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');

Line 693: JTF_DIAGNOSTIC_COREAPI.insert_html('');

689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
690: JTF_DIAGNOSTIC_COREAPI.BRPrint;
691:
692: sql_text:= io1_sql(26);
693: JTF_DIAGNOSTIC_COREAPI.insert_html('');
694: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
695: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
696: JTF_DIAGNOSTIC_COREAPI.BRPrint;
697:

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

690: JTF_DIAGNOSTIC_COREAPI.BRPrint;
691:
692: sql_text:= io1_sql(26);
693: JTF_DIAGNOSTIC_COREAPI.insert_html('');
694: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
695: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
696: JTF_DIAGNOSTIC_COREAPI.BRPrint;
697:
698: sql_text:= io1_sql(27);

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

691:
692: sql_text:= io1_sql(26);
693: JTF_DIAGNOSTIC_COREAPI.insert_html('');
694: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
695: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
696: JTF_DIAGNOSTIC_COREAPI.BRPrint;
697:
698: sql_text:= io1_sql(27);
699: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 696: JTF_DIAGNOSTIC_COREAPI.BRPrint;

692: sql_text:= io1_sql(26);
693: JTF_DIAGNOSTIC_COREAPI.insert_html('');
694: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE  [Top]');
695: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
696: JTF_DIAGNOSTIC_COREAPI.BRPrint;
697:
698: sql_text:= io1_sql(27);
699: JTF_DIAGNOSTIC_COREAPI.insert_html('');
700: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

Line 699: JTF_DIAGNOSTIC_COREAPI.insert_html('');

695: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
696: JTF_DIAGNOSTIC_COREAPI.BRPrint;
697:
698: sql_text:= io1_sql(27);
699: JTF_DIAGNOSTIC_COREAPI.insert_html('');
700: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
701: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
702: JTF_DIAGNOSTIC_COREAPI.BRPrint;
703:

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

696: JTF_DIAGNOSTIC_COREAPI.BRPrint;
697:
698: sql_text:= io1_sql(27);
699: JTF_DIAGNOSTIC_COREAPI.insert_html('');
700: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
701: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
702: JTF_DIAGNOSTIC_COREAPI.BRPrint;
703:
704: sql_text:= io1_sql(28);

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

697:
698: sql_text:= io1_sql(27);
699: JTF_DIAGNOSTIC_COREAPI.insert_html('');
700: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
701: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
702: JTF_DIAGNOSTIC_COREAPI.BRPrint;
703:
704: sql_text:= io1_sql(28);
705: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 702: JTF_DIAGNOSTIC_COREAPI.BRPrint;

698: sql_text:= io1_sql(27);
699: JTF_DIAGNOSTIC_COREAPI.insert_html('');
700: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
701: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
702: JTF_DIAGNOSTIC_COREAPI.BRPrint;
703:
704: sql_text:= io1_sql(28);
705: JTF_DIAGNOSTIC_COREAPI.insert_html('');
706: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');

Line 705: JTF_DIAGNOSTIC_COREAPI.insert_html('');

701: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
702: JTF_DIAGNOSTIC_COREAPI.BRPrint;
703:
704: sql_text:= io1_sql(28);
705: JTF_DIAGNOSTIC_COREAPI.insert_html('');
706: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
707: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
708: JTF_DIAGNOSTIC_COREAPI.BRPrint;
709:

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

702: JTF_DIAGNOSTIC_COREAPI.BRPrint;
703:
704: sql_text:= io1_sql(28);
705: JTF_DIAGNOSTIC_COREAPI.insert_html('');
706: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
707: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
708: JTF_DIAGNOSTIC_COREAPI.BRPrint;
709:
710: sql_text:= io1_sql(29);

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

703:
704: sql_text:= io1_sql(28);
705: JTF_DIAGNOSTIC_COREAPI.insert_html('');
706: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
707: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
708: JTF_DIAGNOSTIC_COREAPI.BRPrint;
709:
710: sql_text:= io1_sql(29);
711: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 708: JTF_DIAGNOSTIC_COREAPI.BRPrint;

704: sql_text:= io1_sql(28);
705: JTF_DIAGNOSTIC_COREAPI.insert_html('');
706: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
707: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
708: JTF_DIAGNOSTIC_COREAPI.BRPrint;
709:
710: sql_text:= io1_sql(29);
711: JTF_DIAGNOSTIC_COREAPI.insert_html('');
712: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');

Line 711: JTF_DIAGNOSTIC_COREAPI.insert_html('');

707: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
708: JTF_DIAGNOSTIC_COREAPI.BRPrint;
709:
710: sql_text:= io1_sql(29);
711: JTF_DIAGNOSTIC_COREAPI.insert_html('');
712: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
713: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
714: JTF_DIAGNOSTIC_COREAPI.BRPrint;
715:

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

708: JTF_DIAGNOSTIC_COREAPI.BRPrint;
709:
710: sql_text:= io1_sql(29);
711: JTF_DIAGNOSTIC_COREAPI.insert_html('');
712: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
713: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
714: JTF_DIAGNOSTIC_COREAPI.BRPrint;
715:
716: sql_text:= io1_sql(30);

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

709:
710: sql_text:= io1_sql(29);
711: JTF_DIAGNOSTIC_COREAPI.insert_html('');
712: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
713: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
714: JTF_DIAGNOSTIC_COREAPI.BRPrint;
715:
716: sql_text:= io1_sql(30);
717: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 714: JTF_DIAGNOSTIC_COREAPI.BRPrint;

710: sql_text:= io1_sql(29);
711: JTF_DIAGNOSTIC_COREAPI.insert_html('');
712: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_INTERFACE  [Top]');
713: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
714: JTF_DIAGNOSTIC_COREAPI.BRPrint;
715:
716: sql_text:= io1_sql(30);
717: JTF_DIAGNOSTIC_COREAPI.insert_html('');
718: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

Line 717: JTF_DIAGNOSTIC_COREAPI.insert_html('');

713: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
714: JTF_DIAGNOSTIC_COREAPI.BRPrint;
715:
716: sql_text:= io1_sql(30);
717: JTF_DIAGNOSTIC_COREAPI.insert_html('');
718: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
719: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
720: JTF_DIAGNOSTIC_COREAPI.BRPrint;
721:

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

714: JTF_DIAGNOSTIC_COREAPI.BRPrint;
715:
716: sql_text:= io1_sql(30);
717: JTF_DIAGNOSTIC_COREAPI.insert_html('');
718: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
719: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
720: JTF_DIAGNOSTIC_COREAPI.BRPrint;
721:
722: sql_text:= io1_sql(31);

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

715:
716: sql_text:= io1_sql(30);
717: JTF_DIAGNOSTIC_COREAPI.insert_html('');
718: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
719: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
720: JTF_DIAGNOSTIC_COREAPI.BRPrint;
721:
722: sql_text:= io1_sql(31);
723: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 720: JTF_DIAGNOSTIC_COREAPI.BRPrint;

716: sql_text:= io1_sql(30);
717: JTF_DIAGNOSTIC_COREAPI.insert_html('');
718: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
719: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
720: JTF_DIAGNOSTIC_COREAPI.BRPrint;
721:
722: sql_text:= io1_sql(31);
723: JTF_DIAGNOSTIC_COREAPI.insert_html('');
724: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');

Line 723: JTF_DIAGNOSTIC_COREAPI.insert_html('');

719: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
720: JTF_DIAGNOSTIC_COREAPI.BRPrint;
721:
722: sql_text:= io1_sql(31);
723: JTF_DIAGNOSTIC_COREAPI.insert_html('');
724: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
725: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
726: JTF_DIAGNOSTIC_COREAPI.BRPrint;
727:

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

720: JTF_DIAGNOSTIC_COREAPI.BRPrint;
721:
722: sql_text:= io1_sql(31);
723: JTF_DIAGNOSTIC_COREAPI.insert_html('');
724: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
725: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
726: JTF_DIAGNOSTIC_COREAPI.BRPrint;
727:
728: sql_text:= io1_sql(32);

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

721:
722: sql_text:= io1_sql(31);
723: JTF_DIAGNOSTIC_COREAPI.insert_html('');
724: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
725: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
726: JTF_DIAGNOSTIC_COREAPI.BRPrint;
727:
728: sql_text:= io1_sql(32);
729: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 726: JTF_DIAGNOSTIC_COREAPI.BRPrint;

722: sql_text:= io1_sql(31);
723: JTF_DIAGNOSTIC_COREAPI.insert_html('');
724: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY  [Top]');
725: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
726: JTF_DIAGNOSTIC_COREAPI.BRPrint;
727:
728: sql_text:= io1_sql(32);
729: JTF_DIAGNOSTIC_COREAPI.insert_html('');
730: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

Line 729: JTF_DIAGNOSTIC_COREAPI.insert_html('');

725: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
726: JTF_DIAGNOSTIC_COREAPI.BRPrint;
727:
728: sql_text:= io1_sql(32);
729: JTF_DIAGNOSTIC_COREAPI.insert_html('');
730: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
731: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
732: JTF_DIAGNOSTIC_COREAPI.BRPrint;
733:

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

726: JTF_DIAGNOSTIC_COREAPI.BRPrint;
727:
728: sql_text:= io1_sql(32);
729: JTF_DIAGNOSTIC_COREAPI.insert_html('');
730: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
731: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
732: JTF_DIAGNOSTIC_COREAPI.BRPrint;
733:
734: sql_text:= io1_sql(33);

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

727:
728: sql_text:= io1_sql(32);
729: JTF_DIAGNOSTIC_COREAPI.insert_html('');
730: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
731: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
732: JTF_DIAGNOSTIC_COREAPI.BRPrint;
733:
734: sql_text:= io1_sql(33);
735: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 732: JTF_DIAGNOSTIC_COREAPI.BRPrint;

728: sql_text:= io1_sql(32);
729: JTF_DIAGNOSTIC_COREAPI.insert_html('');
730: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
731: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
732: JTF_DIAGNOSTIC_COREAPI.BRPrint;
733:
734: sql_text:= io1_sql(33);
735: JTF_DIAGNOSTIC_COREAPI.insert_html('');
736: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');

Line 735: JTF_DIAGNOSTIC_COREAPI.insert_html('');

731: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
732: JTF_DIAGNOSTIC_COREAPI.BRPrint;
733:
734: sql_text:= io1_sql(33);
735: JTF_DIAGNOSTIC_COREAPI.insert_html('');
736: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
738: JTF_DIAGNOSTIC_COREAPI.BRPrint;
739:

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

732: JTF_DIAGNOSTIC_COREAPI.BRPrint;
733:
734: sql_text:= io1_sql(33);
735: JTF_DIAGNOSTIC_COREAPI.insert_html('');
736: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
738: JTF_DIAGNOSTIC_COREAPI.BRPrint;
739:
740: sql_text:= io1_sql(35);

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

733:
734: sql_text:= io1_sql(33);
735: JTF_DIAGNOSTIC_COREAPI.insert_html('');
736: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
738: JTF_DIAGNOSTIC_COREAPI.BRPrint;
739:
740: sql_text:= io1_sql(35);
741: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 738: JTF_DIAGNOSTIC_COREAPI.BRPrint;

734: sql_text:= io1_sql(33);
735: JTF_DIAGNOSTIC_COREAPI.insert_html('');
736: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE  [Top]');
737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
738: JTF_DIAGNOSTIC_COREAPI.BRPrint;
739:
740: sql_text:= io1_sql(35);
741: JTF_DIAGNOSTIC_COREAPI.insert_html('');
742: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

Line 741: JTF_DIAGNOSTIC_COREAPI.insert_html('');

737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
738: JTF_DIAGNOSTIC_COREAPI.BRPrint;
739:
740: sql_text:= io1_sql(35);
741: JTF_DIAGNOSTIC_COREAPI.insert_html('');
742: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
743: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
744: JTF_DIAGNOSTIC_COREAPI.BRPrint;
745:

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

738: JTF_DIAGNOSTIC_COREAPI.BRPrint;
739:
740: sql_text:= io1_sql(35);
741: JTF_DIAGNOSTIC_COREAPI.insert_html('');
742: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
743: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
744: JTF_DIAGNOSTIC_COREAPI.BRPrint;
745:
746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

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

739:
740: sql_text:= io1_sql(35);
741: JTF_DIAGNOSTIC_COREAPI.insert_html('');
742: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
743: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
744: JTF_DIAGNOSTIC_COREAPI.BRPrint;
745:
746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

Line 744: JTF_DIAGNOSTIC_COREAPI.BRPrint;

740: sql_text:= io1_sql(35);
741: JTF_DIAGNOSTIC_COREAPI.insert_html('');
742: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
743: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
744: JTF_DIAGNOSTIC_COREAPI.BRPrint;
745:
746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

Line 746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

742: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
743: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
744: JTF_DIAGNOSTIC_COREAPI.BRPrint;
745:
746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

Line 748: JTF_DIAGNOSTIC_COREAPI.insert_html('');

744: JTF_DIAGNOSTIC_COREAPI.BRPrint;
745:
746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

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

745:
746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

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

746: JTF_DIAGNOSTIC_COREAPI.insert_html('

Organization Setup Details

Line 751: JTF_DIAGNOSTIC_COREAPI.BRPrint;

747: sql_text:= io1_sql(36);
748: JTF_DIAGNOSTIC_COREAPI.insert_html('');
749: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS  [Top]');
750: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
751: JTF_DIAGNOSTIC_COREAPI.BRPrint;
752:
753: sql_text:= io1_sql(37);
754: JTF_DIAGNOSTIC_COREAPI.insert_html('');
755: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');

Line 754: JTF_DIAGNOSTIC_COREAPI.insert_html('');

750: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
751: JTF_DIAGNOSTIC_COREAPI.BRPrint;
752:
753: sql_text:= io1_sql(37);
754: JTF_DIAGNOSTIC_COREAPI.insert_html('');
755: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
756: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
757: JTF_DIAGNOSTIC_COREAPI.BRPrint;
758:

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

751: JTF_DIAGNOSTIC_COREAPI.BRPrint;
752:
753: sql_text:= io1_sql(37);
754: JTF_DIAGNOSTIC_COREAPI.insert_html('');
755: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
756: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
757: JTF_DIAGNOSTIC_COREAPI.BRPrint;
758:
759: sql_text:= io1_sql(38);

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

752:
753: sql_text:= io1_sql(37);
754: JTF_DIAGNOSTIC_COREAPI.insert_html('');
755: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
756: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
757: JTF_DIAGNOSTIC_COREAPI.BRPrint;
758:
759: sql_text:= io1_sql(38);
760: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 757: JTF_DIAGNOSTIC_COREAPI.BRPrint;

753: sql_text:= io1_sql(37);
754: JTF_DIAGNOSTIC_COREAPI.insert_html('');
755: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
756: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
757: JTF_DIAGNOSTIC_COREAPI.BRPrint;
758:
759: sql_text:= io1_sql(38);
760: JTF_DIAGNOSTIC_COREAPI.insert_html('');
761: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');

Line 760: JTF_DIAGNOSTIC_COREAPI.insert_html('');

756: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
757: JTF_DIAGNOSTIC_COREAPI.BRPrint;
758:
759: sql_text:= io1_sql(38);
760: JTF_DIAGNOSTIC_COREAPI.insert_html('');
761: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
762: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
763: JTF_DIAGNOSTIC_COREAPI.BRPrint;
764:

Line 761: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');

757: JTF_DIAGNOSTIC_COREAPI.BRPrint;
758:
759: sql_text:= io1_sql(38);
760: JTF_DIAGNOSTIC_COREAPI.insert_html('');
761: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
762: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
763: JTF_DIAGNOSTIC_COREAPI.BRPrint;
764:
765: sql_text:= io1_sql(39);

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

758:
759: sql_text:= io1_sql(38);
760: JTF_DIAGNOSTIC_COREAPI.insert_html('');
761: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
762: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
763: JTF_DIAGNOSTIC_COREAPI.BRPrint;
764:
765: sql_text:= io1_sql(39);
766: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 763: JTF_DIAGNOSTIC_COREAPI.BRPrint;

759: sql_text:= io1_sql(38);
760: JTF_DIAGNOSTIC_COREAPI.insert_html('');
761: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS  [Top]');
762: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
763: JTF_DIAGNOSTIC_COREAPI.BRPrint;
764:
765: sql_text:= io1_sql(39);
766: JTF_DIAGNOSTIC_COREAPI.insert_html('');
767: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');

Line 766: JTF_DIAGNOSTIC_COREAPI.insert_html('');

762: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
763: JTF_DIAGNOSTIC_COREAPI.BRPrint;
764:
765: sql_text:= io1_sql(39);
766: JTF_DIAGNOSTIC_COREAPI.insert_html('');
767: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
768: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
769: JTF_DIAGNOSTIC_COREAPI.BRPrint;
770:

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

763: JTF_DIAGNOSTIC_COREAPI.BRPrint;
764:
765: sql_text:= io1_sql(39);
766: JTF_DIAGNOSTIC_COREAPI.insert_html('');
767: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
768: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
769: JTF_DIAGNOSTIC_COREAPI.BRPrint;
770:
771: JTF_DIAGNOSTIC_COREAPI.insert_html('');

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

764:
765: sql_text:= io1_sql(39);
766: JTF_DIAGNOSTIC_COREAPI.insert_html('');
767: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
768: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
769: JTF_DIAGNOSTIC_COREAPI.BRPrint;
770:
771: JTF_DIAGNOSTIC_COREAPI.insert_html('');
772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

Line 769: JTF_DIAGNOSTIC_COREAPI.BRPrint;

765: sql_text:= io1_sql(39);
766: JTF_DIAGNOSTIC_COREAPI.insert_html('');
767: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
768: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
769: JTF_DIAGNOSTIC_COREAPI.BRPrint;
770:
771: JTF_DIAGNOSTIC_COREAPI.insert_html('');
772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

Line 771: JTF_DIAGNOSTIC_COREAPI.insert_html('');

767: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
768: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
769: JTF_DIAGNOSTIC_COREAPI.BRPrint;
770:
771: JTF_DIAGNOSTIC_COREAPI.insert_html('');
772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

Line 772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

768: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
769: JTF_DIAGNOSTIC_COREAPI.BRPrint;
770:
771: JTF_DIAGNOSTIC_COREAPI.insert_html('');
772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

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

770:
771: JTF_DIAGNOSTIC_COREAPI.insert_html('');
772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

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

771: JTF_DIAGNOSTIC_COREAPI.insert_html('');
772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

Line 776: JTF_DIAGNOSTIC_COREAPI.BRPrint;

772: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

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

775: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
776: JTF_DIAGNOSTIC_COREAPI.BRPrint;
777:
778: sql_text:= io1_sql(41);
779: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
780: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
781: JTF_DIAGNOSTIC_COREAPI.BRPrint;
782:
783: sql_text:= io1_sql(42);

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

776: JTF_DIAGNOSTIC_COREAPI.BRPrint;
777:
778: sql_text:= io1_sql(41);
779: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
780: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
781: JTF_DIAGNOSTIC_COREAPI.BRPrint;
782:
783: sql_text:= io1_sql(42);
784: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

Line 781: JTF_DIAGNOSTIC_COREAPI.BRPrint;

777:
778: sql_text:= io1_sql(41);
779: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
780: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
781: JTF_DIAGNOSTIC_COREAPI.BRPrint;
782:
783: sql_text:= io1_sql(42);
784: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
785: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

780: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
781: JTF_DIAGNOSTIC_COREAPI.BRPrint;
782:
783: sql_text:= io1_sql(42);
784: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
785: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
786: JTF_DIAGNOSTIC_COREAPI.BRPrint;
787:
788: sql_text:= io1_sql(43);

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

781: JTF_DIAGNOSTIC_COREAPI.BRPrint;
782:
783: sql_text:= io1_sql(42);
784: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
785: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
786: JTF_DIAGNOSTIC_COREAPI.BRPrint;
787:
788: sql_text:= io1_sql(43);
789: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

Line 786: JTF_DIAGNOSTIC_COREAPI.BRPrint;

782:
783: sql_text:= io1_sql(42);
784: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
785: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
786: JTF_DIAGNOSTIC_COREAPI.BRPrint;
787:
788: sql_text:= io1_sql(43);
789: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
790: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

785: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
786: JTF_DIAGNOSTIC_COREAPI.BRPrint;
787:
788: sql_text:= io1_sql(43);
789: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
790: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
791: JTF_DIAGNOSTIC_COREAPI.BRPrint;
792:
793: sql_text:= io1_sql(44);

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

786: JTF_DIAGNOSTIC_COREAPI.BRPrint;
787:
788: sql_text:= io1_sql(43);
789: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
790: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
791: JTF_DIAGNOSTIC_COREAPI.BRPrint;
792:
793: sql_text:= io1_sql(44);
794: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

Line 791: JTF_DIAGNOSTIC_COREAPI.BRPrint;

787:
788: sql_text:= io1_sql(43);
789: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
790: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
791: JTF_DIAGNOSTIC_COREAPI.BRPrint;
792:
793: sql_text:= io1_sql(44);
794: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

790: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
791: JTF_DIAGNOSTIC_COREAPI.BRPrint;
792:
793: sql_text:= io1_sql(44);
794: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
796: JTF_DIAGNOSTIC_COREAPI.BRPrint;
797:
798: sql_text:= io1_sql(45);

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

791: JTF_DIAGNOSTIC_COREAPI.BRPrint;
792:
793: sql_text:= io1_sql(44);
794: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
796: JTF_DIAGNOSTIC_COREAPI.BRPrint;
797:
798: sql_text:= io1_sql(45);
799: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

Line 796: JTF_DIAGNOSTIC_COREAPI.BRPrint;

792:
793: sql_text:= io1_sql(44);
794: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
796: JTF_DIAGNOSTIC_COREAPI.BRPrint;
797:
798: sql_text:= io1_sql(45);
799: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
800: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
796: JTF_DIAGNOSTIC_COREAPI.BRPrint;
797:
798: sql_text:= io1_sql(45);
799: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
800: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
801: JTF_DIAGNOSTIC_COREAPI.BRPrint;
802:
803: sql_text:= io1_sql(46);

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

796: JTF_DIAGNOSTIC_COREAPI.BRPrint;
797:
798: sql_text:= io1_sql(45);
799: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
800: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
801: JTF_DIAGNOSTIC_COREAPI.BRPrint;
802:
803: sql_text:= io1_sql(46);
804: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

Line 801: JTF_DIAGNOSTIC_COREAPI.BRPrint;

797:
798: sql_text:= io1_sql(45);
799: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
800: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
801: JTF_DIAGNOSTIC_COREAPI.BRPrint;
802:
803: sql_text:= io1_sql(46);
804: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
805: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

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

800: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
801: JTF_DIAGNOSTIC_COREAPI.BRPrint;
802:
803: sql_text:= io1_sql(46);
804: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
805: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
806: JTF_DIAGNOSTIC_COREAPI.BRPrint;
807: END IF;
808:

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

801: JTF_DIAGNOSTIC_COREAPI.BRPrint;
802:
803: sql_text:= io1_sql(46);
804: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
805: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
806: JTF_DIAGNOSTIC_COREAPI.BRPrint;
807: END IF;
808:
809:

Line 806: JTF_DIAGNOSTIC_COREAPI.BRPrint;

802:
803: sql_text:= io1_sql(46);
804: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
805: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
806: JTF_DIAGNOSTIC_COREAPI.BRPrint;
807: END IF;
808:
809:
810: statusStr := 'SUCCESS';

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

814:
815:
816: EXCEPTION
817: when others then
818: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
819: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
820: statusStr := 'FAILURE';
821: errStr := sqlerrm ||' occurred in script Exception handled';
822: fixInfo := 'Unexpected Exception in INVDR01B.pls';

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

815:
816: EXCEPTION
817: when others then
818: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
819: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
820: statusStr := 'FAILURE';
821: errStr := sqlerrm ||' occurred in script Exception handled';
822: fixInfo := 'Unexpected Exception in INVDR01B.pls';
823: isFatal := 'FALSE';