VIEW: APPS.OTA_PROGRAM_MEMBERSHIPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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