GL FSG - Content Set Summary Listing

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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