ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9279D2E0530100007F1FF2 GL Ledger / Set 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.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 AR جميع دفاتر الأستاذ ومجموعات دفتر الأستاذ D Alle Ledger und Ledger-Sets E Todos los libros de contabilidad y conjuntos de libros de contabilidad F Tous les grands livres et ensembles de grands livres I Tutti i registri e i set di registri JA すべての元帳と元帳セット KO 모든 원장 및 원장 세트 PTB Todos os livros contábeis e conjuntos de livros contábeis RU Все бухгалтерские книги и комплекты бухгалтерских книг S Alla reskontrar och reskontrasatser TR Tüm defterler ve defter setleri US All ledgers and ledger sets ZHS 所有分类账和分类账组 8E2FF36EDF3F79D2E0530100007F1FF2 GL Period (non adjustment) Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger.value) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.adjustment_period_flag='N' and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger.value,gl.name)='Y') and (:$flex$.chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name AR جميع فترات دفتر الأستاذ العام غير القابلة للتعديل ، تعتمد على وحدة التشغيل أو دفتر الأستاذ أو مخطط الحسابات D Alle nicht angepassten GL-Perioden, abhängig von Bedieneinheit, Ledger oder Kontenplan E Todos los periodos GL no ajustados, dependientes de la unidad operativa, el libro mayor o el plan de cuentas F Toutes les périodes de garantie non ajustées, en fonction de l'unité opérationnelle, du grand livre ou du plan comptable I Tutti i periodi GL non rettificati, a seconda dell'unità operativa, del libro mastro o del piano dei conti JA すべての非調整GL期間は、オペレーティング・ユニット、元帳または財務諸表に依存しています。 KO 운영 단위, 원장 또는 계정과 목표에 따라 모든 비 조정 GL 기간 PTB Todos os períodos sem ajuste GL, dependendo da unidade operacional, ledger ou plano de contas RU Все периоды, не подлежащие корректировке, в зависимости от операционной единицы, бухгалтерской книги или плана счетов. S Alla icke-justerade GL-perioder, beroende på operativ enhet, bokföring eller kontoplan TR Tüm ayarlanmamış GL dönemleri, işletim birimi, defter veya hesap planına bağlı olarak US All non adjustment GL periods, dependent on operating unit, ledger or chart of accounts ZHS 所有不调整的总分类账期，取决于业务单位、分类账或会计科目表。 83800B4BB6A60DB5E0531F8B2A0AD753Y select z.*, gcck1.concatenated_segments gjl_account, gcck2.concatenated_segments xal_account from ( select max(dr_mismatch) over (partition by je_header_id,je_line_num) max_dr_mismatch, max(cr_mismatch) over (partition by je_header_id,je_line_num) max_cr_mismatch, max(ccid_mismatch) over (partition by je_header_id,je_line_num) max_ccid_mismatch, y.* from ( select decode(nvl(gjl_accounted_dr,0),nvl(xal_accounted_dr_sum,0),null,'Y') dr_mismatch, decode(nvl(gjl_accounted_cr,0),nvl(xal_accounted_cr_sum,0),null,'Y') cr_mismatch, decode(gjl_code_combination_id,xal_code_combination_id,null,'Y') ccid_mismatch, x.* from ( select gjb.name batch_name, gjh.je_category, gjh.je_source, gjh.je_header_id, gjl.je_line_num, count(*) over (partition by gjl.je_header_id, gjl.je_line_num) xal_count, xal.ae_header_id, xal.ae_line_num, xal.application_id, xah.event_id, xal.gl_sl_link_id, xal.gl_sl_link_table, gjl.accounted_dr gjl_accounted_dr, xal.accounted_dr xal_accounted_dr, sum(xal.accounted_dr) over (partition by gjl.je_header_id, gjl.je_line_num) xal_accounted_dr_sum, gjl.accounted_cr gjl_accounted_cr, xal.accounted_cr xal_accounted_cr, sum(xal.accounted_cr) over (partition by gjl.je_header_id, gjl.je_line_num) xal_accounted_cr_sum, gjl.code_combination_id gjl_code_combination_id, xal.code_combination_id xal_code_combination_id, gl.name ledger, gjh.period_name, gjh.posted_date from gl_ledgers gl, gl_periods gp, gl_je_batches gjb, gl_je_headers gjh, gl_je_lines gjl, gl_import_references gir, xla_ae_lines xal, xla_ae_headers xah where 1=1 and gl.period_set_name=gp.period_set_name and gp.adjustment_period_flag='N' and gp.period_name=gjh.period_name and gl.ledger_id=gjh.ledger_id and gjh.status='P' and gjh.actual_flag='A' and gjb.je_batch_id=gjh.je_batch_id and gjh.je_header_id=gjl.je_header_id and gjl.je_header_id=gir.je_header_id(+) and gjl.je_line_num=gir.je_line_num(+) and gir.gl_sl_link_id=xal.gl_sl_link_id and gir.gl_sl_link_table=xal.gl_sl_link_table and xah.ae_header_id=xal.ae_header_id and xah.application_id=xal.application_id ) x ) y ) z, gl_code_combinations_kfv gcck1, gl_code_combinations_kfv gcck2 where (max_dr_mismatch is not null or max_cr_mismatch is not null or max_ccid_mismatch is not null) and gjl_code_combination_id=gcck1.code_combination_id(+) and xal_code_combination_id=gcck2.code_combination_id(+) order by je_header_id, je_line_num, ae_header_id, ae_line_num, application_id US GL Journal vs Subledger mismatches 1=1 1 10 1=1 gl.name=:ledger_name LOV GL Ledger / Set 8E2FF36EDE9279D2E0530100007F1FF2 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.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 US Ledger 2 20 1=1 gjl.period_name=:period_name LOV GL Period (non adjustment) 8E2FF36EDF3F79D2E0530100007F1FF2 Y select distinct gp.period_name value, ( select xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_period_statuses gps where gp.period_name=gps.period_name and gps.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=:$flex$.ledger.value) and gps.application_id=101 ) description, min(gp.start_date) over (partition by gp.period_name) min_start_date from gl_periods gp where gp.adjustment_period_flag='N' and (gp.period_set_name,gp.period_type) in ( select gl.period_set_name, gl.accounted_period_type from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger.value,gl.name)='Y') and (:$flex$.chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y')) ) order by min_start_date desc, gp.period_name US Period 3 30 1=1 gjb.name=:batch_name Char US Batch Name