ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472D451A9E05362FB09050512Y select a.valuation_date VALUE_DATE, a.security_description SEC_DESCRIP, a.security_ref SEC_REF, a.company_code COMP_CODE, a.issued_by ISSUED_BY, a.valuer VALUER, a.security_value/:amt_unit2 SEC_VALUE, a.priority_sum/:amt_unit2 PRIORITY_SUM, decode(nvl(upper(:ORDER_BY_PTY_MGR2),'C') ,'C',b.short_name,b.account_manager ) PARTY_NAME, b.short_name CPARTY, b.account_manager ACCT_MANAGER from XTR_LOAN_SECURITIES_V a, XTR_PARTIES_V b, XTR_PARTIES_V c where a.cparty_code like nvl(upper(:PARTY_CODE2), a.cparty_code) and a.company_code like nvl(upper(:P_COMPANY),'%') and a.cparty_code = b.party_code and nvl(b.account_manager,'%') like nvl(upper(:ACCOUNT_MANAGER2), b.account_manager) and a.valuer = c.party_code (+) and ((c.party_code like nvl(upper(:VALUER2),'%')) or (:VALUER2 is null)) and nvl(a.valuation_date ,to_date('01/01/1980','MM/DD/YYYY')) <= nvl(:BEFORE_VALUE_DATE2, nvl(a.valuation_date ,to_date('01/01/1980','MM/DD/YYYY'))) and nvl(a.security_value,0) >= nvl(:OVER_VALUATION2,0) and nvl(a.priority_sum,0) >= nvl(:OVER_PRIORITY_SUM2,0) order by 8,7 XTR XTRMILNS_XML AR XTR إدارة - تقرير الأوراق المالية للقروض (بتنسيق XML) Imported from BI Publisher Description: إدارة - تقرير الأوراق المالية للقروض Application: الخزانة Source: إدارة - تقرير الأوراق المالية للقروض (بتنسيق XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG D XTR Kreditsicherung Imported from BI Publisher Description: Auswertung "Administrator: Kreditsicherung" Application: Treasury Source: Administrator: Kreditsicherung (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG E XTR Administración - Informe de Valores de Préstamos Imported from BI Publisher Description: Administración - Informe de Valores de Préstamos Application: Treasury Source: Administración - Informe de Valores de Préstamos (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG F XTR Admin - Etat Valeurs mobilières des emprunts Imported from BI Publisher Description: Admin - Etat Valeurs mobilières des emprunts Application: Treasury Source: Admin - Etat Valeurs mobilières des emprunts (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG I XTR Amministratore - Rapporto Titoli obbligazionari Imported from BI Publisher Description: Amministratore - rapporto dei titoli obbligazionari Application: Treasury Source: Amministratore - Rapporto Titoli obbligazionari (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG JA XTR 管理 - 貸付証券レポート Imported from BI Publisher Description: 管理 - 貸付証券レポート Application: Treasury Source: 管理 - 貸付証券レポート(XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG KO XTR 관리자 - 대출 담보물 보고서 Imported from BI Publisher Description: 관리자 - 대출 담보물 보고서 Application: Treasury Source: 관리자 - 대출 담보물 보고서(XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG PTB XTR Administração - Relatório de Títulos do Empréstimo Imported from BI Publisher Description: Administração - Relatório de Títulos do Empréstimo Application: Treasury Source: Administração - Relatório de Títulos do Empréstimo (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG RU XTR Администратор - отчет по облигациям Imported from BI Publisher Description: Администратор - отчет по облигациям Application: Казначейство Source: Администратор - отчет по облигациям (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG S XTR Admin - Säkerheter - rapport Imported from BI Publisher Description: Admin - Säkerheter - rapport Application: Treasury Source: Admin - Säkerheter - rapport (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG TR XTR Yönetici - Borç Menkul Kıymetler Raporu Imported from BI Publisher Description: Yönetici - Borç Menkul Kıymetler Raporu Application: Hazine Yönetimi Source: Yönetici - Borç Menkul Kıymetler Raporu (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG US XTR Admin - Loan Securities Imported from BI Publisher Description: Admin - Loan Securities Report Application: Treasury Source: Admin - Loan Securities Report (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG ZHS XTR 管理 - 贷款抵押报表 Imported from BI Publisher Description: 管理 - 贷款抵押报表 Application: 理财管理系统 Source: 管理 - 贷款抵押报表 (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG BI Publisher :account_manager2 :amt_unit2 :before_value_date2 :company_name_header :cp_para :lp_factor_desc :order_by_pty_mgr2 :over_priority_sum2 :over_valuation2 :p_account_manager :p_before_date :p_company :p_conc_request_id :p_cparty :p_cparty_name :p_display_debug :p_factor :p_priority_total :p_sort_by :p_sql_trace :p_validation_amount :p_valuer :party_code2 :report_date :report_short_name :valuer :valuer2 :z1acct_mgr :z1company :z1name :z1order_by_pty_mgr :z1p_factor :z1parameters :z1party_code :z1priority_sum :z1valuation_amount :z1valuation_reviews_before :z1valuer :z2company :z2end_of_report :z2issued_by :z2page :z2party_acct_manager :z2party_name1 :z2priority_sum :z2sec_value :z2security_description :z2security_ref :z2value_date 1 -40 :p_sort_by LOV Oracle XTR_PARTY_MANAGER Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('COUNTERPARTY','ACCOUNT MANAGER') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'COUNTERPARTY' Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Bazı Sıralama Bazı US Sort By Sort By ZHS 排序依据 排序依据 2 -30 :p_sql_trace Char N AR تتبع SQL تتبع SQL D SQL-Trace SQL-Trace E Rastreo SQL Rastreo SQL I SQL trace SQL trace JA SQLトレース SQLトレース KO SQL 추적 SQL 추적 PTB Rastreamento SQL Rastreamento SQL RU Трассировка SQL Трассировка SQL S SQL-spårning SQL-spårning TR SQL İzleme SQL İzleme US SQL Trace SQL Trace ZHS SQL 跟踪 SQL 跟踪 3 -20 :p_display_debug Char N AR عرض معالجة الأخطاء عرض معالجة الأخطاء D Debug anzeigen Debug anzeigen E Mostrar Depuración Mostrar Depuración F Afficher diagnostic Afficher diagnostic I Visualizza debug Visualizza debug JA デバッグ表示 デバッグ表示 KO 디버그 표시 디버그 표시 PTB Exibir Depuração Exibir Depuração RU Вывод отладочных сообщений Вывод отладочных сообщений S Visa felsökning Visa felsökning TR Hata Ayıklamayı Görüntüle Hata Ayıklamayı Görüntüle US Display Debug Display Debug ZHS 显示调试 显示调试 4 10 :p_company LOV Oracle XTR_COMPANY Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='C' order by party_code 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 公司 公司 5 20 :p_cparty LOV Oracle XTR_CPARTY Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='CP' order by party_code AR الطرف الآخر الطرف الآخر D Geschäftspartner Geschäftspartner E Contraparte Contraparte F Contrepartie Contrepartie I Controparte Controparte JA 相手方 相手方 KO 거래 상대 거래 상대 PTB Banco Banco RU Вторая сторона Вторая сторона S Motpart Motpart TR Karşı Taraf Karşı Taraf US Counterparty Counterparty ZHS 订约方 订约方 6 30 :p_valuer LOV Oracle XTR_VALUER Y select party_code id, party_code value, short_name description from xtr_parties_v where valuer_yn='Y' order by party_code AR المقيم المقيم D Schätzer Schätzer E Tasador Tasador F Expert Expert I Stimatore Stimatore JA 評価者 評価者 KO 평가자 평가자 PTB Avaliador Avaliador RU Оценщик Оценщик S Värderingsman Värderingsman TR Değerleyici Değerleyici US Valuer Valuer ZHS 估价人 估价人 7 40 :p_before_date Date sysdate Y AR تقييم قبل الميعاد تقييم قبل الميعاد D Bewertung vor Bewertung vor E Valoración Antes de Fecha Valoración Antes de Fecha F Valorisation avant date Valorisation avant date I Valutazione precedente alla data Valutazione precedente alla data JA 評価対象期限日 評価対象期限日 KO 일자 이전 평가 일자 이전 평가 PTB Avaliação Antes da Data Avaliação Antes da Data RU Срок оценки Срок оценки S Värdering före Värdering före TR Bu Tarih Öncesinde Değerleme Bu Tarih Öncesinde Değerleme US Valuation Before Date Valuation Before Date ZHS 估价截止日期 估价截止日期 8 50 :p_validation_amount Number AR مبلغ التقييم مبلغ التقييم D Bewertungsbetrag Bewertungsbetrag E Importe de Valoración Importe de Valoración F Montant de valorisation Montant de valorisation I Importo valutazione Importo della valutazione JA 評価額 評価額 KO 평가 금액 평가 금액 PTB Quantia da Avaliação Quantia da Avaliação RU Сумма оценки Сумма оценки S Värderingsbelopp Värderingsbelopp TR Değerleme Tutarı Değerleme Tutarı US Valuation Amount Valuation Amount ZHS 估价金额 估价金额 9 60 :p_priority_total Number AR إجمالي الأولوية إجمالي الأولوية D Sicherungssumme Sicherungssumme E Suma de Prioridades Total de Prioridad F Somme priorité Total priorité I Sintetico priorità Totale della priorità JA 優先度要約 優先度合計 KO 우선순위 합계 우선순위 합계 PTB Soma da Prioridade Total da Prioridade RU Сумма задолженности Общая сумма задолженности S Prioritetssummering Prioritetssumma TR Öncelik Toplamı Öncelik Toplamı US Priority Sum Priority Total ZHS 优先级总计 优先级合计 10 70 :p_account_manager LOV Oracle XTR_ACCOUNT_MANAGER Y select account_manager id, account_manager value, name description from xtr_account_managers_v order by account_manager AR مدير الحساب مدير الحساب D Account-Manager Account-Manager E Gestor de Cuentas Gestor de Cuentas F Gestionnaire de comptes Gestionnaire de comptes I Responsabile account Responsabile account JA 会計主任 会計主任 KO 계정 관리자 계정 관리자 PTB Gerente da Conta Gerente da Conta RU Менеджер счета Менеджер счета S Kontoansvarig Kontoansvarig TR Hesap Yöneticisi Hesap Yöneticisi US Account Manager Account Manager ZHS 客户经理 客户经理 11 80 :p_factor LOV Oracle XTR_FACTOR Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('UNIT','THOUSAND','MILLION','BILLION') order by lookup_code SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'UNIT' Y AR المعامل المعامل D Faktor Faktor F Facteur Facteur I Fattore Fattore JA ファクタ ファクタ KO 단위 단위 PTB Fator Fator RU Множитель Множитель S Faktor Faktor TR Faktör Faktör US Factor Factor ZHS 贴现 贴现