[Home] [Help]
View: GMS_TASK_BAL_V
Product: | GMS - Grants Accounting |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.GMS_TASK_BAL_V
|
View Text
SELECT PROJECT_ID
, AWARD_ID
, TOP_TASK_ID
, GMS_BUDGET_UTILS.GET_TASK_NUMBER(TOP_TASK_ID)
, BUDGET_VERSION_ID
, START_DATE
, END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM GMS_AWARD_BAL_V GROUP BY BUDGET_VERSION_ID
, AWARD_ID
, PROJECT_ID
, TOP_TASK_ID
, GMS_BUDGET_UTILS.GET_TASK_NUMBER(TOP_TASK_ID)
, START_DATE
, END_DATE
Columns
Name |
PROJECT_ID |
AWARD_ID |
TOP_TASK_ID |
TOP_TASK_NUMBER |
BUDGET_VERSION_ID |
START_DATE |
END_DATE |
BUDGET |
ACTUALS |
ENCUMBRANCES |