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
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
|
|
|