View: PA_RES_GRP_FC_RESULTS_V

Product:	PA - Projects
Description:	Base View for Budget Funds Check Results - Resource Group Level
Implementation/DBA Data:	APPS.PA_RES_GRP_FC_RESULTS_V

View Text

SELECT PROJECT_ID
, BUDGET_VERSION_ID
, DECODE(PARENT_MEMBER_ID
, NULL
, RESOURCE_LIST_MEMBER_ID
, 0
, RESOURCE_LIST_MEMBER_ID
, PARENT_MEMBER_ID)
, START_DATE
, END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM PA_PROJECT_BAL_V GROUP BY BUDGET_VERSION_ID
, PROJECT_ID
, DECODE(PARENT_MEMBER_ID
, NULL
, RESOURCE_LIST_MEMBER_ID
, 0
, RESOURCE_LIST_MEMBER_ID
, PARENT_MEMBER_ID)
, START_DATE
, END_DATE

Columns