eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OTA.OTA_RESOURCE_USAGES#

Source

View Text - Preformatted


select RESOURCE_USAGE_ID RESOURCE_USAGE_ID, SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REQUIRED_FLAG REQUIRED_FLAG, START_DATE START_DATE, COMMENTS COMMENTS, END_DATE END_DATE, QUANTITY QUANTITY, RESOURCE_TYPE RESOURCE_TYPE, ROLE_TO_PLAY ROLE_TO_PLAY, USAGE_REASON USAGE_REASON, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, RUD_INFORMATION_CATEGORY RUD_INFORMATION_CATEGORY, RUD_INFORMATION1 RUD_INFORMATION1, RUD_INFORMATION2 RUD_INFORMATION2, RUD_INFORMATION3 RUD_INFORMATION3, RUD_INFORMATION4 RUD_INFORMATION4, RUD_INFORMATION5 RUD_INFORMATION5, RUD_INFORMATION6 RUD_INFORMATION6, RUD_INFORMATION7 RUD_INFORMATION7, RUD_INFORMATION8 RUD_INFORMATION8, RUD_INFORMATION9 RUD_INFORMATION9, RUD_INFORMATION10 RUD_INFORMATION10, RUD_INFORMATION11 RUD_INFORMATION11, RUD_INFORMATION12 RUD_INFORMATION12, RUD_INFORMATION13 RUD_INFORMATION13, RUD_INFORMATION14 RUD_INFORMATION14, RUD_INFORMATION15 RUD_INFORMATION15, RUD_INFORMATION16 RUD_INFORMATION16, RUD_INFORMATION17 RUD_INFORMATION17, RUD_INFORMATION18 RUD_INFORMATION18, RUD_INFORMATION19 RUD_INFORMATION19, RUD_INFORMATION20 RUD_INFORMATION20, OFFERING_ID OFFERING_ID from "OTA"."OTA_RESOURCE_USAGES"

View Text - HTML Formatted

SELECT RESOURCE_USAGE_ID RESOURCE_USAGE_ID
, SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REQUIRED_FLAG REQUIRED_FLAG
, START_DATE START_DATE
, COMMENTS COMMENTS
, END_DATE END_DATE
, QUANTITY QUANTITY
, RESOURCE_TYPE RESOURCE_TYPE
, ROLE_TO_PLAY ROLE_TO_PLAY
, USAGE_REASON USAGE_REASON
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, RUD_INFORMATION_CATEGORY RUD_INFORMATION_CATEGORY
, RUD_INFORMATION1 RUD_INFORMATION1
, RUD_INFORMATION2 RUD_INFORMATION2
, RUD_INFORMATION3 RUD_INFORMATION3
, RUD_INFORMATION4 RUD_INFORMATION4
, RUD_INFORMATION5 RUD_INFORMATION5
, RUD_INFORMATION6 RUD_INFORMATION6
, RUD_INFORMATION7 RUD_INFORMATION7
, RUD_INFORMATION8 RUD_INFORMATION8
, RUD_INFORMATION9 RUD_INFORMATION9
, RUD_INFORMATION10 RUD_INFORMATION10
, RUD_INFORMATION11 RUD_INFORMATION11
, RUD_INFORMATION12 RUD_INFORMATION12
, RUD_INFORMATION13 RUD_INFORMATION13
, RUD_INFORMATION14 RUD_INFORMATION14
, RUD_INFORMATION15 RUD_INFORMATION15
, RUD_INFORMATION16 RUD_INFORMATION16
, RUD_INFORMATION17 RUD_INFORMATION17
, RUD_INFORMATION18 RUD_INFORMATION18
, RUD_INFORMATION19 RUD_INFORMATION19
, RUD_INFORMATION20 RUD_INFORMATION20
, OFFERING_ID OFFERING_ID
FROM "OTA"."OTA_RESOURCE_USAGES"