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.

VIEW: PJI.PJI_RM_RES_WT_F#

Source

View Text - Preformatted


select CAPACITY_HRS CAPACITY_HRS, TOTAL_HRS_A TOTAL_HRS_A, CONF_HRS_S CONF_HRS_S, PROV_HRS_S PROV_HRS_S, UNASSIGNED_HRS_S UNASSIGNED_HRS_S, CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S, PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S, PERIOD_TYPE_ID PERIOD_TYPE_ID, CALENDAR_TYPE CALENDAR_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, TIME_ID TIME_ID, PERSON_ID PERSON_ID, JOB_ID JOB_ID, WORK_TYPE_ID WORK_TYPE_ID, PROJECT_ID PROJECT_ID, BILL_HRS_A BILL_HRS_A, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RECORD_TYPE RECORD_TYPE from "PJI"."PJI_RM_RES_WT_F"

View Text - HTML Formatted

SELECT CAPACITY_HRS CAPACITY_HRS
, TOTAL_HRS_A TOTAL_HRS_A
, CONF_HRS_S CONF_HRS_S
, PROV_HRS_S PROV_HRS_S
, UNASSIGNED_HRS_S UNASSIGNED_HRS_S
, CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S
, PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, TIME_ID TIME_ID
, PERSON_ID PERSON_ID
, JOB_ID JOB_ID
, WORK_TYPE_ID WORK_TYPE_ID
, PROJECT_ID PROJECT_ID
, BILL_HRS_A BILL_HRS_A
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RECORD_TYPE RECORD_TYPE
FROM "PJI"."PJI_RM_RES_WT_F"