VIEW: APPS.GMS_RES_V

Source

View Text - Preformatted

SELECT gms.project_id , gms.award_id, decode(pbem.entry_level_code,'P',0,gms.task_id), decode(pbem.entry_level_code,'P',NULL,gms_budget_utils.get_task_number(gms.task_id)), gms.resource_list_member_id, pr.name, gms.budget_version_id, decode(gms.parent_member_id , null , gms.resource_list_member_id, 0, gms.resource_list_member_id, gms.parent_member_id), decode(pbem.entry_level_code,'P',0,gms.top_task_id), gms.start_date, gms.end_date, sum(gms.budget), sum(gms.actuals), sum(gms.encumbrances) FROM gms_award_bal_v gms, gms_budget_versions gbv, pa_budget_entry_methods pbem, pa_resources pr, pa_resource_list_members prm WHERE gms.budget_version_id = gbv.budget_version_id and gbv.budget_entry_method_code = pbem.budget_entry_method_code and prm.resource_list_member_id = gms.resource_list_member_id and prm.resource_id = pr.resource_id and (nvl( gms.parent_member_id,0) <> 0 or exists ( SELECT 1 FROM pa_resource_lists pa, pa_resource_list_members rlm WHERE rlm.resource_list_member_id = gms.resource_list_member_id and rlm.resource_list_id = pa.resource_list_id and pa.group_resource_type_id = 0 )) group by gms.budget_version_id, gms.award_id, gms.project_id, decode(pbem.entry_level_code,'P',0,gms.top_task_id), decode(pbem.entry_level_code,'P',0,gms.task_id), decode(pbem.entry_level_code,'P',NULL,gms_budget_utils.get_task_number(gms.task_id)), gms.resource_list_member_id, pr.name, decode(gms.parent_member_id ,null ,gms.resource_list_member_id,0, gms.resource_list_member_id,gms.parent_member_id), gms.start_date, gms.end_date

View Text - HTML Formatted

SELECT GMS.PROJECT_ID
, GMS.AWARD_ID
, DECODE(PBEM.ENTRY_LEVEL_CODE
, 'P'
, 0
, GMS.TASK_ID)
, DECODE(PBEM.ENTRY_LEVEL_CODE
, 'P'
, NULL
, GMS_BUDGET_UTILS.GET_TASK_NUMBER(GMS.TASK_ID))
, GMS.RESOURCE_LIST_MEMBER_ID
, PR.NAME
, GMS.BUDGET_VERSION_ID
, DECODE(GMS.PARENT_MEMBER_ID
, NULL
, GMS.RESOURCE_LIST_MEMBER_ID
, 0
, GMS.RESOURCE_LIST_MEMBER_ID
, GMS.PARENT_MEMBER_ID)
, DECODE(PBEM.ENTRY_LEVEL_CODE
, 'P'
, 0
, GMS.TOP_TASK_ID)
, GMS.START_DATE
, GMS.END_DATE
, SUM(GMS.BUDGET)
, SUM(GMS.ACTUALS)
, SUM(GMS.ENCUMBRANCES)
FROM GMS_AWARD_BAL_V GMS
, GMS_BUDGET_VERSIONS GBV
, PA_BUDGET_ENTRY_METHODS PBEM
, PA_RESOURCES PR
, PA_RESOURCE_LIST_MEMBERS PRM
WHERE GMS.BUDGET_VERSION_ID = GBV.BUDGET_VERSION_ID
AND GBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND PRM.RESOURCE_LIST_MEMBER_ID = GMS.RESOURCE_LIST_MEMBER_ID
AND PRM.RESOURCE_ID = PR.RESOURCE_ID
AND (NVL( GMS.PARENT_MEMBER_ID
, 0) <> 0 OR EXISTS ( SELECT 1
FROM PA_RESOURCE_LISTS PA
, PA_RESOURCE_LIST_MEMBERS RLM
WHERE RLM.RESOURCE_LIST_MEMBER_ID = GMS.RESOURCE_LIST_MEMBER_ID
AND RLM.RESOURCE_LIST_ID = PA.RESOURCE_LIST_ID
AND PA.GROUP_RESOURCE_TYPE_ID = 0 )) GROUP BY GMS.BUDGET_VERSION_ID
, GMS.AWARD_ID
, GMS.PROJECT_ID
, DECODE(PBEM.ENTRY_LEVEL_CODE
, 'P'
, 0
, GMS.TOP_TASK_ID)
, DECODE(PBEM.ENTRY_LEVEL_CODE
, 'P'
, 0
, GMS.TASK_ID)
, DECODE(PBEM.ENTRY_LEVEL_CODE
, 'P'
, NULL
, GMS_BUDGET_UTILS.GET_TASK_NUMBER(GMS.TASK_ID))
, GMS.RESOURCE_LIST_MEMBER_ID
, PR.NAME
, DECODE(GMS.PARENT_MEMBER_ID
, NULL
, GMS.RESOURCE_LIST_MEMBER_ID
, 0
, GMS.RESOURCE_LIST_MEMBER_ID
, GMS.PARENT_MEMBER_ID)
, GMS.START_DATE
, GMS.END_DATE