[Home] [Help]
81: if p_wip_entity_id is not null then
82: sqltxt :=sqltxt||' and b.wip_entity_id = '|| p_wip_entity_id;
83: end if;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
86: 'JOB HEADER ( WIP DISCRETE JOBS , WIP ENTITIES )',null,'Y',row_limit);
87:
88: IF (dummy_num = row_limit) THEN
89: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
86: 'JOB HEADER ( WIP DISCRETE JOBS , WIP ENTITIES )',null,'Y',row_limit);
87:
88: IF (dummy_num = row_limit) THEN
89: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
90: END IF;
91:
92: sqltxt :=
93: 'select a.operation_seq_num, ' ||
128: sqltxt :=sqltxt||' and b.wip_entity_id = '|| p_wip_entity_id;
129: sqltxt :=sqltxt||' order by 1 ';
130: end if;
131:
132: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
133: 'WIP OPERATIONS',null,'Y',row_limit);
134:
135: IF (dummy_num = row_limit) THEN
136: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
132: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
133: 'WIP OPERATIONS',null,'Y',row_limit);
134:
135: IF (dummy_num = row_limit) THEN
136: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
137: END IF;
138:
139: sqltxt :=
140: 'select a.wip_entity_id, '||
171: sqltxt :=sqltxt||' and b.wip_entity_id = '|| p_wip_entity_id;
172: sqltxt :=sqltxt||' order by operation_seq_num,inventory_item_id ';
173: end if;
174:
175: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
176: 'WIP REQUIREMENT OPERATIONS',null,'Y',row_limit);
177:
178: IF (dummy_num = row_limit) THEN
179: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
175: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
176: 'WIP REQUIREMENT OPERATIONS',null,'Y',row_limit);
177:
178: IF (dummy_num = row_limit) THEN
179: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
180: END IF;
181:
182: sqltxt :=
183: 'select a.operation_seq_num, '||
213: sqltxt :=sqltxt||' and a.wip_entity_id = '|| p_wip_entity_id;
214: sqltxt :=sqltxt||' order by 1,2';
215: end if;
216:
217: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
218: 'WIP OPERATION RESOURCES',null,'Y',row_limit);
219:
220: IF (dummy_num = row_limit) THEN
221: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
217: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
218: 'WIP OPERATION RESOURCES',null,'Y',row_limit);
219:
220: IF (dummy_num = row_limit) THEN
221: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
222: END IF;
223:
224: sqltxt :=
225: 'select a.operation_seq_num, '||
244: sqltxt :=sqltxt||' and a.wip_entity_id = '|| p_wip_entity_id;
245: sqltxt :=sqltxt||' order by 1,2 ';
246: end if;
247:
248: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
249: 'WIP OPERATION RESOURCE USAGES',null,'Y',row_limit);
250:
251: IF (dummy_num = row_limit) THEN
252: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
248: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
249: 'WIP OPERATION RESOURCE USAGES',null,'Y',row_limit);
250:
251: IF (dummy_num = row_limit) THEN
252: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
253: END IF;
254:
255: sqltxt :=
256: 'select acct_period_id, '||
291: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id;
292: sqltxt :=sqltxt||' order by creation_date ';
293: end if;
294:
295: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
296: 'WIP PERIOD BALANCES',null,'Y',row_limit);
297:
298: IF (dummy_num = row_limit) THEN
299: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
295: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
296: 'WIP PERIOD BALANCES',null,'Y',row_limit);
297:
298: IF (dummy_num = row_limit) THEN
299: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
300: END IF;
301:
302: sqltxt :=
303: 'select wmt.transaction_id, '||
344: sqltxt :=sqltxt||' and wmt.wip_entity_id = '|| p_wip_entity_id;
345: sqltxt :=sqltxt||' order by 1 ';
346: end if;
347:
348: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
349: 'WIP MOVE TRANSACTIONS',null,'Y',row_limit);
350:
351: IF (dummy_num = row_limit) THEN
352: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
348: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
349: 'WIP MOVE TRANSACTIONS',null,'Y',row_limit);
350:
351: IF (dummy_num = row_limit) THEN
352: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
353: END IF;
354:
355: sqltxt :=
356: 'select wmti.transaction_id, '||
415: sqltxt :=sqltxt||' and wip_entity_id = '|| p_wip_entity_id;
416: sqltxt :=sqltxt||' order by 1 ';
417: end if;
418:
419: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
420: 'WIP MOVE TXN INTERFACE',null,'Y',row_limit);
421:
422: IF (dummy_num = row_limit) THEN
423: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
419: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
420: 'WIP MOVE TXN INTERFACE',null,'Y',row_limit);
421:
422: IF (dummy_num = row_limit) THEN
423: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
424: END IF;
425:
426: /*
427: sqltxt :=
442: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ;
443: sqltxt :=sqltxt||' order by allocation_id ';
444: end if;
445:
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
447: 'WIP SO ALLOCATIONS',null,'Y',row_limit);
448:
449: IF (dummy_num = row_limit) THEN
450: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
447: 'WIP SO ALLOCATIONS',null,'Y',row_limit);
448:
449: IF (dummy_num = row_limit) THEN
450: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
451: END IF;
452: */
453:
454: sqltxt :=
516: sqltxt :=sqltxt||' and wip_entity_id = '|| p_wip_entity_id ;
517: sqltxt :=sqltxt||' order by transaction_id';
518: end if;
519:
520: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
521: 'WIP COST TXN INTERFACE',null,'Y',row_limit);
522:
523: IF (dummy_num = row_limit) THEN
524: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
520: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
521: 'WIP COST TXN INTERFACE',null,'Y',row_limit);
522:
523: IF (dummy_num = row_limit) THEN
524: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
525: END IF;
526:
527: sqltxt :=
528: 'select wt.transaction_id, '||
563: sqltxt :=sqltxt||' and wip_entity_id = '|| p_wip_entity_id ;
564: sqltxt :=sqltxt||' order by transaction_id';
565: end if;
566:
567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
568: 'WIP TRANSACTIONS',null,'Y',row_limit);
569:
570: IF (dummy_num = row_limit) THEN
571: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
568: 'WIP TRANSACTIONS',null,'Y',row_limit);
569:
570: IF (dummy_num = row_limit) THEN
571: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
572: END IF;
573:
574: sqltxt :=
575: 'select transaction_interface_id, '||
644: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id;
645: sqltxt :=sqltxt||' order by transaction_interface_id, transaction_date ';
646: end if;
647:
648: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
649: 'MTI TRANSACTIONS',null,'Y',row_limit);
650:
651: IF (dummy_num = row_limit) THEN
652: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
648: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
649: 'MTI TRANSACTIONS',null,'Y',row_limit);
650:
651: IF (dummy_num = row_limit) THEN
652: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
653: END IF;
654:
655: sqltxt :=
656: 'select '||
676: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id ||')';
677: sqltxt :=sqltxt||' order by lot_expiration_date ';
678: end if;
679:
680: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
681: 'MTLI TRANSACTIONS',null,'Y',row_limit);
682:
683: IF (dummy_num = row_limit) THEN
684: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
680: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
681: 'MTLI TRANSACTIONS',null,'Y',row_limit);
682:
683: IF (dummy_num = row_limit) THEN
684: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
685: END IF;
686:
687: sqltxt :=
688: 'select '||
707: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id ||')';
708: sqltxt :=sqltxt||' order by fm_serial_number ';
709: end if;
710:
711: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
712: 'MSNI TRANSACTIONS',null,'Y',row_limit);
713:
714: IF (dummy_num = row_limit) THEN
715: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
711: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
712: 'MSNI TRANSACTIONS',null,'Y',row_limit);
713:
714: IF (dummy_num = row_limit) THEN
715: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
716: END IF;
717:
718: sqltxt :=
719: 'select transaction_temp_id, '||
793: sqltxt :=sqltxt||' and transaction_source_id = '|| p_wip_entity_id ;
794: sqltxt :=sqltxt||' order by transaction_temp_id ';
795: end if;
796:
797: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
798: 'MMTT TRANSACTIONS',null,'Y',row_limit);
799:
800: IF (dummy_num = row_limit) THEN
801: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
797: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
798: 'MMTT TRANSACTIONS',null,'Y',row_limit);
799:
800: IF (dummy_num = row_limit) THEN
801: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
802: END IF;
803:
804: sqltxt :=
805: 'select '||
825: sqltxt :=sqltxt||' and mmtt.transaction_source_id = '|| p_wip_entity_id ||')' ;
826: sqltxt :=sqltxt||' order by transaction_temp_id, lot_number ';
827: end if;
828:
829: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
830: 'MTLT TRANSACTIONS',null,'Y',row_limit);
831:
832: IF (dummy_num = row_limit) THEN
833: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
829: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
830: 'MTLT TRANSACTIONS',null,'Y',row_limit);
831:
832: IF (dummy_num = row_limit) THEN
833: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
834: END IF;
835:
836: sqltxt :=
837: 'select '||
857: sqltxt :=sqltxt||' and mmtt.transaction_source_id = '|| p_wip_entity_id ||')' ;
858: sqltxt :=sqltxt||' order by transaction_temp_id, fm_serial_number ';
859: end if;
860:
861: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
862: 'MSNT TRANSACTIONS',null,'Y',row_limit);
863:
864: IF (dummy_num = row_limit) THEN
865: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
861: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
862: 'MSNT TRANSACTIONS',null,'Y',row_limit);
863:
864: IF (dummy_num = row_limit) THEN
865: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
866: END IF;
867:
868: sqltxt :=
869: 'select DISTINCT '||
939: sqltxt :=sqltxt||' and we.wip_entity_id = '|| p_wip_entity_id ||')' ;
940: sqltxt :=sqltxt||' order by request_number ';
941: end if;
942:
943: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
944: 'MTL_TXN_REQUEST_LINES_V TRANSACTIONS - MOVE ORDERS',null,'Y',row_limit);
945:
946: IF (dummy_num = row_limit) THEN
947: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
943: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
944: 'MTL_TXN_REQUEST_LINES_V TRANSACTIONS - MOVE ORDERS',null,'Y',row_limit);
945:
946: IF (dummy_num = row_limit) THEN
947: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
948: END IF;
949:
950: sqltxt :=
951: 'select transaction_id, '||
1020: sqltxt :=sqltxt||' and transaction_source_id = '|| p_wip_entity_id ;
1021: sqltxt :=sqltxt||' order by transaction_id ';
1022: end if;
1023:
1024: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1025: 'MMT TRANSACTIONS',null,'Y',row_limit);
1026:
1027: IF (dummy_num = row_limit) THEN
1028: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1024: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1025: 'MMT TRANSACTIONS',null,'Y',row_limit);
1026:
1027: IF (dummy_num = row_limit) THEN
1028: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1029: END IF;
1030:
1031: sqltxt :=
1032: 'select '||
1065: sqltxt :=sqltxt||' and mmt.transaction_source_id = '|| p_wip_entity_id ||')';
1066: sqltxt :=sqltxt||' order by inventory_item_id, lot_number ';
1067: end if;
1068:
1069: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1070: 'MTLN TRANSACTIONS',null,'Y',row_limit);
1071:
1072: IF (dummy_num = row_limit) THEN
1073: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1069: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1070: 'MTLN TRANSACTIONS',null,'Y',row_limit);
1071:
1072: IF (dummy_num = row_limit) THEN
1073: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1074: END IF;
1075:
1076: sqltxt :=
1077: 'select '||
1100: sqltxt :=sqltxt||' where msn.wip_entity_id = '|| p_wip_entity_id ;
1101: sqltxt :=sqltxt||' order by inventory_item_id, serial_number ';
1102: end if;
1103:
1104: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1105: 'MSN TRANSACTIONS for WIP Serial Tracking',null,'Y',row_limit);
1106:
1107: IF (dummy_num = row_limit) THEN
1108: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1104: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1105: 'MSN TRANSACTIONS for WIP Serial Tracking',null,'Y',row_limit);
1106:
1107: IF (dummy_num = row_limit) THEN
1108: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1109: END IF;
1110:
1111: sqltxt :=
1112: ' select mmt.inventory_item_id, ' ||
1128: sqltxt :=sqltxt||' order by mmt.inventory_item_id, mut.serial_number ';
1129: end if ;
1130:
1131:
1132: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1133: 'MSN TRANSACTIONS',null,'Y',row_limit);
1134:
1135: IF (dummy_num = row_limit) THEN
1136: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1132: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1133: 'MSN TRANSACTIONS',null,'Y',row_limit);
1134:
1135: IF (dummy_num = row_limit) THEN
1136: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1137: END IF;
1138:
1139: sqltxt :=
1140: 'select header_id, '||
1172: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ;
1173: sqltxt :=sqltxt||' order by header_id ';
1174: end if;
1175:
1176: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1177: 'WIP LPN COMPLETIONS',null,'Y',row_limit);
1178:
1179: IF (dummy_num = row_limit) THEN
1180: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1176: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1177: 'WIP LPN COMPLETIONS',null,'Y',row_limit);
1178:
1179: IF (dummy_num = row_limit) THEN
1180: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1181: END IF;
1182:
1183: sqltxt :=
1184: 'select '||
1247: sqltxt :=sqltxt||' and we.wip_entity_id = '|| p_wip_entity_id ;
1248: sqltxt :=sqltxt||' order by reservation_id ';
1249: end if;
1250:
1251: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1252: 'MTL RESERVATIONS',null,'Y',row_limit);
1253:
1254: IF (dummy_num = row_limit) THEN
1255: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1251: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1252: 'MTL RESERVATIONS',null,'Y',row_limit);
1253:
1254: IF (dummy_num = row_limit) THEN
1255: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1256: END IF;
1257:
1258: sqltxt :=
1259: 'Select '||
1277: if p_wip_entity_id is not null then
1278: sqltxt :=sqltxt||' and rqi.interface_source_line_id = '|| p_wip_entity_id ;
1279: end if;
1280:
1281: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1282: 'PO REQUISITION INTERFACE',null,'Y',row_limit);
1283:
1284: IF (dummy_num = row_limit) THEN
1285: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1281: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1282: 'PO REQUISITION INTERFACE',null,'Y',row_limit);
1283:
1284: IF (dummy_num = row_limit) THEN
1285: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1286: END IF;
1287:
1288: sqltxt :=
1289: 'select '||
1302: if p_wip_entity_id is not null then
1303: sqltxt :=sqltxt||' and rqi.interface_source_line_id = '|| p_wip_entity_id ;
1304: end if;
1305:
1306: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1307: 'PO INTERFACE ERRORS',null,'Y',row_limit);
1308:
1309: IF (dummy_num = row_limit) THEN
1310: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1306: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1307: 'PO INTERFACE ERRORS',null,'Y',row_limit);
1308:
1309: IF (dummy_num = row_limit) THEN
1310: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1311: END IF;
1312:
1313: sqltxt :=
1314: 'select '||
1352: sqltxt :=sqltxt||' and rql.wip_entity_id = '|| p_wip_entity_id ;
1353: sqltxt :=sqltxt||' order by RQH.REQUISITION_HEADER_ID, RQL.REQUISITION_LINE_ID, RQL.ITEM_ID';
1354: end if;
1355:
1356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1357: 'PO REQUISITION DETAILS',null,'Y',row_limit);
1358:
1359: IF (dummy_num = row_limit) THEN
1360: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1357: 'PO REQUISITION DETAILS',null,'Y',row_limit);
1358:
1359: IF (dummy_num = row_limit) THEN
1360: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1361: END IF;
1362:
1363: sqltxt :=
1364: 'select '||
1405: ' and LKP.LOOKUP_CODE = WFS.ACTIVITY_STATUS ';
1406:
1407: sqltxt :=sqltxt||' order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME';
1408:
1409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1410: 'WORKFLOW REQUISITION APPROVAL STATUS',null,'Y',row_limit);
1411:
1412: IF (dummy_num = row_limit) THEN
1413: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1410: 'WORKFLOW REQUISITION APPROVAL STATUS',null,'Y',row_limit);
1411:
1412: IF (dummy_num = row_limit) THEN
1413: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1414: END IF;
1415:
1416: sqltxt :=
1417: 'select '||
1456: ' and LKP.LOOKUP_CODE = WFS.ACTIVITY_STATUS '||
1457: ' and WFS.ERROR_NAME is not NULL '||
1458: ' order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME ';
1459:
1460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1461: 'WORKFLOW REQUISITION APPROVAL ERRORS',null,'Y',row_limit);
1462:
1463: IF (dummy_num = row_limit) THEN
1464: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1460: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1461: 'WORKFLOW REQUISITION APPROVAL ERRORS',null,'Y',row_limit);
1462:
1463: IF (dummy_num = row_limit) THEN
1464: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1465: END IF;
1466:
1467: sqltxt :=
1468: 'select '||
1507: sqltxt :=sqltxt||' and prl.wip_entity_id = '|| p_wip_entity_id ;
1508: sqltxt :=sqltxt||' order by poh.po_header_id, pol.po_line_id ';
1509: end if;
1510:
1511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1512: 'PO DETAILS',null,'Y',row_limit);
1513:
1514: IF (dummy_num = row_limit) THEN
1515: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1512: 'PO DETAILS',null,'Y',row_limit);
1513:
1514: IF (dummy_num = row_limit) THEN
1515: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1516: END IF;
1517:
1518: sqltxt :=
1519: 'select '||
1563: 'and LKP.LOOKUP_TYPE = ''WFENG_STATUS'' '||
1564: 'and LKP.LOOKUP_CODE = WFS.ACTIVITY_STATUS '||
1565: 'order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME ';
1566:
1567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1568: 'WORKFLOW PURCHASE ORDER APPROVAL STATUS',null,'Y',row_limit);
1569:
1570: IF (dummy_num = row_limit) THEN
1571: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1568: 'WORKFLOW PURCHASE ORDER APPROVAL STATUS',null,'Y',row_limit);
1569:
1570: IF (dummy_num = row_limit) THEN
1571: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1572: END IF;
1573:
1574: sqltxt :=
1575: 'select '||
1620: 'and WFS.ERROR_NAME is not NULL '||
1621: 'order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME ';
1622:
1623:
1624: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1625: 'WORKFLOW PURCHASE APPROVAL ERRORS',null,'Y',row_limit);
1626:
1627: IF (dummy_num = row_limit) THEN
1628: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1624: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1625: 'WORKFLOW PURCHASE APPROVAL ERRORS',null,'Y',row_limit);
1626:
1627: IF (dummy_num = row_limit) THEN
1628: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1629: END IF;
1630:
1631: sqltxt :=
1632: 'select default_discrete_class, '||
1680: if p_wip_entity_id is not null then
1681: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
1682: end if;
1683:
1684: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1685: 'WIP PARAMETERS',null,'Y',row_limit);
1686:
1687: IF (dummy_num = row_limit) THEN
1688: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1684: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1685: 'WIP PARAMETERS',null,'Y',row_limit);
1686:
1687: IF (dummy_num = row_limit) THEN
1688: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1689: END IF;
1690:
1691: sqltxt :=
1692: 'select a.assembly_item_id, '||
1733: sqltxt :=sqltxt||' and wj.wip_entity_id = '|| p_wip_entity_id ;
1734: sqltxt :=sqltxt||' order by a.bill_sequence_id, a.assembly_item_id, a.alternate_bom_designator, b.component_sequence_id ';
1735: end if;
1736:
1737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1738: 'BILL OF MATERIAL',null,'Y',row_limit);
1739:
1740: IF (dummy_num = row_limit) THEN
1741: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1737: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1738: 'BILL OF MATERIAL',null,'Y',row_limit);
1739:
1740: IF (dummy_num = row_limit) THEN
1741: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1742: END IF;
1743:
1744: sqltxt :=
1745: 'select bor.assembly_item_id, '||
1791: sqltxt :=sqltxt||' and wj.wip_entity_id = '|| p_wip_entity_id ;
1792: sqltxt :=sqltxt||' order by bor.routing_sequence_id, bor.alternate_routing_designator, a.operation_seq_num';
1793: end if;
1794:
1795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1796: 'ROUTING',null,'Y',row_limit);
1797:
1798: IF (dummy_num = row_limit) THEN
1799: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1795: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1796: 'ROUTING',null,'Y',row_limit);
1797:
1798: IF (dummy_num = row_limit) THEN
1799: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1800: END IF;
1801:
1802: sqltxt :=
1803: 'SELECT msik.inventory_item_id, '||
1821: if p_wip_entity_id is not null then
1822: sqltxt :=sqltxt||' and wor.wip_entity_id = '|| p_wip_entity_id ;
1823: end if;
1824:
1825: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1826: 'OSP ITEM DETAILS',null,'Y',row_limit);
1827:
1828: IF (dummy_num = row_limit) THEN
1829: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1825: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1826: 'OSP ITEM DETAILS',null,'Y',row_limit);
1827:
1828: IF (dummy_num = row_limit) THEN
1829: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1830: END IF;
1831:
1832: sqltxt :=
1833: 'select secondary_inventory_name, '||
1859: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
1860: sqltxt :=sqltxt||' order by 1';
1861: end if;
1862:
1863: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1864: 'SUBINVENTORY SETUP',null,'Y',row_limit);
1865:
1866: IF (dummy_num = row_limit) THEN
1867: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1863: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1864: 'SUBINVENTORY SETUP',null,'Y',row_limit);
1865:
1866: IF (dummy_num = row_limit) THEN
1867: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1868: END IF;
1869:
1870: -- Run following diagnostics only for Lot Based jobs
1871: begin
1892: ' from wsm_parameters wp, wip_entities we ' ||
1893: ' where wp.organization_id = we.organization_id' ||
1894: ' and we.wip_entity_id = ' || p_wip_entity_id ;
1895:
1896: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1897: 'OSFM PARAMETER SETUP',null,'Y',row_limit);
1898:
1899: IF (dummy_num = row_limit) THEN
1900: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1896: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1897: 'OSFM PARAMETER SETUP',null,'Y',row_limit);
1898:
1899: IF (dummy_num = row_limit) THEN
1900: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1901: END IF;
1902:
1903: sqltxt :=
1904: ' select a.from_seq_num,' ||
1913: ' where wj.wip_entity_id = ' || p_wip_entity_id ||
1914: ' and wj.common_routing_sequence_id = a.routing_sequence_id' ||
1915: ' order by a.transition_type, a.row_id' ;
1916:
1917: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1918: 'ROUTING NETWORK',null,'Y',row_limit);
1919:
1920: IF (dummy_num = row_limit) THEN
1921: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1917: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1918: 'ROUTING NETWORK',null,'Y',row_limit);
1919:
1920: IF (dummy_num = row_limit) THEN
1921: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1922: END IF;
1923:
1924: sqltxt :=
1925: ' select tm.transaction_id,' ||
1964: ' and sj.wip_entity_id = w.wip_entity_id' ||
1965: ' and w.wip_entity_id = ' || p_wip_entity_id ||
1966: ' order by 1' ;
1967:
1968: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1969: 'WIP Lot Transaction : Starting Lots',null,'Y',row_limit);
1970:
1971: IF (dummy_num = row_limit) THEN
1972: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1968: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
1969: 'WIP Lot Transaction : Starting Lots',null,'Y',row_limit);
1970:
1971: IF (dummy_num = row_limit) THEN
1972: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
1973: END IF;
1974:
1975: sqltxt :=
1976: ' select tm.transaction_id,' ||
2022: ' from wsm_sm_starting_jobs wssj' ||
2023: ' where wssj.wip_entity_id = ' || p_wip_entity_id ||
2024: ' ) order by transaction_id' ;
2025:
2026: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2027: 'Resulting Lots',null,'Y',row_limit);
2028:
2029: IF (dummy_num = row_limit) THEN
2030: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2026: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2027: 'Resulting Lots',null,'Y',row_limit);
2028:
2029: IF (dummy_num = row_limit) THEN
2030: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2031: END IF;
2032:
2033: sqltxt :=
2034: ' select tm.transaction_id,' ||
2078: ' and rj.wip_entity_id = w.wip_entity_id' ||
2079: ' and w.wip_entity_id = ' || p_wip_entity_id ||
2080: ' order by transaction_id' ;
2081:
2082: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2083: 'WIP Lot Transactions : Resulting Lots',null,'Y',row_limit);
2084:
2085: IF (dummy_num = row_limit) THEN
2086: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2082: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2083: 'WIP Lot Transactions : Resulting Lots',null,'Y',row_limit);
2084:
2085: IF (dummy_num = row_limit) THEN
2086: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2087: END IF;
2088:
2089: sqltxt :=
2090: ' select tm.transaction_id,' ||
2131: ' from wsm_sm_resulting_jobs wsrj' ||
2132: ' where wsrj.wip_entity_id = ' || p_wip_entity_id ||
2133: ' ) order by transaction_id' ;
2134:
2135: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2136: 'Starting Lots',null,'Y',row_limit);
2137:
2138: IF (dummy_num = row_limit) THEN
2139: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2135: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2136: 'Starting Lots',null,'Y',row_limit);
2137:
2138: IF (dummy_num = row_limit) THEN
2139: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2140: END IF;
2141:
2142: exception
2143: when no_data_found then null ;
2232: if p_rep_schedule_id is not null then
2233: sqltxt := sqltxt ||' and a.repetitive_schedule_id = '|| p_rep_schedule_id;
2234: end if;
2235:
2236: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2237: 'WIP HEADER ( WIP REPETITIVE SCHEDULES, WIP REPETITIVE ITEMS, WIP ENTITIES )',null,'Y',row_limit);
2238:
2239: IF (dummy_num = row_limit) THEN
2240: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2236: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2237: 'WIP HEADER ( WIP REPETITIVE SCHEDULES, WIP REPETITIVE ITEMS, WIP ENTITIES )',null,'Y',row_limit);
2238:
2239: IF (dummy_num = row_limit) THEN
2240: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2241: END IF;
2242:
2243:
2244: sqltxt :=
2282: sqltxt :=sqltxt||' and a.repetitive_schedule_id = '|| p_rep_schedule_id;
2283: sqltxt :=sqltxt||' order by 1 ';
2284: end if;
2285:
2286: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2287: 'WIP OPERATIONS',null,'Y',row_limit);
2288:
2289: IF (dummy_num = row_limit) THEN
2290: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2286: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2287: 'WIP OPERATIONS',null,'Y',row_limit);
2288:
2289: IF (dummy_num = row_limit) THEN
2290: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2291: END IF;
2292:
2293: sqltxt :=
2294: 'select a.wip_entity_id, '||
2328: sqltxt :=sqltxt||' and a.repetitive_schedule_id = '|| p_rep_schedule_id;
2329: sqltxt :=sqltxt||' order by operation_seq_num,inventory_item_id ';
2330: end if;
2331:
2332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2333: 'WIP REQUIREMENT OPERATIONS',null,'Y',row_limit);
2334:
2335: IF (dummy_num = row_limit) THEN
2336: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2333: 'WIP REQUIREMENT OPERATIONS',null,'Y',row_limit);
2334:
2335: IF (dummy_num = row_limit) THEN
2336: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2337: END IF;
2338:
2339: sqltxt :=
2340: 'select a.operation_seq_num, '||
2373: sqltxt :=sqltxt||' and a.repetitive_schedule_id = '|| p_rep_schedule_id;
2374: sqltxt :=sqltxt||' order by 1,2';
2375: end if;
2376:
2377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2378: 'WIP OPERATION RESOURCES',null,'Y',row_limit);
2379:
2380: IF (dummy_num = row_limit) THEN
2381: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2378: 'WIP OPERATION RESOURCES',null,'Y',row_limit);
2379:
2380: IF (dummy_num = row_limit) THEN
2381: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2382: END IF;
2383:
2384: sqltxt :=
2385: 'select a.operation_seq_num, '||
2407: sqltxt :=sqltxt||' and a.repetitive_schedule_id = '|| p_rep_schedule_id;
2408: sqltxt :=sqltxt||' order by 1,2 ';
2409: end if;
2410:
2411: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2412: 'WIP OPERATION RESOURCE USAGES',null,'Y',row_limit);
2413:
2414: IF (dummy_num = row_limit) THEN
2415: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2411: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2412: 'WIP OPERATION RESOURCE USAGES',null,'Y',row_limit);
2413:
2414: IF (dummy_num = row_limit) THEN
2415: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2416: END IF;
2417:
2418: sqltxt :=
2419: 'select acct_period_id, '||
2457: sqltxt :=sqltxt||' and repetitive_schedule_id = '|| p_rep_schedule_id;
2458: sqltxt :=sqltxt||' order by creation_date ';
2459: end if;
2460:
2461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2462: 'WIP PERIOD BALANCES',null,'Y',row_limit);
2463:
2464: IF (dummy_num = row_limit) THEN
2465: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2461: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2462: 'WIP PERIOD BALANCES',null,'Y',row_limit);
2463:
2464: IF (dummy_num = row_limit) THEN
2465: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2466: END IF;
2467:
2468: sqltxt :=
2469: 'select wmt.transaction_id, '||
2509: sqltxt :=sqltxt||' and wmta.repetitive_schedule_id = '|| p_rep_schedule_id;
2510: sqltxt :=sqltxt||' order by 1 ';
2511: end if;
2512:
2513: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2514: 'WIP MOVE TRANSACTIONS AND ALLOCATION',null,'Y',row_limit);
2515:
2516: IF (dummy_num = row_limit) THEN
2517: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2513: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2514: 'WIP MOVE TRANSACTIONS AND ALLOCATION',null,'Y',row_limit);
2515:
2516: IF (dummy_num = row_limit) THEN
2517: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2518: END IF;
2519:
2520: sqltxt :=
2521: 'select wmti.transaction_id, '||
2580: sqltxt :=sqltxt||' and wip_entity_id = '|| p_wip_entity_id;
2581: sqltxt :=sqltxt||' order by 1 ';
2582: end if;
2583:
2584: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2585: 'WIP MOVE TXN INTERFACE',null,'Y',row_limit);
2586:
2587: IF (dummy_num = row_limit) THEN
2588: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2584: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2585: 'WIP MOVE TXN INTERFACE',null,'Y',row_limit);
2586:
2587: IF (dummy_num = row_limit) THEN
2588: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2589: END IF;
2590:
2591: /*
2592: sqltxt :=
2607: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ;
2608: sqltxt :=sqltxt||' order by allocation_id ';
2609: end if;
2610:
2611: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2612: 'WIP SO ALLOCATIONS',null,'Y',row_limit);
2613:
2614: IF (dummy_num = row_limit) THEN
2615: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2611: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2612: 'WIP SO ALLOCATIONS',null,'Y',row_limit);
2613:
2614: IF (dummy_num = row_limit) THEN
2615: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2616: END IF;
2617:
2618: */
2619:
2685: sqltxt :=sqltxt||' and repetitive_schedule_id = '|| p_rep_schedule_id ;
2686: sqltxt :=sqltxt||' order by transaction_id';
2687: end if;
2688:
2689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2690: 'WIP COST TXN INTERFACE',null,'Y',row_limit);
2691:
2692: IF (dummy_num = row_limit) THEN
2693: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2689: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2690: 'WIP COST TXN INTERFACE',null,'Y',row_limit);
2691:
2692: IF (dummy_num = row_limit) THEN
2693: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2694: END IF;
2695:
2696: sqltxt :=
2697: 'select wt.transaction_id, '||
2734: sqltxt :=sqltxt||' and wta.repetitive_schedule_id = '|| p_rep_schedule_id ;
2735: sqltxt :=sqltxt||' order by transaction_id';
2736: end if;
2737:
2738: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2739: 'WIP TRANSACTIONS AND ALLOCATIONS',null,'Y',row_limit);
2740:
2741: IF (dummy_num = row_limit) THEN
2742: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2738: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2739: 'WIP TRANSACTIONS AND ALLOCATIONS',null,'Y',row_limit);
2740:
2741: IF (dummy_num = row_limit) THEN
2742: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2743: END IF;
2744:
2745: sqltxt :=
2746: 'select transaction_interface_id, '||
2815: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id;
2816: sqltxt :=sqltxt||' order by transaction_interface_id, transaction_date ';
2817: end if;
2818:
2819: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2820: 'MTI TRANSACTIONS',null,'Y',row_limit);
2821:
2822: IF (dummy_num = row_limit) THEN
2823: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2819: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2820: 'MTI TRANSACTIONS',null,'Y',row_limit);
2821:
2822: IF (dummy_num = row_limit) THEN
2823: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2824: END IF;
2825:
2826: sqltxt :=
2827: 'select '||
2847: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id ||')';
2848: sqltxt :=sqltxt||' order by lot_expiration_date ';
2849: end if;
2850:
2851: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2852: 'MTLI TRANSACTIONS',null,'Y',row_limit);
2853:
2854: IF (dummy_num = row_limit) THEN
2855: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2851: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2852: 'MTLI TRANSACTIONS',null,'Y',row_limit);
2853:
2854: IF (dummy_num = row_limit) THEN
2855: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2856: END IF;
2857:
2858: sqltxt :=
2859: 'select '||
2878: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id ||')';
2879: sqltxt :=sqltxt||' order by fm_serial_number ';
2880: end if;
2881:
2882: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2883: 'MSNI TRANSACTIONS',null,'Y',row_limit);
2884:
2885: IF (dummy_num = row_limit) THEN
2886: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2882: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2883: 'MSNI TRANSACTIONS',null,'Y',row_limit);
2884:
2885: IF (dummy_num = row_limit) THEN
2886: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2887: END IF;
2888:
2889: sqltxt :=
2890: 'select transaction_temp_id, '||
2964: sqltxt :=sqltxt||' and transaction_source_id = '|| p_wip_entity_id ;
2965: sqltxt :=sqltxt||' order by transaction_temp_id ';
2966: end if;
2967:
2968: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2969: 'MMTT TRANSACTIONS',null,'Y',row_limit);
2970:
2971: IF (dummy_num = row_limit) THEN
2972: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2968: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
2969: 'MMTT TRANSACTIONS',null,'Y',row_limit);
2970:
2971: IF (dummy_num = row_limit) THEN
2972: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
2973: END IF;
2974:
2975: sqltxt :=
2976: 'select '||
2996: sqltxt :=sqltxt||' and mmtt.transaction_source_id = '|| p_wip_entity_id ||')' ;
2997: sqltxt :=sqltxt||' order by transaction_temp_id, lot_number ';
2998: end if;
2999:
3000: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3001: 'MTLT TRANSACTIONS',null,'Y',row_limit);
3002:
3003: IF (dummy_num = row_limit) THEN
3004: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3000: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3001: 'MTLT TRANSACTIONS',null,'Y',row_limit);
3002:
3003: IF (dummy_num = row_limit) THEN
3004: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3005: END IF;
3006:
3007: sqltxt :=
3008: 'select '||
3028: sqltxt :=sqltxt||' and mmtt.transaction_source_id = '|| p_wip_entity_id ||')' ;
3029: sqltxt :=sqltxt||' order by transaction_temp_id, fm_serial_number ';
3030: end if;
3031:
3032: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3033: 'MSNT TRANSACTIONS',null,'Y',row_limit);
3034:
3035: IF (dummy_num = row_limit) THEN
3036: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3032: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3033: 'MSNT TRANSACTIONS',null,'Y',row_limit);
3034:
3035: IF (dummy_num = row_limit) THEN
3036: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3037: END IF;
3038:
3039: sqltxt :=
3040: 'select DISTINCT '||
3110: sqltxt :=sqltxt||' and we.wip_entity_id = '|| p_wip_entity_id ||')' ;
3111: sqltxt :=sqltxt||' order by request_number ';
3112: end if;
3113:
3114: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3115: 'MTL_TXN_REQUEST_LINES_V TRANSACTIONS - MOVE ORDERS',null,'Y',row_limit);
3116:
3117: IF (dummy_num = row_limit) THEN
3118: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3114: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3115: 'MTL_TXN_REQUEST_LINES_V TRANSACTIONS - MOVE ORDERS',null,'Y',row_limit);
3116:
3117: IF (dummy_num = row_limit) THEN
3118: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3119: END IF;
3120:
3121: sqltxt :=
3122: 'select mmt.transaction_id, '||
3192: ' and mmta.repetitive_schedule_id = ' || p_rep_schedule_id ;
3193: sqltxt :=sqltxt||' order by transaction_id ';
3194: end if;
3195:
3196: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3197: 'MMT TRANSACTIONS AND ALLOCATIONS',null,'Y',row_limit);
3198:
3199: IF (dummy_num = row_limit) THEN
3200: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3196: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3197: 'MMT TRANSACTIONS AND ALLOCATIONS',null,'Y',row_limit);
3198:
3199: IF (dummy_num = row_limit) THEN
3200: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3201: END IF;
3202:
3203: sqltxt :=
3204: 'select '||
3237: sqltxt :=sqltxt||' and mmt.transaction_source_id = '|| p_wip_entity_id ||')';
3238: sqltxt :=sqltxt||' order by inventory_item_id, lot_number ';
3239: end if;
3240:
3241: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3242: 'MTLN TRANSACTIONS',null,'Y',row_limit);
3243:
3244: IF (dummy_num = row_limit) THEN
3245: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3241: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3242: 'MTLN TRANSACTIONS',null,'Y',row_limit);
3243:
3244: IF (dummy_num = row_limit) THEN
3245: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3246: END IF;
3247:
3248: /*
3249: sqltxt :=
3273: sqltxt :=sqltxt||' where msn.wip_entity_id = '|| p_wip_entity_id ;
3274: sqltxt :=sqltxt||' order by inventory_item_id, serial_number ';
3275: end if;
3276:
3277: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3278: 'MSN TRANSACTIONS',null,'Y',row_limit);
3279:
3280: IF (dummy_num = row_limit) THEN
3281: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3277: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3278: 'MSN TRANSACTIONS',null,'Y',row_limit);
3279:
3280: IF (dummy_num = row_limit) THEN
3281: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3282: END IF;
3283:
3284: */
3285:
3306: sqltxt :=sqltxt||' order by mmt.inventory_item_id, mut.serial_number ';
3307: end if ;
3308:
3309:
3310: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3311: 'MSN TRANSACTIONS',null,'Y',row_limit);
3312:
3313: IF (dummy_num = row_limit) THEN
3314: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3310: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3311: 'MSN TRANSACTIONS',null,'Y',row_limit);
3312:
3313: IF (dummy_num = row_limit) THEN
3314: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3315: END IF;
3316:
3317: /*
3318: sqltxt :=
3351: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ;
3352: sqltxt :=sqltxt||' order by header_id ';
3353: end if;
3354:
3355: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3356: 'WIP LPN COMPLETIONS',null,'Y',row_limit);
3357:
3358: IF (dummy_num = row_limit) THEN
3359: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3355: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3356: 'WIP LPN COMPLETIONS',null,'Y',row_limit);
3357:
3358: IF (dummy_num = row_limit) THEN
3359: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3360: END IF;
3361:
3362: */
3363:
3430: sqltxt :=sqltxt||' and we.wip_entity_id = '|| p_wip_entity_id ;
3431: sqltxt :=sqltxt||' order by reservation_id ';
3432: end if;
3433:
3434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3435: 'MTL RESERVATIONS',null,'Y',row_limit);
3436:
3437: IF (dummy_num = row_limit) THEN
3438: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3435: 'MTL RESERVATIONS',null,'Y',row_limit);
3436:
3437: IF (dummy_num = row_limit) THEN
3438: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3439: END IF;
3440:
3441: sqltxt :=
3442: 'Select '||
3460: if p_wip_entity_id is not null then
3461: sqltxt :=sqltxt||' and rqi.interface_source_line_id = '|| p_wip_entity_id ;
3462: end if;
3463:
3464: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3465: 'PO REQUISITION INTERFACE',null,'Y',row_limit);
3466:
3467: IF (dummy_num = row_limit) THEN
3468: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3464: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3465: 'PO REQUISITION INTERFACE',null,'Y',row_limit);
3466:
3467: IF (dummy_num = row_limit) THEN
3468: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3469: END IF;
3470:
3471: sqltxt :=
3472: 'select '||
3485: if p_wip_entity_id is not null then
3486: sqltxt :=sqltxt||' and rqi.interface_source_line_id = '|| p_wip_entity_id ;
3487: end if;
3488:
3489: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3490: 'PO INTERFACE ERRORS',null,'Y',row_limit);
3491:
3492: IF (dummy_num = row_limit) THEN
3493: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3489: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3490: 'PO INTERFACE ERRORS',null,'Y',row_limit);
3491:
3492: IF (dummy_num = row_limit) THEN
3493: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3494: END IF;
3495:
3496: sqltxt :=
3497: 'select '||
3535: sqltxt :=sqltxt||' and rql.wip_entity_id = '|| p_wip_entity_id ;
3536: sqltxt :=sqltxt||' order by RQH.REQUISITION_HEADER_ID, RQL.REQUISITION_LINE_ID, RQL.ITEM_ID';
3537: end if;
3538:
3539: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3540: 'PO REQUISITION DETAILS',null,'Y',row_limit);
3541:
3542: IF (dummy_num = row_limit) THEN
3543: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3539: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3540: 'PO REQUISITION DETAILS',null,'Y',row_limit);
3541:
3542: IF (dummy_num = row_limit) THEN
3543: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3544: END IF;
3545:
3546: sqltxt :=
3547: 'select '||
3588: ' and LKP.LOOKUP_CODE = WFS.ACTIVITY_STATUS ';
3589:
3590: sqltxt :=sqltxt||' order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME';
3591:
3592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3593: 'WORKFLOW REQUISITION APPROVAL STATUS',null,'Y',row_limit);
3594:
3595: IF (dummy_num = row_limit) THEN
3596: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3592: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3593: 'WORKFLOW REQUISITION APPROVAL STATUS',null,'Y',row_limit);
3594:
3595: IF (dummy_num = row_limit) THEN
3596: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3597: END IF;
3598:
3599: sqltxt :=
3600: 'select '||
3639: ' and LKP.LOOKUP_CODE = WFS.ACTIVITY_STATUS '||
3640: ' and WFS.ERROR_NAME is not NULL '||
3641: ' order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME ';
3642:
3643: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3644: 'WORKFLOW REQUISITION APPROVAL ERRORS',null,'Y',row_limit);
3645:
3646: IF (dummy_num = row_limit) THEN
3647: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3643: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3644: 'WORKFLOW REQUISITION APPROVAL ERRORS',null,'Y',row_limit);
3645:
3646: IF (dummy_num = row_limit) THEN
3647: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3648: END IF;
3649:
3650: sqltxt :=
3651: 'select '||
3690: sqltxt :=sqltxt||' and prl.wip_entity_id = '|| p_wip_entity_id ;
3691: sqltxt :=sqltxt||' order by poh.po_header_id, pol.po_line_id ';
3692: end if;
3693:
3694: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3695: 'PO DETAILS',null,'Y',row_limit);
3696:
3697: IF (dummy_num = row_limit) THEN
3698: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3694: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3695: 'PO DETAILS',null,'Y',row_limit);
3696:
3697: IF (dummy_num = row_limit) THEN
3698: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3699: END IF;
3700:
3701: sqltxt :=
3702: 'select '||
3746: 'and LKP.LOOKUP_TYPE = ''WFENG_STATUS'' '||
3747: 'and LKP.LOOKUP_CODE = WFS.ACTIVITY_STATUS '||
3748: 'order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME ';
3749:
3750: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3751: 'WORKFLOW PURCHASE ORDER APPROVAL STATUS',null,'Y',row_limit);
3752:
3753: IF (dummy_num = row_limit) THEN
3754: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3750: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3751: 'WORKFLOW PURCHASE ORDER APPROVAL STATUS',null,'Y',row_limit);
3752:
3753: IF (dummy_num = row_limit) THEN
3754: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3755: END IF;
3756:
3757: sqltxt :=
3758: 'select '||
3803: 'and WFS.ERROR_NAME is not NULL '||
3804: 'order by WFS.ITEM_KEY, WFS.BEGIN_DATE, EXECUTION_TIME ';
3805:
3806:
3807: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3808: 'WORKFLOW PURCHASE APPROVAL ERRORS ',null,'Y',row_limit);
3809:
3810: IF (dummy_num = row_limit) THEN
3811: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3807: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3808: 'WORKFLOW PURCHASE APPROVAL ERRORS ',null,'Y',row_limit);
3809:
3810: IF (dummy_num = row_limit) THEN
3811: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3812: END IF;
3813:
3814: sqltxt :=
3815: 'select default_discrete_class, '||
3861: if p_wip_entity_id is not null then
3862: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
3863: end if;
3864:
3865: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3866: 'WIP PARAMETERS',null,'Y',row_limit);
3867:
3868: IF (dummy_num = row_limit) THEN
3869: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3865: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3866: 'WIP PARAMETERS',null,'Y',row_limit);
3867:
3868: IF (dummy_num = row_limit) THEN
3869: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3870: END IF;
3871:
3872: sqltxt :=
3873: 'select a.assembly_item_id, '||
3914: sqltxt :=sqltxt||' and wj.wip_entity_id = '|| p_wip_entity_id ;
3915: sqltxt :=sqltxt||' order by a.bill_sequence_id, a.assembly_item_id, a.alternate_bom_designator, b.component_sequence_id ';
3916: end if;
3917:
3918: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3919: 'BILL OF MATERIAL',null,'Y',row_limit);
3920:
3921: IF (dummy_num = row_limit) THEN
3922: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3918: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3919: 'BILL OF MATERIAL',null,'Y',row_limit);
3920:
3921: IF (dummy_num = row_limit) THEN
3922: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3923: END IF;
3924:
3925: sqltxt :=
3926: 'select bor.assembly_item_id, '||
3972: sqltxt :=sqltxt||' and wj.wip_entity_id = '|| p_wip_entity_id ;
3973: sqltxt :=sqltxt||' order by bor.routing_sequence_id, bor.alternate_routing_designator, a.operation_seq_num';
3974: end if;
3975:
3976: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3977: 'ROUTING',null,'Y',row_limit);
3978:
3979: IF (dummy_num = row_limit) THEN
3980: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3976: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
3977: 'ROUTING',null,'Y',row_limit);
3978:
3979: IF (dummy_num = row_limit) THEN
3980: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
3981: END IF;
3982:
3983: sqltxt :=
3984: 'SELECT msik.inventory_item_id, '||
4002: if p_wip_entity_id is not null then
4003: sqltxt :=sqltxt||' and wor.wip_entity_id = '|| p_wip_entity_id ;
4004: end if;
4005:
4006: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4007: 'OSP ITEM DETAILS',null,'Y',row_limit);
4008:
4009: IF (dummy_num = row_limit) THEN
4010: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4006: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4007: 'OSP ITEM DETAILS',null,'Y',row_limit);
4008:
4009: IF (dummy_num = row_limit) THEN
4010: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4011: END IF;
4012:
4013: sqltxt :=
4014: 'select secondary_inventory_name, '||
4040: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
4041: sqltxt :=sqltxt||' order by 1';
4042: end if;
4043:
4044: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4045: 'SUBINVENTORY SETUP',null,'Y',row_limit);
4046:
4047: IF (dummy_num = row_limit) THEN
4048: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4044: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4045: 'SUBINVENTORY SETUP',null,'Y',row_limit);
4046:
4047: IF (dummy_num = row_limit) THEN
4048: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4049: END IF;
4050:
4051: END repetitive ;
4052:
4098: sqltxt :=sqltxt||' and b.wip_entity_id = '|| p_wip_entity_id;
4099: end if;
4100:
4101:
4102: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4103: 'JOB HEADER ( WIP FLOW SCHEDULES , WIP ENTITIES )',null,'Y',row_limit);
4104:
4105: IF (dummy_num = row_limit) THEN
4106: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4102: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4103: 'JOB HEADER ( WIP FLOW SCHEDULES , WIP ENTITIES )',null,'Y',row_limit);
4104:
4105: IF (dummy_num = row_limit) THEN
4106: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4107: END IF;
4108:
4109: sqltxt :=
4110: 'select acct_period_id, '||
4145: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id;
4146: sqltxt :=sqltxt||' order by creation_date ';
4147: end if;
4148:
4149: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4150: 'WIP PERIOD BALANCES',null,'Y',row_limit);
4151:
4152: IF (dummy_num = row_limit) THEN
4153: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4149: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4150: 'WIP PERIOD BALANCES',null,'Y',row_limit);
4151:
4152: IF (dummy_num = row_limit) THEN
4153: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4154: END IF;
4155:
4156: sqltxt :=
4157: 'select wcti.transaction_id, '||
4218: sqltxt :=sqltxt||' and wip_entity_id = '|| p_wip_entity_id ;
4219: sqltxt :=sqltxt||' order by transaction_id';
4220: end if;
4221:
4222: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4223: 'WIP COST TXN INTERFACE',null,'Y',row_limit);
4224:
4225: IF (dummy_num = row_limit) THEN
4226: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4222: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4223: 'WIP COST TXN INTERFACE',null,'Y',row_limit);
4224:
4225: IF (dummy_num = row_limit) THEN
4226: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4227: END IF;
4228:
4229: sqltxt :=
4230: 'select wt.transaction_id, '||
4265: sqltxt :=sqltxt||' and wip_entity_id = '|| p_wip_entity_id ;
4266: sqltxt :=sqltxt||' order by transaction_id';
4267: end if;
4268:
4269: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4270: 'WIP TRANSACTIONS',null,'Y',row_limit);
4271:
4272: IF (dummy_num = row_limit) THEN
4273: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4269: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4270: 'WIP TRANSACTIONS',null,'Y',row_limit);
4271:
4272: IF (dummy_num = row_limit) THEN
4273: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4274: END IF;
4275:
4276: sqltxt :=
4277: 'select transaction_interface_id, '||
4346: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id;
4347: sqltxt :=sqltxt||' order by transaction_interface_id, transaction_date ';
4348: end if;
4349:
4350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4351: 'MTI TRANSACTIONS',null,'Y',row_limit);
4352:
4353: IF (dummy_num = row_limit) THEN
4354: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4351: 'MTI TRANSACTIONS',null,'Y',row_limit);
4352:
4353: IF (dummy_num = row_limit) THEN
4354: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4355: END IF;
4356:
4357: sqltxt :=
4358: 'select '||
4378: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id ||')';
4379: sqltxt :=sqltxt||' order by lot_expiration_date ';
4380: end if;
4381:
4382: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4383: 'MTLI TRANSACTIONS',null,'Y',row_limit);
4384:
4385: IF (dummy_num = row_limit) THEN
4386: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4382: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4383: 'MTLI TRANSACTIONS',null,'Y',row_limit);
4384:
4385: IF (dummy_num = row_limit) THEN
4386: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4387: END IF;
4388:
4389: sqltxt :=
4390: 'select '||
4409: sqltxt :=sqltxt||' and mti.transaction_source_id = '|| p_wip_entity_id ||')';
4410: sqltxt :=sqltxt||' order by fm_serial_number ';
4411: end if;
4412:
4413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4414: 'MSNI TRANSACTIONS',null,'Y',row_limit);
4415:
4416: IF (dummy_num = row_limit) THEN
4417: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4414: 'MSNI TRANSACTIONS',null,'Y',row_limit);
4415:
4416: IF (dummy_num = row_limit) THEN
4417: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4418: END IF;
4419:
4420: sqltxt :=
4421: 'select transaction_temp_id, '||
4495: sqltxt :=sqltxt||' and transaction_source_id = '|| p_wip_entity_id ;
4496: sqltxt :=sqltxt||' order by transaction_temp_id ';
4497: end if;
4498:
4499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4500: 'MMTT TRANSACTIONS',null,'Y',row_limit);
4501:
4502: IF (dummy_num = row_limit) THEN
4503: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4499: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4500: 'MMTT TRANSACTIONS',null,'Y',row_limit);
4501:
4502: IF (dummy_num = row_limit) THEN
4503: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4504: END IF;
4505:
4506: sqltxt :=
4507: 'select '||
4527: sqltxt :=sqltxt||' and mmtt.transaction_source_id = '|| p_wip_entity_id ||')' ;
4528: sqltxt :=sqltxt||' order by transaction_temp_id, lot_number ';
4529: end if;
4530:
4531: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4532: 'MTLT TRANSACTIONS',null,'Y',row_limit);
4533:
4534: IF (dummy_num = row_limit) THEN
4535: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4531: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4532: 'MTLT TRANSACTIONS',null,'Y',row_limit);
4533:
4534: IF (dummy_num = row_limit) THEN
4535: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4536: END IF;
4537:
4538: sqltxt :=
4539: 'select '||
4559: sqltxt :=sqltxt||' and mmtt.transaction_source_id = '|| p_wip_entity_id ||')' ;
4560: sqltxt :=sqltxt||' order by transaction_temp_id, fm_serial_number ';
4561: end if;
4562:
4563: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4564: 'MSNT TRANSACTIONS',null,'Y',row_limit);
4565:
4566: IF (dummy_num = row_limit) THEN
4567: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4563: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4564: 'MSNT TRANSACTIONS',null,'Y',row_limit);
4565:
4566: IF (dummy_num = row_limit) THEN
4567: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4568: END IF;
4569:
4570: sqltxt :=
4571: 'select DISTINCT '||
4641: sqltxt :=sqltxt||' and we.wip_entity_id = '|| p_wip_entity_id ||')' ;
4642: sqltxt :=sqltxt||' order by request_number ';
4643: end if;
4644:
4645: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4646: 'MTL_TXN_REQUEST_LINES_V TRANSACTIONS - MOVE ORDERS',null,'Y',row_limit);
4647:
4648: IF (dummy_num = row_limit) THEN
4649: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4645: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4646: 'MTL_TXN_REQUEST_LINES_V TRANSACTIONS - MOVE ORDERS',null,'Y',row_limit);
4647:
4648: IF (dummy_num = row_limit) THEN
4649: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4650: END IF;
4651:
4652: sqltxt :=
4653: 'select transaction_id, '||
4722: sqltxt :=sqltxt||' and transaction_source_id = '|| p_wip_entity_id ;
4723: sqltxt :=sqltxt||' order by transaction_id ';
4724: end if;
4725:
4726: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4727: 'MMT TRANSACTIONS',null,'Y',row_limit);
4728:
4729: IF (dummy_num = row_limit) THEN
4730: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4726: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4727: 'MMT TRANSACTIONS',null,'Y',row_limit);
4728:
4729: IF (dummy_num = row_limit) THEN
4730: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4731: END IF;
4732:
4733: sqltxt :=
4734: 'select '||
4767: sqltxt :=sqltxt||' and mmt.transaction_source_id = '|| p_wip_entity_id ||')';
4768: sqltxt :=sqltxt||' order by inventory_item_id, lot_number ';
4769: end if;
4770:
4771: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4772: 'MTLN TRANSACTIONS',null,'Y',row_limit);
4773:
4774: IF (dummy_num = row_limit) THEN
4775: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4771: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4772: 'MTLN TRANSACTIONS',null,'Y',row_limit);
4773:
4774: IF (dummy_num = row_limit) THEN
4775: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4776: END IF;
4777:
4778: /*
4779: sqltxt :=
4803: sqltxt :=sqltxt||' where msn.wip_entity_id = '|| p_wip_entity_id ;
4804: sqltxt :=sqltxt||' order by inventory_item_id, serial_number ';
4805: end if;
4806:
4807: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4808: 'MSN TRANSACTIONS',null,'Y',row_limit);
4809:
4810: IF (dummy_num = row_limit) THEN
4811: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4807: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4808: 'MSN TRANSACTIONS',null,'Y',row_limit);
4809:
4810: IF (dummy_num = row_limit) THEN
4811: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4812: END IF;
4813:
4814: */
4815:
4833: sqltxt :=sqltxt||' order by mmt.inventory_item_id, mut.serial_number ';
4834: end if ;
4835:
4836:
4837: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4838: 'MSN TRANSACTIONS',null,'Y',row_limit);
4839:
4840: IF (dummy_num = row_limit) THEN
4841: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4837: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4838: 'MSN TRANSACTIONS',null,'Y',row_limit);
4839:
4840: IF (dummy_num = row_limit) THEN
4841: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4842: END IF;
4843:
4844: sqltxt :=
4845: 'select header_id, '||
4877: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ;
4878: sqltxt :=sqltxt||' order by header_id ';
4879: end if;
4880:
4881: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4882: 'WIP LPN COMPLETIONS',null,'Y',row_limit);
4883:
4884: IF (dummy_num = row_limit) THEN
4885: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4881: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4882: 'WIP LPN COMPLETIONS',null,'Y',row_limit);
4883:
4884: IF (dummy_num = row_limit) THEN
4885: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4886: END IF;
4887:
4888: sqltxt :=
4889: 'select '||
4937: sqltxt :=sqltxt||' and we.wip_entity_id = '|| p_wip_entity_id ;
4938: sqltxt :=sqltxt||' order by reservation_id ';
4939: end if;
4940:
4941: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4942: 'MTL RESERVATIONS',null,'Y',row_limit);
4943:
4944: IF (dummy_num = row_limit) THEN
4945: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4941: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4942: 'MTL RESERVATIONS',null,'Y',row_limit);
4943:
4944: IF (dummy_num = row_limit) THEN
4945: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
4946: END IF;
4947:
4948: sqltxt :=
4949: 'select secondary_inventory_name, '||
4975: sqltxt :=sqltxt||' where wip_entity_id = '|| p_wip_entity_id ||')';
4976: sqltxt :=sqltxt||' order by 1';
4977: end if;
4978:
4979: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
4980: 'SUBINVENTORY SETUP',null,'Y',row_limit);
4981: END flow ;
4982:
4983: procedure setup (p_org_id IN NUMBER,
5085: ' and fpov.level_value = to_number( ' || l_resp_id_string || ')) '||
5086: ' or (fpov.level_id = 10004 and fpov.level_value = to_number( ' || l_user_id_string || '))) ' ||
5087: ' order by fpo.user_profile_option_name, fpov.level_id desc ' ;
5088:
5089: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
5090: 'WIP Profiles',null,'Y',row_limit);
5091:
5092: IF (dummy_num = row_limit) THEN
5093: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5089: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
5090: 'WIP Profiles',null,'Y',row_limit);
5091:
5092: IF (dummy_num = row_limit) THEN
5093: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5094: END IF;
5095:
5096: */
5097:
5095:
5096: */
5097:
5098: reportStr := 'WIP Profiles' ;
5099: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5100: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(706) ;
5101:
5102: reportStr := 'MRP Debug Profile' ;
5103: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5096: */
5097:
5098: reportStr := 'WIP Profiles' ;
5099: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5100: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(706) ;
5101:
5102: reportStr := 'MRP Debug Profile' ;
5103: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5104: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(704, 'MRP_DEBUG');
5099: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5100: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(706) ;
5101:
5102: reportStr := 'MRP Debug Profile' ;
5103: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5104: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(704, 'MRP_DEBUG');
5105:
5106:
5107:
5100: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(706) ;
5101:
5102: reportStr := 'MRP Debug Profile' ;
5103: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5104: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(704, 'MRP_DEBUG');
5105:
5106:
5107:
5108: apps_ver := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version ;
5104: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(704, 'MRP_DEBUG');
5105:
5106:
5107:
5108: apps_ver := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version ;
5109:
5110: /* Fix for #5757345. in following if */
5111:
5112: if (release_level in ('11.5.10' , '11.5.10.1', '11.5.10.2')) then
5111:
5112: if (release_level in ('11.5.10' , '11.5.10.1', '11.5.10.2')) then
5113:
5114: reportStr := 'FND Profiles' ;
5115: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5116:
5117: -- Check FND Profile for WIP Debugging
5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5115: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5116:
5117: -- Check FND Profile for WIP Debugging
5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:
5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5116:
5117: -- Check FND Profile for WIP Debugging
5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:
5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:
5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5125:
5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:
5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5125:
5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5125:
5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5129:
5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;
5131: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5125:
5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5129:
5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;
5131: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5132: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_MODULE');
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5129:
5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;
5131: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5132: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_MODULE');
5133:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5129:
5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;
5131: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5132: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_MODULE');
5133:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5131: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5132: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_MODULE');
5133:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5137: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Operation Backflush Setup') ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5132: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_MODULE');
5133:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5137: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Operation Backflush Setup') ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5140: JTF_DIAGNOSTIC_COREAPI.Tab1Print('WIP:Job Name Updatable') ;
5133:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5137: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Operation Backflush Setup') ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5140: JTF_DIAGNOSTIC_COREAPI.Tab1Print('WIP:Job Name Updatable') ;
5141:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5137: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Operation Backflush Setup') ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5140: JTF_DIAGNOSTIC_COREAPI.Tab1Print('WIP:Job Name Updatable') ;
5141:
5142: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5135: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5137: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Operation Backflush Setup') ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5140: JTF_DIAGNOSTIC_COREAPI.Tab1Print('WIP:Job Name Updatable') ;
5141:
5142: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5143:
5136: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Background Shop Floor Material Processing') ;
5137: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Operation Backflush Setup') ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5140: JTF_DIAGNOSTIC_COREAPI.Tab1Print('WIP:Job Name Updatable') ;
5141:
5142: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5143:
5144: reportStr := 'Following profiles are introduced in 11.5.10' ;
5138: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug File') ;
5139: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Debug Directory') ;
5140: JTF_DIAGNOSTIC_COREAPI.Tab1Print('WIP:Job Name Updatable') ;
5141:
5142: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5143:
5144: reportStr := 'Following profiles are introduced in 11.5.10' ;
5145: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5146:
5141:
5142: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5143:
5144: reportStr := 'Following profiles are introduced in 11.5.10' ;
5145: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5146:
5147: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Work Order-less Completion Transaction Form') ;
5148: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Work Order-less Default Completion Type') ;
5149:
5143:
5144: reportStr := 'Following profiles are introduced in 11.5.10' ;
5145: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5146:
5147: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Work Order-less Completion Transaction Form') ;
5148: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Work Order-less Default Completion Type') ;
5149:
5150: end if ;
5151:
5144: reportStr := 'Following profiles are introduced in 11.5.10' ;
5145: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5146:
5147: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Work Order-less Completion Transaction Form') ;
5148: JTF_DIAGNOSTIC_COREAPI.Tab1Print('TP:WIP Work Order-less Default Completion Type') ;
5149:
5150: end if ;
5151:
5152:
5149:
5150: end if ;
5151:
5152:
5153: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5154:
5155: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_CONC_MESSAGE_LEVEL', l_user_id, l_resp_id, l_appl_id );
5156:
5157: if (profile_val <> 0 ) then
5151:
5152:
5153: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5154:
5155: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_CONC_MESSAGE_LEVEL', l_user_id, l_resp_id, l_appl_id );
5156:
5157: if (profile_val <> 0 ) then
5158: -- Check for MRP Debug value. It must be set to yes so that debug messages can be printed.
5159: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('MRP_DEBUG', l_user_id, l_resp_id, 704);
5155: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_CONC_MESSAGE_LEVEL', l_user_id, l_resp_id, l_appl_id );
5156:
5157: if (profile_val <> 0 ) then
5158: -- Check for MRP Debug value. It must be set to yes so that debug messages can be printed.
5159: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('MRP_DEBUG', l_user_id, l_resp_id, 704);
5160:
5161: reportStr := ' MRP: Debug profile must be set to ''Yes'' so that Debug messages in concurrent definition of Job , WIP Mass Load, Autocreate FAS, Leadtime request will be printed' ;
5162: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
5163:
5158: -- Check for MRP Debug value. It must be set to yes so that debug messages can be printed.
5159: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('MRP_DEBUG', l_user_id, l_resp_id, 704);
5160:
5161: reportStr := ' MRP: Debug profile must be set to ''Yes'' so that Debug messages in concurrent definition of Job , WIP Mass Load, Autocreate FAS, Leadtime request will be printed' ;
5162: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
5163:
5164: else
5165: reportStr := 'Debug messages in concurrent definition of Job , WIP Mass Load, Autocreate FAS, Leadtime request will not be printed' ;
5166: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
5162: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
5163:
5164: else
5165: reportStr := 'Debug messages in concurrent definition of Job , WIP Mass Load, Autocreate FAS, Leadtime request will not be printed' ;
5166: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
5167: end if ;
5168: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5169:
5170:
5164: else
5165: reportStr := 'Debug messages in concurrent definition of Job , WIP Mass Load, Autocreate FAS, Leadtime request will not be printed' ;
5166: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
5167: end if ;
5168: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5169:
5170:
5171:
5172: -- Check if Oracle Flow Manufacturing is installed as check profiles as appropriate
5170:
5171:
5172: -- Check if Oracle Flow Manufacturing is installed as check profiles as appropriate
5173: -- if (FNDUtility.getInstallStatus(report, 714) = 2) then
5174: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_WORKORDERLESS_COMP_FORM_DEFAULT', l_user_id, l_resp_id, l_appl_id );
5175:
5176: if (profile_val = 4 ) then
5177: reportStr := ' The profile option ''TP:WIP Work Order-less Default Completion Type'' has not been set.';
5178: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5174: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_WORKORDERLESS_COMP_FORM_DEFAULT', l_user_id, l_resp_id, l_appl_id );
5175:
5176: if (profile_val = 4 ) then
5177: reportStr := ' The profile option ''TP:WIP Work Order-less Default Completion Type'' has not been set.';
5178: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5179: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('If discrete manufacturing or project manufacturing or flow manufacturing '||
5180: 'is planned to be used this profile must be set. Please see the' || l_url , l_desc, 'for more information on how to setup WIP Profile') ;
5181: end if ;
5182:
5175:
5176: if (profile_val = 4 ) then
5177: reportStr := ' The profile option ''TP:WIP Work Order-less Default Completion Type'' has not been set.';
5178: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5179: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('If discrete manufacturing or project manufacturing or flow manufacturing '||
5180: 'is planned to be used this profile must be set. Please see the' || l_url , l_desc, 'for more information on how to setup WIP Profile') ;
5181: end if ;
5182:
5183: -- end if ;
5180: 'is planned to be used this profile must be set. Please see the' || l_url , l_desc, 'for more information on how to setup WIP Profile') ;
5181: end if ;
5182:
5183: -- end if ;
5184: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5185:
5186:
5187: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_JOB_PREFIX', l_user_id, l_resp_id, l_appl_id , 'No Prefix');
5188: if (profile_val = 4 )then
5183: -- end if ;
5184: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5185:
5186:
5187: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_JOB_PREFIX', l_user_id, l_resp_id, l_appl_id , 'No Prefix');
5188: if (profile_val = 4 )then
5189: reportStr := ' The profile option ''WIP:Discrete Job Prefix'' has not been set.';
5190: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5191: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('If discrete manufacturing or project manufacturing or flow manufacturing'||
5186:
5187: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_JOB_PREFIX', l_user_id, l_resp_id, l_appl_id , 'No Prefix');
5188: if (profile_val = 4 )then
5189: reportStr := ' The profile option ''WIP:Discrete Job Prefix'' has not been set.';
5190: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5191: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('If discrete manufacturing or project manufacturing or flow manufacturing'||
5192: ' is planned to be used this profile must be set. Please see the' , l_url , l_desc ,'for more information on how to setup WIP Profile') ;
5193: end if ;
5194: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5187: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_JOB_PREFIX', l_user_id, l_resp_id, l_appl_id , 'No Prefix');
5188: if (profile_val = 4 )then
5189: reportStr := ' The profile option ''WIP:Discrete Job Prefix'' has not been set.';
5190: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5191: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('If discrete manufacturing or project manufacturing or flow manufacturing'||
5192: ' is planned to be used this profile must be set. Please see the' , l_url , l_desc ,'for more information on how to setup WIP Profile') ;
5193: end if ;
5194: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5195:
5190: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5191: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('If discrete manufacturing or project manufacturing or flow manufacturing'||
5192: ' is planned to be used this profile must be set. Please see the' , l_url , l_desc ,'for more information on how to setup WIP Profile') ;
5193: end if ;
5194: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5195:
5196: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_OSP_WF', l_user_id, l_resp_id, l_appl_id );
5197: if (profile_val = 4) then
5198: reportStr := ' The profile option ''WIP:Job Name Updatable'' has not been set.';
5192: ' is planned to be used this profile must be set. Please see the' , l_url , l_desc ,'for more information on how to setup WIP Profile') ;
5193: end if ;
5194: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5195:
5196: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_OSP_WF', l_user_id, l_resp_id, l_appl_id );
5197: if (profile_val = 4) then
5198: reportStr := ' The profile option ''WIP:Job Name Updatable'' has not been set.';
5199: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5200: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('If discrete manufacturing or project manufacturing or flow '||
5195:
5196: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_OSP_WF', l_user_id, l_resp_id, l_appl_id );
5197: if (profile_val = 4) then
5198: reportStr := ' The profile option ''WIP:Job Name Updatable'' has not been set.';
5199: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5200: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('If discrete manufacturing or project manufacturing or flow '||
5201: 'manufacturing is planned to be used this profile must be set. Please see the', l_url ,
5202: l_desc,'for more information on how to setup WIP Profile') ;
5203: end if ;
5196: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_OSP_WF', l_user_id, l_resp_id, l_appl_id );
5197: if (profile_val = 4) then
5198: reportStr := ' The profile option ''WIP:Job Name Updatable'' has not been set.';
5199: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
5200: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('If discrete manufacturing or project manufacturing or flow '||
5201: 'manufacturing is planned to be used this profile must be set. Please see the', l_url ,
5202: l_desc,'for more information on how to setup WIP Profile') ;
5203: end if ;
5204: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5200: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('If discrete manufacturing or project manufacturing or flow '||
5201: 'manufacturing is planned to be used this profile must be set. Please see the', l_url ,
5202: l_desc,'for more information on how to setup WIP Profile') ;
5203: end if ;
5204: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5205:
5206: /*
5207: if (apps_ver = '11.5.9') then
5208: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_DEBUG_FILE', l_user_id, l_resp_id, l_appl_id, 'wip.log' );
5204: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5205:
5206: /*
5207: if (apps_ver = '11.5.9') then
5208: profile_val := JTF_DIAGNOSTIC_COREAPI.CheckProfile('WIP_DEBUG_FILE', l_user_id, l_resp_id, l_appl_id, 'wip.log' );
5209: end if ;
5210: */
5211:
5212:
5209: end if ;
5210: */
5211:
5212:
5213: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5214:
5215: end checkWipProfiles ;
5216:
5217: procedure checkWipDetails is
5336:
5337:
5338:
5339:
5340: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Parameters SETUP',null,'Y',row_limit);
5341:
5342: IF (dummy_num = row_limit) THEN
5343: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5344: END IF;
5339:
5340: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Parameters SETUP',null,'Y',row_limit);
5341:
5342: IF (dummy_num = row_limit) THEN
5343: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5344: END IF;
5345:
5346: if dummy_num = 0 then
5347: reportStr := 'There are no work in process parameters defined for this organization';
5345:
5346: if dummy_num = 0 then
5347: reportStr := 'There are no work in process parameters defined for this organization';
5348:
5349: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
5350: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please see the' , l_url, l_desc, ' for more information on how to setup these parameter values') ;
5351: else
5352: open wip_param_v_csr ;
5353: fetch wip_param_v_csr into wip_param_v_rec ;
5346: if dummy_num = 0 then
5347: reportStr := 'There are no work in process parameters defined for this organization';
5348:
5349: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
5350: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please see the' , l_url, l_desc, ' for more information on how to setup these parameter values') ;
5351: else
5352: open wip_param_v_csr ;
5353: fetch wip_param_v_csr into wip_param_v_rec ;
5354: close wip_param_v_csr ;
5362: close inv_param_csr ;
5363:
5364: if (inv_param_rec.primary_cost_method = 2 ) then -- Average Costing
5365:
5366: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Method Average Parameters' ) ;
5367: JTF_DIAGNOSTIC_COREAPI.Line_Out('Default Completion Cost Source = ' || wip_param_v_rec.completion_cost_source_meaning || '
' );
5368: JTF_DIAGNOSTIC_COREAPI.Line_Out('System Option = ' || wip_param_v_rec.system_option || '
');
5369: JTF_DIAGNOSTIC_COREAPI.Line_Out('Cost Type = ' || wip_param_v_rec.cost_type || '
');
5370:
5363:
5364: if (inv_param_rec.primary_cost_method = 2 ) then -- Average Costing
5365:
5366: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Method Average Parameters' ) ;
5367: JTF_DIAGNOSTIC_COREAPI.Line_Out('Default Completion Cost Source = ' || wip_param_v_rec.completion_cost_source_meaning || '
' );
5368: JTF_DIAGNOSTIC_COREAPI.Line_Out('System Option = ' || wip_param_v_rec.system_option || '
');
5369: JTF_DIAGNOSTIC_COREAPI.Line_Out('Cost Type = ' || wip_param_v_rec.cost_type || '
');
5370:
5371:
5364: if (inv_param_rec.primary_cost_method = 2 ) then -- Average Costing
5365:
5366: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Method Average Parameters' ) ;
5367: JTF_DIAGNOSTIC_COREAPI.Line_Out('Default Completion Cost Source = ' || wip_param_v_rec.completion_cost_source_meaning || '
' );
5368: JTF_DIAGNOSTIC_COREAPI.Line_Out('System Option = ' || wip_param_v_rec.system_option || '
');
5369: JTF_DIAGNOSTIC_COREAPI.Line_Out('Cost Type = ' || wip_param_v_rec.cost_type || '
');
5370:
5371:
5372: if (wip_param_rec.system_option_id = 2 ) then
5365:
5366: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Method Average Parameters' ) ;
5367: JTF_DIAGNOSTIC_COREAPI.Line_Out('Default Completion Cost Source = ' || wip_param_v_rec.completion_cost_source_meaning || '
' );
5368: JTF_DIAGNOSTIC_COREAPI.Line_Out('System Option = ' || wip_param_v_rec.system_option || '
');
5369: JTF_DIAGNOSTIC_COREAPI.Line_Out('Cost Type = ' || wip_param_v_rec.cost_type || '
');
5370:
5371:
5372: if (wip_param_rec.system_option_id = 2 ) then
5373: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('This setting will cause lot based resources and overheads to be over-relieved. Select ''Use Actual Resources '' to avoid this problem.
Please see the ', l_url, l_desc , 'for more information') ;
5369: JTF_DIAGNOSTIC_COREAPI.Line_Out('Cost Type = ' || wip_param_v_rec.cost_type || '
');
5370:
5371:
5372: if (wip_param_rec.system_option_id = 2 ) then
5373: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('This setting will cause lot based resources and overheads to be over-relieved. Select ''Use Actual Resources '' to avoid this problem.
Please see the ', l_url, l_desc , 'for more information') ;
5374: end if ;
5375:
5376: if (wip_param_v_rec.completion_cost_source_meaning is null or
5377: wip_param_v_rec.system_option is null or
5377: wip_param_v_rec.system_option is null or
5378: wip_param_v_rec.cost_type is null or
5379: wip_param_v_rec.auto_compute_final_completion is null) then
5380:
5381: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Parameters not set for average cost method. Please see the ', l_url, l_desc, ' for information on how to setup WIP parameters') ;
5382: end if ;
5383: end if;
5384: end if ;
5385: end checkWIPDetails ;
5398: AND mtl.bom_enabled_flag = 'Y'
5399: AND mtl.organization_id = p_org_id) ;
5400:
5401:
5402: -- JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5403: -- JTF_DIAGNOSTIC_COREAPI.Tab2Print('There are ' || l_count || ' ATO items defined
');
5404:
5405: if l_count = 0 then
5406: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer ', 111874.1, ' for information on how to setup ATO parameters') ;
5399: AND mtl.organization_id = p_org_id) ;
5400:
5401:
5402: -- JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5403: -- JTF_DIAGNOSTIC_COREAPI.Tab2Print('There are ' || l_count || ' ATO items defined
');
5404:
5405: if l_count = 0 then
5406: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer ', 111874.1, ' for information on how to setup ATO parameters') ;
5407: end if;
5402: -- JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5403: -- JTF_DIAGNOSTIC_COREAPI.Tab2Print('There are ' || l_count || ' ATO items defined
');
5404:
5405: if l_count = 0 then
5406: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer ', 111874.1, ' for information on how to setup ATO parameters') ;
5407: end if;
5408:
5409: end CheckAtoAttributes ;
5410:
5418: begin
5419:
5420: l_found := 0 ;
5421:
5422: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5423:
5424: for cost_grp_rec in cost_grp_csr loop
5425: JTF_DIAGNOSTIC_COREAPI.Tab2Print('Cost Group ' || cost_grp_rec.cost_group || '
');
5426: l_found := 1 ;
5421:
5422: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5423:
5424: for cost_grp_rec in cost_grp_csr loop
5425: JTF_DIAGNOSTIC_COREAPI.Tab2Print('Cost Group ' || cost_grp_rec.cost_group || '
');
5426: l_found := 1 ;
5427: end loop ;
5428:
5429: if l_found = 0 then
5431: reportStr := 'No cost group defined for this organization. A cost group must be setup.' ;
5432: reportStr := reportStr || 'Then assign the WIP accounting class needed for the cost group' ;
5433:
5434: /*
5435: JTF_DIAGNOSTIC_COREAPI.Tab2Print('No cost group defined for this organization. A cost group must be setup
');
5436: JTF_DIAGNOSTIC_COREAPI.Tab2Print('Then assign the WIP accounting class needed for the cost group
');
5437: */
5438:
5439: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5432: reportStr := reportStr || 'Then assign the WIP accounting class needed for the cost group' ;
5433:
5434: /*
5435: JTF_DIAGNOSTIC_COREAPI.Tab2Print('No cost group defined for this organization. A cost group must be setup
');
5436: JTF_DIAGNOSTIC_COREAPI.Tab2Print('Then assign the WIP accounting class needed for the cost group
');
5437: */
5438:
5439: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5440:
5435: JTF_DIAGNOSTIC_COREAPI.Tab2Print('No cost group defined for this organization. A cost group must be setup
');
5436: JTF_DIAGNOSTIC_COREAPI.Tab2Print('Then assign the WIP accounting class needed for the cost group
');
5437: */
5438:
5439: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5440:
5441: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer to note:', '1079196.6', 'for more information') ;
5442: end if ;
5443:
5437: */
5438:
5439: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5440:
5441: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer to note:', '1079196.6', 'for more information') ;
5442: end if ;
5443:
5444: end checkCostGroup ;
5445:
5460: begin
5461:
5462: l_found := 0 ;
5463:
5464: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5465:
5466: for op_move_rec in op_move_csr loop
5467: l_found := 1 ;
5468: if op_move_rec.status_move_flag_code = 1 then
5470: else
5471: l_string := 'Not Allowed' ;
5472: end if ;
5473:
5474: JTF_DIAGNOSTIC_COREAPI.Tab2Print('Operation Moves ' || l_string || ' for shop floor status '
5475: || op_move_rec.shop_floor_status_code);
5476: end loop ;
5477:
5478: if l_found = 0 then
5478: if l_found = 0 then
5479: reportStr := 'No operation moves allowed with pending move transaction for this organization.';
5480: reportStr := reportStr || 'There is no move shop floor status created or being used. This is the intended functionality if the shop floor status is not used.' ;
5481:
5482: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5483: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer to note', 165224.1, 'for more information on how to setup these parameter values') ;
5484:
5485: end if ;
5486: end checkOpMove;
5479: reportStr := 'No operation moves allowed with pending move transaction for this organization.';
5480: reportStr := reportStr || 'There is no move shop floor status created or being used. This is the intended functionality if the shop floor status is not used.' ;
5481:
5482: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5483: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink('Please refer to note', 165224.1, 'for more information on how to setup these parameter values') ;
5484:
5485: end if ;
5486: end checkOpMove;
5487:
5494: into l_count
5495: FROM wip_employee_labor_rates wipl
5496: WHERE wipl.organization_id = p_org_id ;
5497:
5498: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5499: JTF_DIAGNOSTIC_COREAPI.Tab2Print('There are ' || l_count || ' employees defined');
5500:
5501: if l_count = 0 then
5502:
5495: FROM wip_employee_labor_rates wipl
5496: WHERE wipl.organization_id = p_org_id ;
5497:
5498: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5499: JTF_DIAGNOSTIC_COREAPI.Tab2Print('There are ' || l_count || ' employees defined');
5500:
5501: if l_count = 0 then
5502:
5503: reportStr := 'There are no employee labor rates defined for this organization' ;
5500:
5501: if l_count = 0 then
5502:
5503: reportStr := 'There are no employee labor rates defined for this organization' ;
5504: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr) ;
5505:
5506: reportStr := 'Please define employee labor rates for manual resource charge. ' ;
5507: reportStr := reportStr || 'Please refer to note' ;
5508:
5505:
5506: reportStr := 'Please define employee labor rates for manual resource charge. ' ;
5507: reportStr := reportStr || 'Please refer to note' ;
5508:
5509: JTF_DIAGNOSTIC_COREAPI.ActionWarningLink(reportStr, 157959.1, ' for more information') ;
5510:
5511: end if ;
5512:
5513:
5578: ' gcc12.code_combination_id(+) = wac.expense_account AND ' ||
5579: ' gcc13.code_combination_id(+) = wac.est_scrap_account AND ' ||
5580: ' gcc14.code_combination_id(+) = wac.est_scrap_var_account' ;
5581:
5582: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5583: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Accounting Classes Setup',null,'Y',row_limit);
5584:
5585: IF (dummy_num = row_limit) THEN
5586: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5579: ' gcc13.code_combination_id(+) = wac.est_scrap_account AND ' ||
5580: ' gcc14.code_combination_id(+) = wac.est_scrap_var_account' ;
5581:
5582: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5583: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Accounting Classes Setup',null,'Y',row_limit);
5584:
5585: IF (dummy_num = row_limit) THEN
5586: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5587: END IF;
5582: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5583: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'WIP Accounting Classes Setup',null,'Y',row_limit);
5584:
5585: IF (dummy_num = row_limit) THEN
5586: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5587: END IF;
5588:
5589: if dummy_num = 0 then
5590:
5590:
5591:
5592: reportStr := 'No accounting classes defined for this organization.' ;
5593:
5594: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
5595:
5596: reportStr := 'Please define the wip accounting classes for this organization. Please see the';
5597:
5598: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink(reportStr, l_url, l_desc ,' for more information') ;
5594: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
5595:
5596: reportStr := 'Please define the wip accounting classes for this organization. Please see the';
5597:
5598: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink(reportStr, l_url, l_desc ,' for more information') ;
5599:
5600: end if ;
5601:
5602: end checkAccClass ;
5616: 'AND ml1.lookup_type = ''SYS_YES_NO'' ' ||
5617: 'AND ml2.lookup_code = bp.inherit_phantom_op_seq ' ||
5618: 'AND ml2.lookup_type = ''SYS_YES_NO'' ';
5619:
5620: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5621: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'BOM Parameters',null,'Y',row_limit);
5622:
5623: IF (dummy_num = row_limit) THEN
5624: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5617: 'AND ml2.lookup_code = bp.inherit_phantom_op_seq ' ||
5618: 'AND ml2.lookup_type = ''SYS_YES_NO'' ';
5619:
5620: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5621: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'BOM Parameters',null,'Y',row_limit);
5622:
5623: IF (dummy_num = row_limit) THEN
5624: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5625: END IF;
5620: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5621: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'BOM Parameters',null,'Y',row_limit);
5622:
5623: IF (dummy_num = row_limit) THEN
5624: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5625: END IF;
5626:
5627: end checkBomParams ;
5628:
5661: 'ml1.lookup_type = ''WIP_LINE_SCHED_TYPE'' AND ' ||
5662: 'wl.organization_id = ' || p_org_id || ' AND ' ||
5663: 'mar.rule_id(+) = wl.atp_rule_id';
5664:
5665: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5666: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Work In Process Production Lines ',null,'Y',row_limit);
5667:
5668: IF (dummy_num = row_limit) THEN
5669: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5662: 'wl.organization_id = ' || p_org_id || ' AND ' ||
5663: 'mar.rule_id(+) = wl.atp_rule_id';
5664:
5665: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5666: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Work In Process Production Lines ',null,'Y',row_limit);
5667:
5668: IF (dummy_num = row_limit) THEN
5669: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5670: END IF;
5665: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5666: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Work In Process Production Lines ',null,'Y',row_limit);
5667:
5668: IF (dummy_num = row_limit) THEN
5669: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5670: END IF;
5671:
5672: if dummy_num = 0 then
5673: JTF_DIAGNOSTIC_COREAPI.Tab2Print('No production lines have been defined
');
5669: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5670: END IF;
5671:
5672: if dummy_num = 0 then
5673: JTF_DIAGNOSTIC_COREAPI.Tab2Print('No production lines have been defined
');
5674: end if ;
5675:
5676: end checkWipProdLines ;
5677:
5685: ' wsg.inactive_on ' ||
5686: ' FROM wip_schedule_groups wsg ' ||
5687: ' WHERE wsg.organization_id = ' || p_org_id ;
5688:
5689: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5690: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'In Process Schedule Groups',null,'Y',row_limit);
5691:
5692: IF (dummy_num = row_limit) THEN
5693: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5686: ' FROM wip_schedule_groups wsg ' ||
5687: ' WHERE wsg.organization_id = ' || p_org_id ;
5688:
5689: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5690: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'In Process Schedule Groups',null,'Y',row_limit);
5691:
5692: IF (dummy_num = row_limit) THEN
5693: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5694: END IF;
5689: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5690: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'In Process Schedule Groups',null,'Y',row_limit);
5691:
5692: IF (dummy_num = row_limit) THEN
5693: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5694: END IF;
5695:
5696: end checkWipSchGrps ;
5697:
5731: 'sign(fcq.max_processes) desc, ' ||
5732: 'fcq.concurrent_queue_name, ' ||
5733: 'fcq.application_id';
5734:
5735: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5736: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Manager',null,'Y',row_limit);
5737:
5738: IF (dummy_num = row_limit) THEN
5739: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5732: 'fcq.concurrent_queue_name, ' ||
5733: 'fcq.application_id';
5734:
5735: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5736: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Manager',null,'Y',row_limit);
5737:
5738: IF (dummy_num = row_limit) THEN
5739: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5740: END IF;
5735: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5736: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Manager',null,'Y',row_limit);
5737:
5738: IF (dummy_num = row_limit) THEN
5739: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5740: END IF;
5741:
5742: end displayConcLibProcess ;
5743:
5758: 'p.concurrent_program_id = r.concurrent_program_id(+) ' ||
5759: 'order by nvl(r.hold_flag,''N''), ' ||
5760: 'r.actual_completion_date desc';
5761:
5762: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5763: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Manager',null,'Y',row_limit);
5764:
5765: IF (dummy_num = row_limit) THEN
5766: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5759: 'order by nvl(r.hold_flag,''N''), ' ||
5760: 'r.actual_completion_date desc';
5761:
5762: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5763: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Manager',null,'Y',row_limit);
5764:
5765: IF (dummy_num = row_limit) THEN
5766: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5767: END IF;
5762: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5763: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Manager',null,'Y',row_limit);
5764:
5765: IF (dummy_num = row_limit) THEN
5766: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5767: END IF;
5768: end checkConcProcess;
5769:
5770: procedure docReferences is
5848: ' decode(use_finite_scheduler,1,''Yes'',2,''No'') Use_Finite_Scheduler'||
5849: ' from wip_parameters'||
5850: ' where organization_id = ' || p_org_id ;
5851:
5852: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
5853: 'WIP Parameters SETUP');
5854:
5855:
5856:
5855:
5856:
5857: */
5858: checkWipProfiles ;
5859: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5860:
5861: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Organization ' || get_org(p_org_id) ) ;
5862: checkWIPDetails ;
5863: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5857: */
5858: checkWipProfiles ;
5859: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5860:
5861: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Organization ' || get_org(p_org_id) ) ;
5862: checkWIPDetails ;
5863: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5864:
5865: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Item Attributes for Assemble To Order (ATO) discrete jobs') ;
5859: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5860:
5861: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Organization ' || get_org(p_org_id) ) ;
5862: checkWIPDetails ;
5863: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5864:
5865: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Item Attributes for Assemble To Order (ATO) discrete jobs') ;
5866: checkAtoAttributes ;
5867: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5861: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Organization ' || get_org(p_org_id) ) ;
5862: checkWIPDetails ;
5863: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5864:
5865: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Item Attributes for Assemble To Order (ATO) discrete jobs') ;
5866: checkAtoAttributes ;
5867: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5868:
5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;
5863: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5864:
5865: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Item Attributes for Assemble To Order (ATO) discrete jobs') ;
5866: checkAtoAttributes ;
5867: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5868:
5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;
5870: checkCostGroup ;
5871: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5865: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Item Attributes for Assemble To Order (ATO) discrete jobs') ;
5866: checkAtoAttributes ;
5867: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5868:
5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;
5870: checkCostGroup ;
5871: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5872:
5873: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Operation moves with Pending Move Transactions') ;
5867: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5868:
5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;
5870: checkCostGroup ;
5871: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5872:
5873: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Operation moves with Pending Move Transactions') ;
5874: checkOpMove;
5875: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5869: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Cost Group Setup for WIP Parameters') ;
5870: checkCostGroup ;
5871: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5872:
5873: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Operation moves with Pending Move Transactions') ;
5874: checkOpMove;
5875: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5876:
5877: JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Employee Labor Rates Definition') ;
5871: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5872:
5873: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Operation moves with Pending Move Transactions') ;
5874: checkOpMove;
5875: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5876:
5877: JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Employee Labor Rates Definition') ;
5878: checkEmpRate;
5879: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5873: JTF_DIAGNOSTIC_COREAPI.SectionPrint('Operation moves with Pending Move Transactions') ;
5874: checkOpMove;
5875: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5876:
5877: JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Employee Labor Rates Definition') ;
5878: checkEmpRate;
5879: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5880:
5881: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Accounting Classes Setup') ;
5875: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5876:
5877: JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Employee Labor Rates Definition') ;
5878: checkEmpRate;
5879: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5880:
5881: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Accounting Classes Setup') ;
5882: checkAccClass;
5883: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5877: JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Employee Labor Rates Definition') ;
5878: checkEmpRate;
5879: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5880:
5881: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Accounting Classes Setup') ;
5882: checkAccClass;
5883: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5884:
5885: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('BOM Parameters') ;
5879: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5880:
5881: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Accounting Classes Setup') ;
5882: checkAccClass;
5883: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5884:
5885: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('BOM Parameters') ;
5886: checkBomParams;
5887: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5881: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('WIP Accounting Classes Setup') ;
5882: checkAccClass;
5883: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5884:
5885: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('BOM Parameters') ;
5886: checkBomParams;
5887: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5888:
5889: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Production Lines') ;
5883: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5884:
5885: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('BOM Parameters') ;
5886: checkBomParams;
5887: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5888:
5889: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Production Lines') ;
5890: checkWipProdLines;
5891: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5885: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('BOM Parameters') ;
5886: checkBomParams;
5887: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5888:
5889: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Production Lines') ;
5890: checkWipProdLines;
5891: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5892:
5893: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('In Process Schedule Groups') ;
5887: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5888:
5889: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Production Lines') ;
5890: checkWipProdLines;
5891: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5892:
5893: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('In Process Schedule Groups') ;
5894: checkWipSchGrps;
5895: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5889: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('Work In Process Production Lines') ;
5890: checkWipProdLines;
5891: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5892:
5893: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('In Process Schedule Groups') ;
5894: checkWipSchGrps;
5895: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5896:
5897: /*
5891: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5892:
5893: -- JTF_DIAGNOSTIC_COREAPI.SectionPrint('In Process Schedule Groups') ;
5894: checkWipSchGrps;
5895: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5896:
5897: /*
5898: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCLIB') ;
5899: displayConcLibProcess('MRCLIB');
5894: checkWipSchGrps;
5895: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5896:
5897: /*
5898: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCLIB') ;
5899: displayConcLibProcess('MRCLIB');
5900: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5901:
5902: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCRLF') ;
5896:
5897: /*
5898: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCLIB') ;
5899: displayConcLibProcess('MRCLIB');
5900: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5901:
5902: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCRLF') ;
5903: checkConcProcess('MRCRLF');
5904: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5898: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCLIB') ;
5899: displayConcLibProcess('MRCLIB');
5900: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5901:
5902: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCRLF') ;
5903: checkConcProcess('MRCRLF');
5904: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5905: */
5906:
5900: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5901:
5902: JTF_DIAGNOSTIC_COREAPI.Tab1Print('MRCRLF') ;
5903: checkConcProcess('MRCRLF');
5904: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5905: */
5906:
5907: JTF_DIAGNOSTIC_COREAPI.SectionPrint('References') ;
5908: docReferences;
5903: checkConcProcess('MRCRLF');
5904: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5905: */
5906:
5907: JTF_DIAGNOSTIC_COREAPI.SectionPrint('References') ;
5908: docReferences;
5909: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5910:
5911: EXCEPTION
5905: */
5906:
5907: JTF_DIAGNOSTIC_COREAPI.SectionPrint('References') ;
5908: docReferences;
5909: JTF_DIAGNOSTIC_COREAPI.BRPrint ;
5910:
5911: EXCEPTION
5912: WHEN OTHERS then
5913:
5928: row_limit number;
5929: BEGIN
5930: row_limit := 1000;
5931:
5932: JTF_DIAGNOSTIC_COREAPI.Display_table('WIP_COST_TXN_INTERFACE', 'Pending Resource Transactions',
5933: 'where organization_id = ' || p_org_id,
5934: 'order by transaction_date',
5935: 'N'
5936: );
5948: 'where wi.transaction_id = wtie.transaction_id ' ||
5949: 'and wi.organization_id = ' || p_org_id ||
5950: ' order by wi.transaction_date, wi.wip_entity_id, wi.wip_entity_name' ;
5951:
5952: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Resource Transactions Errors',null,'Y',row_limit) ;
5953:
5954: IF (dummy_num = row_limit) THEN
5955: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5956: END IF;
5951:
5952: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Resource Transactions Errors',null,'Y',row_limit) ;
5953:
5954: IF (dummy_num = row_limit) THEN
5955: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5956: END IF;
5957:
5958: JTF_DIAGNOSTIC_COREAPI.Display_table('WIP_MOVE_TXN_INTERFACE', 'Pending Move Transactions',
5959: 'where organization_id = ' || p_org_id,
5954: IF (dummy_num = row_limit) THEN
5955: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5956: END IF;
5957:
5958: JTF_DIAGNOSTIC_COREAPI.Display_table('WIP_MOVE_TXN_INTERFACE', 'Pending Move Transactions',
5959: 'where organization_id = ' || p_org_id,
5960: 'order by transaction_date',
5961: 'N'
5962: );
5974: 'where wi.transaction_id = wtie.transaction_id ' ||
5975: 'and wi.organization_id = ' || p_org_id ||
5976: ' order by wi.transaction_date, wi.wip_entity_id, wi.wip_entity_name' ;
5977:
5978: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Move Transactions Errors',null,'Y',row_limit) ;
5979:
5980: IF (dummy_num = row_limit) THEN
5981: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5982: END IF;
5977:
5978: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Move Transactions Errors',null,'Y',row_limit) ;
5979:
5980: IF (dummy_num = row_limit) THEN
5981: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5982: END IF;
5983:
5984: JTF_DIAGNOSTIC_COREAPI.Display_table('WIP_JOB_SCHEDULE_INTERFACE', 'Pending Jobs ',
5985: 'where organization_id = ' || p_org_id,
5980: IF (dummy_num = row_limit) THEN
5981: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
5982: END IF;
5983:
5984: JTF_DIAGNOSTIC_COREAPI.Display_table('WIP_JOB_SCHEDULE_INTERFACE', 'Pending Jobs ',
5985: 'where organization_id = ' || p_org_id,
5986: 'order by group_id, header_id, interface_id',
5987: 'N'
5988: );
6001: 'where wjsi.interface_id = wie.interface_id ' ||
6002: 'and wjsi.organization_id = ' || p_org_id ||
6003: ' order by wjsi.group_id, wjsi.interface_id, wjsi.wip_entity_id, wjsi.job_name' ;
6004:
6005: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Jobs Error',null,'Y',row_limit) ;
6006:
6007: IF (dummy_num = row_limit) THEN
6008: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
6009: END IF;
6004:
6005: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Jobs Error',null,'Y',row_limit) ;
6006:
6007: IF (dummy_num = row_limit) THEN
6008: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
6009: END IF;
6010:
6011: JTF_DIAGNOSTIC_COREAPI.Display_table('MTL_TRANSACTIONS_INTERFACE', 'Transactions Open Interface',
6012: 'where transaction_source_type_id = 5 and organization_id = ' || p_org_id ||
6007: IF (dummy_num = row_limit) THEN
6008: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
6009: END IF;
6010:
6011: JTF_DIAGNOSTIC_COREAPI.Display_table('MTL_TRANSACTIONS_INTERFACE', 'Transactions Open Interface',
6012: 'where transaction_source_type_id = 5 and organization_id = ' || p_org_id ||
6013: ' and process_flag = 3',
6014: 'order by transaction_date',
6015: 'N'
6013: ' and process_flag = 3',
6014: 'order by transaction_date',
6015: 'N'
6016: );
6017: JTF_DIAGNOSTIC_COREAPI.Display_table('MTL_MATERIAL_TRANSACTIONS_TEMP', 'Pending Material Transactions',
6018: 'where transaction_source_type_id = 5 and organization_id = ' || p_org_id ||
6019: ' and process_flag = ''E'' ' ,
6020: 'order by transaction_date',
6021: 'N'
6020: 'order by transaction_date',
6021: 'N'
6022: );
6023:
6024: JTF_DIAGNOSTIC_COREAPI.Display_table('MTL_MATERIAL_TRANSACTIONS', 'Material Transactions',
6025: 'where transaction_source_type_id = 5 and organization_id = ' || p_org_id ||
6026: ' and costed_flag = ''E'' ' ,
6027: 'order by transaction_date',
6028: 'N'
6031:
6032: /*
6033:
6034: sqltxt := 'select * from wip_cost_txn_interface where organization_id = ' || p_org_id ;
6035: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6036: 'Pending Resource Transactions');
6037: sqltxt := 'select * from wip_job_schedule_interface where organization_id = ' || p_org_id ;
6038: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6039: 'Pending Mass Load Transactions');
6034: sqltxt := 'select * from wip_cost_txn_interface where organization_id = ' || p_org_id ;
6035: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6036: 'Pending Resource Transactions');
6037: sqltxt := 'select * from wip_job_schedule_interface where organization_id = ' || p_org_id ;
6038: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6039: 'Pending Mass Load Transactions');
6040: sqltxt := 'select * from wip_job_dtls_interface ' ;
6041: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6042: 'Mass Load Errors');
6037: sqltxt := 'select * from wip_job_schedule_interface where organization_id = ' || p_org_id ;
6038: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6039: 'Pending Mass Load Transactions');
6040: sqltxt := 'select * from wip_job_dtls_interface ' ;
6041: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6042: 'Mass Load Errors');
6043: sqltxt := 'select * from wip_interface_errors ';
6044: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6045: ' Interface Errors');
6040: sqltxt := 'select * from wip_job_dtls_interface ' ;
6041: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6042: 'Mass Load Errors');
6043: sqltxt := 'select * from wip_interface_errors ';
6044: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6045: ' Interface Errors');
6046: sqltxt := 'select * from wip_move_txn_interface where organization_id = ' || p_org_id ;
6047: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6048: 'Pending Move Transactions');
6043: sqltxt := 'select * from wip_interface_errors ';
6044: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6045: ' Interface Errors');
6046: sqltxt := 'select * from wip_move_txn_interface where organization_id = ' || p_org_id ;
6047: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6048: 'Pending Move Transactions');
6049: sqltxt := 'select * from mtl_transactions_interface where transaction_source_type_id = 5 and organization_id = ' || p_org_id ;
6050: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6051: 'Transaction Open Interface (MTI)');
6046: sqltxt := 'select * from wip_move_txn_interface where organization_id = ' || p_org_id ;
6047: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6048: 'Pending Move Transactions');
6049: sqltxt := 'select * from mtl_transactions_interface where transaction_source_type_id = 5 and organization_id = ' || p_org_id ;
6050: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6051: 'Transaction Open Interface (MTI)');
6052: sqltxt := 'select * from mtl_material_transactions_temp where transaction_source_type_id = 5 and organization_id = ' || p_org_id ;
6053: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6054: 'Pending Material Transactions (MMTT)');
6049: sqltxt := 'select * from mtl_transactions_interface where transaction_source_type_id = 5 and organization_id = ' || p_org_id ;
6050: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6051: 'Transaction Open Interface (MTI)');
6052: sqltxt := 'select * from mtl_material_transactions_temp where transaction_source_type_id = 5 and organization_id = ' || p_org_id ;
6053: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
6054: 'Pending Material Transactions (MMTT)');
6055: */
6056:
6057: END Pending_txns ;