[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: |
APPS.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 |