ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5723869E053B46B63588994Y select a.amount_date VAL_DATE, a.company COMPANY, a.cparty CPARTY, decode(a.contract_type,'ONC',a.transaction_number,a.deal_number) DEAL_NO, nvl(b.user_deal_type,a.user_deal_type)||' '||a.user_deal_subtype DEAL_TYPE, a.user_amount_type AMT_TYPE, a.product PROD, a.rate RATE, a.currency CCY, a.portfolio PORT, a.amount/:amt_unit2 AMOUNT, a.hce_amount/:amt_unit2 HCE_AMOUNT, a.user_date_type date_type from XTR_MATURITIES_V a, XTR_DEAL_TYPES_V b where &p_period_where_clause and a.amount > 0 and a.company like nvl(upper(:P_COMPANY),a.company) and a.contract_type like nvl(upper(:P_DEAL_TYPE),a.contract_type) and a.contract_type != 'DN' and a.subtype like nvl(upper(:P_DEAL_SUBTYPE),a.subtype) and a.product like nvl(upper(:P_PRODUCT_TYPE),a.product) and a.currency like nvl(upper(:P_CURRENCY),a.currency) and a.cparty like nvl(upper(:P_CPARTY),a.cparty) and a.portfolio like nvl(upper(:P_PORTFOLIO),a.portfolio) and ((nvl(a.client,'%') like nvl(:P_CLIENT,a.client) and nvl(upper(:P_AS_PRINCIPAL),'N') = 'N') or (nvl(a.client,'NILL') = 'NILL' and nvl(upper(:P_AS_PRINCIPAL),'N') = 'Y')) and b.deal_type = a.contract_type and a.contract_status ='CURRENT' and NOT EXISTS ( select 'x' from xtr_maturities_v c where c.company = a.company and c.user_deal_type = a.user_deal_type and c.user_date_type = a.user_date_type and c.user_amount_type = a.user_amount_type and c.type_of_amount = a.type_of_amount and c.date_type = a.date_type and c.type_of_amount = 'FACEVAL' and c.contract_type = 'TMM' and c.date_type = 'RATESET' and c.contract_type = a.contract_type and c.product = a.product and c.currency = a.currency and c.cparty = a.cparty and c.portfolio = a.portfolio and c.amount_date = a.amount_date ) order by 1,2,5,4,6 XTR XTRMTDAT_XML AR XTR المراكز - تقرير الاستحقاقات حسب التاريخ (بتنسيق XML) Application: الخزانة Source: المراكز - تقرير الاستحقاقات حسب التاريخ (بتنسيق XML) Short Name: XTRMTDAT_XML DB package: XTR_XTRMTDAT_XMLP_PKG D XTR Fälligkeiten nach Datum Application: Treasury Source: Positionen: Fälligkeiten nach Datum (XML) Short Name: XTRMTDAT_XML DB package: XTR_XTRMTDAT_XMLP_PKG F XTR Positions - Etat Maturité par date Application: Treasury Source: Positions - Etat Maturité par date (XML) Short Name: XTRMTDAT_XML DB package: XTR_XTRMTDAT_XMLP_PKG US XTR Positions - Maturities by Date Application: Treasury Source: Positions - Maturities by Date Report (XML) Short Name: XTRMTDAT_XML DB package: XTR_XTRMTDAT_XMLP_PKG ZHS XTR 头寸 - 按日期列出的到期交易报表 Application: 理财管理系统 Source: 头寸 - 按日期列出的到期交易报表 (XML) Short Name: XTRMTDAT_XML DB package: XTR_XTRMTDAT_XMLP_PKG BI Publisher &p_period_where_clause :amt_unit2 :as_principal :client_code :company_code :company_name_header :cp_para :cparty_code :currency_code :deal_subtype :deal_type1 :from_date :lp_factor_desc :p_as_principal :p_client :p_company :p_conc_request_id :p_cparty :p_currency :p_deal_subtype :p_deal_type :p_display_debug :p_factor :p_period_from :p_period_from_1 :p_period_to :p_period_to_1 :p_period_where_clause :p_portfolio :p_product_type :p_sql_trace :port_code :product_type :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :to_date_1 :use_defaults :z1as_principal :z1client :z1company :z1cparty :z1currency :z1date_from :z1dealtype :z1p_date_type :z1p_factor :z1parameters :z1portfolio :z1product_type :z1subtype :z1to :z2amount :z2amount_type :z2ccy :z2deal_ref :z2deal_type_sub :z2end_of_report :z2hce_amount :z2maturity :z2page :z2product :z2rate :z2status_code 1 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 F Société US Company ZHS 公司 2 20 :p_deal_type LOV Oracle XTR_DEAL_TYPE Y select deal_type id, user_deal_type value, name description from xtr_deal_types_v where authorised='Y' order by user_deal_type AR نوع الصفقة D Geschäftsart F Type d'opération US Deal Type ZHS 交易类型 3 30 :p_deal_subtype LOV Oracle XTR_DEAL_SUBTYPE Y select deal_subtype id, user_deal_subtype value, name description from xtr_deal_subtypes_v where authorised='Y' and deal_type=nvl(:$flex$.xtr_deal_type,deal_type) order by user_deal_subtype AR النوع الفرعي للصفقة D Geschäftsunterart F Sous-type d'opération US Deal Subtype ZHS 交易子类型 4 40 :p_product_type LOV Oracle XTR_PRODUCT_TYPE Y select product_type id, product_type value, product_desc description from xtr_product_types_v where product_auth='Y' and deal_type=nvl(:$flex$.xtr_deal_type,deal_type) order by product_type AR نوع المنتج D Produktart F Type de produit US Product Type ZHS 产品类型 5 50 :p_portfolio LOV Oracle XTR_PORTFOLIO Y select portfolio id, portfolio value, name description from xtr_portfolios_v where company_code=nvl(:$flex$.xtr_company,company_code) order by company_code AR سندات تجارية F Portefeuille US Portfolio ZHS 资产组合 6 60 :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 F Contrepartie US Counterparty ZHS 订约方 7 70 :p_currency LOV Oracle XTR_CURRENCY Y select currency id, currency value, name description from xtr_master_currencies_v where authorised='Y' order by currency AR العملة D Währung F Devise US Currency ZHS 币种 8 80 :p_period_from Date AR فترة من D Von Periode F Période - De US Period From ZHS 期间自 9 90 :p_period_to Date AR فترة إلى D Bis Periode F Période - A US Period To ZHS 终止期间 10 100 :p_client LOV Oracle XTR_CLIENT Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='CP' and party_category='CL' order by party_code AR العميل D Kunde US Client ZHS 客户机 11 110 :p_as_principal LOV Oracle XTR_YN Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='YES_NO' order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'YES_NO' AND lookup_code = 'Y' Y AR كرأس مال D Direktinvestition F Comme principal US As Principal ZHS 本金 12 120 :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 F Facteur US Factor ZHS 贴现