SELECT  @SELECT:DIM:USER_DEF:IMPLIED:PLATFORM:P.ID:SCEN_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:S.ID:PLATFORM_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_PLATFORM_NAME:PLATFORM_NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:Substr(P.NAME,instr(P.NAME,'/',1,1)+1,instr(P.NAME,'/',1,2)-2):Division@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:Substr(P.NAME,instr(P.NAME,'/',1,2)+1,instr(P.NAME,'/',1,3)-instr(P.NAME,'/',1,2)-1):Platform_Group@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.NAME:NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_SLOT_HIGH_LOE:HIGH_LOE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_SLOT_LOW_LOE:LOW_LOE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_START_DATE:START_DATE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_END_DATE:END_DATE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:(select Name from cmn_lookups_V where lookup_type = 'CODS_SLOTTING_CATEGORY' and language_code = 'en' and lookup_code = P.CODS_SLOT_CATEGORY):SLOT_CATEGORY@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_PLATFORM_DEPEND:PLATFORM_DEPEND@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_WORK_DRIVERS:WORK_DRIVERS@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:P.CODS_DESCRIPTION:PLAT_NOTES@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PLATFORM:CODS_Platform_Contacts(p.id):platform_contacts@
FROM ODF_CA_CODS_SCENARIO S,
ODF_CA_CODS_PLATFORM P
WHERE P.ODF_PARENT_ID=S.ID 
AND S.ID=@WHERE:PARAM:XML:INTEGER:/data/id/@value@
AND @FILTER@