ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726A51A9E05362FB09050512 SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex', 'SQLGL', 'GL#', C.CHART_OF_ACCOUNTS_ID, NULL, C.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acc_desc', 'SQLGL', 'GL#', C.CHART_OF_ACCOUNTS_ID, NULL, C.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_ACC_DESC, c.code_combination_id CODE_COMBINATION_ID, c.chart_of_accounts_id CHART_OF_ACCOUNTS_ID, b.name BATCH, h.name JOURNAL, h.period_name PERIOD, l.effective_date EFFECTIVE_DATE, h.currency_code CURRENCY_CODE, l.entered_dr ENTERED_DR, l.entered_cr ENTERED_CR, l.accounted_dr ACCOUNTED_DR, l.accounted_cr ACCOUNTED_CR, l.je_header_id JE_HEADER_ID, r.je_line_num JE_LINE_NUM, NVL(r.jgzz_recon_id,0) RECONCILIATION_ID, NVL(r.jgzz_recon_date ,SYSDATE) RECONCILIATION_DATE, r.jgzz_recon_ref REFERENCE FROM gl_je_lines_recon r, gl_je_lines l, gl_je_headers h, gl_je_batches b, gl_period_statuses ps, gl_code_combinations c WHERE c.code_combination_id = l.code_combination_id AND r.je_header_id = l.je_header_id AND r.je_line_num = l.je_line_num AND r.ledger_id = :P_LEDGER_ID AND l.ledger_id = :P_LEDGER_ID AND l.je_header_id = h.je_header_id AND h.je_batch_id = b.je_batch_id AND l.period_name = ps.period_name AND ps.application_id = 101 AND ps.ledger_id = :P_LEDGER_ID AND c.chart_of_accounts_id = :C_STRUCT_NUM &C_WHERE_REC_STATUS AND l.status = 'P' AND h.status = 'P' AND :P_LEDGER_CURRENCY IS NOT NULL AND &C_WHERE_FLEX &C_WHERE_CURRENCY &C_WHERE_DAS &C_JGZZ_RECON_FLAG AND l.effective_date BETWEEN greatest(:CP_PERIOD_START,NVL(:CP_start_date,:CP_PERIOD_START)) AND least(:CP_PERIOD_END,NVL(:CP_end_date,:CP_PERIOD_END)) Order by 1, h.currency_code, l.effective_date,h.name,l.je_line_num Y SQLGL GLXRCUNR_XML AR GL التسوية - حركات غير مسواة (بتنسيق XML) Imported from BI Publisher Application: الأستاذ العام Source: التسوية - حركات غير مسواة (بتنسيق XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG D GL Abstimmung - Nicht abgestimmte Transaktionen Imported from BI Publisher Application: Rechnungswesen Source: Abstimmung - Nicht abgestimmte Transaktionen (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG E GL Conciliación - Transacciones No Reconciliadas Imported from BI Publisher Application: General Ledger Source: Conciliación - Transacciones No Reconciliadas (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG F GL Rapprochement - Mouvements non rapprochés Imported from BI Publisher Application: General Ledger Source: Rapprochement - Mouvements non rapprochés (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG I GL Quadratura - Transazioni non quadrate Imported from BI Publisher Application: General Ledger Source: Quadratura - Transazioni non quadrate (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG JA GL 消込 - 未消込取引 Imported from BI Publisher Application: General Ledger Source: 消込 - 未消込取引 (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG KO GL 대사 - 미대사 거래 Imported from BI Publisher Application: General Ledger Source: 대사 - 미대사 거래(XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG PTB GL Reconciliação - Transações Não reconciliadas Imported from BI Publisher Application: General Ledger Source: Reconciliação - Transações Não reconciliadas (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG RU GL Выверка - невыверенные транзакции Imported from BI Publisher Application: Главная книга Source: Выверка - невыверенные транзакции (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG S GL Avstämning - Oavstämda transaktioner Imported from BI Publisher Application: General Ledger Source: Avstämning - Oavstämda transaktioner (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG TR GL Mutabakat - Mutabık Olunmayan İşlemler Imported from BI Publisher Application: Genel Muhasebe Source: Mutabakat - Mutabık Olunmayan İşlemler (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG US GL Reconciliation - Unreconciled Transactions Imported from BI Publisher Application: General Ledger Source: Reconciliation - Unreconciled Transactions (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG ZHS GL 调节 - 未调节事务处理 Imported from BI Publisher Application: 总帐管理系统 Source: 调节 - 未调节事务处理 (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG BI Publisher &c_jgzz_recon_flag &c_where_currency &c_where_das &c_where_flex &c_where_rec_status :c_acc_flex :c_access_set_name :c_base_curr :c_jgzz_recon_flag :c_ledger_name :c_login_id :c_orderby_acct :c_orderby_comp :c_recon_id :c_select_acct :c_select_comp :c_select_det_acct :c_select_det_comp :c_struct_num :c_where_acct :c_where_currency :c_where_das :c_where_date :c_where_flex :c_where_rec_status :c_where_ref :count_rows :cp_count_rec :cp_eff_period_end :cp_eff_period_start :cp_end_date :cp_period_end :cp_period_start :cp_start_date :p_access_set_id :p_amount_type :p_conc_request_id :p_end_date :p_flex_from :p_flex_to :p_ledger_currency :p_ledger_id :p_ledger_name :p_period_from :p_period_to :p_rec_unrec :p_start_date 1 -40 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة صلاحيات الوصول معرف مجموعة صلاحيات الوصول D ZugriffsSet-Kennung ZugriffsSet-Kennung E Id Juego de Accesos Id Juego de Accesos F ID jeu d'accès ID jeu d'accès I Id serie di accesso Id della serie di accesso JA アクセス・セットID アクセス・セットID KO 액세스 세트 ID 액세스 세트 ID PTB Id do Conjunto de Acesso ID do Conjunto de Acesso RU Идент. набора доступа Идент. набора доступа S Åtkomstuppsättnings-id Åtkomstuppsättnings-id TR Erişim Kümesi No Erişim Kümesi No US Access Set Id Access Set ID ZHS 访问权限集标识 访问权限集标识 2 -30 :p_chart_of_accounts_id Number select chart_of_accounts_id from gl_access_sets where access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف دلائل الحسابات معرف دلائل الحسابات D Kontenplankennung Kontenplankennung E Id Planes de Cuentas Id Planes de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB ID do Plano de Contas ID do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Charts Of Accounts ID Charts Of Accounts ID ZHS 科目表标识 科目表标识 3 -20 :p_rec_unrec Char U Y AR التسوية مُسوى/غير مُسوى D Abstimmen Abgestimmt/Nicht abgestimmt E Reconciliar Reconciliada/No Reconciliada F Rapprocher Rapproché/non rapproché I Esegui quadratura Quadrate/non quadrate JA 消込 消込済/未消込 KO 대사 대사/미대사 PTB Reconciliar Reconciliado/Não reconciliado RU Выверка Выверено/не выверено S Avstämning Avstämd/oavstämd TR Mutabık Kıl Mutabık/Mutabık Değil US Reconcile Reconciled/Unreconciled ZHS 调节 已调节/未调节 4 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_RECON_READ Y select led.ledger_id id, led.name value, led.description description from gl_access_set_ledgers ac,gl_ledgers led where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and led.object_type_code='L' and led.enable_reconciliation_flag='Y' order by led.name SELECT name FROM gl_ledgers WHERE ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'),'R') Y AR الأستاذ معرف الأستاذ D Buch Buchkennung E Libro Mayor Id Libro Mayor F Livre ID livre I Libro contabile Id sezionale JA 元帳 元帳ID KO 원장 원장 ID PTB Razão ID do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger Ledger ID ZHS 分类账 分类账标识 5 20 :p_ledger_currency LOV Oracle GL_SRS_CURRENCY_PLUS_ALL_CURRENCIES Y select currency_code id, currency_code value, null description from gl_srs_recon_currencies_v order by currency_code SELECT CURRENCY_CODE FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de Divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Cód. da Moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi Kodu US Currency Currency Code ZHS 币种 币种代码 6 30 :p_period_from LOV Oracle GL_SRS_LEDGER_RECON_FROM Y select period_name id, period_name value, null description from gl_period_statuses where application_id=101 and ledger_id=:$flex$.gl_srs_ledger_recon_read and closing_status in ('O','C','P') order by period_year,period_num SELECT period_name FROM gl_period_statuses WHERE application_id = 101 and ledger_id = :$flex$.ledger and effective_period_num = (select min(ps1.effective_period_num) from gl_period_statuses ps1 where ps1.application_id = 101 and ps1.ledger_id = :$flex$.ledger and ps1.closing_status = 'O') Y AR الفترة من الفترة من D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間: 自 期間: 自 KO 기간: 부터 기간: 부터 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem, Başlangıç Dönem, Başlangıç US Period From Period From ZHS 期间自 期间自 7 40 :p_period_to LOV Oracle GL_SRS_LEDGER_RECON_TO Y select ps2.period_name id, ps2.period_name value, null description from gl_period_statuses ps1,gl_period_statuses ps2 where ps1.application_id=101 and ps1.ledger_id=:$flex$.gl_srs_ledger_recon_read and ps1.period_name=:$flex$.gl_srs_ledger_recon_from and ps2.application_id=101 and ps2.ledger_id=:$flex$.gl_srs_ledger_recon_read and ps2.closing_status in ('O','C','P') and ps2.effective_period_num>=ps1.effective_period_num order by ps2.period_year,ps2.period_num :$flex$.period_from Y AR الفترة إلى الفترة إلى D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A JA 期間: 至 期間: 至 KO 기간: 까지 기간: 까지 PTB Período - Até Período - Até RU Период по Период по S Till period Till period TR Dönem, Son Dönem, Son US Period To Period To ZHS 期间至 期间至 8 50 :p_start_date Date select start_date from gl_period_statuses where application_id= 101 and ledger_id =:$flex$.ledger and period_name =:$flex$.period_from AR تاريخ البداية تاريخ البداية D Startdatum Startdatum E Fecha de Inicio Fecha de Inicio F Date de début Date de début I Data avvio Data avvio JA 開始日 開始日 KO 시작 일자 시작 일자 PTB Data Inicial Data Inicial RU Начальная дата Начальная дата S Startdatum Startdatum TR Başlangıç Tarihi Başlangıç Tarihi US Start Date Start Date ZHS 起始日期 起始日期 9 60 :p_end_date Date select end_date from gl_period_statuses where application_id=101 and ledger_id = :$flex$.ledger and period_name = :$flex$.period_to AR تاريخ النهاية تاريخ النهاية D Enddatum Enddatum E Fecha de Finalización Fecha de Finalización F Date de fin Date de fin I Data fine Data fine JA 日付:至 日付:至 KO 종료 일자 종료 일자 PTB Data Final Data Final RU Конечная дата Конечная дата S Slutdatum Slutdatum TR Bitiş Tarihi Bitiş Tarihi US End Date End Date ZHS 终止日期 终止日期 10 70 :p_flex_from Char AR الحساب من حقل مرن من D Von Konto Von FlexFeld E De Cuenta De Estructura F Compte - De Clé flexible - De I Conto - Da Flexfield - Da JA 勘定科目:自 フレックスフィールド:自 KO 계정: 부터 가변필드 From PTB Conta - De Do Flex RU Счет с ГП с S Från konto Från flexfält TR Hesap, İlk İlk Esnekalan US Account From Flexfield From ZHS 账户自 弹性域自 11 80 :p_flex_to Char AR حساب إلى حقل مرن إلى D Bis Konto Bis FlexFeld E A Cuenta A Estructura F Compte - A Clé flexible - A I Conto - A Flexfield - A JA 勘定科目:至 フレックスフィールド:至 KO 계정: 까지 가변필드 To PTB Conta - Até Até o Flex RU Счет по ГП по S Till konto Till flexfält TR Hesap, Son Son Esnekalan US Account To Flexfield To ZHS 账户至 弹性域至 :$flex$.gl_srs_ledger_recon_from Period From Period To :$flex$.gl_srs_ledger_recon_read Ledger Period From :$flex$.gl_srs_ledger_recon_read Ledger Period To :$flex$.ledger Ledger Currency :$flex$.ledger Ledger End Date :$flex$.ledger Ledger Period From :$flex$.ledger Ledger Start Date :$flex$.period_from Period From Period To :$flex$.period_from Period From Start Date :$flex$.period_to Period To End Date