GL FSG - Report Set Summary Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: FSG - Report Set Summary Listing (XML)
Short Name: RGXRSETS_XML
DB package: GL_RGXRSETS_XMLP_PKG
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
Parameter Name SQL text Validation
Access Set Id
 
Number