ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A803B608ACE0530100007FEB91 select /*+ parallel*/ distinct gl.name ledger, gjh.je_category category, gjcv.description category_desc, &columns1 count(*) over (partition by gl.name, gjh.je_category &partition_by) header_count, count(distinct gjb.name) over (partition by gl.name &partition_by) batch_name_count, count(distinct gjh.period_name) over (partition by gl.name, gjh.je_category &partition_by) period_count, min(distinct gps.start_date) over (partition by gl.name, gjh.je_category &partition_by) min_period_start_date, max(distinct gps.end_date) over (partition by gl.name, gjh.je_category &partition_by) max_period_end_date, count(*) over (partition by gl.name, gjh.je_category) total_count from gl_ledgers gl, gl_period_statuses gps, gl_je_batches gjb, gl_je_headers gjh, gl_je_categories_vl gjcv where gl.ledger_id=gjh.ledger_id and gps.application_id=101 and gps.period_name=gjh.period_name and gps.ledger_id=gjh.ledger_id and gjh.status='P' and gjh.actual_flag='A' and gjh.je_batch_id=gjb.je_batch_id and gjh.je_category=gjcv.je_category_name(+) order by gl.name, total_count desc, gjh.je_category, header_count desc Y AR GL Header Categories Summary تقرير بيانات رئيسي يعرض تعريفات دفتر الأستاذ والفئة والمصدر عبر دفاتر الأستاذ المتعددة. D GL Header Categories Summary Stammdatenbericht mit Ledger-, Kategorie- und Quellendefinitionen über mehrere Ledger hinweg. E GL Header Categories Summary Informe de datos maestros que muestra las definiciones del libro mayor, la categoría y la fuente en varios libros mayores. F GL Header Categories Summary Rapport sur les données de base montrant les définitions de grand livre, de catégorie et de source dans plusieurs grands livres. I GL Header Categories Summary Rapporto sui dati principali che mostra le definizioni di registro, categoria e fonte in più registri. JA GL Header Categories Summary 複数の元帳にまたがる元帳、カテゴリ、ソースの定義を示すマスターデータレポート。 KO GL Header Categories Summary 여러 원장에 대한 원장, 범주 및 소스 정의를 보여주는 마스터 데이터 보고서. PTB GL Header Categories Summary Relatório de dados mestre mostrando ledger, categoria e definições de fonte em vários ledgers. RU GL Header Categories Summary Отчет об основных данных, содержащий определения бухгалтерской книги, категорий и источников по нескольким бухгалтерским книгам. S GL Header Categories Summary Huvuddatarapport som visar huvudbok-, kategori- och källdefinitioner över flera huvudböcker. TR GL Header Categories Summary Birden çok defterde genel muhasebe, kategori ve kaynak tanımlarını gösteren ana veri raporu. US GL Header Categories Summary Master data report showing ledger, category and source definitions across multiple ledgers. ZHS GL Header Categories Summary 主数据报告显示多个分类账的分类账、类别和来源定义。 Enginatics &columns1 &partition_by 1 10 &columns1 gjh.je_source source, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Développer les sources US Expand Sources 2 &partition_by , gjh.je_source F Développer les sources US Expand Sources