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
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
|
|
|