ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F55D3869E053B46B63588994Y select a.COMPANY_CODE company, p.SHORT_NAME company_name, a.DEAL_NO deal_no, a.TRANSACTION_NO trans_no, a.CURRENCY ccy, a.CPARTY_CODE cparty, t.USER_DEAL_TYPE type, s.USER_DEAL_SUBTYPE subtype, a.PRODUCT_TYPE product, a.CREATED_ON created, a.UPDATED_ON updated, substr(a.CREATED_BY,1,18) created_by, substr(a.UPDATED_BY,1,18) updated_by from XTR_DEALS_V a, XTR_PARTIES_V p, XTR_DEAL_TYPES_V t, XTR_DEAL_SUBTYPES_V s where a.STATUS_CODE = 'CANCELLED' and a.DEAL_TYPE != 'ONC' and a.COMPANY_CODE like nvl(upper(:COMP_CODE2),a.COMPANY_CODE) and (a.UPDATED_ON between nvl(:CANCEL_FROM2,a.UPDATED_ON) and nvl(:CANCEL_TO2,a.UPDATED_ON) or a.UPDATED_ON is null) and nvl(a.UPDATED_BY,'%') like nvl(upper(:CANCELLED_BY2),'%') and a.DEAL_TYPE like nvl(upper(:DEAL_TYPE2),a.DEAL_TYPE) and p.PARTY_CODE = a.COMPANY_CODE and a.DEAL_TYPE = t.DEAL_TYPE and a.DEAL_SUBTYPE = s.DEAL_SUBTYPE UNION select a.COMPANY_CODE company, p.SHORT_NAME company_name, a.DEAL_NUMBER deal_no, a.TRANSACTION_NUMBER trans_no, a.CURRENCY ccy, a.CPARTY_CODE cparty, t.USER_DEAL_TYPE type, s.USER_DEAL_SUBTYPE subtype, a.PRODUCT_TYPE product, a.CREATED_ON created, a.UPDATED_ON updated, substr(a.CREATED_BY,1,18) created_by, substr(a.UPDATED_BY,1,18) updated_by from XTR_ROLLOVER_TRANSACTIONS_V a, XTR_PARTIES_V p, XTR_DEAL_TYPES_V t, XTR_DEAL_SUBTYPES_V s where a.STATUS_CODE = 'CANCELLED' and a.DEAL_TYPE = 'ONC' and a.COMPANY_CODE like nvl(upper(:COMP_CODE2),a.COMPANY_CODE) and (a.UPDATED_ON between nvl(:CANCEL_FROM2,a.UPDATED_ON) and nvl(:CANCEL_TO2,a.UPDATED_ON) or a.UPDATED_ON is null) and nvl(a.UPDATED_BY,'%') like nvl(upper(:CANCELLED_BY2),'%') and a.DEAL_TYPE like nvl(upper(:DEAL_TYPE2),a.DEAL_TYPE) and p.PARTY_CODE = a.COMPANY_CODE and a.DEAL_TYPE = t.DEAL_TYPE and a.DEAL_SUBTYPE = s.DEAL_SUBTYPE order by 1,11 XTR XTRAUNCL_XML AR XTR إدارة - تقرير إجمالي الحركات الملغاة (بتنسيق XML) Application: الخزانة Source: إدارة - تقرير إجمالي الحركات الملغاة (بتنسيق XML) Short Name: XTRAUNCL_XML DB package: XTR_XTRAUNCL_XMLP_PKG D XTR Stornierte Transaktionen - Übersicht Application: Treasury Source: Administrator: Stornierte Transaktionen - Übersicht (XML) Short Name: XTRAUNCL_XML DB package: XTR_XTRAUNCL_XMLP_PKG F XTR Admin - Synthèse des mouvements annulés Application: Treasury Source: Admin - Synthèse des mouvements annulés (XML) Short Name: XTRAUNCL_XML DB package: XTR_XTRAUNCL_XMLP_PKG US XTR Admin - Cancelled Transactions Summary Application: Treasury Source: Admin - Cancelled Transactions Summary Report (XML) Short Name: XTRAUNCL_XML DB package: XTR_XTRAUNCL_XMLP_PKG ZHS XTR 管理 - 已取消的事务处理汇总报表 Application: 理财管理系统 Source: 管理 - 已取消的事务处理汇总报表 (XML) Short Name: XTRAUNCL_XML DB package: XTR_XTRAUNCL_XMLP_PKG BI Publisher :cancel_by :cancel_from :cancel_from2 :cancel_to :cancel_to2 :cancelled_by2 :comp_code :comp_code2 :company_name_header :cp_para :deal_type :deal_type2 :p_cancelled_by :p_cancelled_from :p_cancelled_from_t :p_cancelled_to :p_cancelled_to_t :p_company :p_conc_request_id :p_deal_type :p_display_debug :p_sql_trace :p_user_deal_type :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :use_defaults :version_num :z1cancelled_by :z1cancelled_from :z1company :z1deal_type :z1parameters :z1to :z2cancelled_on :z2ccy :z2cparty :z2created_by :z2created_on :z2deal_ref :z2end_of_report :z2page :z2product :z2subtype :z2trans_ref :z2type 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_deal_type LOV Oracle XTR_DEAL_TYPE Y select deal_type id, user_deal_type value, name description from xtr_deal_types_v where authorised='Y' order by user_deal_type AR نوع الصفقة D Geschäftsart F Type d'opération US Deal Type ZHS 交易类型 3 30 :p_cancelled_by LOV Oracle XTR_DEALER Y select dealer_code id, dealer_code value, dealer_user_name description from xtr_dealer_codes_v where 1=1 order by dealer_code AR إلغاء بواسطة D Storniert von F Annulé par US Cancelled By ZHS 取消者 4 40 :p_cancelled_from Date Y AR التاريخ من الملغي D Von Stornodatum F Date d'annulation - Du US Cancelled Date From ZHS 取消起始日期 5 50 :p_cancelled_to Date Y AR التاريخ إلى الملغي D Bis Stornodatum F Date d'annulation - Au US Cancelled Date To ZHS 取消终止日期