FND Design Data [Home] [Help]

View: PA_RES_FC_RESULTS_V

Product: PA - Projects
Description: Base View for Budget Funds Check Results - Resource Level
Implementation/DBA Data: ViewAPPS.PA_RES_FC_RESULTS_V
View Text

SELECT PROJECT_ID
, RESOURCE_LIST_MEMBER_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
, RESOURCE_LIST_MEMBER_ID
, START_DATE
, END_DATE

Columns

Name
PROJECT_ID
RESOURCE_LIST_MEMBER_ID
BUDGET_VERSION_ID
START_DATE
END_DATE
BUDGET
ACTUALS
ENCUMBRANCES