FND Design Data [Home] [Help]

View: OTA_LP_SECTIONS_VL

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

SELECT TLS.ROWID
, TLS.LEARNING_PATH_SECTION_ID
, TSL.NAME
, TSL.DESCRIPTION
, TLS.LEARNING_PATH_ID
, TLS.SECTION_SEQUENCE
, TLS.COMPLETION_TYPE_CODE
, TLS.NO_OF_MANDATORY_COURSES
, TLS.BUSINESS_GROUP_ID
, TLS.OBJECT_VERSION_NUMBER
, TLS.CREATED_BY
, TLS.CREATION_DATE
, TLS.LAST_UPDATE_DATE
, TLS.LAST_UPDATED_BY
, TLS.LAST_UPDATE_LOGIN
, TLS.ATTRIBUTE_CATEGORY
, TLS.ATTRIBUTE1
, TLS.ATTRIBUTE2
, TLS.ATTRIBUTE3
, TLS.ATTRIBUTE4
, TLS.ATTRIBUTE5
, TLS.ATTRIBUTE6
, TLS.ATTRIBUTE7
, TLS.ATTRIBUTE8
, TLS.ATTRIBUTE9
, TLS.ATTRIBUTE10
, TLS.ATTRIBUTE11
, TLS.ATTRIBUTE12
, TLS.ATTRIBUTE13
, TLS.ATTRIBUTE14
, TLS.ATTRIBUTE15
, TLS.ATTRIBUTE16
, TLS.ATTRIBUTE17
, TLS.ATTRIBUTE18
, TLS.ATTRIBUTE19
, TLS.ATTRIBUTE20
FROM OTA_LP_SECTIONS TLS
, OTA_LP_SECTIONS_TL TSL
WHERE TLS.LEARNING_PATH_SECTION_ID= TSL.LEARNING_PATH_SECTION_ID
AND TSL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
LEARNING_PATH_SECTION_ID
NAME
DESCRIPTION
LEARNING_PATH_ID
SECTION_SEQUENCE
COMPLETION_TYPE_CODE
NO_OF_MANDATORY_COURSES
BUSINESS_GROUP_ID
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20