VIEW: APPS.OTA_LP_SECTIONS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')