ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725351A9E05362FB09050512 SELECT S.user_je_source_name Source, B.name Batch_Name, B.default_effective_date Batch_Eff_date, B.posted_date Batch_Posted_Date, B.default_period_name Batch_Period, B.je_batch_id Batch_Id, B.actual_flag Actual_Flag, B.average_journal_flag Average_Journal_Flag, B.running_total_accounted_dr B_TOT_DR, B.running_total_accounted_cr B_TOT_CR, D.je_header_id Header_id, D.name Header_Name, L.name Ledger_Name, D.default_effective_date Header_Eff_Date, C.user_je_category_name Category, D.currency_code Currency_Code, D.external_reference Header_Reference, D.running_total_accounted_dr H_TOT_DR, D.running_total_accounted_cr H_TOT_CR, J.je_line_num Je_Line_Num, decode(nvl(CC.code_combination_id, -1), -1, 'A',null) FLEXDATA_H, J.effective_date Line_Effective_Date, J.description Line_Description, J.accounted_dr Line_Acc_Dr, J.accounted_cr Line_Acc_Cr, &POSTING_STATUS_SELECT Reference1_4, nvl(J.stat_amount,0) Line_Stat_Amount, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata_dsp', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') FLEXDATA_SECURE FROM gl_je_sources S, gl_je_categories C, gl_je_lines J, gl_code_combinations CC, gl_je_headers D, gl_je_batches B, &LEDGER_FROM gl_ledgers L WHERE S.je_source_name = D.je_source AND C.je_category_name = D.je_category AND J.code_combination_id = CC.code_combination_id(+) AND J.je_header_id = D.je_header_id AND &CURRENCY_WHERE AND D.je_source = NVL(:P_JE_SOURCE_NAME, D.je_source) AND (D.display_alc_journal_flag is null or D.display_alc_journal_flag = 'Y') AND D.je_batch_id = B.je_batch_id AND &POSTING_STATUS_WHERE AND B.name = NVL(:P_BATCH_NAME, B.name) AND &PERIOD_WHERE AND &LEDGER_WHERE L.ledger_id = D.ledger_id &DAS_WHERE /*ORDER BY S.user_je_source_name, B.actual_flag, B.name, B.default_effective_date, L.name, D.name, J.je_line_num*/ order by Source,Batch_Name,Batch_Eff_date,Actual_Flag,Header_Name,Ledger_Name,Je_Line_Num Y SQLGL GLGENJRN_XML AR GL اليوميات - عام (132 حرف) (بتنسيق XML) Imported from BI Publisher Description: يوميات عامة - 132 Application: الأستاذ العام Source: اليوميات - عام (132 حرف) (بتنسيق XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG D GL Buchungen - allgemein (132 Zeichen) Imported from BI Publisher Description: Buchungen - allgemein (132 Zeichen) Application: Rechnungswesen Source: Buchungen - allgemein (132 Zeichen) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG E GL Asientos - General (132 Car) Imported from BI Publisher Description: Asientos Generales - 132 Application: General Ledger Source: Asientos - General (132 Car) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG F GL Pièces - Général (132 car) Imported from BI Publisher Description: Journal général - 132 Application: General Ledger Source: Pièces - Général (132 car) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG I GL Scritture contabili - Generale (132 caratteri) Imported from BI Publisher Description: Scritture contabili generali - 132 Application: General Ledger Source: Scritture contabili - Generale (132 caratteri) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG JA GL 仕訳 - 一覧表(132文字) Imported from BI Publisher Description: 総勘定元帳 - 132 Application: General Ledger Source: 仕訳 - 一覧表(132文字) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG KO GL 분개 - 일반(132자) Imported from BI Publisher Description: 일반 분개 - 132 Application: General Ledger Source: 분개 - 일반(132자)(XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG PTB GL Lançamentos - Gerais(132 Caracteres) Imported from BI Publisher Description: Lançamentos Gerais - 132 Application: General Ledger Source: Lançamentos - Gerais(132 Caracteres) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG RU GL Журналы - Главная книга (132 символа) Imported from BI Publisher Description: Журналы Главной книги (132 символа) Application: Главная книга Source: Журналы - Главная книга (132 символа) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG S GL Verifikationer - Allmänt (132 tkn) Imported from BI Publisher Description: Allmänna verifikationer - 132 Application: General Ledger Source: Verifikationer - Allmänt (132 tkn) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG TR GL Fişler - Genel(132 Karakter) Imported from BI Publisher Description: Genel Fişler - 132 Application: Genel Muhasebe Source: Fişler - Genel(132 Karakter) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG US GL Journals - General(132 Char) Imported from BI Publisher Description: General Journals - 132 Application: General Ledger Source: Journals - General(132 Char) (XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG ZHS GL 日记账 - 普通（132 个字符） Imported from BI Publisher Description: 通用日记账 - 132 Application: 总帐管理系统 Source: 日记账 - 普通（132 个字符）(XML) Short Name: GLGENJRN_XML DB package: GL_GLRGNJ_XMLP_PKG BI Publisher &currency_where &das_where &ledger_from &ledger_where &period_where &posting_status_select &posting_status_where :access_set_name :consolidation_ledger_flag :currency_where :das_where :flexdata :inv_flex_msg :je_user_source_dsp :ledger_from :ledger_where :p_access_set_id :p_batch_name :p_conc_request_id :p_currency_code :p_end_date :p_je_source_name :p_kind :p_ledger_id :p_pagesize :p_period_name :p_posting_status :p_start_date :param_currency :param_end_date :param_ledger_name :param_ledger_type :param_period_name :param_posting_status :param_reference_type :param_start_date :period_from :period_to :period_where :posting_status_select :posting_status_where :stat :struct_num :width 1 -30 :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 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 -20 :p_pagesize Number 132 Y AR حجم الصفحة حجم الصفحة D Seitenformat Seitenformat E Tamaño de Página Tamaño de Página F Taille page Taille page I Dimensioni pagina Dimensioni della pagina JA ページ・サイズ ページ・サイズ KO 쪽 크기 쪽 크기 PTB Tamanho da página Tamanho da página RU Размер страницы Размер страницы S Sidstorlek Sidstorlek TR Sayfaboyutu Sayfaboyutu US Pagesize Pagesize ZHS 页面大小 页面大小 3 10 :p_kind LOV Oracle GL_SRS_JOURNAL_RPT_KIND Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='ACCOUNT_RPT_KIND' and lookup_code in ('L','S') order by meaning Y AR النوع صنف السطر أو صنف المصدر D Art Position oder Herkunft E Tipo Línea de Artículo u Origen de Línea F Type Ecriture ou origine I Tipo Articolo linea o articolo origine JA タイプ 明細品目またはソース品目 KO 유형 라인 항목 또는 출처 항목 PTB Tipo Item de Linha ou Item de Origem RU Тип Позиция строки или источника S Typ Radartikel eller källartikel TR Tip Satır Kalemi veya Kaynak Kalemi US Type Line Item or Source Item ZHS 类型 行项目或来源项目 4 20 :p_posting_status LOV Oracle GL_SRS_JOURNAL_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='JOURNAL_REPORT_TYPE' order by (meaning) Y AR موقف الترحيل مرحل، غير مرحل، خطأ D Verbuchungsstatus Verbucht, Nicht verbucht, Fehler E Estado de Contabilización Contabilizado, No Contabilizado, Error F Statut d'imputation Imputé, Non imputé, Erreur I Stato contabilizzazione Contabilizzato, non contabilizzato, errore JA 転記ステータス 転記、未転記、エラー KO 전기 상태 전기, 미전기, 오류 PTB Status da Contabilização Contabilizado, Não Contabilizado, Erro RU Статус проводки Проведено, Не проведено, Ошибка S Postningsstatus Postad, Opostad, Fel TR Muhasebeleşme Statüsü Muhasebeleşti, Muhasebeleşmedi, Hatalı US Posting Status Posted, Unposted, Error ZHS 过账状态 已过账，未过账，误差 5 30 :p_currency_code LOV Oracle GL_SRS_DAS_LEDGER_CURRENCIES_AND_STAT Y select curr.currency_code id, curr.currency_code value, null description from fnd_currencies curr where curr.currency_code='STAT' or curr.currency_code in (select l.currency_code from gl_access_set_ledgers acc,gl_ledgers l where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=acc.ledger_id and l.object_type_code='L') order by value,description 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 40 :p_ledger_id LOV Oracle GL_SRS_LEDGER_WITH_SETS_STORE_ID_FILTER_CURR Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers acc,gl_ledgers l where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=acc.ledger_id and (l.object_type_code='S' or l.currency_code=:$flex$.gl_srs_das_ledger_currencies_and_stat or :$flex$.gl_srs_das_ledger_currencies_and_stat='STAT') order by l.name AR دفتر الأستاذ/مجموعة دفاتر الأستاذ دفتر الأستاذ/مجموعة دفاتر الأستاذ D Buch/BuchSet Buch/BuchSet E Libro Mayor/Juego de Libros Mayores Libro Mayor/Juego de Libros Mayores F Livre/jeu de livres Livre/jeu de livres I Libro contabile/serie libri contabili Libro contabile/serie libri contabili JA 元帳/元帳セット 元帳/元帳セット KO 원장/원장 세트 원장/원장 세트 PTB Razão/Conjunto de Razões Razão/Conjunto de Razões RU Книга/набор книг Книга/набор книг S Huvudbok/huvudboksgrupp Huvudbok/huvudboksgrupp TR Defter / Defter Kümesi Defter / Defter Kümesi US Ledger/Ledger Set Ledger/Ledger Set ZHS 分类账/分类账集 分类账/分类账集 7 50 :p_period_name LOV Oracle GL_SRS_JRN_PERIOD Y select per.period_name id, per.period_name value, null description from gl_access_sets acc,gl_periods per where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and per.period_set_name=acc.period_set_name and per.period_type=acc.accounted_period_type and exists ( select 'has data' from gl_access_set_ledgers asl, gl_ledgers led, gl_ledger_set_assignments ls, gl_period_statuses ps where asl.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and asl.ledger_id=nvl(:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,asl.ledger_id) and led.ledger_id=nvl(:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,asl.ledger_id) and ls.ledger_set_id (+)=decode(led.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,led.ledger_id,-1) and ps.ledger_id=nvl(ls.ledger_id,led.ledger_id) and ps.period_name=per.period_name and ((ps.closing_status='F' and :$flex$.gl_srs_journal_type:null in ('E','U')) or ps.closing_status in ('C','O','P')) and ps.application_id=101) order by per.period_year desc,per.period_num desc AR الفترة اسم الفترة D Periode Periodenbezeichnung E Período Nombre del Período F Période Nom de la période I Periodo Nome del periodo JA 期間 期間名 KO 기간 기간명 PTB Período Nome do Período RU Период Имя периода S Period Periodnamn TR Dönem Dönem Adı US Period Period Name ZHS 期间 期间名称 8 60 :p_start_date Date AR GL_SRS_STANDARD_DATE_LOW تاريخ البداية D GL_SRS_STANDARD_DATE_LOW Startdatum E GL_SRS_STANDARD_DATE_LOW Fecha de Inicio F GL_SRS_STANDARD_DATE_LOW Date de début I GL_SRS_STANDARD_DATE_LOW Data avvio JA GL_SRS_STANDARD_DATE_LOW 開始日 KO GL_SRS_STANDARD_DATE_LOW 시작 일자 PTB GL_SRS_STANDARD_DATE_LOW Data Inicial RU GL_SRS_STANDARD_DATE_LOW Начальная дата S GL_SRS_STANDARD_DATE_LOW Startdatum TR GL_SRS_STANDARD_DATE_LOW Başlangıç Tarihi US GL_SRS_STANDARD_DATE_LOW Start Date ZHS GL_SRS_STANDARD_DATE_LOW 起始日期 9 70 :p_end_date Date AR GL_SRS_STANDARD_DATE_HIGH تاريخ النهاية D GL_SRS_STANDARD_DATE_HIGH Enddatum E GL_SRS_STANDARD_DATE_HIGH Fecha de Finalización F GL_SRS_STANDARD_DATE_HIGH Date de fin I GL_SRS_STANDARD_DATE_HIGH Data fine JA GL_SRS_STANDARD_DATE_HIGH 日付:至 KO GL_SRS_STANDARD_DATE_HIGH 종료 일자 PTB GL_SRS_STANDARD_DATE_HIGH Data Final RU GL_SRS_STANDARD_DATE_HIGH Конечная дата S GL_SRS_STANDARD_DATE_HIGH Slutdatum TR GL_SRS_STANDARD_DATE_HIGH Bitiş Tarihi US GL_SRS_STANDARD_DATE_HIGH End Date ZHS GL_SRS_STANDARD_DATE_HIGH 终止日期 10 80 :p_je_source_name LOV Oracle GL_SRS_JOURNAL_SOURCE Y select je_source_name id, user_je_source_name value, description description from gl_je_sources order by user_je_source_name AR المصدر المصدر D Herkunft Herkunft E Origen Origen F Origine Origine I Origine Origine JA ソース ソース KO 출처 출처 PTB Origem Origem RU Источник Источник S Källa Källa TR Kaynak Kaynak US Source Source ZHS 来源 来源 11 90 :p_batch_name LOV Oracle GL_SRS_BASE_BATCH Y select b.name id, b.name value, b.description description from gl_je_batches b where b.je_batch_id in (select max(b.je_batch_id) from gl_je_batches b where b.je_batch_id in (select h.je_batch_id from gl_je_headers h where h.ledger_id in (select nvl(ls.ledger_id,acc.ledger_id) from gl_access_set_ledgers acc,gl_ledger_set_assignments ls where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and acc.ledger_id=nvl2(:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,acc.ledger_id) and ls.ledger_set_id (+)=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,acc.ledger_id,-1)) and h.period_name=:$flex$.gl_srs_jrn_period:null and :$flex$.gl_srs_jrn_period:null is not null and h.je_source=nvl(:$flex$.gl_srs_journal_source:null, h.je_source) and decode(h.currency_code,'STAT',1,0)= decode(:$flex$.gl_srs_das_ledger_currencies_and_stat,'STAT',1,0) union all select h.je_batch_id from gl_je_headers h where h.ledger_id in (select nvl(ls.ledger_id,acc.ledger_id) from gl_access_set_ledgers acc,gl_ledger_set_assignments ls where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and acc.ledger_id=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,acc.ledger_id) and ls.ledger_set_id (+)=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id_filter_curr:null,acc.ledger_id,-1)) and :$flex$.gl_srs_jrn_period:null is null and h.je_source=nvl(:$flex$.gl_srs_journal_source:null, h.je_source) and decode(h.currency_code,'STAT',1,0)= decode(:$flex$.gl_srs_das_ledger_currencies_and_stat,'STAT',1,0) ) and (trunc(b.default_effective_date) between decode(:$flex$.gl_srs_journal_type, 'P',trunc(b.default_effective_date), nvl(to_date(:$flex$.gl_srs_standard_date_low:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(b.default_effective_date))) and decode(:$flex$.gl_srs_journal_type, 'P',trunc(b.default_effective_date), nvl(to_date(:$flex$.gl_srs_standard_date_high:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(b.default_effective_date)))) and (trunc(nvl(b.posted_date,sysdate)) between decode(:$flex$.gl_srs_journal_type, 'P',nvl(to_date(:$flex$.gl_srs_standard_date_low:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(nvl(b.posted_date,sysdate))), trunc(nvl(b.posted_date,sysdate))) and decode(:$flex$.gl_srs_journal_type, 'P',nvl(to_date(:$flex$.gl_srs_standard_date_high:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(nvl(b.posted_date,sysdate))), trunc(nvl(b.posted_date,sysdate)))) and b.default_period_name =nvl(:$flex$.gl_srs_jrn_period:null, b.default_period_name) and b.status=decode(:$flex$.gl_srs_journal_type, 'P','P', 'U','U', 'E',decode(b.status, 'P',null,'U',null,'I',null,'S',null,b.status), null) group by b.name) order by value,description AR اسم المجموعة اسم المجموعة D Stapelbezeichnung Stapelbezeichnung E Nombre de Lote Nombre de Lote F Nom du lot Nom du lot I Nome batch Nome batch JA バッチ名 バッチ名 KO 뱃치명 뱃치명 PTB Nome do Lote Nome do Lote RU Имя пакета Имя пакета S Bunt Bunt TR İşlem Grubu Adı İşlem Grubu Adı US Batch Name Batch Name ZHS 批名 批名 :$flex$.gl_srs_das_ledger_currencies_and_stat Currency Batch Name :$flex$.gl_srs_das_ledger_currencies_and_stat Currency Ledger/Ledger Set :$flex$.gl_srs_journal_type Posting Status Batch Name