DBA Data[Home] [Help]

VIEW: APPS.XDO_DGF_TEMPLATES_V

Source

View Text - Preformatted

SELECT tl.template_name, tl.template_code, t.data_source_code, t.application_short_name, t.ds_app_short_name
from xdo_templates_b t, xdo_templates_tl tl
WHERE t.template_code = tl.template_code
and   t.application_short_name = tl.application_short_name
and   tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT TL.TEMPLATE_NAME
, TL.TEMPLATE_CODE
, T.DATA_SOURCE_CODE
, T.APPLICATION_SHORT_NAME
, T.DS_APP_SHORT_NAME FROM XDO_TEMPLATES_B T
, XDO_TEMPLATES_TL TL WHERE T.TEMPLATE_CODE = TL.TEMPLATE_CODE AND T.APPLICATION_SHORT_NAME = TL.APPLICATION_SHORT_NAME AND TL.LANGUAGE = USERENV('LANG')