DBA Data[Home] [Help]

APPS.FND_CONC_TEMPLATES dependencies on XDO_LOBS

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