FND Design Data [Home] [Help]

View: PA_TOP_TASK_FC_RESULTS_V

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