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: GME.PC_RESOURCE_WK#

Source

View Text - Preformatted


select SEQ_ID SEQ_ID, RESOURCES RESOURCES, BATCH_ID BATCH_ID, BATCHSTEP_NO BATCHSTEP_NO, ACTIVITY ACTIVITY, ACTUAL_START_DATE ACTUAL_START_DATE, PLAN_RSRC_USAGE PLAN_RSRC_USAGE, ACTUAL_RSRC_USAGE ACTUAL_RSRC_USAGE, USAGE_UM USAGE_UM, ACTUAL_RSRC_COUNT ACTUAL_RSRC_COUNT, PLAN_RSRC_COUNT PLAN_RSRC_COUNT, ACTUAL_USAGE ACTUAL_USAGE, PLND_USAGE PLND_USAGE, PLAN_CMPLT_DATE PLAN_CMPLT_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ACTUAL_CMPLT_DATE ACTUAL_CMPLT_DATE, PLAN_START_DATE PLAN_START_DATE from "GME"."PC_RESOURCE_WK"

View Text - HTML Formatted

SELECT SEQ_ID SEQ_ID
, RESOURCES RESOURCES
, BATCH_ID BATCH_ID
, BATCHSTEP_NO BATCHSTEP_NO
, ACTIVITY ACTIVITY
, ACTUAL_START_DATE ACTUAL_START_DATE
, PLAN_RSRC_USAGE PLAN_RSRC_USAGE
, ACTUAL_RSRC_USAGE ACTUAL_RSRC_USAGE
, USAGE_UM USAGE_UM
, ACTUAL_RSRC_COUNT ACTUAL_RSRC_COUNT
, PLAN_RSRC_COUNT PLAN_RSRC_COUNT
, ACTUAL_USAGE ACTUAL_USAGE
, PLND_USAGE PLND_USAGE
, PLAN_CMPLT_DATE PLAN_CMPLT_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ACTUAL_CMPLT_DATE ACTUAL_CMPLT_DATE
, PLAN_START_DATE PLAN_START_DATE
FROM "GME"."PC_RESOURCE_WK"