ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725651A9E05362FB09050512 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.je_batch_id Batch_Id, B.actual_flag Actual_Flag, B.average_journal_flag Average_Journal_Flag, D.je_header_id Header_id, D.name Header_Name, L.name Ledger_Name, L.currency_code Ledger_Currency, C.user_je_category_name Category, D.currency_code Currency_Code, D.external_reference Header_Reference, D.currency_conversion_date Conversion_Date, GDCT.user_conversion_type Conversion_Type, D.currency_conversion_rate Conversion_Rate, J.je_line_num Je_Line_Num, decode(nvl(CC.code_combination_id,-1),-1,'A',null) FLEXDATA_H, J.effective_date Line_Effective_Data, J.description Line_Description, decode(d.currency_code, 'STAT', null, decode(sign(abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))), 1, nvl(j.accounted_dr,0) - nvl(j.accounted_cr,0), -1, nvl(j.accounted_cr,0) - nvl(j.accounted_dr,0), 0, decode(sign(abs(nvl(j.accounted_dr,0)) - abs(nvl(j.accounted_cr,0))), 1, nvl(j.accounted_dr,0) - nvl(j.accounted_cr,0), -1, nvl(j.accounted_cr,0) - nvl(j.accounted_dr,0), 0))) Accounted_Amount, decode(sign(abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))), 1, nvl(j.entered_dr,0) - nvl(j.entered_cr,0), -1, nvl(j.entered_cr,0) - nvl(j.entered_dr,0), 0) Entered_Amount, decode((abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))), 0, sign(abs(nvl(j.accounted_dr,0)) - abs(nvl(j.accounted_cr,0))), sign(abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0)))) Dr_Cr, &POSTING_STATUS_SELECT Recerence1_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, GL_GLRFGNJ_XMLP_PKG.dr_cr_dspformula(decode ( ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 0 , sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) )) DR_CR_DSP, GL_GLRFGNJ_XMLP_PKG.ent_x_drcrformula(decode ( ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 0 , sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) ), decode ( sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 1 , nvl ( j.entered_dr , 0 ) - nvl ( j.entered_cr , 0 ) , - 1 , nvl ( j.entered_cr , 0 ) - nvl ( j.entered_dr , 0 ) , 0 )) ENT_X_DRCR, GL_GLRFGNJ_XMLP_PKG.acct_x_drcrformula(decode ( ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 0 , sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) ), decode ( d.currency_code , 'STAT' , null , decode ( sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 1 , nvl ( j.accounted_dr , 0 ) - nvl ( j.accounted_cr , 0 ) , - 1 , nvl ( j.accounted_cr , 0 ) - nvl ( j.accounted_dr , 0 ) , 0 , decode ( sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , 1 , nvl ( j.accounted_dr , 0 ) - nvl ( j.accounted_cr , 0 ) , - 1 , nvl ( j.accounted_cr , 0 ) - nvl ( j.accounted_dr , 0 ) , 0 ) ) )) ACCT_X_DRCR, 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_daily_conversion_types GDCT, 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 GDCT.conversion_type = D.currency_conversion_type AND 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 D.currency_code = :P_CURRENCY_CODE 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 Y SQLGL GLRFGNJ180_XML AR GL اليوميات - العملة المدخلة (180 حرف) (بتنسيق XML) Imported from BI Publisher Description: يوميات أجنبية - 180 Application: الأستاذ العام Source: اليوميات - العملة المدخلة (180 حرف) (بتنسيق XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG D GL Buchungen - Eingabewährung (180 Zeichen) Imported from BI Publisher Description: Buchungen - Fremdwährung (180 Zeichen) Application: Rechnungswesen Source: Buchungen - Eingabewährung (180 Zeichen) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG E GL Asientos - Divisa Introducida (180 Car) Imported from BI Publisher Description: Asientos Extranjeros - 180 Application: General Ledger Source: Asientos - Divisa Introducida (180 Car) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG F GL Pièces - Devise de saisie (180 caractères) Imported from BI Publisher Description: Pièces en devises - 180 Application: General Ledger Source: Pièces - Devise de saisie (180 caractères) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG I GL Scritture contabili - Divisa inserita (180 caratteri) Imported from BI Publisher Description: Scritture contabili estere - 180 Application: General Ledger Source: Scritture contabili - Divisa inserita (180 caratteri) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG JA GL 仕訳 - 入力通貨(180文字) Imported from BI Publisher Description: 外貨仕訳 - 180 Application: General Ledger Source: 仕訳 - 入力通貨(180文字) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG KO GL 분개 - 입력 통화(180자) Imported from BI Publisher Description: 외부 분개 - 180 Application: General Ledger Source: 분개 - 입력 통화(180자)(XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG PTB GL Lançamentos - Moeda Informada (180 Caracteres) Imported from BI Publisher Description: Lançamentos Externos - 180 Application: General Ledger Source: Lançamentos - Moeda Informada (180 Caracteres) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG RU GL Журналы - введенная валюта (180 символов) Imported from BI Publisher Description: Журналы иностранной валюты (180 символов) Application: Главная книга Source: Журналы - введенная валюта (180 символов) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG S GL Verifikationer - Registrerad valuta (180 tkn) Imported from BI Publisher Description: Verifikationer i utländsk valuta - 180 Application: General Ledger Source: Verifikationer - Registrerad valuta (180 tkn) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG TR GL Fişler - Girilen Para Birimi (180 Karakter) Imported from BI Publisher Description: Dövizli Fişler - 180 Application: Genel Muhasebe Source: Fişler - Girilen Para Birimi (180 Karakter) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG US GL Journals - Entered Currency (180 Char) Imported from BI Publisher Description: Foreign Journals - 180 Application: General Ledger Source: Journals - Entered Currency (180 Char) (XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG ZHS GL 日记账 - 输入币种（180 个字符） Imported from BI Publisher Description: 外币日记账 - 180 Application: 总帐管理系统 Source: 日记账 - 输入币种（180 个字符）(XML) Short Name: GLRFGNJ180_XML DB package: GL_GLRFGNJ_XMLP_PKG BI Publisher &das_where &ledger_from &ledger_where &period_where &posting_status_select &posting_status_where :access_set_name :consolidation_ledger_flag :credit_dsp :curr_format_mask :das_where :debit_dsp :flexdata :inv_flex_msg :ledger_from :ledger_where :mixed_precision :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_ledger_curr :param_ledger_name :param_ledger_type :period_where :posting_status_select :posting_status_where :stat :struct_num :thousands_separator :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 180 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_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 Y AR العملة المدخلة العملة المدخلة D Eingabewährung Eingabewährung E Divisa Introducida Divisa Introducida F Devise de saisie Devise de saisie I Divisa inserita Divisa inserita JA 入力通貨 入力通貨 KO 입력 통화 입력 통화 PTB Moeda Informada Moeda Informada RU Введенная валюта Введенная валюта S Registrerad valuta Registrerad valuta TR Girilen Para Birimi Girilen Para Birimi US Entered Currency Entered Currency ZHS 输入币种 输入币种 6 40 :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 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_FOREIGN_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=nvl(:$flex$.gl_srs_ledger_with_sets_store_id:null,acc.ledger_id) and ls.ledger_set_id (+)=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id: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 h.currency_code=:$flex$.gl_srs_currencies 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=nvl(:$flex$.gl_srs_ledger_with_sets_store_id:null,acc.ledger_id) and ls.ledger_set_id (+)=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id: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 h.currency_code=:$flex$.gl_srs_currencies ) 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, 'U',null,'P',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_currencies Entered Currency Batch Name :$flex$.gl_srs_journal_type Posting Status Batch Name