GL FSG - Row Set Summary Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- FSG - Row Set Summary Listing (XML)
- Short Name
- RGXROWS_XML
- DB package
- GL_RGXROWS_XMLP_PKG
Imported from BI Publisher
Row Set Summary Listing
Row Set Summary Listing
SQL 23 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 = '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 |