ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDED679D2E0530100007F1FF2 GL Chart of Accounts (all) Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name US All chart of accounts D51B8A09676D86C9E0530100007F8BEE select rrv.name report_name, rrv.report_title, xxen_util.yes(rrv.security_flag) 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 Y US GL FSG Reports Financial Statement Generator reports Enginatics R12 only 1=1 1 10 1=1 fifsv.id_flex_structure_name=:id_flex_structure_name LOV GL Chart of Accounts (all) 8E2FF36EDED679D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name select x.* from ( select fifsv.id_flex_structure_name from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gl.chart_of_accounts_id=fifsv.id_flex_num order by decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name ) x where rownum=1 F Nom de la structure US Structure Name 2 20 1=1 rrv.row_order=:row_order LOV custom Y select rro.name value, rro.description from rg_row_orders rro, fnd_id_flex_structures_vl fifsv where (:$flex$.gl_chart_of_accounts is null or xxen_util.contains(:$flex$.gl_chart_of_accounts,fifsv.id_flex_structure_name)='Y') and rro.application_id=fifsv.application_id and rro.id_flex_code=fifsv.id_flex_code and rro.structure_id=fifsv.id_flex_num order by rro.name F Ordre des rangs US Row Order