[Home] [Help]
MATERIALIZED VIEW: APPS.PJI_FP_CLSO_ET_F_MV
Source
select /* 12.0: bug#4526784 */
fec.TIME_ID,
den.ORGANIZATION_ID PROJECT_ORGANIZATION_ID,
fec.CALENDAR_TYPE,
fec.PERIOD_TYPE_ID,
fec.PROJECT_CLASS_ID,
fec.CURR_RECORD_TYPE_ID,
fec.CURRENCY_CODE,
fec.PROJECT_ORG_ID,
fec.EXP_EVT_TYPE_ID,
count(*) CNT,
sum (fec.REVENUE) REVENUE,
count(fec.REVENUE) REVENUE_CNT,
sum (fec.LABOR_REVENUE) LABOR_REVENUE,
count(fec.LABOR_REVENUE) LABOR_REVENUE_CNT,
sum (fec.RAW_COST) RAW_COST,
count(fec.RAW_COST) RAW_COST_CNT,
sum (fec.BURDENED_COST) BURDENED_COST,
count(fec.BURDENED_COST) BURDENED_COST_CNT,
sum (fec.BILL_RAW_COST) BILL_RAW_COST,
count(fec.BILL_RAW_COST) BILL_RAW_COST_CNT,
sum (fec.BILL_BURDENED_COST) BILL_BURDENED_COST,
count(fec.BILL_BURDENED_COST) BILL_BURDENED_COST_CNT,
sum (fec.LABOR_RAW_COST) LABOR_RAW_COST,
count(fec.LABOR_RAW_COST) LABOR_RAW_COST_CNT,
sum (fec.LABOR_BURDENED_COST) LABOR_BURDENED_COST,
count(fec.LABOR_BURDENED_COST) LABOR_BURDENED_COST_CNT,
sum (fec.BILL_LABOR_RAW_COST) BILL_LABOR_RAW_COST,
count(fec.BILL_LABOR_RAW_COST) BILL_LABOR_RAW_COST_CNT,
sum (fec.BILL_LABOR_BURDENED_COST) BILL_LABOR_BURDENED_COST,
count(fec.BILL_LABOR_BURDENED_COST) BILL_LABOR_BURDENED_COST_CNT,
sum (fec.CAPITAL_RAW_COST) CAPITAL_RAW_COST,
count(fec.CAPITAL_RAW_COST) CAPITAL_RAW_COST_CNT,
sum (fec.CAPITAL_BRDN_COST) CAPITAL_BRDN_COST,
count(fec.CAPITAL_BRDN_COST) CAPITAL_BRDN_COST_CNT,
sum (fec.CONTRACT_RAW_COST) CONTRACT_RAW_COST,
count(fec.CONTRACT_RAW_COST) CONTRACT_RAW_COST_CNT,
sum (fec.CONTRACT_BRDN_COST) CONTRACT_BRDN_COST,
count(fec.CONTRACT_BRDN_COST) CONTRACT_BRDN_COST_CNT,
sum (fec.CAPITALIZABLE_RAW_COST) CAPITALIZABLE_RAW_COST,
count(fec.CAPITALIZABLE_RAW_COST) CAPITALIZABLE_RAW_COST_CNT,
sum (fec.CAPITALIZABLE_BRDN_COST) CAPITALIZABLE_BRDN_COST,
count(fec.CAPITALIZABLE_BRDN_COST) CAPITALIZABLE_BRDN_COST_CNT,
sum (fec.PROJECT_COUNT) PROJECT_COUNT,
count(fec.PROJECT_COUNT) PROJECT_COUNT_CNT,
sum (fec.LABOR_HRS) LABOR_HRS,
count(fec.LABOR_HRS) LABOR_HRS_CNT,
sum (fec.BILL_LABOR_HRS) BILL_LABOR_HRS,
count(fec.BILL_LABOR_HRS) BILL_LABOR_HRS_CNT,
sum (fec.QUANTITY) QUANTITY,
count(fec.QUANTITY) QUANTITY_CNT,
sum (fec.BILL_QUANTITY) BILL_QUANTITY,
count(fec.BILL_QUANTITY) BILL_QUANTITY_CNT
from
PJI_FP_CLS_ET_F_MV fec,
PJI.PJI_ORG_DENORM den
where
fec.PROJECT_ORGANIZATION_ID = den.SUB_ORGANIZATION_ID
group by
fec.TIME_ID,
den.ORGANIZATION_ID,
fec.CALENDAR_TYPE,
fec.PERIOD_TYPE_ID,
fec.PROJECT_CLASS_ID,
fec.CURR_RECORD_TYPE_ID,
fec.CURRENCY_CODE,
fec.PROJECT_ORG_ID,
fec.EXP_EVT_TYPE_ID