GL FSG - Row Set Summary Listing

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