GL FSG - Report Summary Listing

SELECT report.name report_name,
       rowset.name rowset_name,
       colset.name colset_name,
       conset.name conset_name,
       roword.name roword_name,
       lk1.meaning level_of_detail,
       report.segment_override,
       report.unit_of_measure_id currency,
       lk2.meaning rounding_option,
       ds.name display_set,
       report.description,
	GL_RGXRPTS_XMLP_PKG.c_segment_overrideformula(report.segment_override) C_Segment_Override
FROM
       rg_reports report,
       rg_report_axis_sets rowset,
       rg_report_axis_sets colset,
       rg_report_content_sets conset,
       rg_row_orders roword,
       rg_lookups lk1,
       rg_lookups lk2,
       rg_report_display_sets ds,
       rg_lookups lk3
WHERE
         report.column_set_id = colset.axis_set_id
AND  report.row_set_id = rowset.axis_set_id
AND  report.content_set_id =
            conset.content_set_id(+)
AND  report.row_order_id =
            roword.row_order_id(+)
AND  lk1.lookup_type(+) = 'GL_DISPLAY_LEVEL'
AND  lk1.lookup_code(+) =
    TO_CHAR(report.minimum_display_level)
AND  lk2.lookup_type(+) = 'ROUNDING_OPTION'
AND  lk2.lookup_code(+) = report.rounding_option
AND  ds.report_display_set_id(+) =
         report.report_display_set_id
AND nvl(report.id_flex_code,:C_ID_FLEX_CODE) = :C_ID_FLEX_CODE
AND  nvl(report.structure_id,nvl(:C_STRUCTURE_ID,101)) =
        nvl(:C_STRUCTURE_ID, nvl(report.structure_id,101))
AND  report.application_id in (101,168)
AND  lk3.lookup_type = 'FSG_ADHOC_REPORT_NAME_PREFIX'
AND  lk3.lookup_code = 'ADHOC_PREFIX'
AND  report.name not like lk3.meaning || '%'
AND decode(report.security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_FSG_REPORT_V',
'GL_DAS_FSG_REPORT',to_char(report_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),'Y') = 'Y'
ORDER BY   report.name