[Home] [Help]
View: PA_RES_FC_RESULTS_V
Product: | PA - Projects |
Description: | Base View for Budget Funds Check Results - Resource Level |
Implementation/DBA Data: |
APPS.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 |