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 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 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 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 7F4C3AA03876145EE0530100007F05FC select haouv.name business_group, &ledger_set_column 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, hou.name operating_unit, ood.organization_code, (select mp0.organization_code from mtl_parameters mp, mtl_parameters mp0 where ood.organization_id=mp.organization_id and mp.master_organization_id=mp0.organization_id and mp.organization_id<>mp.master_organization_id) master_org, ood.organization_name organization_name, ftv.territory_short_name country, hla.town_or_city city, &legal_entity_column hla.location_code, nvl2(hla.address_line_1,hla.address_line_1||', ','')|| nvl2(hla.address_line_2,hla.address_line_2||', ','')|| nvl2(hla.address_line_3,hla.address_line_3||', ','')|| nvl2(hla.region_2,hla.region_2||', ','') address, hla.postal_code, fifsv.id_flex_structure_name chart_of_accounts_name, gl.ledger_id, fifsv.id_flex_structure_code chart_of_accounts_code, gl.chart_of_accounts_id, ood.operating_unit operating_unit_id, ood.organization_id from gl_ledgers gl, fnd_id_flex_structures_vl fifsv, hr_operating_units hou, hr_all_organization_units_vl haouv, org_organization_definitions ood, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv &legal_entity_table where nvl(ood.disable_date,sysdate)>=sysdate and nvl(hou.date_to,sysdate)>=sysdate and 1=1 and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gl.ledger_id=hou.set_of_books_id(+) and hou.business_group_id=haouv.organization_id(+) and hou.organization_id=ood.operating_unit(+) and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) &legal_entity_join order by chart_of_accounts_name, &ledger_set_order_by business_group, ledger, currency, operating_unit, country, organization_code Added calendar Y AR GL Ledgers and Organizations تقرير بيانات رئيسي يعرض مجموعة الأعمال ، مجموعة دفتر الأستاذ ، دفتر الأستاذ ، فئة دفتر الأستاذ ، العملة ، اسم مخطط الحسابات ، وحدة التشغيل ، رمز المؤسسة ، البلد ، الكيان القانوني ، معرف دفتر الأستاذ ، رمز مخطط الحسابات. ويتضمن أيضًا عناصر الدعم مثل معرف دليل الحسابات ومعرف وحدة التشغيل ومعرف المؤسسة. D GL Ledgers and Organizations Stammdatenbericht mit Geschäftsgruppe, Ledger-Set, Ledger, Ledger-Kategorie, Währung, Kontenplanname, Betriebseinheit, Organisationscode, Land, juristische Person, Ledger-ID, Kontenplancode. Er enthält auch Hilfselemente wie Kontenplan-ID, Betriebseinheits-ID und Organisations-ID. E GL Ledgers and Organizations Informe de datos maestros que muestra el grupo empresarial, el conjunto de libros, el libro mayor, la categoría de libros, la moneda, el nombre del plan de cuentas, la unidad operativa, el código de la organización, el país, la entidad legal, el identificador del libro mayor y el código del plan de cuentas. También incluye elementos de apoyo como el ID del plan de cuentas, el ID de la unidad operativa y el ID de la organización. F GL Ledgers and Organizations Rapport sur les données de base indiquant le groupe d'entreprises, le set de comptes, le grand livre, la catégorie de comptes, la devise, le nom du plan comptable, l'unité opérationnelle, le code d'organisation, le pays, l'entité juridique, l'identification du grand livre, le code du plan comptable. Il comprend également des éléments de support tels que l'ID du plan comptable, l'ID de l'unité opérationnelle et l'ID de l'organisation. I GL Ledgers and Organizations Rapporto sui dati master che mostra il gruppo d'affari, l'insieme del libro mastro, il libro mastro, la categoria del libro mastro, la valuta, il nome del piano dei conti, l'unità operativa, il codice dell'organizzazione, il paese, l'entità legale, l'id del libro mastro, il codice del piano dei conti. Include anche elementi di supporto come ID piano dei conti, ID unità operativa e ID organizzazione. JA GL Ledgers and Organizations 事業グループ、元帳セット、元帳、元帳カテゴリ、通貨、勘定科目名、操作単位、組織コード、国、法人、元帳ID、勘定科目コードを表示するマスターデータレポートです。勘定科目ID、操作単位ID、組織IDなどのサポート要素も含まれています。 KO GL Ledgers and Organizations 업무 그룹, 원장 세트, 원장, 원장 범주, 통화, 계정과 목표 이름, 운영 단위, 조직 코드, 국가, 법인, 원장 ID, 계정과 목표 코드를 보여주는 마스터 데이터 보고서. 또한 계정과 목표 ID, 운영 단위 ID 및 조직 ID와 같은 지원 요소도 포함됩니다. PTB GL Ledgers and Organizations Relatório de dados mestre mostrando grupo empresarial, conjunto de razões, razão, categoria da razão, moeda, nome do plano de contas, unidade operacional, código de organização, país, pessoa jurídica, id da razão, código do plano de contas. Também inclui elementos de suporte como ID do plano de contas, ID da unidade operacional e ID da organização. RU GL Ledgers and Organizations Отчет по основным данным, показывающий бизнес-группу, набор бухгалтерских книг, бухгалтерскую книгу, категорию бухгалтерской книги, валюту, план наименования счетов, операционную единицу, код организации, страну, юридическое лицо, идентификатор бухгалтерской книги, план кода счетов. Он также включает такие вспомогательные элементы, как план счетов ID, ID операционной единицы и ID организации. S GL Ledgers and Organizations Huvuddatarapport som visar affärsgrupp, bokföringsuppsättning, bokföringsbok, huvudbokskategori, valuta, kontoplan, verksamhetsenhet, organisationskod, land, juridisk enhet, bokförings-id, kontoplan. Det innehåller också supportelement som kontoplan-ID, operativ enhets-ID och organisations-ID. TR GL Ledgers and Organizations İş grubu, defter seti, defter, genel muhasebe kategorisi, para birimi, hesap planı adı, işletim birimi, organizasyon kodu, ülke, tüzel kişilik, defter kimliği, hesap planı kodunu gösteren ana veri raporu. Ayrıca hesap planı kimliği, işletim birimi kimliği ve kuruluş kimliği gibi destek öğelerini de içerir. US GL Ledgers and Organizations Master data report showing business group, ledger set, ledger, ledger category, currency, chart of accounts name, operating unit, organization code, country, legal entity, ledger id, chart of accounts code. It also includes support elements such as chart of accounts ID, operating unit ID, and organization ID. ZHS GL Ledgers and Organizations 主数据报表显示业务组、账套、明细账、明细账类别、货币、账表名称、经营单位、组织机构代码、国家、法人、明细账ID、账表代码。还包括账表ID、经营单位ID、组织ID等支持要素。 Enginatics &ledger_set_column &ledger_set_order_by &legal_entity_column &legal_entity_join &legal_entity_table 1=1 1 -10 &ledger_set_column ( 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, Char 12 select decode(fnd_release.major_version,'11','11','12') from dual F Version de la version EBS US EBS Release Version 2 &ledger_set_order_by ledger_set, 12 F Version de la version EBS US EBS Release Version 3 &legal_entity_column xep.name legal_entity, 12 F Version de la version EBS US EBS Release Version 4 &legal_entity_join and ood.legal_entity=xep.legal_entity_id(+) 12 F Version de la version EBS US EBS Release Version 5 &legal_entity_table , xle_entity_profiles xep 12 F Version de la version EBS US EBS Release Version 6 10 1=1 fifsv.id_flex_structure_name=:chart_of_accounts 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 F Plan comptable US Chart of Accounts 7 20 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 8 30 1=1 hou.name=:operating_unit LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US Operating Unit 9 40 1=1 ood.organization_code=:organization_code LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US Organization Code 10 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 11 60 1=1 nvl(ood.disable_date,sysdate)>=sysdate and nvl(hou.date_to,sysdate)>=sysdate LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Organisations actives uniquement US Active Organizations only :$flex$.chart_of_accounts Chart of Accounts Ledger :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Organization Code :$flex$.operating_unit Operating Unit Organization Code