ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725151A9E05362FB09050512 select null TO_FLEXDATA, null FROM_FLEXDATA, from_jeb.name FROM_BATCH_NAME, from_jeh.name FROM_HEADER_NAME, nvl(from_jel.accounted_dr, 0) DEBITS, nvl(from_jel.accounted_cr, 0) CREDITS, fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield', 'SQLGL', 'GL#', TO_CC.CHART_OF_ACCOUNTS_ID, NULL, TO_CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') TO_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield_pad', 'SQLGL', 'GL#', TO_CC.CHART_OF_ACCOUNTS_ID, NULL, TO_CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') TO_FLEXFIELD_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('to_acctdesc', 'SQLGL', 'GL#', TO_CC.CHART_OF_ACCOUNTS_ID, NULL, TO_CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') TO_ACCTDESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('from_flexfield', 'SQLGL', 'GL#', FROM_CC.CHART_OF_ACCOUNTS_ID, NULL, FROM_CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FROM_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('from_acctdesc', 'SQLGL', 'GL#', FROM_CC.CHART_OF_ACCOUNTS_ID, NULL, FROM_CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') FROM_ACCTDESC --commented /*FROM_FLEX FROM_FLEXDATA, from_jeb.name FROM_BATCH_NAME, from_jeh.name FROM_HEADER_NAME, nvl(from_jel.accounted_dr, 0) DEBITS, nvl(from_jel.accounted_cr, 0) CREDITS*/ from gl_code_combinations to_cc, gl_code_combinations from_cc, gl_je_batches from_jeb, gl_je_lines from_jel, gl_je_headers from_jeh, gl_je_lines to_jel, gl_import_references jir where jir.je_header_id in (select to_jeh.je_header_id from gl_je_headers to_jeh where to_jeh.je_batch_id = :P_TO_BATCH_ID) and to_jel.je_header_id = jir.je_header_id and to_jel.je_line_num = jir.je_line_num and from_jeh.je_header_id = jir.reference_3 and from_jel.je_header_id = from_jeh.je_header_id and from_jel.je_line_num = jir.reference_4 and from_jeb.je_batch_id = from_jeh.je_batch_id and from_cc.code_combination_id = from_jel.code_combination_id and to_cc.code_combination_id = to_jel.code_combination_id &WHERE_DAS_CLAUSE order by to_jel.je_header_id, &ORDERBY_TO_FLEX, &ORDERBY_FROM_FLEX Y SQLGL GLCRDR_XML AR GL التجميع - اليوميات (بتنسيق XML) Imported from BI Publisher Description: تقرير اليوميات المجمعة Application: الأستاذ العام Source: التجميع - اليوميات (بتنسيق XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG D GL Konsolidierung - Journale Imported from BI Publisher Description: Konsolidierungsbuchungen Application: Rechnungswesen Source: Konsolidierung - Journale (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG E GL Consolidación - Asientos Imported from BI Publisher Description: Informe Consolidación - Asientos Application: General Ledger Source: Consolidación - Asientos (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG F GL Consolidation - Pièces Imported from BI Publisher Description: Etat des pièces de consolidation Application: General Ledger Source: Consolidation - Pièces (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG I GL Consolidamento - Scritture contabili Imported from BI Publisher Description: Rapporto Scritture contabili consolidamento Application: General Ledger Source: Consolidamento - Scritture contabili (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG JA GL 連結 - 仕訳 Imported from BI Publisher Description: 連結仕訳レポート Application: General Ledger Source: 連結 - 仕訳 (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG KO GL 연결 - 분개 Imported from BI Publisher Description: 통합 분개 보고서 Application: General Ledger Source: 연결 - 분개(XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG PTB GL Consolidação - Lançamentos Imported from BI Publisher Description: Relatório de Lançamentos de Consolidação Application: General Ledger Source: Consolidação - Lançamentos (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG RU GL Консолидация - журналы Imported from BI Publisher Description: Отчет по журналам консолидации Application: Главная книга Source: Консолидация - журналы (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG S GL Konsolidering - Verifikationer Imported from BI Publisher Description: Konsolideringsverifikationer - rapport Application: General Ledger Source: Konsolidering - Verifikationer (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG TR GL Konsolidasyon - Fişler Imported from BI Publisher Description: Konsolidasyon Fişleri Raporu Application: Genel Muhasebe Source: Konsolidasyon - Fişler (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG US GL Consolidation - Journals Imported from BI Publisher Description: Consolidation Journals Report Application: General Ledger Source: Consolidation - Journals (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG ZHS GL 合并 - 日记账 Imported from BI Publisher Description: 合并日记账报表 Application: 总帐管理系统 Source: 合并 - 日记账 (XML) Short Name: GLCRDR_XML DB package: GL_GLCRDR_XMLP_PKG BI Publisher &orderby_from_flex &orderby_to_flex &where_das_clause :consolidation_name :currency_code :das_name :from_chart_of_accounts_id :from_ledger_id :from_ledger_name :orderby_from_flex :orderby_to_flex :p_access_set_id :p_conc_request_id :p_to_batch_id :select_from_flex :select_to_flex :to_batch_name :to_chart_of_accounts_id :to_ledger_id :to_ledger_name :to_period :where_das_clause 1 -20 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة الوصول للبيانات معرف مجموعة الوصول للبيانات D Kennung DatenzugriffsSet Kennung DatenzugriffsSet E Id Juego de Accesos a Datos Id juego de accesos a datos F ID jeu d'accès aux données ID jeu d'accès aux données I Id serie di accesso dati Id della serie di accesso ai dati JA データ・アクセス・セットID データ・アクセス・セットID KO 데이터 액세스 세트 ID 데이터 액세스 세트 ID PTB Id do Conjunto de Acesso a Dados Id do Conjunto de Acesso a Dados RU Идент. набора доступа к данным Идент. набора доступа к данным S Id för dataåtkomstuppsättning Id för dataåtkomstuppsättning TR Veri Erişim Kümesi No Veri Erişim Kümesi No US Data Access Set Id Data Access Set Id ZHS 数据访问权限集标识 数据访问权限集标识 2 10 :p_to_batch_id LOV Oracle GL_SRS_CONSOL_NAME Y select je_batch_id id, name value, null description from gl_je_batches where je_batch_id in (select je_batch_id from gl_je_headers jeh,gl_access_set_ledgers gas where je_source='Consolidation' and exists (select 'Has References' from gl_je_lines jel where jel.je_header_id=jeh.je_header_id and reference_1 is not null and reference_2 is not null and reference_3 is not null and reference_4 is not null and reference_5 is not null) and gas.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gas.ledger_id=jeh.ledger_id) order by name Y AR مجموعة التجميع مجموعة التجميع D Konsolidierungsstapel Konsolidierungsstapel E Lote de Consolidación Lote de Consolidación F Lot de consolidation Lot de consolidation I Batch di consolidamenti Batch di consolidamenti JA 連結バッチ 連結バッチ KO 통합 뱃치 통합 뱃치 PTB Lote de Consolidação Lote de Consolidação RU Пакет консолидации Пакет консолидации S Konsolideringsbunt Konsolideringsbunt TR Konsolidasyon İşlem Grubu Konsolidasyon İşlem Grubu US Consolidation Batch Consolidation Batch ZHS 合并批 合并批