PJS_FP_PROJ_FCST_V

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name

PROJECT_ID PROJECT_ELEMENT_ID PLAN_VERSION_ID PLAN_TYPE_ID TIME_ID RBS_VERSION_ID RBS_ELEMENT_ID CURRENCY_TYPE CURRENCY_CODE CALENDAR_TYPE REVENUE LABOR_REVENUE RAW_COST BILL_RAW_COST CAP_RAW_COST EXP_RAW_COST LABOR_RAW_COST BILL_LABOR_RAW_COST EQUIPMENT_RAW_COST BRDN_COST BILL_BRDN_COST CAP_BRDN_COST EXP_BRDN_COST LABOR_BRDN_COST BILL_LABOR_BRDN_COST EQUIPMENT_BRDN_COST LABOR_HRS BILL_LABOR_HRS EQUIPMENT_HRS BILL_EQUIPMENT_HRS

Query

SQL_Statement

select fct.PROJECT_ID, fct.PROJECT_ELEMENT_ID, fct.PLAN_VERSION_ID, fct.PLAN_TYPE_ID, fct.TIME_ID, fct.RBS_VERSION_ID, fct.RBS_ELEMENT_ID, fct.CURRENCY_TYPE, fct.CURRENCY_CODE, fct.CALENDAR_TYPE, fct.REVENUE, fct.LABOR_REVENUE, fct.RAW_COST, fct.BILL_RAW_COST, fct.CAP_RAW_COST, fct.EXP_RAW_COST, fct.LABOR_RAW_COST, fct.BILL_LABOR_RAW_COST, fct.EQUIPMENT_RAW_COST, fct.BRDN_COST, fct.BILL_BRDN_COST, fct.CAP_BRDN_COST, fct.EXP_BRDN_COST, fct.LABOR_BRDN_COST, fct.BILL_LABOR_BRDN_COST, fct.EQUIPMENT_BRDN_COST, fct.LABOR_HRS, fct.BILL_LABOR_HRS, fct.EQUIPMENT_HRS, fct.BILL_EQUIPMENT_HRS from PJS_FP_PROJ_FCST_F fct