ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US A95C471001B20DD1E0530100007FBF83 GL Ledger (all) Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name D Alle Hauptbücher E Todos los libros de contabilidad F Tous les livres I Tutti i libri contabili US All ledgers A08E8022E6A1387DE0530100007F076F select ( select distinct listagg(gl0.name,', ') within group (order by gl0.name) over (partition by glsnav.ledger_id) ledger_set from gl_ledger_set_norm_assign_v glsnav, gl_ledgers gl0 where gl.ledger_id=glsnav.ledger_id and glsnav.ledger_set_id=gl0.ledger_id ) ledger_set, gl.name ledger, xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101) ledger_category, gl.currency_code currency, gl.period_set_name calendar, ftv.territory_short_name country, xfi.town_or_city city, xfi.name legal_entity, xfi.legal_entity_identifier, ( select distinct listagg(gleb.flex_segment_value,', ') within group (order by gleb.flex_segment_value) over (partition by gleb.legal_entity_id) segment_value from gl_legal_entities_bsvs gleb where xfi.legal_entity_id=gleb.legal_entity_id ) balancing_segment_value, ( select distinct listagg(decode(ffvs.flex_value_set_id,null,gl_ledgers_pkg.get_bsv_desc('LE',gleb.flex_value_set_id,gleb.flex_segment_value),ffvs.description),', ') within group (order by gleb.flex_segment_value) over (partition by gleb.legal_entity_id) description from gl_legal_entities_bsvs gleb, fnd_flex_values_vl ffvs where xfi.legal_entity_id=gleb.legal_entity_id and gleb.flex_value_set_id=ffvs.flex_value_set_id(+) and gleb.flex_segment_value=ffvs.flex_value(+) ) bsv_description, xfi.registration_number, ftv.territory_short_name||nvl2(xfi.legislative_cat_code,' - '||xxen_util.meaning(xfi.legislative_cat_code,'LEGISLATIVE_CATEGORY',222),null) juristdiction, xfi.address_line_1, xfi.address_line_2, xfi.address_line_3, xfi.postal_code, (select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#') chart_of_accounts_name, gl.ledger_category_code, xxen_util.user_name(gl.created_by) created_by, xxen_util.client_time(gl.creation_date) creation_date, xxen_util.user_name(gl.last_updated_by) last_updated_by, xxen_util.client_time(gl.last_update_date) last_update_date, gl.ledger_id, gl.chart_of_accounts_id, xfi.legal_entity_id from gl_ledgers gl, gl_ledger_config_details glcd, xle_firstparty_information_v xfi, fnd_territories_vl ftv where 1=1 and gl.object_type_code='L' and gl.configuration_id=glcd.configuration_id(+) and glcd.object_type_code(+)='LEGAL_ENTITY' and glcd.setup_step_code(+)='NONE' and glcd.object_id=xfi.legal_entity_id(+) and xfi.country=ftv.territory_code(+) order by chart_of_accounts_name, ledger_set, ledger, legal_entity, currency, country Added calendar Y US GL Ledgers and Legal Entities Master data report showing ledger set, ledger name, ledger category, currency, legal entity, and balancing segment across all ledgers and legal entities. Enginatics R12 only 1=1 1 10 1=1 gl.name=:ledger LOV GL Ledger (all) A95C471001B20DD1E0530100007FBF83 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name F Grand livre US Ledger 2 50 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name F Pays US Country