ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN D522E894B535508EE0530100007F7AD6Y select rro.name row_order, rro.description, xxen_util.yes(rro.security_flag) security, rro.column_name, rro.column_number column_order, xxen_util.meaning(rro.row_rank_type,'RANKING_TYPE',168) ranking, rrssv.segment_sequence sequence, rrssv.seg_name segment, xxen_util.meaning(rrssv.seg_order_type,decode(rrssv.application_column_name,'LEDGER_SEGMENT','LEDGER_ORDERING_TYPE','ORDERING_TYPE'),168) order_by, xxen_util.meaning(rrssv.seg_display_type,decode(rrssv.application_column_name,'LEDGER_SEGMENT','LEDGER_SEG_DISPLAY_TYPE','SEG_DISPLAY_TYPE'),168) display, rrssv.segment_width width, xxen_util.user_name(rrssv.created_by) created_by, xxen_util.client_time(rrssv.creation_date) creation_date, xxen_util.user_name(rrssv.last_updated_by) last_updated_by, xxen_util.client_time(rrssv.last_update_date) last_update_date, fifsv.id_flex_structure_name, rro.structure_id, rro.row_order_id from rg_row_orders rro, fnd_id_flex_structures_vl fifsv, rg_row_segment_sequences_v rrssv where 1=1 and rro.application_id=fifsv.application_id and rro.id_flex_code=fifsv.id_flex_code and rro.structure_id=fifsv.id_flex_num and rro.row_order_id=rrssv.row_order_id and rro.structure_id=rrssv.structure_id order by fifsv.id_flex_structure_name, rro.name, rrssv.segment_sequence US GL FSG Row Orders Financial Statement Generator row order listing Enginatics 1=1 1 10 1=1 fifsv.id_flex_structure_name=:id_flex_structure_name LOV custom Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code||': '||fifsv.description description from fnd_id_flexs fif, fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fif.application_id=fifsv.application_id and fif.id_flex_code=fifsv.id_flex_code 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