[Home] [Help]
View: PA_TASK_FC_RESULTS_V
View Text
SELECT BAL.PROJECT_ID
, BAL.TASK_ID
, BUDGET_VERSION_ID
, BAL.START_DATE
, BAL.END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM PA_PROJECT_BAL_V BAL
, PA_TASKS PT1
WHERE (BAL.TASK_ID = PT1.TASK_ID
AND PT1.PARENT_TASK_ID IS NOT NULL) GROUP BY BUDGET_VERSION_ID
, BAL.PROJECT_ID
, BAL.TASK_ID
, BAL.START_DATE
, BAL.END_DATE UNION ( SELECT BAL.PROJECT_ID
, BAL.TASK_ID
, BUDGET_VERSION_ID
, BAL.START_DATE
, BAL.END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM PA_PROJECT_BAL_V BAL
WHERE 1 = (SELECT COUNT(PT2.TOP_TASK_ID)
FROM PA_TASKS PT2
WHERE PT2.TOP_TASK_ID = BAL.TASK_ID) GROUP BY BUDGET_VERSION_ID
, BAL.PROJECT_ID
, BAL.TASK_ID
, BAL.START_DATE
, BAL.END_DATE )
Columns
Name |
PROJECT_ID |
TASK_ID |
BUDGET_VERSION_ID |
START_DATE |
END_DATE |
BUDGET |
ACTUALS |
ENCUMBRANCES |