VIEW: PJI.PJI_RM_DNGL_RES#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, ROW_ID ROW_ID, CAPACITY_HRS CAPACITY_HRS, TOTAL_HRS_A TOTAL_HRS_A, BILL_HRS_A BILL_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, PROJECT_ID PROJECT_ID, WORK_TYPE_ID WORK_TYPE_ID, DANGLING_FLAG DANGLING_FLAG, RECORD_TYPE RECORD_TYPE, GL_CALENDAR_ID GL_CALENDAR_ID, PA_CALENDAR_ID PA_CALENDAR_ID from "PJI"."PJI_RM_DNGL_RES"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, ROW_ID ROW_ID
, CAPACITY_HRS CAPACITY_HRS
, TOTAL_HRS_A TOTAL_HRS_A
, BILL_HRS_A BILL_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
, PROJECT_ID PROJECT_ID
, WORK_TYPE_ID WORK_TYPE_ID
, DANGLING_FLAG DANGLING_FLAG
, RECORD_TYPE RECORD_TYPE
, GL_CALENDAR_ID GL_CALENDAR_ID
, PA_CALENDAR_ID PA_CALENDAR_ID
FROM "PJI"."PJI_RM_DNGL_RES"