GL FSG - Column Set Summary Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- FSG - Column Set Summary Listing (XML)
- Short Name
- RGXCOLS_XML
- DB package
- GL_RGXCOLS_XMLP_PKG
Imported from BI Publisher
Column Set Summary Listing
Column Set Summary Listing
SQL 24 lines
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 |