ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5753869E053B46B63588994 select a.company_code COMPANY, a.deal_subtype D_SUB, a.product_type PROD, a.amount_date AMT_DATE, a.currency CCY, a.account_no ACCT, a.cparty_code CPARTY, nvl(a.settlement_party, decode(sign(a.cashflow_amount) ,-1,a.cparty_code ,a.company_code)) BENEFICIARY, a.deal_type D_TYPE, a.deal_number DEAL_NO, a.transaction_number TRANS_NO, a.amount_type AMT_TYPE, a.cashflow_amount CFLOW, a.settlement_authorised_by AUTH_BY, decode(nvl(a.chq_reqd,'N') ,'Y','CQ' ,decode(nvl(a.direct_debit,'N') ,'Y','DD' ,decode(nvl(a.trans_mts,'N') ,'Y','FT'))) METHOD, XTR_XTRSESTA_XMLP_PKG.cflow1formula(a.cashflow_amount, a.currency) CFLOW1 from XTR_DEAL_DATE_AMOUNTS_V a where a.COMPANY_CODE like nvl(upper(:P_COMPANY),a.COMPANY_CODE) and a.CASHFLOW_AMOUNT != 0 and a.STATUS_CODE != 'CANCELLED' and a.CURRENCY like nvl(upper(:P_CURRENCY),a.CURRENCY) and nvl(a.MULTIPLE_SETTLEMENTS,'N') != 'Y' and a.ACCOUNT_NO like nvl(upper(:P_BANK_ACCOUNT_NUMBER),a.ACCOUNT_NO) and a.AMOUNT_DATE >= nvl(:FROM_DATE2,a.AMOUNT_DATE) and a.AMOUNT_DATE <= nvl(:TO_DATE2,a.AMOUNT_DATE) and a.SETTLE = decode(:P_AUTH_UNAUTH,'AUTHORIZED','Y','UNAUTHORIZED','N',a.SETTLE) and ((nvl(a.SETTLEMENT_PARTY,a.COMPANY_CODE) like nvl(upper(:P_BENEFICIARY),'%') and a.CASHFLOW_AMOUNT > 0) or (nvl(a.SETTLEMENT_PARTY,CPARTY_CODE) like nvl(upper(:P_BENEFICIARY),'%') and a.CASHFLOW_AMOUNT < 0)) order by COMPANY_CODE,AMOUNT_DATE,CURRENCY Y XTR XTRSESTA_XML AR XTR تسويات - تقرير الموقف (بتنسيق XML) Application: الخزانة Source: تسويات - تقرير الموقف (بتنسيق XML) Short Name: XTRSESTA_XML DB package: XTR_XTRSESTA_XMLP_PKG D XTR Abrechnungen - Status Application: Treasury Source: Abrechnungen - Status (XML) Short Name: XTRSESTA_XML DB package: XTR_XTRSESTA_XMLP_PKG F XTR Liquidations - Etat Statut Application: Treasury Source: Liquidations - Etat Statut (XML) Short Name: XTRSESTA_XML DB package: XTR_XTRSESTA_XMLP_PKG US XTR Settlements - Status Application: Treasury Source: Settlements - Status Report (XML) Short Name: XTRSESTA_XML DB package: XTR_XTRSESTA_XMLP_PKG ZHS XTR 结算 - 状态报表 Application: 理财管理系统 Source: 结算 - 状态报表 (XML) Short Name: XTRSESTA_XML DB package: XTR_XTRSESTA_XMLP_PKG BI Publisher :account_no :account_no2 :auth_unauth :auth_unauth2 :beneficiary :beneficiary2 :company_code :company_code2 :company_name_header :cp_para :currency_code :currency_code2 :from_date :from_date2 :p_auth_unauth :p_bank_account_number :p_beneficiary :p_company :p_conc_request_id :p_currency :p_display_debug :p_settlement_date_from :p_settlement_date_to :p_sql_trace :report_date :report_group :report_nos :report_short_name :report_short_name2 :to_date2 :to_date_1 :use_defaults :version_num :z1account_nos :z1authorised_unauthorised_both :z1beneficiary :z1company_code :z1currency :z1parameters :z1settlements_from :z1to :z2account_number :z2amount :z2amount_date :z2authorised :z2by :z2by_user :z2ccy :z2code :z2company :z2cparty :z2deal :z2end_of_report :z2number :z2page :z2product :z2set :z2settlement :z2subtype :z2trans :z2type :z2user 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_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 币种 3 30 :p_bank_account_number LOV Oracle XTR_BANK_ACCOUNT Y select account_number id, account_number value, null description from xtr_bank_accounts_v where party_code=nvl(:$flex$.xtr_company,party_code) and currency=nvl(:$flex$.xtr_currency,currency) and nvl(authorised,'N')='Y' order by account_number AR رقم حساب البنك D Kontonummer F Numéro de compte bancaire US Bank Account Number ZHS 银行帐号 4 40 :p_settlement_date_from Date AR تاريخ التسوية من D Von Abrechnungsdatum F Date de liquidation - Du US Settlement Date From ZHS 结算日期自 5 50 :p_settlement_date_to Date AR تاريخ التسوية إلى D Bis Abrechnungsdatum F Date de liquidation - Au US Settlement Date To ZHS 结算日期至 6 60 :p_auth_unauth LOV Oracle XTR_AUTH_UNAUTH Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('AUTHORIZED','UNAUTHORIZED','ALL') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'ALL' Y AR معتمد/غير معتمد D Genehmigt/Nicht genehmigt F Autorisé/Non autorisé US Authorised/Unauthorised ZHS 核准/未核准 7 70 :p_beneficiary LOV Oracle XTR_BENEFICIARY Y select party_code id, party_code value, short_name description from xtr_parties_v order by party_code AR المستفيد D Begünstigter F Bénéficiaire US Beneficiary ZHS 受益人 :$flex$.xtr_company Company Bank Account Number :$flex$.xtr_currency Currency Bank Account Number