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 173: delete from bom_diag_temp_tab; -- Clear the temporary tables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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