GL FSG - Report Set Summary Listing

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Report Set Summary Listing
Application: General Ledger
Source: FSG - Report Set Summary Listing (XML)
Short Name: RGXRSETS_XML
DB package: GL_RGXRSETS_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 name,description
FROM rg_report_sets
WHERE  NVL(id_flex_code,:C_ID_FLEX_CODE) = :C_ID_FLEX_CODE
   AND   NVL(structure_id,NVL(:C_STRUCTURE_ID,101)) =
            NVL(:C_STRUCTURE_ID,NVL(structure_id,101))
   AND  APPLICATION_ID IN (101, 168)
AND decode(security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_FSG_REPORT_SET_V',
'GL_DAS_FSG_REPORT_SET',to_char(report_set_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),
'Y') = 'Y' 
ORDER BY name