ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5653869E053B46B63588994 select decode(nvl(:CF_TEXP_IGBAL,0) ,0,NULL,round(((-1 * (nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0)) / :cf_texp_igbal) * 100))) COVER, round(nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0) + nvl(:cf_texp_igbal,0),0) COVER_100, least((-1 * (nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0) )- nvl(:cf_texp_igbal,0) * nvl(minimum_band,1 / 100)) ,(-1 * (nvl(:fx_cover,0) + nvl(:cf_coh_cabal,0) )- nvl(:cf_texp_igbal,0) * nvl(maximum_band,1))) MIN_COVER, nvl(minimum_band,1/100) min_hedge, nvl(maximum_band,1) max_hedge, currency, XTR_XTRFXEXP_XMLP_PKG.cf_amt_reqformula(decode ( nvl ( :CF_TEXP_IGBAL , 0 ) , 0 , NULL , round ( ( ( - 1 * ( nvl ( :fx_cover , 0 ) + nvl ( :cf_coh_cabal , 0 ) ) / :cf_texp_igbal ) * 100 ) ) ), nvl ( minimum_band , 1 / 100 ), :CF_TEXP_IGBAL, nvl ( maximum_band , 1 ),:TOTAL_HEDGE) CF_AMT_REQ from XTR_master_currencies_V where currency = nvl(:currency_code2, currency) and currency=:CCY Y XTR XTRFXEXP_XML AR XTR المراكز - تقرير تعرضات الصرف الأجنبي (بتنسيق XML) Application: الخزانة Source: المراكز - تقرير تعرضات الصرف الأجنبي (بتنسيق XML) Short Name: XTRFXEXP_XML DB package: XTR_XTRFXEXP_XMLP_PKG D XTR Wechselkursrisiken Application: Treasury Source: Positionen: Wechselkursrisiken (XML) Short Name: XTRFXEXP_XML DB package: XTR_XTRFXEXP_XMLP_PKG F XTR Positions - Etat Positions de change Application: Treasury Source: Positions - Etat Positions de change (XML) Short Name: XTRFXEXP_XML DB package: XTR_XTRFXEXP_XMLP_PKG US XTR Positions - FX Exposures Application: Treasury Source: Positions - FX Exposures Report (XML) Short Name: XTRFXEXP_XML DB package: XTR_XTRFXEXP_XMLP_PKG ZHS XTR 头寸 - FX 风险报表 Application: 理财管理系统 Source: 头寸 - FX 风险报表 (XML) Short Name: XTRFXEXP_XML DB package: XTR_XTRFXEXP_XMLP_PKG BI Publisher :amt_unit2 :ccy :cf_coh_cabal :cf_texp_igbal :company_code2 :company_name_header :cp_para :currency_code2 :fx_cover :lp_factor_desc :p_1 :p_company :p_conc_request_id :p_currency :p_display_debug :p_exposure_type :p_exposure_type_dsp :p_factor :p_factor_dsp :p_include_intercomp :p_sql_trace :p_yes_no_dsp :period_from :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :total_hedge :use_defaults :z1and_call_dep_adv :z1company :z1currency :z1p_exposure_type :z1p_factor :z1p_include_ic :z1parameters :z2amount_req :z2ccy :z2cover :z2curr_ac_balance :z2end_of_report :z2for_policy :z2fx_option :z2fx_spot_fwds :z2net_exposure :z2note_all_amounts :z2page :z2total_exposure :z2total_hedge 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_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 币种 3 30 :p_exposure_type LOV Oracle XTR_EXPOSURE_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('FIRM','INDICATIVE','ALL','NONE') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'ALL' Y AR نوع التعرض D Risikoart F Type de risque US Exposure Type 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_include_intercomp LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT meaning FROM fnd_lookups WHERE lookup_type = 'YES_NO' and lookup_code = 'Y' AR تضمين الحسابات بين الشركات D Mit zwischenbetrieblichen Transaktionen F Inclure intersociété US Include Intercompany ZHS 包括公司间