GL FSG - Row Set Summary Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Row Set Summary Listing
Application: General Ledger
Source: FSG - Row Set Summary Listing (XML)
Short Name: RGXROWS_XML
DB package: GL_RGXROWS_XMLP_PKG
Run GL FSG - Row Set Summary Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT rg_report_axis_sets.name,
       rg_report_axis_sets.description,
       id_flex_structure_name
FROM   rg_report_axis_sets,
       fnd_id_flex_structures_tl
WHERE
       axis_set_type = 'R'
AND   nvl(rg_report_axis_sets.structure_id,
               nvl(:C_STRUCTURE_ID,101)) = 
          nvl(:C_STRUCTURE_ID,
                nvl(rg_report_axis_sets.structure_id,101))
AND   nvl(rg_report_axis_sets.id_flex_code,:C_ID_FLEX_CODE) =
         :C_ID_FLEX_CODE
AND    rg_report_axis_sets.structure_id = 
               fnd_id_flex_structures_tl.id_flex_num (+)
AND    rg_report_axis_sets.id_flex_code =
               fnd_id_flex_structures_tl.id_flex_code(+) 
AND  rg_report_axis_sets.application_id in (101,168)
AND  fnd_id_flex_structures_tl.language(+) = userenv('LANG') 
AND decode(security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_FSG_ROW_SET_V',
'GL_DAS_FSG_ROW_SET',to_char(axis_set_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),'Y')='Y' 
ORDER BY rg_report_axis_sets.name
Download
 
Related Blitz Reports
GL FSG - Column Set Summary Listing GL FSG - Report Summary Listing GL FSG - Report Detail Listing GL FSG - Column Set Detail Listing GL FSG - Row Set Detail Listing GL FSG Reports GL FSG - Report Set Detail Listing GL FSG - Content Set Summary Listing GL FSG - Report Set Summary Listing
Blitz Report™

Blitz Report™ provides multiple benefits: