[Home] [Help]
View: PA_RPT_PROJECT_PERIOD_AMOUNTS
View Text
SELECT PROJECT_ID
, ACCUMULATION_PERIOD_TYPE
, PERIOD_NAME
, START_DATE
, END_DATE
, SUM( DECODE( AMOUNT_TYPE_CODE
, 'COST'
, NVL(ACTUAL
, 0)
, 0 ) )
, SUM( DECODE( AMOUNT_TYPE_CODE
, 'REVENUE'
, NVL(ACTUAL
, 0)
, 0 ) )
, SUM( DECODE( AMOUNT_TYPE_CODE
, 'COST'
, NVL(BUDGET
, 0)
, 0 ) )
, SUM( DECODE( AMOUNT_TYPE_CODE
, 'REVENUE'
, NVL(BUDGET
, 0)
, 0 ) )
FROM PA_BIS_PRJ_BY_PRD_DRILLS
WHERE DRILLDOWN_TYPE = 'ORGANIZATION' GROUP BY PROJECT_ID
, ACCUMULATION_PERIOD_TYPE
, PERIOD_NAME
, START_DATE
, END_DATE
Columns
Name |
PROJECT_ID |
PERIOD_TYPE |
PERIOD_NAME |
START_DATE |
END_DATE |
ACTUAL_COST |
ACTUAL_REVENUE |
BUDGET_COST |
BUDGET_REVENUE |