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