[Home] [Help]
View: PA_TOP_TASK_FC_RESULTS_V
View Text
SELECT PROJECT_ID
, TOP_TASK_ID
, BUDGET_VERSION_ID
, START_DATE
, END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM PA_PROJECT_BAL_V GROUP BY BUDGET_VERSION_ID
, PROJECT_ID
, TOP_TASK_ID
, START_DATE
, END_DATE
Columns
| Name |
| PROJECT_ID |
| TOP_TASK_ID |
| BUDGET_VERSION_ID |
| START_DATE |
| END_DATE |
| BUDGET |
| ACTUALS |
| ENCUMBRANCES |