ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5763869E053B46B63588994Y select r.deal_number DEAL_NUM2, ' ' NILL_FIELD, 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_OVERDUE2, 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_OVERDUE2, r.start_date START_DATE, r.maturity_date MAT_DATE, r.pi_amount_due PI_AMOUNT_DUE, /* XTR_XTRTMAOD_XMLP_PKG.int_component1formula(:INT_OD_RUNNING, 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) INT_COMPONENT1, XTR_XTRTMAOD_XMLP_PKG.bal_component1formula(:BAL_RUNNING, 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) BAL_COMPONENT1, */ XTR_XTRTMAOD_XMLP_PKG.tot_overdue1formula() TOT_OVERDUE1, /* XTR_XTRTMAOD_XMLP_PKG.prin_amt_dueformula(r.pi_amount_due) INT_AMT_DUE,*/ /* XTR_XTRTMAOD_XMLP_PKG.INT_COMPONENT_p INT_COMPONENT, XTR_XTRTMAOD_XMLP_PKG.BAL_COMPONENT_p BAL_COMPONENT,*/ XTR_XTRTMAOD_XMLP_PKG.TOT_OVERDUE_p TOT_OVERDUE from XTR_ROLLOVER_TRANSACTIONS_V r where nvl(upper(:SHOW_DETAILS2),'N') = 'Y' and (r.accum_interest > 0 or ((r.expected_balance_out - r.balance_out) < 0)) and r.maturity_date <= :AS_AT_DATE2 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 <= :AS_AT_DATE2 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 r.deal_number=:DEAL_NUM order by r.start_date desc XTR XTRTMAOD_XML AR XTR أموال الفترة - تقرير تجاوزات استحقاق أموال فترة التجزئة (بتنسيق XML) Application: الخزانة Source: أموال الفترة - تقرير تجاوزات استحقاق أموال فترة التجزئة (بتنسيق XML) Short Name: XTRTMAOD_XML DB package: XTR_XTRTMAOD_XMLP_PKG D XTR Festgeld - überfällige Verlängerungstransaktionen Application: Treasury Source: Festgeld - überfällige Verlängerungstransaktionen (XML) Short Name: XTRTMAOD_XML DB package: XTR_XTRTMAOD_XMLP_PKG F XTR Financement à terme - Etat Mouvements échus financement à terme privé Application: Treasury Source: Financement à terme - Etat Mouvements échus financement à terme privé (XML) Short Name: XTRTMAOD_XML DB package: XTR_XTRTMAOD_XMLP_PKG US XTR Term Money - Retail Term Money Overdues Application: Treasury Source: Term Money - Retail Term Money Overdues Report (XML) Short Name: XTRTMAOD_XML DB package: XTR_XTRTMAOD_XMLP_PKG ZHS XTR 分期贷款 - 逾期个人分期贷款报表 Application: 理财管理系统 Source: 分期贷款 - 逾期个人分期贷款报表 (XML) Short Name: XTRTMAOD_XML DB package: XTR_XTRTMAOD_XMLP_PKG BI Publisher :as_at_date2 :bal_component :company_name_header :cp_para :cparty_code2 :cparty_name2 :deal_no2 :deal_num :int_component :order_by_column2 :p_as_of_date :p_as_of_date_1 :p_conc_request_id :p_cparty :p_deal_number :p_display_debug :p_include_prev_act :p_product_type :p_show_details_dsp :p_sort_by :p_sort_by_dsp :p_sql_trace :product_type2 :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :show_details :show_details2 :tot_overdue :use_defaults :z1as_at_date :z1deal_number :z1order_by_column :z1parameters :z1party_code :z1party_name :z1product :z1show_details :z2amount :z2balance :z2client :z2client_name :z2code :z2current :z2deal :z2due_date :z2end_of_report :z2interest :z2most_recent :z2number :z2overdue_amounts :z2overdue_amounts_by_periods :z2page :z2principal :z2product :z2received :z2rollover :z2total :z2total_due :z2type 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_include_prev_act 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 Mit bereits aufgelisteten Vorgängen F Inclure actions précédentes US Include Previously Actioned ZHS 包括以前进行的交易 5 50 :p_as_of_date Date select sysdate from dual Y AR اعتباراً من تاريخ D Vom F En date du US As of Date ZHS 截止日期 6 60 :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 排序依据