GL FSG Rowset and column set
Description
select report.application_id , report.security_flag, report.name report_name, rowset.name row_set_name, colset.name column_set_name, conset.name content_set_name, roword.name row_order_name, lk1.meaning level_of_detail, report.segment_override, report.unit_of_measure_id currency, lk2.meaning rounding_option, lk3.meaning output_option, ds.name display_set, report.description, report.parameter_set_id parm_set_id, gl_rgxrptd_xmlp_pkg.c_segment_overirdeformula(report.segment_override) C_Segment_Overirde, report.id_flex_code, report.structure_id, fnd_data_security.check_function(1.0,'GL_DAS_FSG_REPORT_V', 'GL_DAS_FSG_REPORT',to_char(report.report_id),null,null,null,null,fnd_global.user_name) check_function_, rg.data_type, rg.parameter_num, rg.entered_currency, rg.ledger_currency, rg.currency_type, rg.period_num, rg.fiscal_year_offset 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_lookups lk3, rg_report_display_sets ds, rg_report_parameters rg 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 lk3.lookup_type(+)='OUTPUT_OPTION' and lk3.lookup_code(+)=report.output_option and ds.report_display_set_id(+)=report.report_display_set_id and report.parameter_set_id=rg.parameter_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 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.report_id),null,null,null,null,fnd_global.user_name),'T','Y','N'), 'Y')='Y'*/ order by report.name |