ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F56D3869E053B46B63588994Y select a.actual_settlement_date AMTDATE ,a.currency CCY1 ,a.settle_amount AMOUNT1 ,'To' TOC ,b.bank_name BKNAME1 ,b.bank_short_code BK_S_CODE ,b.location LOCATION1 ,'For A/C' FORC ,a.cparty_account_no ACCOUNT1 ,c.short_name CPARTY_N1 ,p.contact_name DEALT_CONTACT ,p.short_name DEALT_CPARTY ,p.address_1 DEALT_ADDR1 ,p.address_2 DEALT_ADDR2 ,p.address_3 DEALT_ADDR3 ,p.address_4 DEALT_ADDR4 ,p.address_5 DEALT_ADDR5 ,p.address_6 DEALT_ADDR6 ,decode(a.direct_debit ,'Y','By way of Direct Debit to our account:'||a.account_no , rtrim(b.sub_account_at)||' '|| 'A/c '||rtrim(b.bank_name)||' '||rtrim(b.street)||' '||rtrim(b.location)||decode(nvl(b.sub_account_number, '@x@'),'@x@',null,' A/c Number ')||' '||rtrim(b.sub_account_number)||' '|| 'Favour '||rtrim(c.short_name)||' A/c Number '||rtrim(a.cparty_account_no)) ACCT_DET ,to_char(a.netoff_number) NETOFF_NO ,a.chq_reqd CHQ ,a.direct_debit DD ,a.trans_mts EFT from xtr_settlement_letters_v a, xtr_bank_accounts_v b, xtr_party_info c, xtr_party_info p where a.company_code like nvl(:COMPANY_CODE2,'%') and a.cparty_code like nvl(:CPARTY_CODE2,'%') and a.currency like nvl(:CCY_CODE2,'%') and a.actual_settlement_date >= nvl(:PERIOD_FROM_DATE2, a.actual_settlement_date ) and c.party_code = a.settle_party and p.party_code = a.cparty_code and b.party_code = a.settle_party and b.account_number = a.cparty_account_no and b.currency = a.currency order by 13,DEALT_ADDR5,DEALT_ADDR3,DEALT_ADDR4,DEALT_CPARTY,DEALT_ADDR2,DEALT_CONTACT,DEALT_ADDR6 XTR XTRLTDAP_XML AR XTR تسويات - خطابات المدفوعات / المقبوضات اليومية (بتنسيق XML) Application: الخزانة Source: تسويات - خطابات المدفوعات / المقبوضات اليومية (بتنسيق XML) Short Name: XTRLTDAP_XML DB package: XTR_XTRLTDAP_XMLP_PKG D XTR Abrechnungen - Zahlungsavis Application: Treasury Source: Abrechnungen - Zahlungsavis (XML) Short Name: XTRLTDAP_XML DB package: XTR_XTRLTDAP_XMLP_PKG F XTR Liquidations - Lettres paiements/règlements quotidiens Application: Treasury Source: Liquidations - Lettres paiements/règlements quotidiens (XML) Short Name: XTRLTDAP_XML DB package: XTR_XTRLTDAP_XMLP_PKG US XTR Settlements - Daily Payments / Receipts Letters Application: Treasury Source: Settlements - Daily Payments / Receipts Letters (XML) Short Name: XTRLTDAP_XML DB package: XTR_XTRLTDAP_XMLP_PKG ZHS XTR 结算 - 每日付款/收款信函 Application: 理财管理系统 Source: 结算 - 每日付款/收款信函 (XML) Short Name: XTRLTDAP_XML DB package: XTR_XTRLTDAP_XMLP_PKG BI Publisher :account_number :ccy_code2 :comp_code :company_code2 :company_name_header :cp_para :cparty_code :cparty_code2 :currency_code :p_company :p_conc_request_id :p_cparty :p_currency :p_display_debug :p_period_from :p_sql_trace :period_from_date :period_from_date2 :period_to_date :prev_actioned :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :use_defaults :version_num :z1ccy_code :z1company_code :z1cparty_code :z1parameters :z1period_from_date :z2account_details_method :z2amount :z2ccy :z2page :z2settlement_date :z2we_confirm 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_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_currency LOV Oracle XTR_CURRENCY Y select currency id, currency value, name description from xtr_master_currencies_v where authorised='Y' order by currency AR العملة D Währung F Devise US Currency ZHS 币种 4 40 :p_period_from Date AR فترة من D Von Periode F Période - De US Period From ZHS 期间自