VIEW: APPS.XDO_TEMPLATES_VL

Source

View Text - Preformatted

SELECT B.TEMPLATE_ID,B.APPLICATION_ID,B.APPLICATION_SHORT_NAME,B.TEMPLATE_CODE,B.DS_APP_SHORT_NAME,B.DATA_SOURCE_CODE,B.TEMPLATE_TYPE_CODE,B.DEFAULT_LANGUAGE,B.DEFAULT_TERRITORY,B.MLS_LANGUAGE,B.MLS_TERRITORY,B.TEMPLATE_STATUS,B.USE_ALIAS_TABLE,B.DEPENDENCY_FLAG,B.START_DATE,B.END_DATE,TL.TEMPLATE_NAME,B.DEFAULT_OUTPUT_TYPE,TL.DESCRIPTION,B.CREATED_BY,B.CREATION_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,B.OBJECT_VERSION_NUMBER,B.ATTRIBUTE_CATEGORY,B.ATTRIBUTE1,B.ATTRIBUTE2,B.ATTRIBUTE3,B.ATTRIBUTE4,B.ATTRIBUTE5,B.ATTRIBUTE6,B.ATTRIBUTE7,B.ATTRIBUTE8,B.ATTRIBUTE9,B.ATTRIBUTE10,B.ATTRIBUTE11,B.ATTRIBUTE12,B.ATTRIBUTE13,B.ATTRIBUTE14,B.ATTRIBUTE15 FROM XDO_TEMPLATES_B B,XDO_TEMPLATES_TL TL WHERE TL.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME AND TL.TEMPLATE_CODE = B.TEMPLATE_CODE AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.TEMPLATE_ID
, B.APPLICATION_ID
, B.APPLICATION_SHORT_NAME
, B.TEMPLATE_CODE
, B.DS_APP_SHORT_NAME
, B.DATA_SOURCE_CODE
, B.TEMPLATE_TYPE_CODE
, B.DEFAULT_LANGUAGE
, B.DEFAULT_TERRITORY
, B.MLS_LANGUAGE
, B.MLS_TERRITORY
, B.TEMPLATE_STATUS
, B.USE_ALIAS_TABLE
, B.DEPENDENCY_FLAG
, B.START_DATE
, B.END_DATE
, TL.TEMPLATE_NAME
, B.DEFAULT_OUTPUT_TYPE
, TL.DESCRIPTION
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM XDO_TEMPLATES_B B
, XDO_TEMPLATES_TL TL
WHERE TL.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
AND TL.TEMPLATE_CODE = B.TEMPLATE_CODE
AND TL.LANGUAGE = USERENV('LANG')