View: OTA_RESOURCE_USAGES_V

Product:	OTA - Learning Management
Description:	View to list all resource usages.
Implementation/DBA Data:	APPS.OTA_RESOURCE_USAGES_V

View Text

SELECT RUD.ROWID
, RUD.RESOURCE_USAGE_ID
, RUD.SUPPLIED_RESOURCE_ID
, SRT.NAME RESOURCE_NAME
, RUD.ACTIVITY_VERSION_ID
, TAV.VERSION_NAME ACTIVITY_VERSION_NAME
, RUD.OBJECT_VERSION_NUMBER
, RUD.REQUIRED_FLAG
, RUD.START_DATE
, RUD.COMMENTS
, RUD.END_DATE
, RUD.QUANTITY
, NVL(RUD.RESOURCE_TYPE
, TSR.RESOURCE_TYPE) RESOURCE_TYPE
, RTP.MEANING RESOURCE_TYPE_MEANING
, RUD.ROLE_TO_PLAY
, ROL.MEANING ROLE_TO_PLAY_MEANING
, RUD.USAGE_REASON
, USR.MEANING USAGE_REASON_MEANING
, RUD.LAST_UPDATE_DATE
, RUD.LAST_UPDATED_BY
, RUD.LAST_UPDATE_LOGIN
, RUD.CREATED_BY
, RUD.CREATION_DATE
, RUD.RUD_INFORMATION_CATEGORY
, RUD.RUD_INFORMATION1
, RUD.RUD_INFORMATION2
, RUD.RUD_INFORMATION3
, RUD.RUD_INFORMATION4
, RUD.RUD_INFORMATION5
, RUD.RUD_INFORMATION6
, RUD.RUD_INFORMATION7
, RUD.RUD_INFORMATION8
, RUD.RUD_INFORMATION9
, RUD.RUD_INFORMATION10
, RUD.RUD_INFORMATION11
, RUD.RUD_INFORMATION12
, RUD.RUD_INFORMATION13
, RUD.RUD_INFORMATION14
, RUD.RUD_INFORMATION15
, RUD.RUD_INFORMATION16
, RUD.RUD_INFORMATION17
, RUD.RUD_INFORMATION18
, RUD.RUD_INFORMATION19
, RUD.RUD_INFORMATION20
, RUD.OFFERING_ID
FROM HR_LOOKUPS RTP
, HR_LOOKUPS ROL
, HR_LOOKUPS USR
, OTA_ACTIVITY_VERSIONS_TL TAV
, OTA_SUPPLIABLE_RESOURCES TSR
, OTA_SUPPLIABLE_RESOURCES_TL SRT
, OTA_RESOURCE_USAGES RUD
WHERE RUD.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE = USERENV('LANG')
AND RUD.SUPPLIED_RESOURCE_ID = TSR.SUPPLIED_RESOURCE_ID(+)
AND SRT.SUPPLIED_RESOURCE_ID(+) = TSR.SUPPLIED_RESOURCE_ID
AND SRT.LANGUAGE(+) = USERENV('LANG')
AND NVL(RUD.RESOURCE_TYPE
, TSR.RESOURCE_TYPE) = RTP.LOOKUP_CODE
AND RTP.LOOKUP_TYPE(+) = 'RESOURCE_TYPE'
AND RUD.ROLE_TO_PLAY = ROL.LOOKUP_CODE(+)
AND ROL.LOOKUP_TYPE(+) = 'TRAINER_PARTICIPATION'
AND RUD.USAGE_REASON = USR.LOOKUP_CODE(+)
AND USR.LOOKUP_TYPE(+) = 'RESOURCE_USAGE_REASON'

Columns