[Home] [Help]
View: GMS_RESG_BAL_V
Product: | GMS - Grants Accounting |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.GMS_RESG_BAL_V
|
View Text
SELECT GB.PROJECT_ID
, GB.AWARD_ID
, GB.TASK_ID
, GB.BUDGET_VERSION_ID BUDGET_VERSION_ID
, NVL(GB.PARENT_MEMBER_ID
, GB.RESOURCE_LIST_MEMBER_ID) PARENT_MEMBER_ID
, MIN(GB.START_DATE) START_DATE
, MAX(GB.END_DATE) END_DATE
, SUM(NVL(GB.BUDGET_PERIOD_TO_DATE
, 0)) BUDGET
, SUM(NVL(GB.ACTUAL_PERIOD_TO_DATE
, 0)) ACTUALS
, SUM(NVL(GB.ENCUMB_PERIOD_TO_DATE
, 0)) ENCUMBRANCES
FROM GMS_BALANCES GB
, PA_RESOURCE_LIST_MEMBERS PA
WHERE NVL(GB.PARENT_MEMBER_ID
, GB.RESOURCE_LIST_MEMBER_ID) = PA.RESOURCE_LIST_MEMBER_ID
AND NVL(PA.MEMBER_LEVEL
, 0) = 1 GROUP BY GB.PROJECT_ID
, GB.AWARD_ID
, GB.TASK_ID
, NVL(GB.PARENT_MEMBER_ID
, GB.RESOURCE_LIST_MEMBER_ID)
, GB.BUDGET_VERSION_ID
Columns
Name |
PROJECT_ID |
AWARD_ID |
TASK_ID |
BUDGET_VERSION_ID |
PARENT_MEMBER_ID |
START_DATE |
END_DATE |
BUDGET |
ACTUALS |
ENCUMBRANCES |