FND Design Data [Home] [Help]

View: PA_PRJ_FC_RESULTS_V

Product: PA - Projects
Description: Base View for Budget Funds Check Results - Project Level -- Not Integrated to External Budget
Implementation/DBA Data: ViewAPPS.PA_PRJ_FC_RESULTS_V
View Text

SELECT PROJECT_ID
, BUDGET_VERSION_ID
, START_DATE
, END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM PA_PROJECT_BAL_V GROUP BY PROJECT_ID
, BUDGET_VERSION_ID
, START_DATE
, END_DATE

Columns

Name
PROJECT_ID
BUDGET_VERSION_ID
START_DATE
END_DATE
BUDGET
ACTUALS
ENCUMBRANCES