GL FSG - Column Set Summary Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: FSG - Column Set Summary Listing (XML)
Short Name: RGXCOLS_XML
DB package: GL_RGXCOLS_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 = 'C'
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_COLUMN_SET_V',
'GL_DAS_FSG_COLUMN_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