eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_RPT_PROJECT_PERIOD_AMOUNTS

Product:	PA - Projects
Description:	PA Cost and Revenue amounts by Project and Time Period
Implementation/DBA Data:	APPS.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