ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F57B3869E053B46B63588994Y select a.deal_no DEAL_NUM, a.cparty_code CPARTY, :AS_AT_DATE2 S_DATE, a.start_date COMMENCE, a.face_value_amount S_AMOUNT, decode(a.deal_subtype ,'INVEST',:z_loan_no,:z_dep_no) REF_NUM, decode(a.deal_subtype ,'INVEST',:z_of_your||' '||rtrim(p.product_desc)||' '||:z_loan_follow ,:z_of_your||' '||rtrim(p.product_desc)||' '||:z_dep_follow) D_SUB, b.short_name NAME, b.title_description TITLE, b.address_1 ADDR_1, b.address_2 ADDR_2, b.address_3 ADDR_3, b.address_4 ADDR_4, b.address_5 ADDR_5, d.short_name COMP_NAME, d.address_1 COMP_ADDR_1, d.address_2 COMP_ADDR_2, d.address_3 COMP_ADDR_3, d.address_4 COMP_ADDR_4, d.address_5 COMP_ADDR_5, &LAS_AT_DATE2 STATE_DATE from XTR_DEALS_V a, XTR_PARTIES_V b, XTR_PARTIES_V d, XTR_PRODUCT_TYPES_V p where a.DEAL_NO like nvl(:DEAL_NO2, a.DEAL_NO) and a.DEAL_TYPE = 'RTMM' and a.CPARTY_CODE like nvl(upper(:CPARTY_CODE2), a.CPARTY_CODE) and ((a.START_DATE >= :AS_AT_DATE3) and (a.START_DATE <= :AS_AT_DATE2)) and a.PRODUCT_TYPE = p.PRODUCT_TYPE (+) and p.DEAL_TYPE = 'RTMM' and ((a.DEAL_SUBTYPE = 'INVEST' and UPPER(:DEAL_SUBTYPE2) = 'ADVANCE') or (a.DEAL_SUBTYPE = 'FUND' and upper(:DEAL_SUBTYPE2) = 'DEPOSIT') or (a.DEAL_SUBTYPE IN('FUND','INVEST') and nvl(:DEAL_SUBTYPE2,'%') = '%')) and b.PARTY_CODE = a.CPARTY_CODE and a.COMPANY_CODE = d.PARTY_CODE XTR XTRTMSTM_XML AR XTR أموال الفترة - كشوف حسابات أموال فترة التجزئة (بتنسيق XML) Application: الخزانة Source: أموال الفترة - كشوف حسابات أموال فترة التجزئة (بتنسيق XML) Short Name: XTRTMSTM_XML DB package: XTR_XTRTMSTM_XMLP_PKG D XTR Festgeld - Auszüge Application: Treasury Source: Festgeld - Auszüge (XML) Short Name: XTRTMSTM_XML DB package: XTR_XTRTMSTM_XMLP_PKG F XTR Financement à terme - Relevés des financements privés à terme Application: Treasury Source: Financement à terme - Relevés des financements privés à terme (XML) Short Name: XTRTMSTM_XML DB package: XTR_XTRTMSTM_XMLP_PKG US XTR Term Money - Retail Term Money Statements Application: Treasury Source: Term Money - Retail Term Money Statements (XML) Short Name: XTRTMSTM_XML DB package: XTR_XTRTMSTM_XMLP_PKG ZHS XTR 分期贷款 - 个人分期贷款对帐单 Application: 理财管理系统 Source: 分期贷款 - 个人分期贷款对帐单 (XML) Short Name: XTRTMSTM_XML DB package: XTR_XTRTMSTM_XMLP_PKG BI Publisher &las_at_date2 :actual_bal :adjust_prin :as_at_date1 :as_at_date2 :as_at_date3 :company_name_header :cp_para :cparty_code2 :deal_no2 :deal_subtype2 :las_at_date2 :lp_from_date :lp_to_date :net_due :p_client :p_conc_request_id :p_deal_number :p_deposit_advance :p_display_debug :p_from_date :p_sql_trace :p_to_date :pi_recd :prin_ded :ref_type :report_date :report_short_name :z2a_fee_is_payable :z2action_type :z2amount_name :z2as_at :z2balance :z2customer_no :z2date :z2initial_amount :z2int_settled :z2interest_repaid_as_at :z2on_replacements :z2please_retain_statement :z2principal :z2principal_deductions_as_at :z2start_date :z2statement_of_accounts :z2total_settled :z2total_to_settle_as_at :z_dep_follow :z_dep_no :z_loan_follow :z_loan_no :z_of_your 1 10 :p_client LOV Oracle XTR_CPARTY Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='CP' order by party_code AR الطرف الآخر D Geschäftspartner F Contrepartie US Counterparty ZHS 订约方 2 20 :p_deal_number LOV Oracle XTR_DEAL_NUMBER_RTMM Y select deal_no id, deal_no value, deal_type description from xtr_deals where deal_type='RTMM' order by deal_no AR رقم الصفقة D Geschäftsnummer F Numéro d'opération US Deal Number ZHS 交易编号 3 30 :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 定金/预付款 4 40 :p_from_date Date Y AR من تاريخ D Von Datum F Date de début US From Date ZHS 自日期 5 50 :p_to_date Date Y AR إلى تاريخ D Bis Datum F Date de fin US To Date ZHS 至日期