'||'
Line 306: JTF_DIAGNOSTIC_COREAPI.insert_html('RMA Information
');
302:
303:
304: IF skip_execution <> 1 THEN
305:
306: JTF_DIAGNOSTIC_COREAPI.insert_html('RMA Information
');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top]');
Line 309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
305:
306: JTF_DIAGNOSTIC_COREAPI.insert_html('
RMA Information
');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
Line 310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top]');
306: JTF_DIAGNOSTIC_COREAPI.insert_html('
RMA Information
');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
Line 311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL [Top]');
Line 315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
Line 316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL [Top]');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
Line 317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
321: sql_text := rma1_sql(3);
Line 318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
Line 323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
319:
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');
Line 324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');
328:
Line 325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');
328:
329: sql_text := rma1_sql(4);
Line 327: JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Information
');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Information
');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
Line 330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
Line 331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
327: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information
');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
Line 332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
Line 336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
Line 337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
Line 338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
Line 342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
Line 343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
Line 344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
Line 348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
Line 349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
Line 350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE ');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE ');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
Line 357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
Line 361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
Line 362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
Line 363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
367:
Line 364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
367:
368: sql_text:= rma1_sql(10);
Line 366: JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Information
');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Information
');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
Line 369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
Line 370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
366: JTF_DIAGNOSTIC_COREAPI.insert_html('
Inventory Information
');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
Line 371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
Line 375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
Line 376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
Line 377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
Line 381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
Line 382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
Line 383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
Line 387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
Line 388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
Line 389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES ');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES ');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
Line 396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP ');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP ');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
Line 403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS [Top]');
Line 407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
Line 408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS [Top]');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
Line 409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
Line 413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
Line 414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
Line 415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
Line 419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
Line 420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
Line 421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE ');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE ');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
Line 428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
Line 432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
Line 433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
Line 434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
Line 438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
Line 439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
Line 440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE [Top]');
Line 444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
Line 445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE [Top]');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
Line 446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
Line 450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
Line 451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
Line 452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS ');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS ');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
Line 459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE ');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE ');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
Line 466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
Line 470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
Line 471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
Line 472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
Line 476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
Line 477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
Line 478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
Line 482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
Line 483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
Line 484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL [Top]');
Line 488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
Line 489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL [Top]');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
Line 490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS ');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
Line 495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS ');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
Line 497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
Line 498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
502: sql_text:= rma1_sql(100);
Line 500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
496: QUERIES">[Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
Line 501: JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes
');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes
');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
Line 503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
Line 504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
Line 505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('
Lookup Codes
');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [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:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
Line 510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [Top]');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
Line 511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [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:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
Line 516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [Top]');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
Line 517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [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:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
Line 522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [Top]');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
Line 523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [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:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
Line 528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [Top]');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
Line 529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
Line 533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
Line 534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
Line 535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
Line 536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [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:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
Line 540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [Top]');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544:
Line 541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544:
545: END IF;
Line 542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544:
545: END IF;
546:
Line 557: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
553: end if;
554:
555: EXCEPTION
556: when others then
557: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
559: statusStr := 'FAILURE';
560: errStr := sqlerrm ||' occurred in script Exception handled';
561: isFatal := 'FALSE';
Line 558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
554:
555: EXCEPTION
556: when others then
557: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
559: statusStr := 'FAILURE';
560: errStr := sqlerrm ||' occurred in script Exception handled';
561: isFatal := 'FALSE';
562: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);