ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 80C6012086D83C25E0530100007FE170Y select /*+ parallel*/ &columns fav.application_short_name, fav.application_name, count(*) count, xte.entity_code, xdl.source_distribution_type, coalesce( decode(xdl.source_distribution_type, 'AP_INV_DIST','ap_invoice_distributions_all', 'AP_PMT_DIST','ap_payment_hist_dists', 'AP_PREPAY','ap_prepay_app_dists', 'XLA_MANUAL','ap_self_assessed_tax_dist_all', --FA 'TRX','fa_adjustments', 'DEPRN','fa_deprn_detail', 'IAC','fa_deprn_detail', --PA 'R','pa_cost_distribution_lines_all', 'C','pa_cost_distribution_lines_all', 'D','pa_cost_distribution_lines_all', 'BL','pa_cc_dist_lines_all', 'Revenue - Normal Revenue','pa_cust_rev_dist_lines_all', 'Revenue - Event Revenue','pa_cust_event_rdl_all', 'Revenue - UBR','pa_draft_revenues_all', 'Revenue - UER','pa_draft_revenues_all' ), --GMF decode(xdl.application_id,555,'gmf_xla_extract_lines'), --other case when xdl.source_distribution_type in ( 'PO_REQ_DISTRIBUTIONS_ALL', 'AR_DISTRIBUTIONS_ALL', 'RCV_RECEIVING_SUB_LEDGER', 'RA_CUST_TRX_LINE_GL_DIST_ALL', 'OKL_TRNS_ACC_DSTRS', 'MTL_TRANSACTION_ACCOUNTS', 'WIP_TRANSACTION_ACCOUNTS', 'PO_DISTRIBUTIONS_ALL' ) then lower(xdl.source_distribution_type) end --(select lower(ds.table_name) from dba_synonyms ds where ds.owner='APPS' and xdl.source_distribution_type=ds.synonym_name) ) source_table, coalesce( decode(xdl.source_distribution_type, --AP 'AP_INV_DIST','invoice_distribution_id', 'AP_PMT_DIST','payment_hist_dist_id', 'AP_PREPAY','prepay_app_dist_id', 'XLA_MANUAL','invoice_distribution_id', --FA 'TRX','transaction_header_id,adjustment_line_id', 'DEPRN','book_type_code, asset_id, period_counter, deprn_run_id, distribution_id', 'IAC','book_type_code, asset_id, period_counter, deprn_run_id, distribution_id', --PA 'R','expenditure_item_id, line_num', 'C','expenditure_item_id, line_num', 'D','expenditure_item_id, line_num', 'BL','expenditure_item_id, line_num', 'Revenue - Normal Revenue','expenditure_item_id, line_num', 'Revenue - Event Revenue','event_id, line_num', 'Revenue - UBR','project_id, draft_revenue_num', 'Revenue - UER','project_id, draft_revenue_num' ), --GMF decode(xdl.application_id,555,'line_id'), --other decode(xdl.source_distribution_type, 'PO_REQ_DISTRIBUTIONS_ALL','distribution_id', 'AR_DISTRIBUTIONS_ALL','line_id', 'RCV_RECEIVING_SUB_LEDGER','rcv_sub_ledger_id', 'RA_CUST_TRX_LINE_GL_DIST_ALL','cust_trx_line_gl_dist_id', 'OKL_TRNS_ACC_DSTRS','id', 'MTL_TRANSACTION_ACCOUNTS','inv_sub_ledger_id', 'WIP_TRANSACTION_ACCOUNTS','wip_sub_ledger_id', 'PO_DISTRIBUTIONS_ALL','po_distribution_id' ) ) source_columns, xal.accounting_class_code, xdl.event_class_code, xdl.event_type_code, xdl.accounting_line_code, xdl.accounting_line_type_code, nvl2(xdl.tax_line_ref_id,'not null',null) tax_line_ref_id, nvl2(xdl.tax_rec_nrec_dist_ref_id,'not null',null) tax_rec_nrec_dist_ref_id, nvl2(xdl.tax_summary_line_ref_id,'not null',null) tax_summary_line_ref_id, xdl.applied_to_entity_code, nvl2(xdl.applied_to_entity_id,'not null',null) applied_to_entity_id, xdl.applied_to_distribution_type, nvl2(xdl.applied_to_dist_id_char_1,'not null',null) applied_to_dist_id_char_1, nvl2(xdl.applied_to_dist_id_num_1,'not null',null) applied_to_dist_id_num_1, nvl2(xdl.applied_to_source_id_char_1,'not null',null) applied_to_source_id_char_1, nvl2(xdl.applied_to_source_id_num_1,'not null',null) applied_to_source_id_num_1, nvl2(xdl.source_distribution_id_char_1,'not null',null) source_distribution_id_char_1, nvl2(xdl.source_distribution_id_char_2,'not null',null) source_distribution_id_char_2, nvl2(xdl.source_distribution_id_char_3,'not null',null) source_distribution_id_char_3, nvl2(xdl.source_distribution_id_char_4,'not null',null) source_distribution_id_char_4, nvl2(xdl.source_distribution_id_char_5,'not null',null) source_distribution_id_char_5, nvl2(xdl.source_distribution_id_num_1,'not null',null) source_distribution_id_num_1, nvl2(xdl.source_distribution_id_num_2,'not null',null) source_distribution_id_num_2, nvl2(xdl.source_distribution_id_num_3,'not null',null) source_distribution_id_num_3, nvl2(xdl.source_distribution_id_num_4,'not null',null) source_distribution_id_num_4, nvl2(xdl.source_distribution_id_num_5,'not null',null) source_distribution_id_num_5, xdl.merge_duplicate_code, xdl.line_definition_owner_code, xdl.line_definition_code, sum(xdl.unrounded_entered_cr) unrounded_entered_cr, sum(xdl.unrounded_accounted_cr) unrounded_accounted_cr, nvl2(xdl.upg_batch_id,'not null',null) upg_batch_id, xdl.application_id from gl_ledgers gl, xla_ae_lines xal, xla_ae_headers xah, xla.xla_transaction_entities xte, xla_distribution_links xdl, fnd_application_vl fav where 1=1 and gl.ledger_id=xal.ledger_id and xal.ae_header_id=xah.ae_header_id(+) and xal.application_id=xah.application_id(+) and xah.gl_transfer_status_code(+)='Y' and xah.accounting_entry_status_code(+)='F' and xah.entity_id=xte.entity_id(+) and xah.application_id=xte.application_id(+) and xal.ae_header_id=xdl.ae_header_id and xal.ae_line_num=xdl.ae_line_num and xal.application_id=xdl.application_id and xal.application_id=fav.application_id(+) group by &group_by fav.application_short_name, fav.application_name, xte.entity_code, xdl.source_distribution_type, xal.accounting_class_code, xdl.event_class_code, xdl.event_type_code, xdl.accounting_line_code, xdl.accounting_line_type_code, nvl2(xdl.tax_line_ref_id,'not null',null), nvl2(xdl.tax_rec_nrec_dist_ref_id,'not null',null), nvl2(xdl.tax_summary_line_ref_id,'not null',null), xdl.applied_to_entity_code, nvl2(xdl.applied_to_entity_id,'not null',null), xdl.applied_to_distribution_type, nvl2(xdl.applied_to_dist_id_char_1,'not null',null), nvl2(xdl.applied_to_dist_id_num_1,'not null',null), nvl2(xdl.applied_to_source_id_char_1,'not null',null), nvl2(xdl.applied_to_source_id_num_1,'not null',null), nvl2(xdl.source_distribution_id_char_1,'not null',null), nvl2(xdl.source_distribution_id_char_2,'not null',null), nvl2(xdl.source_distribution_id_char_3,'not null',null), nvl2(xdl.source_distribution_id_char_4,'not null',null), nvl2(xdl.source_distribution_id_char_5,'not null',null), nvl2(xdl.source_distribution_id_num_1,'not null',null), nvl2(xdl.source_distribution_id_num_2,'not null',null), nvl2(xdl.source_distribution_id_num_3,'not null',null), nvl2(xdl.source_distribution_id_num_4,'not null',null), nvl2(xdl.source_distribution_id_num_5,'not null',null), xdl.merge_duplicate_code, xdl.line_definition_owner_code, xdl.line_definition_code, nvl2(xdl.upg_batch_id,'not null',null), xdl.application_id order by fav.application_short_name, fav.application_name, count(*) desc AR XLA Distribution Links Summary ملخص ارتباطات توزيع دفتر الأستاذ الفرعي للمطورين للتعرف على معرفات المصدر التي يتم ملؤها لمصادر جدول دفتر الأستاذ الفرعي. تم وصف الارتباط بجداول دفتر الأستاذ الفرعي لقيم source_distribution_type المختلفة ، على سبيل المثال معرّفات MOS Doc لـ: AP 813968.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=2002464.1 السلطة الفلسطينية 1274575.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=1274575.1 بالنسبة لـ GMF ، هناك تصحيح تقرير التسوية المستحقة لـ AP و PO من OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=2114612.1 و دليل استكشاف الأخطاء وإصلاحها المالية 1213193.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=1213193.1 كيف يتم استخدام جدول gl_import_references في 11i مقابل R12 موصوف في الملاحظات 165327.1 و 130542.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=130542.1 D XLA Distribution Links Summary Zusammenfassung der Links zur Nebenbuchhaltung für Entwickler, um zu verstehen, welche source_ids für welche Quellen der Nebenbuchhaltungstabelle ausgefüllt werden. Der Link zu Nebenbuchhaltungstabellen für verschiedene source_distribution_type-Werte wird beschrieben, z. B. MOS Doc IDs für: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 Für GMF gibt es AP und PO Accrual Reconciliation Report Debugging aus OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 und Financials Troubleshooting Guide 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 Wie die Tabelle gl_import_references in 11i vs. R12 verwendet wird, ist in den Hinweisen 165327.1 und 130542.1 beschrieben https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 E XLA Distribution Links Summary Resumen de los enlaces de distribución del libro mayor para que los desarrolladores entiendan qué source_ids se rellenan para qué fuentes de tablas del libro mayor. El enlace a las tablas del libro mayor para diferentes valores de source_distribution_type se describe, por ejemplo, MOS Doc IDs para: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 Para GMF, hay Depuración del informe de conciliación de AP y PO desde OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 y la Guía de resolución de problemas de Financials 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 Cómo se utiliza la tabla gl_import_references en 11i frente a R12 se describe en las notas 165327.1 y 130542.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 F XLA Distribution Links Summary Résumé des liens de distribution du grand livre auxiliaire pour que les développeurs puissent comprendre quelles sources_id sont remplies pour quelles sources de tables du grand livre auxiliaire. Le lien vers les tables du livre auxiliaire pour différentes valeurs de type source_distribution est décrit, par exemple les ID de documents MOS pour : AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 Pour le GMF, il y a Rapport de réconciliation des comptes d'exercice des AP et des PO Débogage de OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 et Guide de dépannage de Financials 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 La manière dont le tableau gl_import_references est utilisé dans 11i vs R12 est décrite dans les notes 165327.1 et 130542.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 I XLA Distribution Links Summary Riassunto dei link di distribuzione subledger per gli sviluppatori per capire quali source_ids sono popolati per quali fonti di tabelle subledger. Il collegamento alle tabelle subledger per diversi valori di source_distribution_type è descritto, ad esempio, gli ID dei documenti MOS per: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 Per GMF, c'è AP e PO Accrual Reconciliation Report Debugging da OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 e Financials Troubleshooting Guide 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 Come la tabella gl_import_references è usata in 11i vs R12 è descritta nelle note 165327.1 e 130542.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 JA XLA Distribution Links Summary 開発者がどのsource_idがどのサブレッジャーテーブルのソースに対して入力されているかを理解するためのサブレッジャー配布リンクのまとめ。 異なるsource_distribution_type値のサブレッジャーテーブルへのリンクは、例えばMOS Doc ID forなどに記載されています。 AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 GMFの場合は OPM Financials からの AP および PO の未払費用の調整レポートのデバッグ 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 および Financials トラブルシューティング・ガイド 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 11i と R12 で gl_import_references テーブルがどのように使われているかは、ノート 165327.1 と 130542.1 に記載されています。 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 KO XLA Distribution Links Summary 개발자가 보조 원장 테이블 소스에 대해 어떤 source_id가 채워지는지 이해할 수있는 보조 원장 배포 링크 요약입니다. 다른 source_distribution_type 값에 대한 보조 원장 테이블에 대한 링크가 설명됩니다. 다음에 대한 MOS 문서 ID : AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 GMF의 경우 OPM Financials 2114612.1에서 디버깅하는 AP 및 PO 발생 조정 보고서 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 및 재무 문제 해결 가이드 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 11i 대 R12에서 gl_import_references 테이블이 사용되는 방법은 메모 165327.1 및 130542.1에 설명되어 있습니다. https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 PTB XLA Distribution Links Summary Resumo dos links de distribuição de subledger para que os desenvolvedores entendam quais as fontes_identificadas são povoadas para quais fontes de tabela de subledger. O link para tabelas de subledger para diferentes valores do tipo source_distribution_distribution_type é descrito, por exemplo, MOS Doc IDs para: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 Para a GMF, há AP e PO Accrual Reconciliation Report Debugging from OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 e Guia de Solução de Problemas Financeiros 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 Como o quadro gl_import_references utilizado no 11i vs R12 é descrito nas notas 165327.1 e 130542.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 RU XLA Distribution Links Summary Сводка ссылок на распределение в подкаталогах для понимания разработчиками, для каких источников в подкаталогах заполняются source_ids. Описана ссылка на таблицы подкаталогов для различных значений типа source_distribution_, например, MOS Doc IDs для: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 Для GMF, есть Отчет о сверке ДП и ДП по разграничению, отладка из OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1. и Руководство по поиску и устранению неисправностей в финансовых отчетах 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1. Как таблица gl_import_references, используемая в 11i vs R12, описана в примечаниях 165327.1 и 130542.1. https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 S XLA Distribution Links Summary Sammanfattning av distributionslänkar för underledare för utvecklare för att förstå vilka käll_id som är fyllda för vilka källor för tabell under tabell. Länken till subledger-tabeller för olika källfördelningsvärden beskrivs t.ex. MOS Doc ID för: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 För GMF finns det AP och PO-avstämningsrapport felsökning från OPM Financials 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 Felsökningsguide 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 Hur tabellen gl_import_references används i 11i vs R12 beskrivs i noterna 165327.1 och 130542.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 TR XLA Distribution Links Summary Geliştiricilerin, hangi yardımcı defter tablo kaynakları için hangi kaynak_idlerin doldurulduğunu anlamaları için yardımcı defter dağıtım bağlantılarının özeti. Farklı kaynak_distribution_type değerleri için yardımcı defter tablolarına bağlantı, ör. MOS Doküman Kimlikleri: AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 GMF için var OPM Financials'tan AP ve PO Tahakkuk Mutabakat Raporu Hata Ayıklama 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 ve Financials Sorun Giderme Kılavuzu 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 Gl_import_references tablosunun 11i'ye karşı R12'de nasıl kullanıldığı 165327.1 ve 130542.1 numaralı notlarda açıklanmaktadır. https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 US XLA Distribution Links Summary Summary of subledger distribution links for developers to understand which source_ids are populated for which subledger table sources. The link to subledger tables for different source_distribution_type values is described e.g. MOS Doc IDs for: AP KB202448 https://support.oracle.com/support/?kmContentId=813968 FA KB721213 https://support.oracle.com/support/?kmContentId=2002464 PA KB160029 https://support.oracle.com/support/?kmContentId=1274575 For GMF, there is AP and PO Accrual Reconciliation Report Debugging from OPM Financials KB775263 https://support.oracle.com/support/?kmContentId=2114612 and Financials Troubleshooting Guide FAQ6726 https://support.oracle.com/support/?kmContentId=1213193 How the gl_import_references tableis used in 11i vs R12 is described in notes KB626209 and KB625770 https://support.oracle.com/support/?kmContentId=165327 https://support.oracle.com/support/?kmContentId=130542 ZHS XLA Distribution Links Summary 子账分布链接汇总，方便开发者了解哪些子账表源头填充了哪些source_ids。 对于不同的source_distribution_type值的子账表链接进行了描述，例如MOS Doc IDs为。 AP 813968.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=813968.1 FA 2002464.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2002464.1 PA 1274575.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1274575.1 对于全球机制基金，有 从OPM财务系统中调试AP和PO权责发生制对账报告 2114612.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2114612.1 和财务系统故障排除指南 1213193.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1213193.1 gl_import_references表在11i和R12中的使用方法在注释165327.1和130542.1中描述。 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=165327.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=130542.1 Enginatics R12 only &columns &group_by 1=1 1 10 1=1 xah.accounting_date>sysdate-:number_of_history_days Number 365 US Number Of History Days 2 20 &columns xah.period_name, gl.name ledger, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Ledger and Period 3 &group_by xah.period_name, gl.name, US Show Ledger and Period