GL FSG - Report Set Summary Listing

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
General Ledger
Source
FSG - Report Set Summary Listing (XML)
Short Name
RGXRSETS_XML
DB package
GL_RGXRSETS_XMLP_PKG
Imported from BI Publisher
Report Set Summary Listing

SQL 11 lines

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