Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_CERTIFICATIONS_VL |
SELECT CTB.ROWID
, CTB.CERTIFICATION_ID
, CTB.BUSINESS_GROUP_ID
, CTT.NAME
, CTT.DESCRIPTION
, CTT.OBJECTIVES
, CTT.PURPOSE
, CTT.KEYWORDS
, CTT.END_DATE_COMMENTS
, CTT.INITIAL_PERIOD_COMMENTS
, CTT.RENEWAL_PERIOD_COMMENTS
, CTB.PUBLIC_FLAG
, CTB.INITIAL_COMPLETION_DATE
, CTB.INITIAL_COMPLETION_DURATION
, CTB.INITIAL_COMPL_DURATION_UNITS
, CTB.RENEWAL_DURATION
, CTB.RENEWAL_DURATION_UNITS
, CTB.NOTIFY_DAYS_BEFORE_EXPIRE
, CTB.OBJECT_VERSION_NUMBER
, CTB.VALIDITY_DURATION
, CTB.VALIDITY_DURATION_UNITS
, CTB.RENEWABLE_FLAG
, CTB.VALIDITY_START_TYPE
, CTB.COMPETENCY_UPDATE_LEVEL
, CTB.START_DATE_ACTIVE
, CTB.END_DATE_ACTIVE
, CTT.CREATED_BY
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.LAST_UPDATED_BY
, CTT.LAST_UPDATE_LOGIN
, CTB.ATTRIBUTE_CATEGORY
, CTB.ATTRIBUTE1
, CTB.ATTRIBUTE2
, CTB.ATTRIBUTE3
, CTB.ATTRIBUTE4
, CTB.ATTRIBUTE5
, CTB.ATTRIBUTE6
, CTB.ATTRIBUTE7
, CTB.ATTRIBUTE8
, CTB.ATTRIBUTE9
, CTB.ATTRIBUTE10
, CTB.ATTRIBUTE11
, CTB.ATTRIBUTE12
, CTB.ATTRIBUTE13
, CTB.ATTRIBUTE14
, CTB.ATTRIBUTE15
, CTB.ATTRIBUTE16
, CTB.ATTRIBUTE17
, CTB.ATTRIBUTE18
, CTB.ATTRIBUTE19
, CTB.ATTRIBUTE20
FROM OTA_CERTIFICATIONS_TL CTT
, OTA_CERTIFICATIONS_B CTB
WHERE CTB.CERTIFICATION_ID = CTT.CERTIFICATION_ID
AND CTT.LANGUAGE = USERENV('LANG')