Product: | OTA - Learning Management |
---|---|
Description: | View to list all Program Members. |
Implementation/DBA Data: | APPS.OTA_PROGRAM_MEMBERSHIPS_V |
SELECT PMM.ROWID
, PMM.PROGRAM_MEMBERSHIP_ID
, PMM.EVENT_ID
, PMM.PROGRAM_EVENT_ID
, PMM.COMMENTS
, PMM.GROUP_NAME
, HR_GENERAL.DECODE_LOOKUP('PROGRAM_MEMBERSHIP_GROUP'
, PMM.GROUP_NAME)
, PMM.REQUIRED_FLAG
, PMM.ROLE
, HR_GENERAL.DECODE_LOOKUP('PROGRAM_MEMBERSHIP_ROLE'
, PMM.ROLE)
, PMM.SEQUENCE
, PMM.OBJECT_VERSION_NUMBER
, PMM.LAST_UPDATE_DATE
, PMM.LAST_UPDATED_BY
, PMM.LAST_UPDATE_LOGIN
, PMM.CREATED_BY
, PMM.CREATION_DATE
, PMM.PMM_INFORMATION_CATEGORY
, PMM.PMM_INFORMATION1
, PMM.PMM_INFORMATION2
, PMM.PMM_INFORMATION3
, PMM.PMM_INFORMATION4
, PMM.PMM_INFORMATION5
, PMM.PMM_INFORMATION6
, PMM.PMM_INFORMATION7
, PMM.PMM_INFORMATION8
, PMM.PMM_INFORMATION9
, PMM.PMM_INFORMATION10
, PMM.PMM_INFORMATION11
, PMM.PMM_INFORMATION12
, PMM.PMM_INFORMATION13
, PMM.PMM_INFORMATION14
, PMM.PMM_INFORMATION15
, PMM.PMM_INFORMATION16
, PMM.PMM_INFORMATION17
, PMM.PMM_INFORMATION18
, PMM.PMM_INFORMATION19
, PMM.PMM_INFORMATION20
, ENT.TITLE
, EVT.COURSE_END_DATE
, EVT.COURSE_START_DATE
, TAV.VERSION_NAME
FROM OTA_PROGRAM_MEMBERSHIPS PMM
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, OTA_ACTIVITY_VERSIONS_TL TAV
WHERE PMM.EVENT_ID = EVT.EVENT_ID
AND ENT.EVENT_ID = EVT.EVENT_ID
AND ENT.LANGUAGE= USERENV('LANG')
AND EVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE= USERENV('LANG')