VIEW: APPS.OTA_RESOURCE_USAGES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'