ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5643869E053B46B63588994Y SELECT company_code,currency_combination,currency base_ccy, round(sum(decode(sign(cashflow_amount),-1,cashflow_amount,0)),0)/:amt_unit2 base_sales_amt, round(sum(decode(sign(cashflow_amount),-1,-1*transaction_rate*cashflow_amount,0)),0)/:amt_unit2 contra_buy_amt, round(sum(decode(sign(cashflow_amount),-1,0,cashflow_amount)),0)/:amt_unit2 base_buy_amt, round(sum(decode(sign(cashflow_amount),-1,0,-1*transaction_rate*cashflow_amount)),0)/:amt_unit2 contra_sales_amt, XTR_XTRFXAVG_XMLP_PKG.avg_rate1formula(round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , 0 , cashflow_amount ) ) , 0 ) / :amt_unit2, round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , 0 , - 1 * transaction_rate * cashflow_amount ) ) , 0 ) / :amt_unit2) avg_rate1, XTR_XTRFXAVG_XMLP_PKG.avg_rate2formula(round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , cashflow_amount , 0 ) ) , 0 ) / :amt_unit2, round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , - 1 * transaction_rate * cashflow_amount , 0 ) ) , 0 ) / :amt_unit2) avg_rate2, XTR_XTRFXAVG_XMLP_PKG.calcformula(round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , 0 , cashflow_amount ) ) , 0 ) / :amt_unit2, round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , cashflow_amount , 0 ) ) , 0 ) / :amt_unit2, round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , - 1 * transaction_rate * cashflow_amount , 0 ) ) , 0 ) / :amt_unit2, round ( sum ( decode ( sign ( cashflow_amount ) , - 1 , 0 , - 1 * transaction_rate * cashflow_amount ) ) , 0 ) / :amt_unit2) calc, XTR_XTRFXAVG_XMLP_PKG.Base_net_amt_p Base_net_amt, XTR_XTRFXAVG_XMLP_PKG.contra_net_amt_p contra_net_amt, XTR_XTRFXAVG_XMLP_PKG.avg_rate3_p avg_rate3 FROM xtr_deal_date_amounts_v where deal_type='FX' and status_code='CURRENT' and decode(nvl(:date_base2,'MATURITY DATE'),'MATURITY DATE',amount_date,transaction_date) >= :MATURING_FROM2 and ((decode(nvl(:date_base2,'MATURITY DATE'),'MATURITY DATE',amount_date,transaction_date) <=:MATURING_TO2 and :MATURING_TO2 is not null) or :MATURING_TO2 is null) and limit_code is not null and cashflow_amount !=0 and substr(currency_combination,1,3) like nvl(:currency_a2, substr(currency_combination,1,3)) and substr(currency_combination,5,3) like nvl(:currency_b2,substr(currency_combination,5,3)) and company_code like nvl(:p_company,'%') group by company_code,currency_combination,currency order by company_code,currency_combination,currency XTR XTRFXAVG_XML AR XTR إدارة - تقرير متوسط أسعار الصرف الأجنبي (بتنسيق XML) Application: الخزانة Source: إدارة - تقرير متوسط أسعار الصرف الأجنبي (بتنسيق XML) Short Name: XTRFXAVG_XML DB package: XTR_XTRFXAVG_XMLP_PKG D XTR Durchschnittliche Devisenkurse Application: Treasury Source: Administrator: Durchschnittliche Devisenkurse (XML) Short Name: XTRFXAVG_XML DB package: XTR_XTRFXAVG_XMLP_PKG F XTR Admin - Etat taux de change moyens Application: Treasury Source: Admin - Etat taux de change moyens (XML) Short Name: XTRFXAVG_XML DB package: XTR_XTRFXAVG_XMLP_PKG US XTR Admin - Average FX Rates Application: Treasury Source: Admin - Average FX Rates Report (XML) Short Name: XTRFXAVG_XML DB package: XTR_XTRFXAVG_XMLP_PKG ZHS XTR 管理 - 平均 FX 汇率报表 Application: 理财管理系统 Source: 管理 - 平均 FX 汇率报表 (XML) Short Name: XTRFXAVG_XML DB package: XTR_XTRFXAVG_XMLP_PKG BI Publisher :amt_unit2 :avg_rate3 :base_net_amt :company_name_header :contra_net_amt :cp_para :currency_a2 :currency_b2 :date_base2 :lp_factor_desc :maturing_from2 :maturing_to2 :p_company :p_conc_request_id :p_counter_currency :p_date_type :p_display_debug :p_factor :p_reference_currency :p_reference_date_from :p_reference_date_from_1 :p_reference_date_to :p_reference_date_to_1 :p_show_contracts :p_sql_trace :report_date :report_short_name :show_details :show_details2 :z1and :z1between :z1company :z1contracts :z1counter_ccy :z1note_all_amounts :z1p_factor :z1parameters :z1ref_ccy :z1show_transactions :z2avg_rate :z2avg_rate_cross :z2avg_rate_sell :z2base_buy_amt :z2base_ccy :z2base_net_amt :z2base_sales_amt :z2buy_amt :z2buy_ccy :z2contra_buy_amt :z2contra_net_amt :z2contra_sales_amt :z2cparty :z2currency :z2deal_nos :z2end_of_report :z2page :z2rate :z2sell_amt :z2sell_ccy :z2trans_date :z2value_date 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_reference_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 Basiswährung F Devise de base US Base Currency ZHS 基准货币 3 30 :p_counter_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 Umrechnungswährung F Devise de contrepartie US Contra Currency ZHS 相对币种 4 40 :p_reference_date_from Date select sysdate from dual Y AR تاريخ المرجع من D Von Referenzdatum F Date de référence - Du US Reference Date From ZHS 参考日期自 5 50 :p_reference_date_to Date select sysdate from dual Y AR تاريخ المرجع إلى D Bis Referenzdatum F Date de référence - Au US Reference Date To ZHS 参考日期至 6 60 :p_show_contracts 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 Kontrakte anzeigen F Afficher les contrats US Show Contracts ZHS 显示合同 7 70 :p_date_type LOV Oracle XTR_MATURITY_DEAL Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('MATURITY DATE','DEAL DATE') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'MATURITY DATE' Y AR نوع التاريخ D Datumsart F Type de date US Date Type ZHS 日期类型 8 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 F Facteur US Factor ZHS 贴现