ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5783869E053B46B63588994Y select d.deal_no DEAL_NO, decode(ds.user_deal_subtype ,'FUND','Deposit' ,'Advance') DEAL_TYPE, d.product_type PRODUCT, c.product_desc PRODUCT_NAME, d.currency CCY, d.cparty_code CP_CODE, p.short_name CP_NAME, r.start_date START_DATE, r.accum_interest - r.interest + (r.interest_rate / 100 * r.balance_out / m.year_basis * (:AS_AT_DATE2 - TRUNC(r.start_date))) ACCUM_INTEREST, r.balance_out BALANCE_OUT, r.maturity_date MATURITY_DATE, r.interest_rate CURR_RATE from XTR_DEALS_V d, XTR_PARTIES_V p, XTR_ROLLOVER_TRANSACTIONS_V r, XTR_MASTER_CURRENCIES_V m, XTR_PRODUCT_TYPES_V c, XTR_DEAL_SUBTYPES ds where d.status_code='CURRENT' and d.cparty_code like nvl(upper(:CPARTY_CODE2),d.cparty_code) and d.company_code like nvl(upper(:COMPANY2),d.company_code) and d.product_type like nvl(upper(:PRODUCT_TYPE2),d.product_type) and ((d.deal_subtype = 'FUND' and upper(:DEAL_SUBTYPE2) = 'DEPOSIT') or (d.deal_subtype = 'INVEST' and upper(:DEAL_SUBTYPE2) = 'ADVANCE') or (d.deal_subtype IN('INVEST','FUND') and nvl(:DEAL_SUBTYPE2,'%') = '%')) and d.cparty_code = p.party_code and c.deal_type = 'RTMM' and d.product_type = c.product_type and r.currency = m.currency and p.short_name like nvl(upper(:CPARTY_NAME2),p.short_name) and nvl(p.account_manager,'%') like nvl(upper(:ACCOUNT_MANAGER2),'%') and d.deal_type = 'RTMM' and d.deal_no = r.deal_number and r.balance_out >= nvl(:BALANCES_FROM2,0) and r.maturity_date = (select max(t.maturity_date) from XTR_ROLLOVER_TRANSACTIONS_V t where t.deal_number = r.deal_number and t.start_date <= :AS_AT_DATE2 and t.settle_date is NULL) and r.start_date !=r.maturity_date and (((nvl(r.accum_interest_bf,0) > 0 or r.expected_balance_out < r.balance_out) and nvl(upper(:OVERDUE_ONLY2),'N') = 'Y') or (nvl(upper(:OVERDUE_ONLY2),'N') = 'N')) and d.deal_type = ds.deal_type and d.deal_subtype = ds.deal_subtype order by 2,3,5 XTR XTRTMBLT_XML AR XTR أموال الفترة - تقرير حسب النوع والمنتج (بتنسيق XML) Application: الخزانة Source: أموال الفترة - تقرير حسب النوع والمنتج (بتنسيق XML) Short Name: XTRTMBLT_XML DB package: XTR_XTRTMBLT_XMLP_PKG D XTR Festgeld nach Art/Produkt Application: Treasury Source: Festgeld nach Art/Produkt (XML) Short Name: XTRTMBLT_XML DB package: XTR_XTRTMBLT_XMLP_PKG F XTR Financement à terme - Etat par type et par produit Application: Treasury Source: Financement à terme - Etat par type et par produit (XML) Short Name: XTRTMBLT_XML DB package: XTR_XTRTMBLT_XMLP_PKG US XTR Term Money - By Type and Product Application: Treasury Source: Term Money - By Type and Product Report (XML) Short Name: XTRTMBLT_XML DB package: XTR_XTRTMBLT_XMLP_PKG ZHS XTR 分期贷款 - 按类型和产品列出的分期贷款报表 Application: 理财管理系统 Source: 分期贷款 - 按类型和产品列出的分期贷款报表 (XML) Short Name: XTRTMBLT_XML DB package: XTR_XTRTMBLT_XMLP_PKG BI Publisher :account_manager2 :as_at_date2 :balances_from2 :company :company2 :company_name_header :cp_para :cparty_code2 :cparty_name2 :deal_subtype2 :lp_as_of_date :overdue_only2 :p_account_manager :p_as_of_date :p_balances_from :p_company :p_conc_request_id :p_cparty :p_cparty_name :p_deposit_advance :p_display_debug :p_overdue_amounts_only :p_product_type :p_sql_trace :product_type2 :report_date :report_short_name :z1acct_mgr :z1as_at :z1balances_from :z1company :z1deal_subtype :z1name :z1overdues_only :z1parameters :z1party_code :z1product :z2accrued :z2ccy :z2code :z2commence :z2cparty :z2end_of_report :z2interest :z2maturity :z2number :z2page :z2principal_balance :z2recent_rollover :z2ref :z2totals 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_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 产品类型 3 30 :p_cparty 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 订约方 4 40 :p_as_of_date Date select sysdate from dual Y AR اعتباراً من تاريخ D Vom F En date du US As of Date ZHS 截止日期 5 50 :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 定金/预付款 6 60 :p_balances_from Number AR الأرصدة من D Salden von F Soldes - De US Balances From ZHS 余额自 7 70 :p_account_manager LOV Oracle XTR_ACCOUNT_MANAGER Y select account_manager id, account_manager value, name description from xtr_account_managers_v order by account_manager AR مدير الحساب D Account-Manager F Gestionnaire de comptes US Account Manager ZHS 客户经理 8 80 :p_overdue_amounts_only 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 Nur überfällige Beträge F Montants échus uniquement US Overdue Amounts Only ZHS 仅限于具有逾期金额的事务处理