ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5793869E053B46B63588994Y select d.deal_no DEAL_NO, decode(d.deal_subtype ,'FUND','Deposit' ,'Advance') DEAL_TYPE, d.product_type PRODUCT, d.currency CCY, d.cparty_code CP_CODE, p.short_name CP_NAME, d.start_date START_DATE, d.maturity_date MATURITY_DATE, d.face_value_amount FACE_VALUE, d.settle_date SETTLE_DATE, d.payment_schedule_code PYMT_SCHEDULE, d.interest_rate INT_RATE, d.next_coupon_date FIXED_UNTIL, d.payment_freq PYMT_FREQ, d.pi_amount_due PI_AMT_DUE, decode(nvl(upper(substr(:ORDER_BY_COLUMN2,1,1)),'C') ,'C',d.cparty_code ,'D',d.start_date ,' ') ORD_COLUMN from XTR_DEALS_V d, XTR_PARTIES_V p where d.deal_type = 'RTMM' and d.cparty_code = p.party_code &LP_start_date_q1 AND :P_NEW_SETTLED IN ('NEW','ALL') order by 16,7 XTR XTRTMNEW_XML AR XTR أموال الفترة - تقرير أموال فترة التجزئة الجديدة/المسواة (بتنسيق XML) Application: الخزانة Source: أموال الفترة - تقرير أموال فترة التجزئة الجديدة/المسواة (بتنسيق XML) Short Name: XTRTMNEW_XML DB package: XTR_XTRTMNEW_XMLP_PKG D XTR Festgeld - neue/abgerechnete Abschlüsse Application: Treasury Source: Festgeld - neue/abgerechnete Abschlüsse (XML) Short Name: XTRTMNEW_XML DB package: XTR_XTRTMNEW_XMLP_PKG F XTR Financement à terme - Etat des financements privés à terme nouveaux/remboursés Application: Treasury Source: Financement à terme - Etat des financements privés à terme nouveaux/remboursés (XML) Short Name: XTRTMNEW_XML DB package: XTR_XTRTMNEW_XMLP_PKG US XTR Term Money - New/Settled Retail Term Money Application: Treasury Source: Term Money - New/Settled Retail Term Money Report (XML) Short Name: XTRTMNEW_XML DB package: XTR_XTRTMNEW_XMLP_PKG ZHS XTR 分期贷款 - 新建/已结的个人分期贷款报表 Application: 理财管理系统 Source: 分期贷款 - 新建/已结的个人分期贷款报表 (XML) Short Name: XTRTMNEW_XML DB package: XTR_XTRTMNEW_XMLP_PKG BI Publisher &lp_start_date_q1 :company_name_header :cp_deals_repaid_from :cp_new_deals_from :cp_new_deals_to :cp_para :lp_settled_date_q2 :lp_start_date_q1 :new_settled_both2 :order_by_column2 :p_conc_request_id :p_deals_repaid_from :p_deals_repaid_to :p_display_debug :p_new_deals_from :p_new_deals_to :p_new_settled :p_sort_by :p_sql_trace :report_date :report_short_name :use_defaults :z1new_deals_from1 :z1new_settled_both :z1order_by :z1parameters :z1settled_deals_from :z1to :z2ccy :z2client :z2deal_no :z2end_of_report :z2face_value :z2interest_rate :z2maturity_date :z2name :z2new_transactions :z2p_i_amount :z2page :z2payment_frequency :z2product :z2product_type :z2settle_date :z2settled_transactions :z2start_date 1 10 :p_new_deals_from Date AR تاريخ الصفقة الجديدة من D Von Geschäftsdatum F Date nouvelle opération - Du US New Deal Date From ZHS 新交易起始日期 2 20 :p_new_deals_to Date AR تاريخ الصفقة الجديدة إلى D Bis Geschäftsdatum F Date nouvelle opération - Au US New Deal Date To ZHS 新交易终止日期 3 30 :p_deals_repaid_from Date AR تاريخ إعادة دفع الصفقات من D Von Rückzahlungsdatum F Date de remboursement opération - Du US Deals Repaid Date From ZHS 偿还交易起始日期 4 40 :p_deals_repaid_to Date AR تاريخ إعادة دفع الصفقات إلى D Bis Rückzahlungsdatum F Date de remboursement opération - Au US Deals Repaid Date To ZHS 偿还交易终止日期 5 50 :p_new_settled LOV Oracle XTR_NEW_SETTLED Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('NEW','SETTLED','ALL') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'ALL' Y AR جديد/تسوية D Neu/Abgerechnet F Nouveau/Liquidé US New/Settled ZHS 新建/已结 6 60 :p_sort_by LOV Oracle XTR_CLIENT_DATE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('CLIENT','DATE') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'DATE' Y AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据