APPS.FND_CONC_TEMPLATES dependencies on FND_TERRITORIES_VL

Line 353: ' fnd_iso_languages_vl I, fnd_territories_vl T '||

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 '||
357: ' and lower(x.language) = lower(:iso_lang) '||

Line 380: fnd_iso_languages_vl I, fnd_territories_vl T

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
384: and lower(x.language) = lower(iso_lang)

Line 493: ' fnd_iso_languages_vl I, fnd_territories_vl T '||

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 '||
497: ' and a.template_code = x.lob_code '||

Line 521: fnd_iso_languages_vl I, fnd_territories_vl T

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
525: and a.template_code = x.lob_code

Line 851: from fnd_iso_languages_vl I, fnd_territories_vl T

847: else
848: begin
849: select I.name||': '||T.territory_short_name
850: into template_language
851: from fnd_iso_languages_vl I, fnd_territories_vl T
852: where I.iso_language_2 = lower(iso_language)
853: and T.territory_code = upper(iso_territory);
854: exception
855: when NO_DATA_FOUND then

Line 916: FROM FND_LANGUAGES L1, FND_TERRITORIES_VL L2

912: begin
913: begin
914: SELECT lower(L1.iso_language), upper(L2.territory_code)
915: INTO iso_lang, iso_terr
916: FROM FND_LANGUAGES L1, FND_TERRITORIES_VL L2
917: WHERE L1.NLS_LANGUAGE = nls_lang
918: AND L2.NLS_TERRITORY = nls_terr
919: AND ROWNUM = 1;
920: exception

Line 941: FROM FND_LANGUAGES L1, FND_TERRITORIES_VL L2

937: begin
938: begin
939: SELECT upper(L2.territory_code)
940: INTO def_iso_terr
941: FROM FND_LANGUAGES L1, FND_TERRITORIES_VL L2
942: WHERE L1.NLS_LANGUAGE = nls_lang
943: AND L1.NLS_TERRITORY = L2.NLS_TERRITORY
944: AND ROWNUM = 1;
945: exception