GL FSG - Content Set Summary Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Content Set Summary Listing
Application: General Ledger
Source: FSG - Content Set Summary Listing (XML)
Short Name: RGXCONS_XML
DB package: GL_RGXCONS_XMLP_PKG
Run GL FSG - Content Set Summary Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_FSG_CONTENT_SET_V',
'GL_DAS_FSG_CONTENT_SET',to_char(content_set_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),
'Y') = 'Y' 
ORDER BY rg_report_content_sets.name
Download
 
Related Blitz Reports
GL FSG - Report Set Detail Listing GL FSG - Report Detail Listing GL FSG - Report Summary Listing GL FSG - Content Set Detail Listing PN Generate Lease Details GL FSG Reports GL FSG - Report Set Summary Listing GL FSG - Column Set Summary Listing GL FSG - Row Set Summary Listing
Blitz Report™

Blitz Report™ provides multiple benefits: