VIEW: PJI.PJI_FM_AGGR_FIN2#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, DANGLING_RECVR_GL_RATE_FLAG DANGLING_RECVR_GL_RATE_FLAG, DANGLING_RECVR_PA_RATE_FLAG DANGLING_RECVR_PA_RATE_FLAG, DANGLING_PRVDR_EN_TIME_FLAG DANGLING_PRVDR_EN_TIME_FLAG, DANGLING_RECVR_EN_TIME_FLAG DANGLING_RECVR_EN_TIME_FLAG, DANGLING_RECVR_GL_TIME_FLAG DANGLING_RECVR_GL_TIME_FLAG, DANGLING_PRVDR_PA_TIME_FLAG DANGLING_PRVDR_PA_TIME_FLAG, DANGLING_RECVR_PA_TIME_FLAG DANGLING_RECVR_PA_TIME_FLAG, ROW_ID ROW_ID, PJI_PROJECT_RECORD_FLAG PJI_PROJECT_RECORD_FLAG, PJI_RESOURCE_RECORD_FLAG PJI_RESOURCE_RECORD_FLAG, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PERSON_ID PERSON_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, WORK_TYPE_ID WORK_TYPE_ID, JOB_ID JOB_ID, PRVDR_GL_TIME_ID PRVDR_GL_TIME_ID, RECVR_GL_TIME_ID RECVR_GL_TIME_ID, PRVDR_PA_TIME_ID PRVDR_PA_TIME_ID, RECVR_PA_TIME_ID RECVR_PA_TIME_ID, PRJ_REVENUE PRJ_REVENUE, PRJ_LABOR_REVENUE PRJ_LABOR_REVENUE, PRJ_RAW_COST PRJ_RAW_COST, PRJ_BRDN_COST PRJ_BRDN_COST, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST, PRJ_BILL_BRDN_COST PRJ_BILL_BRDN_COST, PRJ_LABOR_RAW_COST PRJ_LABOR_RAW_COST, PRJ_LABOR_BRDN_COST PRJ_LABOR_BRDN_COST, PRJ_BILL_LABOR_RAW_COST PRJ_BILL_LABOR_RAW_COST, PRJ_BILL_LABOR_BRDN_COST PRJ_BILL_LABOR_BRDN_COST, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF, POU_REVENUE POU_REVENUE, POU_LABOR_REVENUE POU_LABOR_REVENUE, POU_RAW_COST POU_RAW_COST, POU_BRDN_COST POU_BRDN_COST, POU_BILL_RAW_COST POU_BILL_RAW_COST, POU_BILL_BRDN_COST POU_BILL_BRDN_COST, POU_LABOR_RAW_COST POU_LABOR_RAW_COST, POU_LABOR_BRDN_COST POU_LABOR_BRDN_COST, POU_BILL_LABOR_RAW_COST POU_BILL_LABOR_RAW_COST, POU_BILL_LABOR_BRDN_COST POU_BILL_LABOR_BRDN_COST, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF, LABOR_HRS LABOR_HRS, BILL_LABOR_HRS BILL_LABOR_HRS, GG_REVENUE GG_REVENUE, GG_LABOR_REVENUE GG_LABOR_REVENUE, GG_RAW_COST GG_RAW_COST, GG_BRDN_COST GG_BRDN_COST, GG_BILL_RAW_COST GG_BILL_RAW_COST, GG_BILL_BRDN_COST GG_BILL_BRDN_COST, GG_LABOR_RAW_COST GG_LABOR_RAW_COST, GG_LABOR_BRDN_COST GG_LABOR_BRDN_COST, GG_BILL_LABOR_RAW_COST GG_BILL_LABOR_RAW_COST, GG_BILL_LABOR_BRDN_COST GG_BILL_LABOR_BRDN_COST, GG_REVENUE_WRITEOFF GG_REVENUE_WRITEOFF, GP_REVENUE GP_REVENUE, GP_LABOR_REVENUE GP_LABOR_REVENUE, GP_RAW_COST GP_RAW_COST, GP_BRDN_COST GP_BRDN_COST, GP_BILL_RAW_COST GP_BILL_RAW_COST, GP_BILL_BRDN_COST GP_BILL_BRDN_COST, GP_LABOR_RAW_COST GP_LABOR_RAW_COST, GP_LABOR_BRDN_COST GP_LABOR_BRDN_COST, GP_BILL_LABOR_RAW_COST GP_BILL_LABOR_RAW_COST, GP_BILL_LABOR_BRDN_COST GP_BILL_LABOR_BRDN_COST, GP_REVENUE_WRITEOFF GP_REVENUE_WRITEOFF, TOTAL_HRS_A TOTAL_HRS_A, BILL_HRS_A BILL_HRS_A, EXPENDITURE_ITEM_TIME_ID EXPENDITURE_ITEM_TIME_ID, DANGLING_PRVDR_GL_TIME_FLAG DANGLING_PRVDR_GL_TIME_FLAG, DANGLING_EXP_EN_TIME_FLAG DANGLING_EXP_EN_TIME_FLAG, DANGLING_EXP_GL_TIME_FLAG DANGLING_EXP_GL_TIME_FLAG, DANGLING_EXP_PA_TIME_FLAG DANGLING_EXP_PA_TIME_FLAG, EXP_EVT_TYPE_ID EXP_EVT_TYPE_ID, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, PJ_GL_CALENDAR_ID PJ_GL_CALENDAR_ID, PJ_PA_CALENDAR_ID PJ_PA_CALENDAR_ID, RS_GL_CALENDAR_ID RS_GL_CALENDAR_ID, RS_PA_CALENDAR_ID RS_PA_CALENDAR_ID, RECORD_TYPE RECORD_TYPE, CMT_RECORD_TYPE CMT_RECORD_TYPE, DANGLING_RECVR_GL_RATE2_FLAG DANGLING_RECVR_GL_RATE2_FLAG, DANGLING_RECVR_PA_RATE2_FLAG DANGLING_RECVR_PA_RATE2_FLAG, TASK_ID TASK_ID, VENDOR_ID VENDOR_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EVENT_TYPE EVENT_TYPE, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY REVENUE_CATEGORY, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, GL_PERIOD_NAME GL_PERIOD_NAME, PA_PERIOD_NAME PA_PERIOD_NAME, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_REVENUE TXN_REVENUE, TXN_RAW_COST TXN_RAW_COST, TXN_BRDN_COST TXN_BRDN_COST, TXN_BILL_RAW_COST TXN_BILL_RAW_COST, TXN_BILL_BRDN_COST TXN_BILL_BRDN_COST, EOU_REVENUE EOU_REVENUE, EOU_RAW_COST EOU_RAW_COST, EOU_BRDN_COST EOU_BRDN_COST, EOU_BILL_RAW_COST EOU_BILL_RAW_COST, EOU_BILL_BRDN_COST EOU_BILL_BRDN_COST, GG1_REVENUE GG1_REVENUE, GG1_LABOR_REVENUE GG1_LABOR_REVENUE, GG1_RAW_COST GG1_RAW_COST, GG1_BRDN_COST GG1_BRDN_COST, GG1_BILL_RAW_COST GG1_BILL_RAW_COST, GG1_BILL_BRDN_COST GG1_BILL_BRDN_COST, GG1_LABOR_RAW_COST GG1_LABOR_RAW_COST, GG1_LABOR_BRDN_COST GG1_LABOR_BRDN_COST, GG1_BILL_LABOR_RAW_COST GG1_BILL_LABOR_RAW_COST, GG1_BILL_LABOR_BRDN_COST GG1_BILL_LABOR_BRDN_COST, GG1_REVENUE_WRITEOFF GG1_REVENUE_WRITEOFF, GP1_REVENUE GP1_REVENUE, GP1_LABOR_REVENUE GP1_LABOR_REVENUE, GP1_RAW_COST GP1_RAW_COST, GP1_BRDN_COST GP1_BRDN_COST, GP1_BILL_RAW_COST GP1_BILL_RAW_COST, GP1_BILL_BRDN_COST GP1_BILL_BRDN_COST, GP1_LABOR_RAW_COST GP1_LABOR_RAW_COST, GP1_LABOR_BRDN_COST GP1_LABOR_BRDN_COST, GP1_BILL_LABOR_RAW_COST GP1_BILL_LABOR_RAW_COST, GP1_BILL_LABOR_BRDN_COST GP1_BILL_LABOR_BRDN_COST, GP1_REVENUE_WRITEOFF GP1_REVENUE_WRITEOFF, GG2_REVENUE GG2_REVENUE, GG2_LABOR_REVENUE GG2_LABOR_REVENUE, GG2_RAW_COST GG2_RAW_COST, GG2_BRDN_COST GG2_BRDN_COST, GG2_BILL_RAW_COST GG2_BILL_RAW_COST, GG2_BILL_BRDN_COST GG2_BILL_BRDN_COST, GG2_LABOR_RAW_COST GG2_LABOR_RAW_COST, GG2_LABOR_BRDN_COST GG2_LABOR_BRDN_COST, GG2_BILL_LABOR_RAW_COST GG2_BILL_LABOR_RAW_COST, GG2_BILL_LABOR_BRDN_COST GG2_BILL_LABOR_BRDN_COST, GG2_REVENUE_WRITEOFF GG2_REVENUE_WRITEOFF, GP2_REVENUE GP2_REVENUE, GP2_LABOR_REVENUE GP2_LABOR_REVENUE, GP2_RAW_COST GP2_RAW_COST, GP2_BRDN_COST GP2_BRDN_COST, GP2_BILL_RAW_COST GP2_BILL_RAW_COST, GP2_BILL_BRDN_COST GP2_BILL_BRDN_COST, GP2_LABOR_RAW_COST GP2_LABOR_RAW_COST, GP2_LABOR_BRDN_COST GP2_LABOR_BRDN_COST, GP2_BILL_LABOR_RAW_COST GP2_BILL_LABOR_RAW_COST, GP2_BILL_LABOR_BRDN_COST GP2_BILL_LABOR_BRDN_COST, GP2_REVENUE_WRITEOFF GP2_REVENUE_WRITEOFF, PO_LINE_ID PO_LINE_ID, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, ASSIGNMENT_ID ASSIGNMENT_ID, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PJI"."PJI_FM_AGGR_FIN2"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, DANGLING_RECVR_GL_RATE_FLAG DANGLING_RECVR_GL_RATE_FLAG
, DANGLING_RECVR_PA_RATE_FLAG DANGLING_RECVR_PA_RATE_FLAG
, DANGLING_PRVDR_EN_TIME_FLAG DANGLING_PRVDR_EN_TIME_FLAG
, DANGLING_RECVR_EN_TIME_FLAG DANGLING_RECVR_EN_TIME_FLAG
, DANGLING_RECVR_GL_TIME_FLAG DANGLING_RECVR_GL_TIME_FLAG
, DANGLING_PRVDR_PA_TIME_FLAG DANGLING_PRVDR_PA_TIME_FLAG
, DANGLING_RECVR_PA_TIME_FLAG DANGLING_RECVR_PA_TIME_FLAG
, ROW_ID ROW_ID
, PJI_PROJECT_RECORD_FLAG PJI_PROJECT_RECORD_FLAG
, PJI_RESOURCE_RECORD_FLAG PJI_RESOURCE_RECORD_FLAG
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PERSON_ID PERSON_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, WORK_TYPE_ID WORK_TYPE_ID
, JOB_ID JOB_ID
, PRVDR_GL_TIME_ID PRVDR_GL_TIME_ID
, RECVR_GL_TIME_ID RECVR_GL_TIME_ID
, PRVDR_PA_TIME_ID PRVDR_PA_TIME_ID
, RECVR_PA_TIME_ID RECVR_PA_TIME_ID
, PRJ_REVENUE PRJ_REVENUE
, PRJ_LABOR_REVENUE PRJ_LABOR_REVENUE
, PRJ_RAW_COST PRJ_RAW_COST
, PRJ_BRDN_COST PRJ_BRDN_COST
, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST
, PRJ_BILL_BRDN_COST PRJ_BILL_BRDN_COST
, PRJ_LABOR_RAW_COST PRJ_LABOR_RAW_COST
, PRJ_LABOR_BRDN_COST PRJ_LABOR_BRDN_COST
, PRJ_BILL_LABOR_RAW_COST PRJ_BILL_LABOR_RAW_COST
, PRJ_BILL_LABOR_BRDN_COST PRJ_BILL_LABOR_BRDN_COST
, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF
, POU_REVENUE POU_REVENUE
, POU_LABOR_REVENUE POU_LABOR_REVENUE
, POU_RAW_COST POU_RAW_COST
, POU_BRDN_COST POU_BRDN_COST
, POU_BILL_RAW_COST POU_BILL_RAW_COST
, POU_BILL_BRDN_COST POU_BILL_BRDN_COST
, POU_LABOR_RAW_COST POU_LABOR_RAW_COST
, POU_LABOR_BRDN_COST POU_LABOR_BRDN_COST
, POU_BILL_LABOR_RAW_COST POU_BILL_LABOR_RAW_COST
, POU_BILL_LABOR_BRDN_COST POU_BILL_LABOR_BRDN_COST
, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF
, LABOR_HRS LABOR_HRS
, BILL_LABOR_HRS BILL_LABOR_HRS
, GG_REVENUE GG_REVENUE
, GG_LABOR_REVENUE GG_LABOR_REVENUE
, GG_RAW_COST GG_RAW_COST
, GG_BRDN_COST GG_BRDN_COST
, GG_BILL_RAW_COST GG_BILL_RAW_COST
, GG_BILL_BRDN_COST GG_BILL_BRDN_COST
, GG_LABOR_RAW_COST GG_LABOR_RAW_COST
, GG_LABOR_BRDN_COST GG_LABOR_BRDN_COST
, GG_BILL_LABOR_RAW_COST GG_BILL_LABOR_RAW_COST
, GG_BILL_LABOR_BRDN_COST GG_BILL_LABOR_BRDN_COST
, GG_REVENUE_WRITEOFF GG_REVENUE_WRITEOFF
, GP_REVENUE GP_REVENUE
, GP_LABOR_REVENUE GP_LABOR_REVENUE
, GP_RAW_COST GP_RAW_COST
, GP_BRDN_COST GP_BRDN_COST
, GP_BILL_RAW_COST GP_BILL_RAW_COST
, GP_BILL_BRDN_COST GP_BILL_BRDN_COST
, GP_LABOR_RAW_COST GP_LABOR_RAW_COST
, GP_LABOR_BRDN_COST GP_LABOR_BRDN_COST
, GP_BILL_LABOR_RAW_COST GP_BILL_LABOR_RAW_COST
, GP_BILL_LABOR_BRDN_COST GP_BILL_LABOR_BRDN_COST
, GP_REVENUE_WRITEOFF GP_REVENUE_WRITEOFF
, TOTAL_HRS_A TOTAL_HRS_A
, BILL_HRS_A BILL_HRS_A
, EXPENDITURE_ITEM_TIME_ID EXPENDITURE_ITEM_TIME_ID
, DANGLING_PRVDR_GL_TIME_FLAG DANGLING_PRVDR_GL_TIME_FLAG
, DANGLING_EXP_EN_TIME_FLAG DANGLING_EXP_EN_TIME_FLAG
, DANGLING_EXP_GL_TIME_FLAG DANGLING_EXP_GL_TIME_FLAG
, DANGLING_EXP_PA_TIME_FLAG DANGLING_EXP_PA_TIME_FLAG
, EXP_EVT_TYPE_ID EXP_EVT_TYPE_ID
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, PJ_GL_CALENDAR_ID PJ_GL_CALENDAR_ID
, PJ_PA_CALENDAR_ID PJ_PA_CALENDAR_ID
, RS_GL_CALENDAR_ID RS_GL_CALENDAR_ID
, RS_PA_CALENDAR_ID RS_PA_CALENDAR_ID
, RECORD_TYPE RECORD_TYPE
, CMT_RECORD_TYPE CMT_RECORD_TYPE
, DANGLING_RECVR_GL_RATE2_FLAG DANGLING_RECVR_GL_RATE2_FLAG
, DANGLING_RECVR_PA_RATE2_FLAG DANGLING_RECVR_PA_RATE2_FLAG
, TASK_ID TASK_ID
, VENDOR_ID VENDOR_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EVENT_TYPE EVENT_TYPE
, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY REVENUE_CATEGORY
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, GL_PERIOD_NAME GL_PERIOD_NAME
, PA_PERIOD_NAME PA_PERIOD_NAME
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_REVENUE TXN_REVENUE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BRDN_COST TXN_BRDN_COST
, TXN_BILL_RAW_COST TXN_BILL_RAW_COST
, TXN_BILL_BRDN_COST TXN_BILL_BRDN_COST
, EOU_REVENUE EOU_REVENUE
, EOU_RAW_COST EOU_RAW_COST
, EOU_BRDN_COST EOU_BRDN_COST
, EOU_BILL_RAW_COST EOU_BILL_RAW_COST
, EOU_BILL_BRDN_COST EOU_BILL_BRDN_COST
, GG1_REVENUE GG1_REVENUE
, GG1_LABOR_REVENUE GG1_LABOR_REVENUE
, GG1_RAW_COST GG1_RAW_COST
, GG1_BRDN_COST GG1_BRDN_COST
, GG1_BILL_RAW_COST GG1_BILL_RAW_COST
, GG1_BILL_BRDN_COST GG1_BILL_BRDN_COST
, GG1_LABOR_RAW_COST GG1_LABOR_RAW_COST
, GG1_LABOR_BRDN_COST GG1_LABOR_BRDN_COST
, GG1_BILL_LABOR_RAW_COST GG1_BILL_LABOR_RAW_COST
, GG1_BILL_LABOR_BRDN_COST GG1_BILL_LABOR_BRDN_COST
, GG1_REVENUE_WRITEOFF GG1_REVENUE_WRITEOFF
, GP1_REVENUE GP1_REVENUE
, GP1_LABOR_REVENUE GP1_LABOR_REVENUE
, GP1_RAW_COST GP1_RAW_COST
, GP1_BRDN_COST GP1_BRDN_COST
, GP1_BILL_RAW_COST GP1_BILL_RAW_COST
, GP1_BILL_BRDN_COST GP1_BILL_BRDN_COST
, GP1_LABOR_RAW_COST GP1_LABOR_RAW_COST
, GP1_LABOR_BRDN_COST GP1_LABOR_BRDN_COST
, GP1_BILL_LABOR_RAW_COST GP1_BILL_LABOR_RAW_COST
, GP1_BILL_LABOR_BRDN_COST GP1_BILL_LABOR_BRDN_COST
, GP1_REVENUE_WRITEOFF GP1_REVENUE_WRITEOFF
, GG2_REVENUE GG2_REVENUE
, GG2_LABOR_REVENUE GG2_LABOR_REVENUE
, GG2_RAW_COST GG2_RAW_COST
, GG2_BRDN_COST GG2_BRDN_COST
, GG2_BILL_RAW_COST GG2_BILL_RAW_COST
, GG2_BILL_BRDN_COST GG2_BILL_BRDN_COST
, GG2_LABOR_RAW_COST GG2_LABOR_RAW_COST
, GG2_LABOR_BRDN_COST GG2_LABOR_BRDN_COST
, GG2_BILL_LABOR_RAW_COST GG2_BILL_LABOR_RAW_COST
, GG2_BILL_LABOR_BRDN_COST GG2_BILL_LABOR_BRDN_COST
, GG2_REVENUE_WRITEOFF GG2_REVENUE_WRITEOFF
, GP2_REVENUE GP2_REVENUE
, GP2_LABOR_REVENUE GP2_LABOR_REVENUE
, GP2_RAW_COST GP2_RAW_COST
, GP2_BRDN_COST GP2_BRDN_COST
, GP2_BILL_RAW_COST GP2_BILL_RAW_COST
, GP2_BILL_BRDN_COST GP2_BILL_BRDN_COST
, GP2_LABOR_RAW_COST GP2_LABOR_RAW_COST
, GP2_LABOR_BRDN_COST GP2_LABOR_BRDN_COST
, GP2_BILL_LABOR_RAW_COST GP2_BILL_LABOR_RAW_COST
, GP2_BILL_LABOR_BRDN_COST GP2_BILL_LABOR_BRDN_COST
, GP2_REVENUE_WRITEOFF GP2_REVENUE_WRITEOFF
, PO_LINE_ID PO_LINE_ID
, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, ASSIGNMENT_ID ASSIGNMENT_ID
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PJI"."PJI_FM_AGGR_FIN2"