GL FSG - Report Detail Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: FSG - Report Detail Listing (XML)
Short Name: RGXRPTD_XML
DB package: GL_RGXRPTD_XMLP_PKG
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,
       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
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
WHERE
     report.report_id = nvl(:P_REPORT_ID, report.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 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
Parameter Name SQL text Validation
RG_SRS_INSTALLATION
 
RG_SRS_ADHOC_REPORT_PREFIX
 
LOV Oracle
GL_SRS_COA_UNVALIDATED
 
Number
Access Set Id
 
Number
Report Name
 
LOV Oracle