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 = :default_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 = default_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 = :default_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 = default_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 = :prog_app_name '||
638: ' and a.data_source_code = :conc_prog_name '||
639: ' and a.template_code = :default_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 = prog_app_name
664: and a.data_source_code = conc_prog_name
665: and a.template_code = default_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 = :template_app_name '||
733: ' and a.data_source_code = :conc_prog_name '||
734: ' and a.template_code = :default_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 = template_app_name
753: and a.data_source_code = conc_prog_name
754: and a.template_code = default_templ_code
755: and a.template_code = x.lob_code

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

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

Line 789: from xdo_templates_b a, xdo_templates_vl x

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

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

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

Line 823: from xdo_templates_b a, xdo_templates_vl x

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

Line 1001: from xdo_templates_vl T

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

Line 1299: where table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')

1295: -- Set it and Forget It! -- Ronco
1296: -- Obtain the count if the default_output_type column
1297: -- exist in the xdo tables.
1298: select count(*) into xdo_columns_cntr from sys.all_tab_columns
1299: where table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')
1300: and column_name = 'DEFAULT_OUTPUT_TYPE';
1301:
1302:
1303: end FND_CONC_TEMPLATES;