VIEW: APPS.OTA_TRAINING_PLAN_MEMBERS_V

Source

View Text - Preformatted

SELECT tpm.ROWID , tpm.TRAINING_PLAN_MEMBER_ID , decode(nvl(tpm.activity_version_id, -1), -1, 'ACTIVITY_DEFINITION','ACTIVITY_VERSION') , tpm.TRAINING_PLAN_ID , tpm.ACTIVITY_VERSION_ID , tav_tl.VERSION_NAME , tpm.ACTIVITY_DEFINITION_ID , tad_tl.NAME , tpm.MEMBER_STATUS_TYPE_ID , lkp.MEANING , tpm.TARGET_COMPLETION_DATE , tpm.BUSINESS_GROUP_ID , tpm.OBJECT_VERSION_NUMBER , tpm.ATTRIBUTE_CATEGORY , tpm.ATTRIBUTE1 , tpm.ATTRIBUTE2 , tpm.ATTRIBUTE3 , tpm.ATTRIBUTE4 , tpm.ATTRIBUTE5 , tpm.ATTRIBUTE6 , tpm.ATTRIBUTE7 , tpm.ATTRIBUTE8 , tpm.ATTRIBUTE9 , tpm.ATTRIBUTE10 , tpm.ATTRIBUTE11 , tpm.ATTRIBUTE12 , tpm.ATTRIBUTE13 , tpm.ATTRIBUTE14 , tpm.ATTRIBUTE15 , tpm.ATTRIBUTE16 , tpm.ATTRIBUTE17 , tpm.ATTRIBUTE18 , tpm.ATTRIBUTE19 , tpm.ATTRIBUTE20 , tpm.ATTRIBUTE21 , tpm.ATTRIBUTE22 , tpm.ATTRIBUTE23 , tpm.ATTRIBUTE24 , tpm.ATTRIBUTE25 , tpm.ATTRIBUTE26 , tpm.ATTRIBUTE27 , tpm.ATTRIBUTE28 , tpm.ATTRIBUTE29 , tpm.ATTRIBUTE30 , tpm.CREATED_BY , tpm.CREATION_DATE , tpm.LAST_UPDATED_BY , tpm.LAST_UPDATE_DATE , tpm.LAST_UPDATE_LOGIN from ota_activity_versions tav , ota_activity_versions_tl tav_tl , ota_activity_definitions tad , ota_activity_definitions_tl tad_tl , hr_lookups lkp , ota_training_plan_members tpm WHERE tav.activity_version_id = tav_tl.activity_version_id(+) and tav_tl.language(+) = userenv('LANG') and tad.activity_id = tad_tl.activity_id(+) and tad_tl.language(+) = userenv('LANG') and tpm.member_status_type_id = lkp.lookup_code and lkp.lookup_type = 'OTA_MEMBER_USER_STATUS_TYPE' and tpm.activity_definition_id = tad.activity_id(+) and tpm.activity_version_id = tav.activity_version_id(+)

View Text - HTML Formatted

SELECT TPM.ROWID
, TPM.TRAINING_PLAN_MEMBER_ID
, DECODE(NVL(TPM.ACTIVITY_VERSION_ID
, -1)
, -1
, 'ACTIVITY_DEFINITION'
, 'ACTIVITY_VERSION')
, TPM.TRAINING_PLAN_ID
, TPM.ACTIVITY_VERSION_ID
, TAV_TL.VERSION_NAME
, TPM.ACTIVITY_DEFINITION_ID
, TAD_TL.NAME
, TPM.MEMBER_STATUS_TYPE_ID
, LKP.MEANING
, TPM.TARGET_COMPLETION_DATE
, TPM.BUSINESS_GROUP_ID
, TPM.OBJECT_VERSION_NUMBER
, TPM.ATTRIBUTE_CATEGORY
, TPM.ATTRIBUTE1
, TPM.ATTRIBUTE2
, TPM.ATTRIBUTE3
, TPM.ATTRIBUTE4
, TPM.ATTRIBUTE5
, TPM.ATTRIBUTE6
, TPM.ATTRIBUTE7
, TPM.ATTRIBUTE8
, TPM.ATTRIBUTE9
, TPM.ATTRIBUTE10
, TPM.ATTRIBUTE11
, TPM.ATTRIBUTE12
, TPM.ATTRIBUTE13
, TPM.ATTRIBUTE14
, TPM.ATTRIBUTE15
, TPM.ATTRIBUTE16
, TPM.ATTRIBUTE17
, TPM.ATTRIBUTE18
, TPM.ATTRIBUTE19
, TPM.ATTRIBUTE20
, TPM.ATTRIBUTE21
, TPM.ATTRIBUTE22
, TPM.ATTRIBUTE23
, TPM.ATTRIBUTE24
, TPM.ATTRIBUTE25
, TPM.ATTRIBUTE26
, TPM.ATTRIBUTE27
, TPM.ATTRIBUTE28
, TPM.ATTRIBUTE29
, TPM.ATTRIBUTE30
, TPM.CREATED_BY
, TPM.CREATION_DATE
, TPM.LAST_UPDATED_BY
, TPM.LAST_UPDATE_DATE
, TPM.LAST_UPDATE_LOGIN
FROM OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL TAV_TL
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL TAD_TL
, HR_LOOKUPS LKP
, OTA_TRAINING_PLAN_MEMBERS TPM
WHERE TAV.ACTIVITY_VERSION_ID = TAV_TL.ACTIVITY_VERSION_ID(+)
AND TAV_TL.LANGUAGE(+) = USERENV('LANG')
AND TAD.ACTIVITY_ID = TAD_TL.ACTIVITY_ID(+)
AND TAD_TL.LANGUAGE(+) = USERENV('LANG')
AND TPM.MEMBER_STATUS_TYPE_ID = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'OTA_MEMBER_USER_STATUS_TYPE'
AND TPM.ACTIVITY_DEFINITION_ID = TAD.ACTIVITY_ID(+)
AND TPM.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID(+)