SELECT   @SELECT:DIM:USER_DEF:IMPLIED:SCENARIO:OCCS.ID:ID@,
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.CODS_DIVISIONAL_ID:DIV_ID@,
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:INV.NAME:INITIATIVE_NAME@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.NAME:SCENARIO_NAME@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.CODS_SCEN_DESC:SCENARIO_DESCRIPTION@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.cods_demand_obs:DEMAND_AREA_OBS@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:(select Name from cmn_lookups_V where lookup_type = 'CO_BENEFIT_CATEGORY' and language_code='en' and lookup_code =OCCS.cods_proj_benf_cat):GOAL_CATEGORY@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.CODS_PRJ_PM:PROJECT_MANAGER@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.CODS_ASSO_PRJ_ID:PROJECT_ID@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.CODS_IT_SPONSOR:IT_SPONSOR@,
                   @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.cods_proj_cust:Project_Requestor@,
                   @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:OCCS.cods_exec_sponsor:Project_VP_Sponsor@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:(select srm.FIRST_NAME ||' '||srm.LAST_NAME FULL_NAME from srm_resources srm where srm.id = OCCS.cods_proj_cust):Project_Requestor_Name@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:(select srm.FIRST_NAME ||' '||srm.LAST_NAME FULL_NAME from srm_resources srm where srm.id = OCCS.cods_exec_sponsor):Project_VP_Sponsor_Name@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:(select srm.FIRST_NAME ||' '||srm.LAST_NAME FULL_NAME from srm_resources srm where srm.id = CODS_PRJ_PM):prj_mgr_name@,
 @SELECT:DIM_PROP:USER_DEF:IMPLIED:SCENARIO:(select srm.FIRST_NAME ||' '||srm.LAST_NAME FULL_NAME from srm_resources srm where srm.id = CODS_IT_SPONSOR):IT_SPONSOR_Name@

FROM INV_INVESTMENTS INV,
         ODF_CA_CODS_SCENARIO OCCS
WHERE    OCCS.ID=@WHERE:PARAM:XML:INTEGER:/data/id/@value@
AND OCCS.ODF_PARENT_ID=INV.ID
AND      @FILTER@