FND Design Data [Home] [Help]

View: OTA_CATEGORY_USAGES_VL

Product: OTA - Learning Management
Description:
Implementation/DBA Data: ViewAPPS.OTA_CATEGORY_USAGES_VL
View Text

SELECT TCU.ROWID
, TCU.CATEGORY_USAGE_ID
, CUL.CATEGORY
, TCU.OBJECT_VERSION_NUMBER
, TCU.TYPE
, TCU.LAST_UPDATE_DATE
, TCU.LAST_UPDATED_BY
, TCU.LAST_UPDATE_LOGIN
, TCU.CREATED_BY
, TCU.CREATION_DATE
, TCU.BUSINESS_GROUP_ID
, TCU.START_DATE_ACTIVE
, TCU.END_DATE_ACTIVE
, CUL.DESCRIPTION
, TCU.PARENT_CAT_USAGE_ID
, TCU.SYNCHRONOUS_FLAG
, TCU.ONLINE_FLAG
, TCU.DATA_SOURCE
, TCU.COMMENTS
, TCU.ATTRIBUTE_CATEGORY
, TCU.ATTRIBUTE1
, TCU.ATTRIBUTE2
, TCU.ATTRIBUTE3
, TCU.ATTRIBUTE4
, TCU.ATTRIBUTE5
, TCU.ATTRIBUTE6
, TCU.ATTRIBUTE7
, TCU.ATTRIBUTE8
, TCU.ATTRIBUTE9
, TCU.ATTRIBUTE10
, TCU.ATTRIBUTE11
, TCU.ATTRIBUTE12
, TCU.ATTRIBUTE13
, TCU.ATTRIBUTE14
, TCU.ATTRIBUTE15
, TCU.ATTRIBUTE16
, TCU.ATTRIBUTE17
, TCU.ATTRIBUTE18
, TCU.ATTRIBUTE19
, TCU.ATTRIBUTE20
FROM OTA_CATEGORY_USAGES TCU
, OTA_CATEGORY_USAGES_TL CUL
WHERE TCU.CATEGORY_USAGE_ID= CUL.CATEGORY_USAGE_ID
AND CUL.LANGUAGE= USERENV('LANG')

Columns

Name
ROW_ID
CATEGORY_USAGE_ID
CATEGORY
OBJECT_VERSION_NUMBER
TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
START_DATE_ACTIVE
END_DATE_ACTIVE
DESCRIPTION
PARENT_CAT_USAGE_ID
SYNCHRONOUS_FLAG
ONLINE_FLAG
DATA_SOURCE
COMMENTS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20