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
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
Run
GL FSG - Report Set Summary Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |