ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727851A9E05362FB09050512Y select fnd_flex_xml_publisher_apis.process_kff_combination_1('p_balance_seg', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') Company, L.name LEDGER_NAME, L.currency_code LEDGER_CURRENCY, T6.start_date period_start_date, T6.period_name Period, T7.user_je_category_name Category, substr(T7.description,1,50) Category_Desc, T2.external_reference Entry_Ref, T3.name Batch_Name, T3.default_effective_date Batch_Date, T3.posted_date Posting_Date, T2.name Entry_Name, T8.user_je_source_name Source, T2.currency_code Currency1, T2.currency_conversion_rate Currency_Rate, gdct.user_conversion_type Currency_Type, T2.doc_sequence_value Doc_Sequence, T1.effective_date, null C_Flexdata, substr(decode(T7.je_category_name, 'Payments', T1.reference_4, 'Purchase Invoices', T1.reference_5, T2.external_reference),1,15) Reference, substr(T1.description,1,25) Description, T1.entered_dr entered_dr, T1.entered_cr entered_cr, T1.accounted_dr ACCOUNTED_dr, T1.accounted_cr ACCOUNTED_CR, --GL_GLYRLJGE_XMLP_PKG.c_bal_lpromptformula(:C_Bal_Lprompt) C_Bal_Lprompt, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_company_name', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') C_Company_Name, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'SECURITY') BAL_SECURE, -- GL_GLYRLJGE_XMLP_PKG.c_curr_nameformula(CURRENCY1) C_CURR_NAME, GL_GLYRLJGE_XMLP_PKG.c_curr_nameformula(T2.currency_code) C_CURR_NAME, -- GL_GLYRLJGE_XMLP_PKG.c_entryformula(DOC_SEQUENCE, ENTRY_NAME) C_Entry, GL_GLYRLJGE_XMLP_PKG.c_entryformula(T2.doc_sequence_value, T2.name) C_Entry, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acc_flexfield', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Acc_Flexfield, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_secure', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') FLEX_SECURE, --GL_GLYRLJGE_XMLP_PKG.zero_indicatorformula(ACCOUNTED_CR, ACCOUNTED_DR, ENTERED_DR, ENTERED_CR) ZERO_INDICATOR GL_GLYRLJGE_XMLP_PKG.zero_indicatorformula(ACCOUNTED_CR, ACCOUNTED_DR, ENTERED_DR, ENTERED_CR) ZERO_INDICATOR, GL_GLYRLJGE_XMLP_PKG.g_batchesgroupfilter(t1.accounted_cr,t1.accounted_dr,t1.entered_dr,t1.entered_cr) BATCHES_GF from gl_period_statuses T6, gl_je_headers T2, gl_je_lines T1, gl_code_combinations T4, gl_je_batches T3, gl_je_categories T7, gl_je_sources T8, gl_daily_conversion_types gdct, &C_LEDGER_FROM gl_ledgers L where T6.application_id = 101 and T6.ledger_id = T2.ledger_id and ( :C_START_DATE between T6.start_date and T6.end_date or :C_END_DATE between T6.start_date and T6.end_date or ( T6.start_date >= :C_START_DATE and T6.end_date <= :C_END_DATE ) ) and T2.status = 'P' and T2.actual_flag = 'A' and T2.period_name = T6.period_name and T1.je_header_id = T2.je_header_id+0 and T1.status = 'P' and T1.effective_date between :C_START_DATE and :C_END_DATE and T4.code_combination_id = T1.code_combination_id+0 and T4.summary_flag = 'N' and T4.template_id IS NULL and T4.chart_of_accounts_id = :C_CHART_OF_ACCTS_ID and T3.je_batch_id = decode(T4.code_combination_id, NULL, T2.je_batch_id, T2.je_batch_id) and T7.je_category_name = decode(T4.code_combination_id, NULL, T2.je_category, T2.je_category) and T8.je_source_name = decode(T4.code_combination_id, NULL, T2.je_source, T2.je_source) and gdct.conversion_type = decode(T4.code_combination_id, NULL, T2.currency_conversion_type, T2.currency_conversion_type) &C_LEDGER_WHERE &C_WHERE_PERIOD and &C_WHERE_LEX &C_WHERE &C_ACCESS_WHERE and T2.ledger_id = L.LEDGER_ID AND DECODE(TO_NUMBER((SELECT GP1.PERIOD_YEAR FROM GL_PERIODS GP1 WHERE GP1.PERIOD_SET_NAME = L.PERIOD_SET_NAME AND GP1.PERIOD_TYPE = L.ACCOUNTED_PERIOD_TYPE and trunc(:P_END_PERIOD) between GP1.start_date and GP1.end_date and GP1.adjustment_period_flag like decode(:P_ADJUSTMENT_PERIODS,'N','N','%') and rownum = 1)) - TO_NUMBER((SELECT GP2.PERIOD_YEAR FROM GL_PERIODS GP2 WHERE GP2.PERIOD_SET_NAME = L.PERIOD_SET_NAME AND GP2.PERIOD_TYPE = L.ACCOUNTED_PERIOD_TYPE and trunc(:P_START_PERIOD) between GP2.start_date and GP2.end_date and GP2.adjustment_period_flag like decode(:P_ADJUSTMENT_PERIODS,'N','N','%') and rownum = 1)), 0, 'N', DECODE(:P_ADJUSTMENT_PERIODS, 'N', 'Y', 'N')) != 'Y' --order by fnd_flex_xml_publisher_apis.process_kff_combination_1('p_balance_seg', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), T6.start_date, T7.user_je_category_name, T3.name, -- T2.name, trunc(T1.effective_date), &P_ORDERBY_ALL, T1.je_line_num order by LEDGER_NAME,fnd_flex_xml_publisher_apis.process_kff_combination_1('p_balance_seg', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), T6.start_date, T6.period_name,Category_Desc,Category, T3.name ,Batch_Date,Posting_Date,Entry_Name,DOC_SEQUENCE,SOURCE,ENTRY_REF,CURRENCY_RATE, CURRENCY_TYPE,EFFECTIVE_DATE,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acc_flexfield', 'SQLGL', 'GL#', T4.CHART_OF_ACCOUNTS_ID, NULL, T4.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),REFERENCE,DESCRIPTION,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,&P_ORDERBY_ALL SQLGL GLYRLJGE_XML AR GL اليوميات - السطر (بتنسيق XML) Imported from BI Publisher Description: تقرير سطوراليومية Application: الأستاذ العام Source: اليوميات - السطر (بتنسيق XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG D GL Buchungen - Position Imported from BI Publisher Description: Auswertung "Buchungspositionen" Application: Rechnungswesen Source: Buchungen - Position (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG E GL Asientos - Líneas Imported from BI Publisher Description: Informe de líneas de asientos Application: General Ledger Source: Asientos - Líneas (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG F GL Pièces - Ecritures Imported from BI Publisher Description: Etat des écritures Application: General Ledger Source: Pièces - Ecritures (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG I GL Scritture contabili - Linea Imported from BI Publisher Description: Rapporto Linea scrittura contabile Application: General Ledger Source: Scritture contabili - Linea (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG JA GL 仕訳 - 明細 Imported from BI Publisher Description: 仕訳明細レポート Application: General Ledger Source: 仕訳 - 明細 (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG KO GL 분개 - 라인 Imported from BI Publisher Description: 분개 라인 보고서 Application: General Ledger Source: 분개 - 라인(XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG PTB GL Lançamentos - Linha Imported from BI Publisher Description: Relatório da Linha do Lançamento Application: General Ledger Source: Lançamentos - Linha (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG RU GL Журналы - строки Imported from BI Publisher Description: Отчет по строкам журнала Application: Главная книга Source: Журналы - строки (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG S GL Verifikationer - Rad Imported from BI Publisher Description: Verifikationsrad - rapport Application: General Ledger Source: Verifikationer - Rad (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG TR GL Fişler - Satır Imported from BI Publisher Description: Fiş Satır Raporu Application: Genel Muhasebe Source: Fişler - Satır (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG US GL Journals - Line Imported from BI Publisher Description: Journal Line Report Application: General Ledger Source: Journals - Line (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG ZHS GL 日记账 - 行 Imported from BI Publisher Description: 日记账行报表 Application: 总帐管理系统 Source: 日记账 - 行 (XML) Short Name: GLYRLJGE_XML DB package: GL_GLYRLJGE_XMLP_PKG BI Publisher &c_access_where &c_ledger_from &c_ledger_where &c_where &c_where_lex &c_where_period &p_orderby_all :c_access_set_name :c_access_where :c_chart_of_accts_id :c_end_date :c_end_date1 :c_industry_code :c_ledger_from :c_ledger_where :c_message :c_start_date :c_start_date1 :c_where :c_where_period :consolidation_ledger_flag :curr_format_mask :mixed_precision :p_access_set_id :p_adjustment_periods :p_balance_seg :p_company :p_conc_request_id :p_currency_code :p_end_period :p_flexdata :p_journal_cat :p_journal_cat_1 :p_ledger_id :p_min_precision :p_orderby_all :p_start_period :p_struct_num :param_ledger_curr :param_ledger_name :param_ledger_type :thousands_separator :width 1 -30 :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 -20 :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 Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id 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 Chart of Accounts Id Chart of Accounts Id ZHS 科目表标识 科目表标识 3 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_WITH_SETS_STORE_ID 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 order by 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/BuchSet Buchkennung E Libro Mayor/Juego de Libros Mayores Id Libro Mayor F Livre/jeu de livres ID livre I Libro contabile/serie libri contabili Id sezionale JA 元帳/元帳セット 元帳ID KO 원장/원장 세트 원장 ID PTB Razão/Conjunto de Razões Id do Razão RU Книга/набор книг Идентификатор книги S Huvudbok/huvudboksgrupp Huvudboks-id TR Defter / Defter Kümesi Defter No US Ledger/Ledger Set Ledger Id ZHS 分类账/分类账集 分类账标识 4 20 :p_currency_code LOV Oracle GL_SRS_CURRENCIES Y select currency_code id, currency_code value, null description from fnd_currencies_vl where enabled_flag in ('Y','N') order by currency_code AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 5 30 :p_start_period Date Y 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 Begin Date Begin Date ZHS 开始日期 开始日期 6 40 :p_end_period Date Y 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 终止日期 终止日期 7 50 :p_journal_cat LOV Oracle GL_SRS_JOURNAL_CATEGORY_2 Y select je_category_name id, user_je_category_name value, description description from gl_je_categories order by user_je_category_name AR الفئة الفئة D Kategorie Kategorie E Categoría Categoría F Catégorie Catégorie I Categoria Categoria JA カテゴリ カテゴリ KO 범주 범주 PTB Categoria Categoria RU Категория Категория S Kategori Kategori TR Kategori Kategori US Category Category ZHS 类别 类别 8 60 :p_company Char AR الشركة الشركة D Firma Firma E Compañía Compañía F Société Société I Società Società JA 会社 会社 KO 회사 회사 PTB Empresa Empresa RU Компания Компания S Företag Företag TR Şirket Şirket US Company Company ZHS 公司 公司 9 70 :p_adjustment_periods LOV Oracle GL_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description Y AR فترات التعديل فترات التعديل D Korrekturperioden Korrekturperioden E Períodos de Ajuste Períodos de Ajuste F Périodes d'ajustement Périodes d'ajustement I Periodi adeguamento Periodi adeguamento JA 期間調整 期間調整 KO 조정 기간 조정 기간 PTB Períodos de Ajuste Períodos de Ajuste RU Периоды корректировки Периоды корректировки S Justeringsperioder Justeringsperioder TR Düzeltme Dönemleri Düzeltme Dönemleri US Adjustment Periods Adjustment Periods ZHS 调整期 调整期