ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5693869E053B46B63588994Y select b.user_deal_type,a.deal_no,a.currency,a.start_date,a.maturity_date, a.face_value_amount/nvl(:AMT_UNIT2,1000000) face_value_amount, a.interest_rate, decode(sign(:dt0+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt0),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt0, decode(sign(:dt1+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt1),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt1, decode(sign(:dt2+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt2),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt2, decode(sign(:dt3+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt3),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt3, decode(sign(:dt4+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt4),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt4, decode(sign(:dt5+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt5),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt5, decode(sign(:dt6+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt6),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt6, decode(sign(:dt7+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt7),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt7, decode(sign(:dt8+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt8),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt8, decode(sign(:dt9+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt9),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt9, decode(sign(:dt10+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt10),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt10, decode(sign(:dt11+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt11),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt11 from XTR_deals_V a , XTR_deal_types b where a.deal_type='FRA' and a.deal_type = b.deal_type and a.currency like nvl(:CCY2,a.currency) and nvl(a.deal_subtype,'*')=nvl(:p_fund_invest,'*') and a.start_date <=to_date(to_char(last_day(:DATE_TO2),'DD-MON-YYYY'),'DD-MON-YYYY') and a.maturity_date >=to_date(to_char(:DATE_FROM2,'MONYYYY'),'MONYYYY') and a.company_code = nvl(:p_company, a.company_code) and a.portfolio_code like nvl(:p_portfolio, a.portfolio_code) union select b.user_deal_type,a.deal_no,a.currency,a.start_date,a.maturity_date, a.face_value_amount/nvl(:AMT_UNIT2,1000000) face_value_amount,a.interest_rate, decode(sign(:dt0+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt0),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt0, decode(sign(:dt1+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt1),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt1, decode(sign(:dt2+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt2),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt2, decode(sign(:dt3+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt3),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt3, decode(sign(:dt4+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt4),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt4, decode(sign(:dt5+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt5),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt5, decode(sign(:dt6+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt6),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt6, decode(sign(:dt7+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt7),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt7, decode(sign(:dt8+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt8),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt8, decode(sign(:dt9+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt9),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt9, decode(sign(:dt10+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt10),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt10, decode(sign(:dt11+1-a.start_date),1,decode(sign(a.maturity_date+1-:dt11),1,a.face_value_amount/nvl(:AMT_UNIT2,1000000),null),null) amt11 from XTR_deals_V a , XTR_deal_types b where a.deal_type='IRO' and a.deal_type = b.deal_type and a.currency like nvl(:CCY2,a.currency) and a.deal_subtype='BCAP' and a.start_date <=to_date(to_char(last_day(:DATE_TO2),'DD-MON-YYYY'),'DD-MON-YYYY') and a.maturity_date >=to_date(to_char(:DATE_FROM2,'MONYYYY'),'MONYYYY') and a.company_code = nvl(:p_company, a.company_code) and a.portfolio_code like nvl(:p_portfolio, a.portfolio_code) union select c.user_deal_type,a.deal_no,a.currency,a.start_date,a.maturity_date, a.face_value_amount/nvl(:AMT_UNIT2,1000000) face_value_amount,a.interest_rate, sum(decode(sign(:dt0+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt0),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt0, sum(decode(sign(:dt1+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt1),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt1, sum(decode(sign(:dt2+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt2),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt2, sum(decode(sign(:dt3+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt3),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt3, sum(decode(sign(:dt4+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt4),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt4, sum(decode(sign(:dt5+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt5),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt5, sum(decode(sign(:dt6+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt6),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt6, sum(decode(sign(:dt7+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt7),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt7, sum(decode(sign(:dt8+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt8),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt8, sum(decode(sign(:dt9+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt9),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt9, sum(decode(sign(:dt10+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt10),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt10, sum(decode(sign(:dt11+1-b.start_date),1,decode(sign(b.maturity_date+1-:dt11),1,b.balance_out/nvl(:AMT_UNIT2,1000000),null),null)) amt11 from xtr_deals_v a , xtr_rollover_transactions_V b , xtr_deal_types c where a.deal_type ='IRS' and a.deal_type = c.deal_type and a.currency like nvl(:CCY2,a.currency) and a.start_date <=to_date(to_char(last_day(:DATE_TO2),'DD-MON-YYYY'),'DD-MON-YYYY') and a.maturity_date >=to_date(to_char(:DATE_FROM2,'MONYYYY'),'MONYYYY') and nvl(a.deal_subtype,'*')=nvl(:p_fund_invest,'*') and a.fixed_or_floating_rate='FIXED' and a.deal_no=b.deal_number and a.company_code = nvl(:p_company, a.company_code) and a.portfolio_code like nvl(:p_portfolio, a.portfolio_code) group by c.user_deal_type,a.deal_no,a.currency, a.start_date, a.maturity_date, a.face_value_amount/nvl(:AMT_UNIT2,1000000), a.interest_rate ORDER BY 3 ASC,1 ASC XTR XTRIRHED_XML AR XTR المراكز - تقرير تغطية مركز سعر الفائدة (بتنسيق XML) Application: الخزانة Source: المراكز - تقرير تغطية مركز سعر الفائدة (بتنسيق XML) Short Name: XTRIRHED_XML DB package: XTR_XTRIRHED_XMLP_PKG D XTR Zins-Hedging Application: Treasury Source: Positionen: Zins-Hedging (XML) Short Name: XTRIRHED_XML DB package: XTR_XTRIRHED_XMLP_PKG F XTR Positions - Etat des couvertures de taux d'intérêt Application: Treasury Source: Positions - Etat des couvertures de taux d'intérêt (XML) Short Name: XTRIRHED_XML DB package: XTR_XTRIRHED_XMLP_PKG US XTR Positions - Interest Rate Hedges Application: Treasury Source: Positions - Interest Rate Hedges Report (XML) Short Name: XTRIRHED_XML DB package: XTR_XTRIRHED_XMLP_PKG ZHS XTR 头寸 - 利率套期交易报表 Application: 理财管理系统 Source: 头寸 - 利率套期交易报表 (XML) Short Name: XTRIRHED_XML DB package: XTR_XTRIRHED_XMLP_PKG BI Publisher :amt_unit2 :ccy2 :company_code2 :company_name_header :cp_para :date_from2 :date_to2 :dt0 :dt1 :dt10 :dt11 :dt2 :dt3 :dt4 :dt5 :dt6 :dt7 :dt8 :dt9 :lp_factor_desc :p_company :p_conc_request_id :p_currency :p_date_from :p_date_from_1 :p_date_to :p_display_debug :p_factor :p_fund_invest :p_portfolio :p_sql_trace :port_code2 :report_date :report_short_name :report_short_name2 :user_name2 :z1amount_unit :z1company_code :z1currency :z1date_from :z1fund_invest :z1parameters :z1portfolio :z1to :z2deal_type :z2end_of_report :z2page 1 10 :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 币种 2 20 :p_date_from Date Y AR من تاريخ D Von Datum F Date de début US Date From ZHS 起始日期 3 30 :p_fund_invest LOV Oracle XTR_FUND_INVEST Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('FUND','INVEST') order by meaning Y AR تمويل/استثمار D Fonds/Investition F Financement/investissement US Fund/Invest ZHS 资金/投资 4 40 :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 贴现 5 50 :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 公司 6 60 :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 资产组合