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