View: PA_TASK_FC_RESULTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.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