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

[Home] [Help]

APPS.BOM_DIAGUNITTEST_TSDATA dependencies on BOM_DIAG_TEMP_TAB

Line 174: delete from bom_diag_temp_tab; -- Clear the temporary tables

170: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
171:
172: /* Script to verify records in mtl_system_items_b table */
173: Begin
174: delete from bom_diag_temp_tab; -- Clear the temporary tables
175: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_B',l_oracle_schema) Loop
176: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
177:
178: sql_stmt := '';

Line 179: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

175: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_B',l_oracle_schema) Loop
176: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
177:
178: sql_stmt := '';
179: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
180: ' char_col1,char_col2) '||
181: ' SELECT msib.inventory_item_id '||
182: ' ,msib.organization_id '||
183: ' ,'''||l_varchar_col_rec.column_name||''' '||

Line 202: ' From bom_diag_temp_tab where 1=1 ';

198: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||
199: ' Organization_id "Organization id", '||
200: ' Char_Col1 "Column Name", '||
201: ' Char_Col2 "Column Value" '||
202: ' From bom_diag_temp_tab where 1=1 ';
203:
204: sqltxt := sqltxt || ' and rownum< '||row_limit;
205: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
206:

Line 219: delete from bom_diag_temp_tab; -- Clear the temporary tables

215: /* End of mtl_system_items_b script */
216:
217: /* Script to verify records in mtl_system_items_tl table */
218: Begin
219: delete from bom_diag_temp_tab; -- Clear the temporary tables
220: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_TL',l_oracle_schema) Loop
221: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
222:
223: sql_stmt := '';

Line 227: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

223: sql_stmt := '';
224:
225: /* If (upper(l_varchar_col_rec.column_name) NOT IN ('DESCRIPTION','LONG_DESCRIPTION')) Then
226: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
not description, long description');
227: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
228: ' char_col3,char_col1,char_col2) '||
229: ' SELECT msitl.inventory_item_id '||
230: ' ,msitl.organization_id '||
231: ' ,msitl.language '||

Line 243: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

239: */
240: If (upper(l_varchar_col_rec.column_name) IN ('DESCRIPTION','LONG_DESCRIPTION')) Then
241: If (upper(l_varchar_col_rec.column_name)='DESCRIPTION') Then
242: /*JTF_DIAGNOSTIC_COREAPI.Line_Out('
description '); */
243: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
244: ' char_col3,char_col1,description) '||
245: ' SELECT msitl.inventory_item_id '||
246: ' ,msitl.organization_id '||
247: ' ,msitl.language '||

Line 258: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

254: ' AND rownum < '||(row_limit/25);
255:
256: ElsIf (upper(l_varchar_col_rec.column_name)='LONG_DESCRIPTION') Then
257: /*JTF_DIAGNOSTIC_COREAPI.Line_Out('
long description');*/
258: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
259: ' char_col3,char_col1,Long_Description) '||
260: ' SELECT msitl.inventory_item_id '||
261: ' ,msitl.organization_id '||
262: ' ,msitl.language '||

Line 287: ' From bom_diag_temp_tab where 1=1 ';

283: ' Char_col3 "Language", '||
284: ' Char_Col1 "Column Name", '||
285: ' Description "Description", '||
286: ' Long_Description "Long Description" '||
287: ' From bom_diag_temp_tab where 1=1 ';
288:
289: sqltxt := sqltxt || ' and rownum< '||row_limit;
290: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col3,char_col1';
291:

Line 304: delete from bom_diag_temp_tab; -- Clear the temporary tables

300: /* End of mtl_system_items_tl script */
301:
302: /* Script to verify records in mtl_item_revisions_b table */
303: Begin
304: delete from bom_diag_temp_tab; -- Clear the temporary tables
305: For l_varchar_col_rec in c_varchar_cols_cur('MTL_ITEM_REVISIONS_B',l_oracle_schema) Loop
306: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
307:
308: sql_stmt := '';

Line 309: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

305: For l_varchar_col_rec in c_varchar_cols_cur('MTL_ITEM_REVISIONS_B',l_oracle_schema) Loop
306: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
307:
308: sql_stmt := '';
309: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
310: ' char_col3,num_col1,char_col1,char_col2) '||
311: ' SELECT mirb.inventory_item_id '||
312: ' ,mirb.organization_id '||
313: ' ,mirb.revision '||

Line 336: ' From bom_diag_temp_tab where 1=1 ';

332: ' Char_Col3 "Revision", '||
333: ' Num_Col1 "Revision Id", '||
334: ' Char_Col1 "Column Name", '||
335: ' Char_Col2 "Column Value" '||
336: ' From bom_diag_temp_tab where 1=1 ';
337:
338: sqltxt := sqltxt || ' and rownum< '||row_limit;
339: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
340:

Line 353: delete from bom_diag_temp_tab; -- Clear the temporary tables

349: /* End of mtl_item_revisions_b script */
350:
351: /* Script to verify records in mtl_item_revisions_tl table */
352: Begin
353: delete from bom_diag_temp_tab; -- Clear the temporary tables
354: For l_varchar_col_rec in c_varchar_cols_cur('MTL_ITEM_REVISIONS_TL',l_oracle_schema) Loop
355: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
356:
357: sql_stmt := '';

Line 358: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

354: For l_varchar_col_rec in c_varchar_cols_cur('MTL_ITEM_REVISIONS_TL',l_oracle_schema) Loop
355: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
356:
357: sql_stmt := '';
358: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
359: ' num_col1,char_col3,char_col1,char_col2) '||
360: ' SELECT mirtl.inventory_item_id '||
361: ' ,mirtl.organization_id '||
362: ' ,mirtl.revision_id '||

Line 385: ' From bom_diag_temp_tab where 1=1 ';

381: ' Num_Col1 "Revision Id", '||
382: ' Char_Col3 "Language", '||
383: ' Char_Col1 "Column Name", '||
384: ' Char_Col2 "Column Value" '||
385: ' From bom_diag_temp_tab where 1=1 ';
386:
387: sqltxt := sqltxt || ' and rownum< '||row_limit;
388: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, num_col1,char_col3,char_col1';
389:

Line 402: delete from bom_diag_temp_tab; -- Clear the temporary tables

398: /* End of mtl_item_revisions_tl script */
399:
400: /* Script to verify records in mtl_descr_element_values table */
401: Begin
402: delete from bom_diag_temp_tab; -- Clear the temporary tables
403: For l_varchar_col_rec in c_varchar_cols_cur('MTL_DESCR_ELEMENT_VALUES',l_oracle_schema) Loop
404: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
405:
406: sql_stmt := '';

Line 407: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, '||

403: For l_varchar_col_rec in c_varchar_cols_cur('MTL_DESCR_ELEMENT_VALUES',l_oracle_schema) Loop
404: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
405:
406: sql_stmt := '';
407: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, '||
408: ' char_col3,num_col1,char_col1,char_col2) '||
409: ' SELECT mdev.inventory_item_id '||
410: ' ,mdev.element_name '||
411: ' ,mdev.element_sequence '||

Line 431: ' From bom_diag_temp_tab where 1=1 ';

427: ' Char_Col3 "Element Name", '||
428: ' Num_Col1 "Element Sequence", '||
429: ' Char_Col1 "Column Name", '||
430: ' Char_Col2 "Column Value" '||
431: ' From bom_diag_temp_tab where 1=1 ';
432:
433: sqltxt := sqltxt || ' and rownum< '||row_limit;
434: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
435:

Line 447: delete from bom_diag_temp_tab; -- Clear the temporary tables

443: /* End of mtl_descr_element_values script */
444:
445: /* Script to verify records in mtl_pending_item_status table */
446: Begin
447: delete from bom_diag_temp_tab; -- Clear the temporary tables
448: For l_varchar_col_rec in c_varchar_cols_cur('MTL_PENDING_ITEM_STATUS',l_oracle_schema) Loop
449: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
450:
451: sql_stmt := '';

Line 452: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

448: For l_varchar_col_rec in c_varchar_cols_cur('MTL_PENDING_ITEM_STATUS',l_oracle_schema) Loop
449: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
450:
451: sql_stmt := '';
452: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
453: ' char_col3,Date_col1,char_col1,char_col2) '||
454: ' SELECT mpis.inventory_item_id '||
455: ' ,mpis.Organization_id '||
456: ' ,mpis.STATUS_CODE '||

Line 479: ' From bom_diag_temp_tab where 1=1 ';

475: ' Char_Col3 "Status Code", '||
476: ' to_char(Date_Col1,''DD-MON-YYYY HH24:MI:SS'') "Effectivity Date", '||
477: ' Char_Col1 "Column Name", '||
478: ' Char_Col2 "Column Value" '||
479: ' From bom_diag_temp_tab where 1=1 ';
480:
481: sqltxt := sqltxt || ' and rownum< '||row_limit;
482: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Date_col1,char_col1';
483:

Line 496: delete from bom_diag_temp_tab; -- Clear the temporary tables

492:
493:
494: /* Script to verify records in mtl_cross_references_b table */
495: Begin
496: delete from bom_diag_temp_tab; -- Clear the temporary tables
497: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CROSS_REFERENCES_B',l_oracle_schema) Loop
498: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
499:
500: sql_stmt := '';

Line 501: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

497: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CROSS_REFERENCES_B',l_oracle_schema) Loop
498: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
499:
500: sql_stmt := '';
501: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
502: ' char_col3,char_col4,char_col1,char_col2) '||
503: ' SELECT mcr.inventory_item_id '||
504: ' ,mcr.Organization_id '||
505: ' ,MCR.CROSS_REFERENCE_TYPE '||

Line 529: ' From bom_diag_temp_tab where 1=1 ';

525: ' Char_Col3 "Cross Reference Type", '||
526: ' Char_Col4 "Cross Reference", '||
527: ' Char_Col1 "Column Name", '||
528: ' Char_Col2 "Column Value" '||
529: ' From bom_diag_temp_tab where 1=1 ';
530:
531: sqltxt := sqltxt || ' and rownum< '||row_limit;
532: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col4,char_col1';
533:

Line 545: delete from bom_diag_temp_tab; -- Clear the temporary tables

541: /* End of mtl_cross_references_b script */
542:
543: /* Script to verify records in mtl_cross_references_tl table */
544: Begin
545: delete from bom_diag_temp_tab; -- Clear the temporary tables
546: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CROSS_REFERENCES_TL',l_oracle_schema) Loop
547: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
548:
549: sql_stmt := '';

Line 550: sql_stmt :=' Insert into bom_diag_temp_tab (num_col1, '||

546: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CROSS_REFERENCES_TL',l_oracle_schema) Loop
547: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
548:
549: sql_stmt := '';
550: sql_stmt :=' Insert into bom_diag_temp_tab (num_col1, '||
551: ' char_col4,char_col1,char_col2) '||
552: ' SELECT mcrt.cross_reference_id '||
553: ' ,mcrt.language '||
554: ' ,'''||l_varchar_col_rec.column_name||''' '||

Line 575: ' From bom_diag_temp_tab where 1=1 ';

571: sqltxt:=' Select num_col1 "Cross Reference Id", '||
572: ' Char_Col4 "Language", '||
573: ' Char_Col1 "Column Name", '||
574: ' Char_Col2 "Column Value" '||
575: ' From bom_diag_temp_tab where 1=1 ';
576:
577: sqltxt := sqltxt || ' and rownum< '||row_limit;
578: sqltxt :=sqltxt||' order by num_col1,char_col4,char_col1';
579:

Line 591: delete from bom_diag_temp_tab; -- Clear the temporary tables

587: /* End of mtl_cross_references_tl script */
588:
589: /* Script to verify records in mtl_customer_item_xrefs table */
590: Begin
591: delete from bom_diag_temp_tab; -- Clear the temporary tables
592: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CUSTOMER_ITEM_XREFS',l_oracle_schema) Loop
593: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
594:
595: sql_stmt := '';

Line 596: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

592: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CUSTOMER_ITEM_XREFS',l_oracle_schema) Loop
593: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
594:
595: sql_stmt := '';
596: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
597: ' Num_col1,char_col1,char_col2) '||
598: ' SELECT mcix.inventory_item_id '||
599: ' ,mcix.Master_Organization_id '||
600: ' ,MCIX.CUSTOMER_ITEM_ID '||

Line 623: ' From bom_diag_temp_tab where 1=1 ';

619: ' Organization_id "Master Organization id", '||
620: ' Num_Col1 "Customer Item Id", '||
621: ' Char_Col1 "Column Name", '||
622: ' Char_Col2 "Column Value" '||
623: ' From bom_diag_temp_tab where 1=1 ';
624:
625: sqltxt := sqltxt || ' and rownum< '||row_limit;
626: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col1';
627:

Line 639: delete from bom_diag_temp_tab; -- Clear the temporary tables

635: /* End of mtl_customer_item_xrefs script */
636:
637: /* Script to verify records in mtl_mfg_part_numbers table */
638: Begin
639: delete from bom_diag_temp_tab; -- Clear the temporary tables
640: For l_varchar_col_rec in c_varchar_cols_cur('MTL_MFG_PART_NUMBERS',l_oracle_schema) Loop
641: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
642:
643: sql_stmt := '';

Line 644: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

640: For l_varchar_col_rec in c_varchar_cols_cur('MTL_MFG_PART_NUMBERS',l_oracle_schema) Loop
641: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
642:
643: sql_stmt := '';
644: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
645: ' Num_col1,char_col3,char_col1,char_col2) '||
646: ' SELECT mmpn.inventory_item_id '||
647: ' ,mmpn.Organization_id '||
648: ' ,MMPN.MANUFACTURER_ID '||

Line 673: ' From bom_diag_temp_tab where 1=1 ';

669: ' Num_Col1 "Manufacturer Id", '||
670: ' Char_Col3 "Mfg Part Num", '||
671: ' Char_Col1 "Column Name", '||
672: ' Char_Col2 "Column Value" '||
673: ' From bom_diag_temp_tab where 1=1 ';
674:
675: sqltxt := sqltxt || ' and rownum< '||row_limit;
676: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col3,char_col1';
677:

Line 689: delete from bom_diag_temp_tab; -- Clear the temporary tables

685: /* End of mtl_mfg_part_numbers script */
686:
687: /* Script to verify records in mtl_rtg_item_revisions table */
688: Begin
689: delete from bom_diag_temp_tab; -- Clear the temporary tables
690: For l_varchar_col_rec in c_varchar_cols_cur('MTL_RTG_ITEM_REVISIONS',l_oracle_schema) Loop
691: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
692:
693: sql_stmt := '';

Line 694: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

690: For l_varchar_col_rec in c_varchar_cols_cur('MTL_RTG_ITEM_REVISIONS',l_oracle_schema) Loop
691: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
692:
693: sql_stmt := '';
694: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
695: ' char_col3,char_col1,char_col2) '||
696: ' SELECT mrir.inventory_item_id '||
697: ' ,mrir.organization_id '||
698: ' ,MRIR.PROCESS_REVISION '||

Line 719: ' From bom_diag_temp_tab where 1=1 ';

715: ' Organization_id "Organization id", '||
716: ' Char_Col3 "Process Revision", '||
717: ' Char_Col1 "Column Name", '||
718: ' Char_Col2 "Column Value" '||
719: ' From bom_diag_temp_tab where 1=1 ';
720:
721: sqltxt := sqltxt || ' and rownum< '||row_limit;
722: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
723:

Line 736: delete from bom_diag_temp_tab; -- Clear the temporary tables

732: /* End of mtl_rtg_item_revisions script */
733:
734: /* Script to verify records in mtl_related_items table */
735: Begin
736: delete from bom_diag_temp_tab; -- Clear the temporary tables
737: For l_varchar_col_rec in c_varchar_cols_cur('MTL_RELATED_ITEMS',l_oracle_schema) Loop
738: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
739:
740: sql_stmt := '';

Line 741: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

737: For l_varchar_col_rec in c_varchar_cols_cur('MTL_RELATED_ITEMS',l_oracle_schema) Loop
738: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
739:
740: sql_stmt := '';
741: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
742: ' Num_col1,Num_col2,char_col1,char_col2) '||
743: ' SELECT mri.inventory_item_id '||
744: ' ,mri.Organization_id '||
745: ' ,MRI.RELATED_ITEM_ID '||

Line 770: ' From bom_diag_temp_tab where 1=1 ';

766: ' Num_Col1 "Related Item Id", '||
767: ' Num_Col2 "Relationship Type Id", '||
768: ' Char_Col1 "Column Name", '||
769: ' Char_Col2 "Column Value" '||
770: ' From bom_diag_temp_tab where 1=1 ';
771:
772: sqltxt := sqltxt || ' and rownum< '||row_limit;
773: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,Num_col2,char_col1';
774:

Line 803: delete from bom_diag_temp_tab; -- Clear the temporary tables

799: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
800:
801: /* Script to verify records in BOM_STRUCTURES_B table */
802: Begin
803: delete from bom_diag_temp_tab; -- Clear the temporary tables
804: For l_varchar_col_rec in c_varchar_cols_cur('BOM_STRUCTURES_B',l_oracle_schema) Loop
805: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
806:
807: sql_stmt := '';

Line 808: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

804: For l_varchar_col_rec in c_varchar_cols_cur('BOM_STRUCTURES_B',l_oracle_schema) Loop
805: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
806:
807: sql_stmt := '';
808: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
809: ' char_col3,Num_col1,char_col1,char_col2) '||
810: ' SELECT bsb.assembly_item_id '||
811: ' ,bsb.Organization_id '||
812: ' ,bsb.ALTERNATE_BOM_DESIGNATOR '||

Line 835: ' From bom_diag_temp_tab where 1=1 ';

831: ' char_Col3 "ALTERNATE BOM DESIGNATOR", '||
832: ' Num_Col1 "BILL SEQUENCE ID", '||
833: ' Char_Col1 "Column Name", '||
834: ' Char_Col2 "Column Value" '||
835: ' From bom_diag_temp_tab where 1=1 ';
836:
837: sqltxt := sqltxt || ' and rownum< '||row_limit;
838: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,char_col1';
839:

Line 851: delete from bom_diag_temp_tab; -- Clear the temporary tables

847: /* End of bom_bill_of_materials script */
848:
849: /* Script to verify records in BOM_COMPONENTS_B table */
850: Begin
851: delete from bom_diag_temp_tab; -- Clear the temporary tables
852: For l_varchar_col_rec in c_varchar_cols_cur('BOM_COMPONENTS_B',l_oracle_schema) Loop
853: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
854:
855: sql_stmt := '';

Line 856: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

852: For l_varchar_col_rec in c_varchar_cols_cur('BOM_COMPONENTS_B',l_oracle_schema) Loop
853: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
854:
855: sql_stmt := '';
856: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
857: ' char_col3,Num_col1,Num_col2,Num_col3,num_col4,char_col1,char_col2)'||
858: ' SELECT bsb.assembly_item_id '||
859: ' ,bsb.Organization_id '||
860: ' ,bsb.ALTERNATE_BOM_DESIGNATOR '||

Line 891: ' From bom_diag_temp_tab where 1=1 ';

887: ' Num_Col3 "COMPONENT ITEM ID", '||
888: ' Num_Col4 "COMPONENT SEQUENCE ID", '||
889: ' Char_Col1 "Column Name", '||
890: ' Char_Col2 "Column Value" '||
891: ' From bom_diag_temp_tab where 1=1 ';
892:
893: sqltxt := sqltxt || ' and rownum< '||row_limit;
894: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,Num_col3,char_col1';
895:

Line 907: delete from bom_diag_temp_tab; -- Clear the temporary tables

903: /* End of bom_inventory_components script */
904:
905: /* Script to verify records in bom_reference_designators table */
906: Begin
907: delete from bom_diag_temp_tab; -- Clear the temporary tables
908: For l_varchar_col_rec in c_varchar_cols_cur('BOM_REFERENCE_DESIGNATORS',l_oracle_schema) Loop
909: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
910:
911: sql_stmt := '';

Line 912: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

908: For l_varchar_col_rec in c_varchar_cols_cur('BOM_REFERENCE_DESIGNATORS',l_oracle_schema) Loop
909: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
910:
911: sql_stmt := '';
912: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
913: ' char_col3,Num_col1,Num_col2,char_col4,char_col1,char_col2) '||
914: ' SELECT bsb.assembly_item_id '||
915: ' ,bsb.Organization_id '||
916: ' ,bsb.ALTERNATE_BOM_DESIGNATOR '||

Line 946: ' From bom_diag_temp_tab where 1=1 ';

942: ' Num_Col2 "COMPONENT SEQUENCE ID", '||
943: ' Char_Col4 "COMPONENT REFERENCE DESIGNATOR", '||
944: ' Char_Col1 "Column Name", '||
945: ' Char_Col2 "Column Value" '||
946: ' From bom_diag_temp_tab where 1=1 ';
947:
948: sqltxt := sqltxt || ' and rownum< '||row_limit;
949: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
950:

Line 962: delete from bom_diag_temp_tab; -- Clear the temporary tables

958: /* End of bom_reference_designators script */
959:
960: /* Script to verify records in bom_substitute_components table */
961: Begin
962: delete from bom_diag_temp_tab; -- Clear the temporary tables
963: For l_varchar_col_rec in c_varchar_cols_cur('BOM_SUBSTITUTE_COMPONENTS',l_oracle_schema) Loop
964: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
965:
966: sql_stmt := '';

Line 967: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

963: For l_varchar_col_rec in c_varchar_cols_cur('BOM_SUBSTITUTE_COMPONENTS',l_oracle_schema) Loop
964: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
965:
966: sql_stmt := '';
967: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
968: ' char_col3,Num_col1,Num_col2,Num_col3,char_col1,char_col2) '||
969: ' SELECT bsb.assembly_item_id '||
970: ' ,bsb.Organization_id '||
971: ' ,bsb.ALTERNATE_BOM_DESIGNATOR '||

Line 1001: ' From bom_diag_temp_tab where 1=1 ';

997: ' Num_Col2 "COMPONENT SEQUENCE ID", '||
998: ' Num_col3 "SUBSTITUTE COMPONENT ID", '||
999: ' Char_Col1 "Column Name", '||
1000: ' Char_Col2 "Column Value" '||
1001: ' From bom_diag_temp_tab where 1=1 ';
1002:
1003: sqltxt := sqltxt || ' and rownum< '||row_limit;
1004: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
1005:

Line 1021: delete from bom_diag_temp_tab; -- Clear the temporary tables

1017: /* Start of Scripts to check for trailing spaces in Rtg Tables */
1018:
1019: /* Script to verify records in bom_operational_routings table */
1020: Begin
1021: delete from bom_diag_temp_tab; -- Clear the temporary tables
1022: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATIONAL_ROUTINGS',l_oracle_schema) Loop
1023: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1024:
1025: sql_stmt := '';

Line 1026: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

1022: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATIONAL_ROUTINGS',l_oracle_schema) Loop
1023: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1024:
1025: sql_stmt := '';
1026: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1027: ' char_col3,Num_col1,char_col1,char_col2) '||
1028: ' SELECT bor.assembly_item_id '||
1029: ' ,bor.Organization_id '||
1030: ' ,BOR.ALTERNATE_ROUTING_DESIGNATOR '||

Line 1054: ' From bom_diag_temp_tab where 1=1 ';

1050: ' char_Col3 "ALTERNATE ROUTING DESIGNATOR", '||
1051: ' Num_Col1 "ROUTING SEQUENCE ID", '||
1052: ' Char_Col1 "Column Name", '||
1053: ' Char_Col2 "Column Value" '||
1054: ' From bom_diag_temp_tab where 1=1 ';
1055:
1056: sqltxt := sqltxt || ' and rownum< '||row_limit;
1057: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1058:

Line 1070: delete from bom_diag_temp_tab; -- Clear the temporary tables

1066: /* End of bom_operational_routings script */
1067:
1068: /* Script to verify records in bom_operation_sequences table */
1069: Begin
1070: delete from bom_diag_temp_tab; -- Clear the temporary tables
1071: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_SEQUENCES',l_oracle_schema) Loop
1072: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1073:
1074: sql_stmt := '';

Line 1075: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

1071: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_SEQUENCES',l_oracle_schema) Loop
1072: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1073:
1074: sql_stmt := '';
1075: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1076: ' char_col3,Num_col1,Num_col2,char_col1,char_col2) '||
1077: ' SELECT bor.assembly_item_id '||
1078: ' ,bor.Organization_id '||
1079: ' ,BOR.ALTERNATE_ROUTING_DESIGNATOR '||

Line 1106: ' From bom_diag_temp_tab where 1=1 ';

1102: ' Num_Col1 "ROUTING SEQUENCE ID", '||
1103: ' Num_Col2 "OPERATION SEQUENCE ID", '||
1104: ' Char_Col1 "Column Name", '||
1105: ' Char_Col2 "Column Value" '||
1106: ' From bom_diag_temp_tab where 1=1 ';
1107:
1108: sqltxt := sqltxt || ' and rownum< '||row_limit;
1109: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1110:

Line 1122: delete from bom_diag_temp_tab; -- Clear the temporary tables

1118: /* End of bom_operation_sequences script */
1119:
1120: /* Script to verify records in bom_operation_resources table */
1121: Begin
1122: delete from bom_diag_temp_tab; -- Clear the temporary tables
1123: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_RESOURCES',l_oracle_schema) Loop
1124: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1125:
1126: sql_stmt := '';

Line 1127: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

1123: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_RESOURCES',l_oracle_schema) Loop
1124: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1125:
1126: sql_stmt := '';
1127: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1128: ' char_col3,Num_col1,Num_col2,Num_col3,Num_col4,char_col1,char_col2)'||
1129: ' SELECT bor.assembly_item_id '||
1130: ' ,bor.Organization_id '||
1131: ' ,BOR.ALTERNATE_ROUTING_DESIGNATOR '||

Line 1164: ' From bom_diag_temp_tab where 1=1 ';

1160: ' Num_Col3 "RESOURCE SEQ NUM", '||
1161: ' Num_Col4 "RESOURCE ID", '||
1162: ' Char_Col1 "Column Name", '||
1163: ' Char_Col2 "Column Value" '||
1164: ' From bom_diag_temp_tab where 1=1 ';
1165:
1166: sqltxt := sqltxt || ' and rownum< '||row_limit;
1167: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1168:

Line 1180: delete from bom_diag_temp_tab; -- Clear the temporary tables

1176: /* End of bom_operation_resources script */
1177:
1178: /* Script to verify records in bom_sub_operation_resources table */
1179: Begin
1180: delete from bom_diag_temp_tab; -- Clear the temporary tables
1181: For l_varchar_col_rec in c_varchar_cols_cur('BOM_SUB_OPERATION_RESOURCES',l_oracle_schema) Loop
1182: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1183:
1184: sql_stmt := '';

Line 1185: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

1181: For l_varchar_col_rec in c_varchar_cols_cur('BOM_SUB_OPERATION_RESOURCES',l_oracle_schema) Loop
1182: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1183:
1184: sql_stmt := '';
1185: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1186: ' char_col3,Num_col1,Num_col2,Num_col3,Num_col4,Num_col5,Num_col6,char_col1,char_col2)'||
1187: ' SELECT bor.assembly_item_id '||
1188: ' ,bor.Organization_id '||
1189: ' ,BOR.ALTERNATE_ROUTING_DESIGNATOR '||

Line 1226: ' From bom_diag_temp_tab where 1=1 ';

1222: ' Num_Col5 "SCHEDULE SEQ NUM", '||
1223: ' Num_Col6 "REPLACEMENT GROUP NUM", '||
1224: ' Char_Col1 "Column Name", '||
1225: ' Char_Col2 "Column Value" '||
1226: ' From bom_diag_temp_tab where 1=1 ';
1227:
1228: sqltxt := sqltxt || ' and rownum< '||row_limit;
1229: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,Num_col6,char_col1';
1230:

Line 1243: delete from bom_diag_temp_tab; -- Clear the temporary tables

1239:
1240:
1241: /* Script to verify records in bom_operation_networks table */
1242: Begin
1243: delete from bom_diag_temp_tab; -- Clear the temporary tables
1244: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_NETWORKS',l_oracle_schema) Loop
1245: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1246:
1247: sql_stmt := '';

Line 1248: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||

1244: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_NETWORKS',l_oracle_schema) Loop
1245: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1246:
1247: sql_stmt := '';
1248: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1249: ' char_col3,Num_col1,Num_col2,Num_col3,Num_col4,char_col1,char_col2)'||
1250: ' SELECT bor.assembly_item_id '||
1251: ' ,bor.Organization_id '||
1252: ' ,BOR.ALTERNATE_ROUTING_DESIGNATOR '||

Line 1285: ' From bom_diag_temp_tab where 1=1 ';

1281: ' Num_Col3 "FROM OP SEQ ID", '||
1282: ' Num_Col4 "TO OP SEQ ID", '||
1283: ' Char_Col1 "Column Name", '||
1284: ' Char_Col2 "Column Value" '||
1285: ' From bom_diag_temp_tab where 1=1 ';
1286:
1287: sqltxt := sqltxt || ' and rownum< '||row_limit;
1288: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1289: