GL FSG - Content Set Summary Listing

Description
Categories: BI Publisher
Columns: Name, Description, Type ...
Application: General Ledger
Source: FSG - Content Set Summary Listing (XML)
Short Name: RGXCONS_XML
DB package: GL_RGXCONS_XMLP_PKG
SELECT rg_report_content_sets.name,
       rg_report_content_sets.description,
       rg_lookups.meaning type
FROM   rg_report_content_sets,
            rg_lookups
WHERE  rg_report_content_sets.structure_id = nvl(:C_STRUCTURE_ID,rg_report_content_sets.structure_id)
AND  rg_report_content_sets.id_flex_code = :C_ID_FLEX_CODE
AND    rg_lookups.lookup_type(+) = 'REPORT_RUN_TYPE'
AND    rg_lookups.lookup_code(+) = 
           rg_report_content_sets.report_run_type
AND   rg_report_content_sets.application_id in (101, 168)
AND decode(security_flag,