Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_LP_SECTIONS_VL |
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')