ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5773869E053B46B63588994Y select d.deal_no DEAL_NUM, decode(d.deal_subtype ,'FUND','DEPOSIT','ADVANCE') SUBTYPE, d.currency CCY, d.product_type PRODUCT /*XTR_XTRTMAVG_XMLP_PKG.wavg_rate1formula() WAVG_RATE1, XTR_XTRTMAVG_XMLP_PKG.avg_amount1formula() AVG_AMOUNT1, XTR_XTRTMAVG_XMLP_PKG.WAVG_RATE_p WAVG_RATE, XTR_XTRTMAVG_XMLP_PKG.AVG_AMOUNT_p AVG_AMOUNT*/ from XTR_DEALS_V d where d.deal_type = 'RTMM' and ((d.deal_subtype = 'FUND' and nvl(upper(:DEAL_SUBTYPE2),deal_subtype) IN('DEPOSIT')) or (d.deal_subtype = 'INVEST' and nvl(upper(:DEAL_SUBTYPE2),deal_subtype) IN('ADVANCE'))) and d.product_type like nvl(upper(:PRODUCT_TYPE2),product_type) and d.start_date <= :AS_AT_DATE2 and d.maturity_date > :AS_AT_DATE2 ORDER BY 2 ASC,3 ASC,4 ASC XTR XTRTMAVG_XML AR XTR أموال الفترة - تقرير متوسط أسعار الفترة (بتنسيق XML) Application: الخزانة Source: أموال الفترة - تقرير متوسط أسعار الفترة (بتنسيق XML) Short Name: XTRTMAVG_XML DB package: XTR_XTRTMAVG_XMLP_PKG D XTR Festgeld - Durchschnittsverzinsung Application: Treasury Source: Festgeld - Durchschnittsverzinsung (XML) Short Name: XTRTMAVG_XML DB package: XTR_XTRTMAVG_XMLP_PKG F XTR Financement à terme - Etat Taux moyens à terme Application: Treasury Source: Financement à terme - Etat Taux moyens à terme (XML) Short Name: XTRTMAVG_XML DB package: XTR_XTRTMAVG_XMLP_PKG US XTR Term Money - Term Average Rates Application: Treasury Source: Term Money - Term Average Rates Report (XML) Short Name: XTRTMAVG_XML DB package: XTR_XTRTMAVG_XMLP_PKG ZHS XTR 分期贷款 - 分期平均汇率报表 Application: 理财管理系统 Source: 分期贷款 - 分期平均汇率报表 (XML) Short Name: XTRTMAVG_XML DB package: XTR_XTRTMAVG_XMLP_PKG BI Publisher :as_at_date :as_at_date2 :avg_amount :company_name_header :cp_para :deal_subtype :deal_subtype2 :p_as_of_date :p_as_of_date_1 :p_conc_request_id :p_deposit_advance :p_display_debug :p_product_type :p_show_contracts :p_sql_trace :product_type2 :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :show_detail2 :use_defaults :wavg_rate :z1as_at_date :z1parameters :z1product_type :z1show_details :z1subtype :z2accrued_int :z2average_balance :z2average_rate :z2balance :z2ccy :z2client :z2deal_nos :z2dep_adv :z2end_of_report :z2int_rate :z2name :z2nos_trans :z2p_i_amount :z2page :z2prev_rollover :z2product :z2total_outstandings :z2trans_nos 1 10 :p_product_type LOV Oracle XTR_PRODUCT_TYPE_RTMM Y select product_type id, product_type value, product_desc description from xtr_product_types where product_auth='Y' and deal_type='RTMM' order by product_type AR نوع المنتج D Produktart F Type de produit US Product Type ZHS 产品类型 2 20 :p_deposit_advance LOV Oracle XTR_DEPOSIT_ADVANCE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('DEPOSIT','ADVANCE') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'DEPOSIT' Y AR إيداع/مقدم D Einlage/Kredit F Dépôt/avance US Deposit/Advance ZHS 定金/预付款 3 30 :p_as_of_date Date select sysdate from dual Y AR اعتباراً من تاريخ D Vom F En date du US As of Date ZHS 截止日期 4 40 :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 显示合同