GL FSG Reports

Description
Categories: Enginatics
Repository: Github
Financial Statement Generator reports

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
rrv.name report_name,
rrv.report_title,
xxen_util.meaning(decode(rrv.security_flag,'Y','Y'),'YES_NO',0) security,
rrv.row_set,
rrv.column_set,
rrv.content_set,
rrv.row_order,
rrv.report_display_set display_set,
rrv.segment_override,
rrv.unit_of_measure_id currency,
xxen_util.meaning(rrv.rounding_option,'ROUNDING_OPTION',168) rounding_option,
xxen_util.meaning(rrv.minimum_display_level,'GL_DISPLAY_LEVEL',168) minimum_display_level,
xxen_util.meaning(rrv.output_option,'OUTPUT_OPTION',168) output_option,
rrv.description,
xxen_util.user_name(rrv.created_by) created_by,
xxen_util.client_time(rrv.creation_date) creation_date,
xxen_util.user_name(rrv.last_updated_by) last_updated_by,
xxen_util.client_time(rrv.last_update_date) last_update_date,
fifsv.id_flex_structure_name,
rrv.structure_id
from
rg_reports_v rrv,
fnd_id_flex_structures_vl fifsv
where
1=1 and
rrv.application_id=fifsv.application_id and
rrv.id_flex_code=fifsv.id_flex_code and
rrv.structure_id=fifsv.id_flex_num
order by
fifsv.id_flex_structure_name,
rrv.name
Parameter Name SQL text Validation
Structure Name
fifsv.id_flex_structure_name=:id_flex_structure_name
LOV
Row Order
rrv.row_order=:row_order
LOV