GL FSG - Report Set Detail Listing

Description
Categories: BI Publisher
Columns: Sequence, Report Name, Rowset Name, Colset Name, Conset Name, Roword Name, Level Of Detail, Segment Override1, Currency, Rounding Option ...
Application: General Ledger
Source: FSG - Report Set Detail Listing (XML)
Short Name: RGXRSETD_XML
DB package: GL_RGXRSETD_XMLP_PKG
SELECT request.sequence,
      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 segment_override1,
       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,
       --request.report_set_id,
       request.report_set_id report_set_id1,
	GL_RGXRSETD_XMLP_PKG.c_segment_overrideformula(report.segment_override) C_Segment_Override
FROM
       rg_reports report,
       rg_report_requests request,
       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
WHERE  report.report_id = request.report_id
AND  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 request.report_set_id=:report_set_id
ORDER BY   request.sequence
Parameter Name SQL text Validation
Report Set Name
 
LOV Oracle
Access Set Id
 
Number
GL_SRS_COA_UNVALIDATED
 
Number
RG_SRS_INSTALLATION