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: PJI.PJI_RM_AGGR_RES6#

Source

View Text - Preformatted


select WORKER_ID WORKER_ID, TOTAL_HRS_A TOTAL_HRS_A, BILL_HRS_A BILL_HRS_A, 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, PROJECT_ID PROJECT_ID, WORK_TYPE_ID WORK_TYPE_ID, GL_CALENDAR_ID GL_CALENDAR_ID, PA_CALENDAR_ID PA_CALENDAR_ID from "PJI"."PJI_RM_AGGR_RES6"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, TOTAL_HRS_A TOTAL_HRS_A
, BILL_HRS_A BILL_HRS_A
, 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
, PROJECT_ID PROJECT_ID
, WORK_TYPE_ID WORK_TYPE_ID
, GL_CALENDAR_ID GL_CALENDAR_ID
, PA_CALENDAR_ID PA_CALENDAR_ID
FROM "PJI"."PJI_RM_AGGR_RES6"