ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5070FB75A6180776E06362FB09058021Y SELECT (select name from hr_operating_units where organization_id =:P_SECURITY_ID_INT_1) OU_NAME ,:P_REPORT_DEFINITION_DSP REPORT_DEFINITION ,:P_JOURNAL_SOURCE_DSP JOURNAL_SOURCE ,to_char(:P_START_DATE ,'YYYY-MM-DD') START_DATE ,to_char(:P_AS_OF_DATE ,'YYYY-MM-DD') AS_OF_DATE ,:P_THIRD_PARTY_NAME THIRD_PARTY_NAME ,:P_SHOW_TRX_DETAIL_DSP SHOW_APPLIED_TRX_DETAIL ,:P_INCL_WRITE_OFF_DSP INCLUDE_WRITE_OFF ,:P_ACCOUNT_FROM ACCOUNT_FROM ,:P_ACCOUNT_TO ACCOUNT_TO ,:P_ACCT_BALANCE_DSP ACCOUNT_BALANCE ,:P_REPORT_MODE_DSP REPORT_MODE FROM dual SQLAP APTBRPT AR AP ميزان مراجعة حساب المدفوعات (1) Imported from BI Publisher Application: المدفوعات Source: ميزان مراجعة حساب المدفوعات Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT D AP Kreditoren Summen-/Saldenliste (1) Imported from BI Publisher Application: Kreditoren Source: Kreditoren Summen-/Saldenliste Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT E AP Balance de Comprobación de Cuentas a Pagar Imported from BI Publisher Application: Payables Source: Balance de Comprobación de Cuentas a Pagar Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT F AP Balance des fournisseurs (1) Imported from BI Publisher Application: Payables Source: Balance des fournisseurs Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT I AP Bilancio di verifica dei debiti in essere Imported from BI Publisher Application: Payables Source: Bilancio di verifica dei debiti in essere Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT JA AP 買掛/未払金残高試算表 Imported from BI Publisher Application: Payables Source: 買掛/未払金残高試算表 Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT KO AP 시산표 Imported from BI Publisher Application: Payables Source: AP 시산표 Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT PTB AP Balancete das Contas a Pagar Imported from BI Publisher Application: Payables Source: Balancete das Contas a Pagar Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT RU AP Пробный баланс Кредиторов Imported from BI Publisher Application: Кредиторы Source: Пробный баланс Кредиторов Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT S AP Råbalans Imported from BI Publisher Application: Payables Source: Leverantörsreskontra: Råbalans Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT TR AP Borçlar Muhasebesi Mizanı Imported from BI Publisher Application: Borçlar Muhasebesi Source: Borçlar Muhasebesi Mizanı Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT US AP Accounts Payable Trial Balance Imported from BI Publisher Application: Payables Source: Accounts Payable Trial Balance Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT ZHS AP 应付帐款试算表 (1) Imported from BI Publisher Application: 应付帐款 Source: 应付帐款试算表 Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT BI Publisher 1=1 :p_account_from :p_account_to :p_acct_balance :p_acct_balance_dsp :p_app_sql_statement :p_as_of_date :p_coa_id :p_custom_param_1 :p_custom_param_2 :p_custom_param_3 :p_definition_code :p_inc_sla_manuals_unposted :p_incl_write_off_dsp :p_incl_write_off_flag :p_include_sla_manuals_unposted :p_journal_source :p_journal_source_dsp :p_report :p_report_definition_dsp :p_report_mode_dsp :p_report_style :p_security_flag :p_security_id_char_1 :p_security_id_int_1 :p_show_trx_detail_dsp :p_show_trx_detail_flag :p_sql_statement :p_start_date :p_summary_sql_statement :p_third_party_id :p_third_party_name :p_valuation_method 1 -70 :p_application_id LOV Oracle XLA_SRS_SUBLEDGERS Y select application_id id, application_name value, null description from (select application_name,application_id from xla_subledgers_fvl union select application_name,application_id from fnd_application_vl where application_id=101) order by value,description SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID= nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID) AR XLA_SRS_SUBLEDGERS معرف التطبيق D XLA_SRS_SUBLEDGERS Anwendungskennung E XLA_SRS_SUBLEDGERS Identificador de aplicación F XLA_SRS_SUBLEDGERS Identifiant de l'application I XLA_SRS_SUBLEDGERS Identificativo dell'applicazione JA XLA_SRS_SUBLEDGERS アプリケーション識別子 KO XLA_SRS_SUBLEDGERS 애플리케이션 식별자 PTB XLA_SRS_SUBLEDGERS Identificador da Aplicação RU XLA_SRS_SUBLEDGERS Идентификатор приложения S XLA_SRS_SUBLEDGERS Applikationsidentifierare TR XLA_SRS_SUBLEDGERS Uygulama Yazılımı Tanımlayıcısı US XLA_SRS_SUBLEDGERS Application Identifier ZHS XLA_SRS_SUBLEDGERS 应用产品标识 2 -60 :p_start_date Date 1950/01/01 00:00:00 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 Start Date Start Date ZHS 起始日期 起始日期 3 -50 :p_coa_id Number SELECT gl.chart_of_accounts_id FROM gl_ledgers gl ,xla_tb_definitions_b td WHERE gl.ledger_id = td.ledger_id AND td.definition_code = :$flex$.report_definition Y AR جدول تصنيف الحسابات جدول تصنيف الحسابات D Kontenplan Kontenplan E Plan de Cuentas Plan de Cuentas F Plan de comptes Plan de comptes I Piano dei conti Piano dei conti JA 勘定体系 勘定体系 KO 계정코드집 계정코드집 PTB Plano de Contas Plano de Contas RU План счетов План счетов S Kontoplan Kontoplan TR Hesap Planı Hesap Planı US Chart of Accounts Chart of Accounts ZHS 科目表 科目表 4 -40 :p_acct_balance LOV Oracle XLA_SRS_TB_ACCT_BALANCE Y select lookup_code id, meaning value, description description from xla_lookups where lookup_type='XLA_TB_ACCT_BALANCE' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_TB_ACCT_BALANCE' AND lookup_code = 'YEAR_TO_DATE' Y AR رصيد الحساب رصيد الحساب D Kontensaldo Kontensaldo E Saldo de Cuenta Saldo de cuenta F Solde comptable Solde comptable I Saldo conto Saldo conto JA 勘定科目残高 勘定科目残高 KO 계정 잔액 계정 잔액 PTB Saldo da Conta Saldo da Conta RU Сальдо счета Сальдо счета S Kontosaldo Kontosaldo TR Hesap Bakiyesi Hesap Bakiyesi US Account Balance Account Balance ZHS 帐户余额 帐户余额 5 -30 :p_security_flag LOV Oracle XLA_SRS_TB_SECURITY_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' and decode(:$flex$.xla_srs_tb_je_sources:null ,null ,'N' ,decode((select count(1) from xla_subledgers where je_source_name= :$flex$.xla_srs_tb_je_sources:null and security_function_name is not null) ,0 ,'N' ,lookup_code)) =lookup_code order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' AND DECODE(:$flex$.journal_source:NULL ,NULL ,'N' ,DECODE((SELECT COUNT(1) FROM xla_subledgers WHERE je_source_name = :$flex$.journal_source:NULL AND security_function_name IS NOT NULL) , 0 ,'N' ,'Y')) = lookup_code AR السرية السرية D Sicherheit Sicherheit E Seguridad Seguridad F Sécurité Sécurité I Sicurezza Sicurezza JA セキュリティ セキュリティ KO 보안 보안 PTB Segurança Segurança RU Защита Защита S Säkerhet Säkerhet TR Güvenlik Güvenlik US Security Security ZHS 安全性 安全性 6 -20 :p_inc_sla_manuals_unposted Char SELECT :$flex$.include_sla_manuals_other_sources.VALUE FROM DUAL AR P_INC_SLA_MANUALS_UNPOSTED قيمة تضمين المصادر الأخرى/قيود اليومية اليدوية لحساب الأستاذ الفرعي D P_INC_SLA_MANUALS_UNPOSTED Mit manuellen Nebenbuchbuchungen/Sonstigen Herkunftsarten - Wert E P_INC_SLA_MANUALS_UNPOSTED Valor de inclusión de manuales de contabilidad auxiliar/otros orígenes F P_INC_SLA_MANUALS_UNPOSTED Valeur Inclure pièces auxiliaires manuelles/autres origines I P_INC_SLA_MANUALS_UNPOSTED Valore Includi manuali SLA/altre origini JA P_INC_SLA_MANUALS_UNPOSTED SLA手動/その他のソースを含む値 KO P_INC_SLA_MANUALS_UNPOSTED SLA 수동/기타 출처 포함 값 PTB P_INC_SLA_MANUALS_UNPOSTED Incluir Manuais SLA/Outros Valores de Origem RU P_INC_SLA_MANUALS_UNPOSTED Значение флага "Вкл. руководства по субкнигам/др. источники" S P_INC_SLA_MANUALS_UNPOSTED Inkludera handböcker för reskontraredovisning/värdet Övriga källor TR P_INC_SLA_MANUALS_UNPOSTED SLA Manuel İşlemlerini/Diğer Kaynakları Dahil Et Değeri US P_INC_SLA_MANUALS_UNPOSTED Include SLA Manuals/Other Sources Value ZHS P_INC_SLA_MANUALS_UNPOSTED 包括 SLA 人工/其它来源值 7 -10 :p_report_style Char SELECT :$flex$.report_mode.VALUE FROM DUAL AR P_REPORT_STYLE معنى طور التقرير D P_REPORT_STYLE Bedeutung Auswertungsmodus E P_REPORT_STYLE Significado de modo de informe F P_REPORT_STYLE Signification du mode d'édition I P_REPORT_STYLE Significato della modalità del rapporto JA P_REPORT_STYLE レポート・モード内容 KO P_REPORT_STYLE 보고서 모드 의미 PTB P_REPORT_STYLE Significado do Modo de Relatório RU P_REPORT_STYLE Расшифровка режима отчета S P_REPORT_STYLE Förklaring till rapportläge TR P_REPORT_STYLE Rapor Modu Açıklaması US P_REPORT_STYLE Report Mode Meaning ZHS P_REPORT_STYLE 报表模式含义 8 10 :p_security_id_int_1 LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description AR وحدة التشغيل وحدة التشغيل D Betriebseinheit Betriebseinheit E Unidad Operativa Unidad operativa F Unité opérationnelle Unité opérationnelle I Unità operativa Unità operativa JA 営業単位 営業単位 KO 운영 단위 운영 단위 PTB Unidade Operacional Unidade Operacional RU Операционная единица Операционная единица S Operativ enhet Operativ enhet TR Faaliyet Birimi Faaliyet Birimi US Operating Unit Operating Unit ZHS 业务实体 业务实体 9 20 :p_definition_code LOV Oracle XLA_SRS_TB_DEFINITIONS_ALL Y select definition_code id, name value, description description from xla_tb_definitions_vl where enabled_flag='Y' and ( definition_code in ( select xtd.definition_code from xla_tb_defn_je_sources xtd ,xla_subledgers xs where xtd.je_source_name=xs.je_source_name and xs.application_id=:$flex$.xla_srs_subledgers ) or decode(:$flex$.xla_srs_subledgers,101,'GL','OTHERS')='GL' ) and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists ( select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and asa.ledger_id=xla_tb_definitions_vl.ledger_id and (gas.access_set_id= nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id= nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'), '-1'))))) order by value,description Y AR تعريف التقرير تعريف التقرير D Auswertungsdefinition Auswertungsdefinition E Definición de Informe Definición de informe F Définition de l'état Définition de l'état I Definizione rapporto Definizione rapporto JA レポート定義 レポート定義 KO 보고서 정의 보고서 정의 PTB Definição do Relatório Definição do Relatório RU Определение отчета Определение отчета S Rapportdefinition Rapportdefinition TR Rapor Tanımı Rapor Tanımı US Report Definition Report Definition ZHS 报表定义 报表定义 10 30 :p_journal_source LOV Oracle XLA_SRS_TB_JE_SOURCES Y select je_source_name id, user_je_source_name value, null description from gl_je_sources a where exists (select 1 from xla_tb_defn_je_sources djs ,xla_subledgers xls where djs.je_source_name=xls.je_source_name and djs.je_source_name=a.je_source_name and djs.definition_code=:$flex$.xla_srs_tb_definitions_all and xls.application_id= decode(nvl(fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE'),'N') ,'Y' ,xls.application_id ,:$flex$.xla_srs_subledgers ) ) order by user_je_source_name SELECT gjs.user_je_source_name FROM gl_je_sources gjs WHERE gjs.je_source_name IN (SELECT xls.je_source_name FROM xla_tb_defn_je_sources xjs ,xla_subledgers xls WHERE xjs.je_source_name = xls.je_source_name AND xjs.definition_code = :$flex$.report_definition AND xls.application_id = nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID)) AR مصدر اليومية مصدر اليومية D Belegherkunft Belegherkunft E Origen de Asiento Origen de asiento F Origine de la pièce Origine de la pièce I Origine scrittura contabile Origine scrittura contabile JA 仕訳ソース 仕訳ソース KO 분개 출처 분개 출처 PTB Origem do Lançamento Origem do Lançamento RU Источник журнала Источник журнала S Verifikationskälla Verifikationskälla TR Fiş Kaynağı Fiş Kaynağı US Journal Source Journal Source ZHS 凭证来源系统 凭证来源系统 11 40 :p_as_of_date Date sysdate Y AR اعتبارًا من تاريخ اعتبارًا من تاريخ D Vom Vom E A la Fecha A la Fecha F En date du En date du I In data In data JA 現在 現在 KO 기준 일자 기준 일자 PTB Data de Referência Data de Referência RU На дату На дату S Per datum Per datum TR Başlangıç Tarihi 2 Başlangıç Tarihi US As of Date As of Date ZHS 截止日期 截止日期 12 50 :p_third_party_id LOV Oracle XLA_SRS_TB_THIRD_PARTY Y select tp.pt_id || '#$' || tp.pt_cd id, tp.pt_nm value, lk.meaning description from ((select vendor_id pt_id,vendor_name pt_nm,'S' pt_cd from ap_suppliers) union all (select hca.cust_account_id pt_id,hp.party_name pt_nm,'C' pt_cd from hz_cust_accounts hca,hz_parties hp where hca.party_id=hp.party_id)) tp,xla_lookups lk where tp.pt_cd=lk.lookup_code and lk.lookup_type='XLA_PARTY_TYPE' order by tp.pt_nm AR اسم الطرف الآخر اسم الطرف الآخر D Geschäftspartnername Geschäftspartnername E Nombre de Terceros Nombre de terceros F Nom du tiers Nom du tiers I Nome terza parte Nome terza parte JA サード・パーティ名 サード・パーティ名 KO 제3자명 제3자명 PTB Nome do Terceiro Nome do Terceiro RU Название сторонней организации Название сторонней организации S Namn på tredje part Namn på tredje part TR Üçüncü Şahıs Adı Üçüncü Şahıs Adı US Third Party Name Third Party Name ZHS 第三方名称 第三方名称 13 60 :p_show_trx_detail_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' AND lookup_code = 'N' Y AR عرض تفاصيل الحركة عرض تفاصيل الحركة D Transaktionsdetails anzeigen Transaktionsdetails anzeigen E Mostrar Detalle de Transacción Mostrar detalle de transacción F Afficher le détail du mouvement Afficher le détail du mouvement I Mostra dettagli transazione Mostra dettagli transazione JA 取引詳細の表示 取引詳細の表示 KO 거래 상세내역 표시 거래 상세내역 표시 PTB Exibir Detalhe da Transação Exibir Detalhe da Transação RU Вывод сведений о транзакции Вывод сведений о транзакции S Visa transaktionsdetalj Visa transaktionsdetalj TR İşlem Detayını Göster İşlem Detayını Göster US Show Transaction Detail Show Transaction Detail ZHS 显示事务处理详细信息 显示事务处理详细信息 14 70 :p_incl_write_off_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' AND lookup_code = 'N' Y AR تضمين المحذوفات تضمين المحذوفات D Mit aufgelösten Rückstellungen Mit aufgelösten Rückstellungen E Incluir Eliminaciones Incluir eliminaciones F Inclure les annulations Inclure les annulations I Includi storni Includi storni JA 貸倒償却を含む 貸倒償却を含む KO 상쇄 포함 상쇄 포함 PTB Incluir Baixas Incluir Baixas RU Включение списаний Включение списаний S Inkludera bortskrivningar Inkludera bortskrivningar TR Kapatmaları Dahil Et Kapatmaları Dahil Et US Include Write Offs Include Write Offs ZHS 包括注销 包括注销 15 80 :p_account_from Char AR حساب من حساب من D Von Konto Von Konto E De Cuenta De cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目: 自 勘定科目: 自 KO 시작 계정 시작 계정 PTB Conta - De Conta - De RU Счет с Счет с S Från konto Från konto TR İlk Hesap İlk Hesap US Account From Account From ZHS 帐户自 帐户自 16 90 :p_account_to Char AR حساب إلى حساب إلى D Bis Konto Bis Konto E A Cuenta A cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目: 至 勘定科目: 至 KO 종료 계정 종료 계정 PTB Conta - Até Conta - Até RU Счет по Счет по S Till konto Till konto TR Son Hesap Son Hesap US Account To Account To ZHS 帐户至 帐户至 17 100 :p_include_sla_manuals_unposted LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type ='XLA_YES_NO' and lookup_code ='N' AR تضمين مصادر أخرى/قيود يوميةيدويةلأستاذفرعي علامة تضمين المصادر الأخرى/قيود اليومية اليدوية لحساب الأستاذ الفرعي D Mit manuellen Nebenbuchbuchungen/Sonstigen Herkunftsarten Kennzeichen "Mit manuellen Nebenbuchbuchungen/Sonstigen Herkunftsarten" E Incluir Manuales de Contabilidad Auxiliar/Otros Orígenes Indicador de inclusión de manuales de contabilidad auxiliar/otros orígenes F Inclure pièces auxiliaires manuelles/autres origines Indicateur Inclure pièces auxiliaires manuelles/autres origines I Includi manuali SLA/altre origini Flag Includi manuali SLA/altre origini JA SLA手動/その他のソースを含む SLA手動/その他のソースを含むフラグ KO SLA 수동/기타 출처 포함 SLA 수동/기타 출처 포함 플래그 PTB Incluir Manuais SLA/Outras Origens Incluir Manuais do SLA/Indicador de Outras Origens RU Вкл. руководства по субкнигам/др. источники Флаг включения руководств по учету на основе субкниг/других источников S Inkludera handböcker för reskontraredovisning/övriga källor Inkludera handböcker för reskontraredovisning/flaggan Övriga källor TR SLA Manuel İşlemlerini/Diğer Kaynakları Dahil Et SLA Manuel İşlemlerini/Diğer Kaynakları Dahil Et İşareti US Include SLA Manuals/Other Sources Include SLA Manuals/Other Sources Flag ZHS 包括 SLA 人工/其它来源 包括 SLA 人工/其它来源标志 18 110 :p_report LOV Oracle XLA_SRS_TB_REPORT_MODE Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk where xlk.lookup_code<>'N' and xlk.lookup_type='XLA_REPORT_LEVEL' order by value,description select xlk.meaning from xla_lookups xlk where xlk.lookup_code = 'S' and xlk.lookup_type = 'XLA_REPORT_LEVEL' Y AR طور التقرير طور التقرير D Auswertungsmodus Auswertungsmodus E Modo de Informe Modo de Informe F Mode d'édition Mode d'édition I Modalità rapporto Modalità del rapporto JA レポート・モード レポート・モード KO 보고서 모드 보고서 모드 PTB Modo de Relatório Modo de Relatório RU Режим отчета Режим отчета S Rapportläge Rapportläge TR Rapor Modu Rapor Modu US Report Mode Report Mode ZHS 报表模式 报表模式