Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_TRAINING_PLAN_MEMBERS_V |
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.VERSION_NAME
, TPM.ACTIVITY_DEFINITION_ID
, TAD.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_DEFINITIONS TAD
, HR_LOOKUPS LKP
, OTA_TRAINING_PLAN_MEMBERS TPM
WHERE 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(+)