VIEW: APPS.OTA_CERTIFICATIONS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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