ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F57A3869E053B46B63588994Y select r.deal_number DEAL_NUM2, months_between(:AS_AT_DATE2,r.maturity_date) NUMDAY, decode(r.accum_interest ,0,0 ,decode(sign(nvl(r.accum_interest,0) - nvl(r.accum_interest_bf,0)) ,1,abs(nvl(round(r.accum_interest,2),0) - nvl(round(r.accum_interest_bf,2),0)) ,round(r.accum_interest,2))) INT_OVERDUE, decode(sign((nvl(r.expected_balance_bf,0) - nvl(r.expected_balance_out,0)) - (nvl(r.balance_out_bf,0) - nvl(r.balance_out,0))) ,0,0 ,-1,nvl(r.expected_balance_bf,0) - nvl(r.expected_balance_out,0) ,(nvl(round(r.expected_balance_bf,2),0) - nvl(round(r.expected_balance_out,2),0)) - (nvl(round(r.balance_out_bf,2),0) - nvl(round(r.balance_out,2),0))) BAL_OVERDUE, r.start_date START_DATE, r.maturity_date MAT_DATE, /* XTR_XTRTMODR_XMLP_PKG.int_component1formula() INT_COMPONENT1, XTR_XTRTMODR_XMLP_PKG.bal_component1formula() BAL_COMPONENT1, XTR_XTRTMODR_XMLP_PKG.tot_overdue1formula() TOT_OVERDUE1, XTR_XTRTMODR_XMLP_PKG.curr1formula() CURR1, XTR_XTRTMODR_XMLP_PKG.day30p1formula() DAY30P1, XTR_XTRTMODR_XMLP_PKG.day60p1formula() DAY60P1, XTR_XTRTMODR_XMLP_PKG.day90p1formula() DAY90P1, */ XTR_XTRTMODR_XMLP_PKG.INT_COMPONENT_p INT_COMPONENT, XTR_XTRTMODR_XMLP_PKG.BAL_COMPONENT_p BAL_COMPONENT, XTR_XTRTMODR_XMLP_PKG.TOT_OVERDUE_p TOT_OVERDUE, XTR_XTRTMODR_XMLP_PKG.CURR_p CURR, XTR_XTRTMODR_XMLP_PKG.DAY30P_p DAY30P, XTR_XTRTMODR_XMLP_PKG.DAY60P_p DAY60P, XTR_XTRTMODR_XMLP_PKG.DAY90P_p DAY90P from XTR_ROLLOVER_TRANSACTIONS_V r where (r.accum_interest > 0 or ((r.expected_balance_out - r.balance_out) < 0)) and r.maturity_date <= nvl(:AS_AT_DATE2, r.maturity_date) and r.maturity_date >= (select max(s.maturity_date) from XTR_ROLLOVER_TRANSACTIONS_V s, XTR_DEALS_V d where s.deal_number = r.deal_number and s.maturity_date <= nvl(:AS_AT_DATE2, s.maturity_date) and ((s.accum_interest = 0 and s.expected_balance_out >= s.balance_out) or (s.deal_number = d.deal_no and s.start_date = d.start_date and s.settle_date is NULL))) and r.deal_number=:DEAL_NUM order by r.start_date desc XTR XTRTMODR_XML AR XTR أموال الفترة - تقرير تقادم أموال فترة التجزئة (بتنسيق XML) Application: الخزانة Source: أموال الفترة - تقرير تقادم أموال فترة التجزئة (بتنسيق XML) Short Name: XTRTMODR_XML DB package: XTR_XTRTMODR_XMLP_PKG D XTR Festgeld - überfällige Rückzahlungen Application: Treasury Source: Festgeld - überfällige Rückzahlungen (XML) Short Name: XTRTMODR_XML DB package: XTR_XTRTMODR_XMLP_PKG F XTR Financement à terme - Balance âgée des financements privés à terme Application: Treasury Source: Financement à terme - Balance âgée des financements privés à terme (XML) Short Name: XTRTMODR_XML DB package: XTR_XTRTMODR_XMLP_PKG US XTR Term Money - Retail Term Money Aging Application: Treasury Source: Term Money - Retail Term Money Aging Report (XML) Short Name: XTRTMODR_XML DB package: XTR_XTRTMODR_XMLP_PKG ZHS XTR 分期贷款 - 个人分期贷款帐龄报表 Application: 理财管理系统 Source: 分期贷款 - 个人分期贷款帐龄报表 (XML) Short Name: XTRTMODR_XML DB package: XTR_XTRTMODR_XMLP_PKG BI Publisher :amt_unit2 :as_at_date2 :bal_component :company_name_header :cp_para :cparty_code2 :cparty_name2 :curr :day30p :day60p :day90p :deal_no2 :deal_num :int_component :lp_as_of_date :lp_factor_desc :order_by_clause :order_by_column2 :p_as_of_date :p_conc_request_id :p_cparty :p_cparty_name :p_deal_number :p_display_debug :p_factor :p_product_type :p_sort_by :p_sql_trace :product_type2 :report_date :report_short_name :tot_overdue :z1as_at_date :z1deal_number :z1order_by_column :z1p_factor :z1parameters :z1party_code :z1party_name :z1product :z2client :z2end_of_report :z2interest :z2name :z2ninty_plus_days :z2number :z2overdue :z2overdue_amounts :z2page :z2principal :z2product_totals :z2ref :z2report_totals :z2sixty_days :z2thirty_days :z2total_due :z2under 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_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 订约方 3 30 :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 交易编号 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_sort_by LOV Oracle XTR_CLIENT_AMOUNT_PROD Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('CLIENT','AMOUNT','PRODUCT') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'PRODUCT' Y AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据 6 60 :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 贴现