select statement inside decode function in report builder 10.1.2.

hello all

this query executes in oracle sql developer and  in report builder 10.1.2.0.2  query,  but not  in report builder's formula column . How can i fix it using decode and select statement ?

 

select gcc.segmentn from gl_code_combinations gcc
where GCC.SEGMENTn in (decode(:P_S,
                                                              '10',
                                                              ( SELECT FVCH.FLEX_VALUE
                                                                FROM FND_FLEX_VALUE_CHILDREN_V FVCH
                                                                WHERE FVCH.FLEX_VALUE_SET_ID = 1014

                                                                AND FVCH.FLEX_VALUE BETWEEN '10' AND '19'
                                                                AND GCC.SEGMENTn = FVCH.FLEX_VALUE
                                                                 AND FVCH.SUMMARY_FLAG = 'N'
                                                                 AND LEVEL IN (0,1,2,3,4)
                                                                 START WITH FVCH.PARENT_FLEX_VALUE = '10'
                                                                  CONNECT BY PRIOR FVCH.FLEX_VALUE = FVCH.PARENT_FLEX_VALUE),