DBA Data[Home] [Help]

VIEW: APPS.XDO_DS_DEFINITIONS_VL

Source

View Text - Preformatted

SELECT B.APPLICATION_SHORT_NAME,B.DATA_SOURCE_CODE,B.DATA_SOURCE_STATUS,B.START_DATE,B.END_DATE,TL.DATA_SOURCE_NAME,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_DS_DEFINITIONS_TL TL,XDO_DS_DEFINITIONS_B B WHERE TL.APPLICATION_SHORT_NAME = B. APPLICATION_SHORT_NAME AND TL.DATA_SOURCE_CODE = B.DATA_SOURCE_CODE AND TL.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.APPLICATION_SHORT_NAME
, B.DATA_SOURCE_CODE
, B.DATA_SOURCE_STATUS
, B.START_DATE
, B.END_DATE
, TL.DATA_SOURCE_NAME
, 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_DS_DEFINITIONS_TL TL
, XDO_DS_DEFINITIONS_B B
WHERE TL.APPLICATION_SHORT_NAME = B. APPLICATION_SHORT_NAME
AND TL.DATA_SOURCE_CODE = B.DATA_SOURCE_CODE
AND TL.LANGUAGE = USERENV('LANG')