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.

APPS.FND_CONC_TEMPLATES dependencies on XDO_TEMPLATES_VL

Line 352: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||

348: 'select a.template_name, I.NAME||'': ''||T.territory_short_name, '||
349: ' b.nls_language, x.language, x.territory, '||
350: ' a.application_short_name, a.template_code, '||
351: ' a.template_type_code, a.default_output_type '||
352: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
353: ' fnd_iso_languages_vl I, fnd_territories_vl T '||
354: ' where a.ds_app_short_name = :prog_app_name '||
355: ' and a.data_source_code = :conc_prog_name '||
356: ' and a.template_code = x.lob_code '||

Line 379: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,

375: a.template_type_code
376: into template_name, template_language, request_language,
377: iso_language, iso_territory, template_app_name,
378: template_code, format_type
379: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
380: fnd_iso_languages_vl I, fnd_territories_vl T
381: where a.ds_app_short_name = prog_app_name
382: and a.data_source_code = conc_prog_name
383: and a.template_code = x.lob_code

Line 402: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||

398: 'select a.template_name, I.NAME, '||
399: ' b.nls_language, x.language, x.territory, '||
400: ' a.application_short_name, a.template_code, '||
401: ' a.template_type_code, a.default_output_type '||
402: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
403: ' fnd_iso_languages_vl I '||
404: ' where a.ds_app_short_name = :prog_app_name '||
405: ' and a.data_source_code = :conc_prog_name '||
406: ' and a.template_code = x.lob_code '||

Line 428: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,

424: a.template_type_code
425: into template_name, template_language, request_language,
426: iso_language, iso_territory, template_app_name,
427: template_code, format_type
428: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
429: fnd_iso_languages_vl I
430: where a.ds_app_short_name = prog_app_name
431: and a.data_source_code = conc_prog_name
432: and a.template_code = x.lob_code

Line 492: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||

488: 'select a.template_name, I.NAME||'': ''||T.territory_short_name, '||
489: ' b.nls_language, x.language, x.territory, '||
490: ' a.application_short_name, a.template_code, '||
491: ' a.template_type_code, a.default_output_type '||
492: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
493: ' fnd_iso_languages_vl I, fnd_territories_vl T '||
494: ' where a.ds_app_short_name = :prog_app_name '||
495: ' and a.data_source_code = :conc_prog_name '||
496: ' and a.template_code = :def_templ_code '||

Line 520: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,

516: a.application_short_name, a.template_code, a.template_type_code
517: into template_name, template_language, request_language,
518: iso_language, iso_territory, template_app_name, template_code,
519: format_type
520: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
521: fnd_iso_languages_vl I, fnd_territories_vl T
522: where a.ds_app_short_name = prog_app_name
523: and a.data_source_code = conc_prog_name
524: and a.template_code = def_templ_code

Line 544: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||

540: 'select a.template_name, I.NAME, '||
541: ' b.nls_language, x.language, x.territory, '||
542: ' a.application_short_name, a.template_code, '||
543: ' a.template_type_code, a.default_output_type '||
544: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
545: ' fnd_iso_languages_vl I '||
546: ' where a.ds_app_short_name = :prog_app_name '||
547: ' and a.data_source_code = :conc_prog_name '||
548: ' and a.template_code = :def_templ_code '||

Line 572: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,

568: a.application_short_name, a.template_code, a.template_type_code
569: into template_name, template_language, request_language,
570: iso_language, iso_territory, template_app_name, template_code,
571: format_type
572: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
573: fnd_iso_languages_vl I
574: where a.ds_app_short_name = prog_app_name
575: and a.data_source_code = conc_prog_name
576: and a.template_code = def_templ_code

Line 635: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||

631: 'select a.template_name, I.NAME, '||
632: ' b.nls_language, x.language, x.territory, '||
633: ' a.application_short_name, a.template_code, '||
634: ' a.template_type_code, a.default_output_type '||
635: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
636: ' fnd_iso_languages_vl I '||
637: ' where a.ds_app_short_name = :default_templ_shrt_name '||
638: ' and a.data_source_code = :conc_prog_name '||
639: ' and a.template_code = :def_templ_code '||

Line 661: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,

657: a.application_short_name, a.template_code, a.template_type_code
658: into template_name, template_language, request_language,
659: iso_language, iso_territory, template_app_name, template_code,
660: format_type
661: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
662: fnd_iso_languages_vl I
663: where a.ds_app_short_name = default_templ_shrt_name
664: and a.data_source_code = conc_prog_name
665: and a.template_code = def_templ_code

Line 684: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||

680: 'select a.template_name, I.NAME, '||
681: ' b.nls_language, x.language, x.territory, '||
682: ' a.application_short_name, a.template_code, '||
683: ' a.template_type_code, a.default_output_type '||
684: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
685: ' fnd_iso_languages_vl I '||
686: ' where a.ds_app_short_name = :prog_app_name '||
687: ' and a.data_source_code = :conc_prog_name '||
688: ' and a.template_code = x.lob_code '||

Line 710: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,

706: a.template_type_code
707: into template_name, template_language, request_language,
708: iso_language, iso_territory, template_app_name,
709: template_code, format_type
710: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
711: fnd_iso_languages_vl I
712: where a.ds_app_short_name = prog_app_name
713: and a.data_source_code = conc_prog_name
714: and a.template_code = x.lob_code

Line 731: ' from xdo_lobs x, xdo_templates_vl a '||

727: 'select a.template_name, a.default_language, '||
728: ' a.default_territory, a.application_short_name, '||
729: ' a.template_code, a.template_type_code, '||
730: ' a.default_output_type '||
731: ' from xdo_lobs x, xdo_templates_vl a '||
732: ' where a.ds_app_short_name = :default_templ_shrt_name '||
733: ' and a.data_source_code = :conc_prog_name '||
734: ' and a.template_code = :def_templ_code '||
735: ' and a.template_code = x.lob_code '||

Line 751: from xdo_lobs x, xdo_templates_vl a

747: a.application_short_name, a.template_code,
748: a.template_type_code
749: into template_name, iso_language, iso_territory,
750: template_app_name, template_code, format_type
751: from xdo_lobs x, xdo_templates_vl a
752: where a.ds_app_short_name = default_templ_shrt_name
753: and a.data_source_code = conc_prog_name
754: and a.template_code = def_templ_code
755: and a.template_code = x.lob_code

Line 773: ' from xdo_templates_b a, xdo_templates_vl x '||

769: 'select x.template_name, a.default_language, '||
770: ' a.default_territory, a.application_short_name, '||
771: ' a.template_code, a.template_type_code, '||
772: ' a.default_output_type '||
773: ' from xdo_templates_b a, xdo_templates_vl x '||
774: ' where a.ds_app_short_name = :prog_app_name '||
775: ' and a.data_source_code = :conc_prog_name '||
776: ' and a.template_code = x.template_code '||
777: ' and a.template_status = ''E'' '||

Line 790: from xdo_templates_b a, xdo_templates_vl x

786: a.application_short_name, a.template_code,
787: a.template_type_code
788: into template_name, iso_language, iso_territory,
789: template_app_name, template_code, format_type
790: from xdo_templates_b a, xdo_templates_vl x
791: where a.ds_app_short_name = prog_app_name
792: and a.data_source_code = conc_prog_name
793: and a.template_code = x.template_code
794: and a.template_status = 'E'

Line 807: ' from xdo_templates_b a, xdo_templates_vl x '||

803: 'select x.template_name, a.default_language, '||
804: ' a.default_territory, a.application_short_name, '||
805: ' a.template_code, a.template_type_code, '||
806: ' a.default_output_type '||
807: ' from xdo_templates_b a, xdo_templates_vl x '||
808: ' where a.ds_app_short_name = :prog_app_name '||
809: ' and a.data_source_code = :conc_prog_name '||
810: ' and a.template_code = :def_templ_code '||
811: ' and a.template_code = x.template_code '||

Line 825: from xdo_templates_b a, xdo_templates_vl x

821: a.application_short_name, a.template_code,
822: a.template_type_code
823: into template_name, iso_language, iso_territory,
824: template_app_name, template_code, format_type
825: from xdo_templates_b a, xdo_templates_vl x
826: where a.ds_app_short_name = prog_app_name
827: and a.data_source_code = conc_prog_name
828: and a.template_code = def_templ_code
829: and a.template_code = x.template_code

Line 1004: from xdo_templates_vl T

1000:
1001: begin
1002: SELECT application_short_name, template_code
1003: into new_t_app_name, new_template_code
1004: from xdo_templates_vl T
1005: where ds_app_short_name = prog_app_name
1006: and data_source_code = conc_prog_name
1007: and template_name = new_template_name;
1008: exception

Line 1324: where syn.synonym_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')

1320: select count(*) into xdo_columns_cntr
1321: from (
1322: select syn.table_name, col.column_name
1323: from user_synonyms syn, all_tab_columns col
1324: where syn.synonym_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')
1325: and col.column_name = 'DEFAULT_OUTPUT_TYPE'
1326: and col.owner = syn.table_owner
1327: and col.table_name = syn.table_name
1328: UNION

Line 1331: where col.table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')

1327: and col.table_name = syn.table_name
1328: UNION
1329: select col.table_name, col.column_name
1330: from user_tab_columns col
1331: where col.table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')
1332: and col.column_name = 'DEFAULT_OUTPUT_TYPE'
1333: );
1334:
1335: