ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5633869E053B46B63588994 select a.deal_no D_NO, a.company_code COMPANY, a.currency CCY, a.start_date S_DATE, a.maturity_date M_DATE, a.product_type PROD, a.deal_subtype D_SUB, a.cparty_code C_PARTY, a.portfolio_code PORT, p.name PORT_NAME, a.acceptor_code ACCEPTOR, a.interest_rate RATE, a.status_code STATUS, b.available_for_resale AVAILABLE, b.face_value_amount/:amt_unit2 FV_AMT, b.parcel_remaining/:amt_unit2 PARCEL_REMAIN, b.reserve_parcel/:amt_unit2 RESERVE_PARCEL, c.short_name COMPANY_NAME from XTR_DEALS_V a, XTR_PARCEL_SPLITS_V b, XTR_PARTIES_V c, XTR_PORTFOLIOS_V p where a.DEAL_TYPE = 'NI' and ( (a.DEAL_SUBTYPE = 'ISSUE' and nvl(upper(:ISS_PURCH2),'ALL') = 'ISSUED') or (a.DEAL_SUBTYPE = 'BUY' and nvl(upper(:ISS_PURCH2),'ALL') = 'PURCHASED') or (nvl(upper(:ISS_PURCH2),'ALL') = 'ALL') ) and a.STATUS_CODE NOT IN('CLOSED','CANCELLED') and nvl(a.COMPANY_CODE,'%') like nvl(upper(:COMPANY_CODE2),'%') and nvl(a.CPARTY_CODE,'%') like nvl(upper(:CPARTY_CODE2),'%') and (((:FROM_DATE2 is null) and (:TO_DATE2 is null)) or ((:FROM_DATE2 is null) and (a.MATURITY_DATE <= :TO_DATE2)) or ((:TO_DATE2 is null) and (a.MATURITY_DATE >= :FROM_DATE2)) or (a.MATURITY_DATE between :FROM_DATE2 and :TO_DATE2)) and nvl(a.PORTFOLIO_CODE,'%') like nvl(upper(:PORTFOLIO2),'%') and nvl(a.PRODUCT_TYPE,'%') like nvl(upper(:PRODUCT_TYPE2),'%') and nvl(a.ACCEPTOR_CODE,'%') like nvl(upper(:ACCEPTOR2),'%') and b.DEAL_NO = a.DEAL_NO and c.PARTY_CODE = a.COMPANY_CODE and p.PORTFOLIO (+) = a.PORTFOLIO_CODE and p.COMPANY_CODE (+) = a.COMPANY_CODE order by a.COMPANY_CODE,a.DEAL_SUBTYPE,a.PORTFOLIO_CODE,a.CURRENCY Y XTR XTRDISRE_XML AR XTR المراكز - سجل الأوراق المالية التي عليها خصم (بتنسيق XML) Application: الخزانة Source: المراكز - سجل الأوراق المالية التي عليها خصم (بتنسيق XML) Short Name: XTRDISRE_XML DB package: XTR_XTRDISRE_XMLP_PKG D XTR Abzinsungspapiere Application: Treasury Source: Positionen: Abzinsungspapiere (XML) Short Name: XTRDISRE_XML DB package: XTR_XTRDISRE_XMLP_PKG F XTR Positions - Registre des valeurs mobilières décotées Application: Treasury Source: Positions - Registre des valeurs mobilières décotées (XML) Short Name: XTRDISRE_XML DB package: XTR_XTRDISRE_XMLP_PKG US XTR Positions - Discounted Securities Register Application: Treasury Source: Positions - Discounted Securities Register (XML) Short Name: XTRDISRE_XML DB package: XTR_XTRDISRE_XMLP_PKG ZHS XTR 头寸 - 折扣证券登记 Application: 理财管理系统 Source: 头寸 - 折扣证券登记 (XML) Short Name: XTRDISRE_XML DB package: XTR_XTRDISRE_XMLP_PKG BI Publisher :acceptor :acceptor2 :amt_unit2 :company_code :company_code2 :company_name_header :cp_para :cparty_code :cparty_code2 :from_date :from_date2 :iss_purch :iss_purch2 :lp_factor_desc :p_acceptor_code :p_company :p_conc_request_id :p_cparty :p_date_from :p_date_from_t :p_date_to :p_date_to_t :p_display_debug :p_factor :p_factor_dsp :p_issued_dsp :p_issued_purchased_both :p_portfolio :p_product_type :p_sql_trace :portfolio :portfolio2 :product_type :product_type2 :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :to_date1 :to_date2 :use_defaults :z1acceptor :z1and :z1company_code :z1cparty_code :z1issued_buy_all :z1maturities_between :z1p_factor :z1parameters :z1portfolio :z1product_type :z1report_nos :z2acceptor_code :z2avail :z2ccy :z2commence_date :z2company :z2deal_number :z2end_of_report :z2face_value_amount :z2interest_rate :z2maturity_date :z2page :z2parcel_remain :z2report :z2requested_by :z2reserved_yn :z2status :z2subtype 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_product_type LOV Oracle XTR_PRODUCT_TYPE_NO_DEAL Y select product_type id, product_type value, product_desc description from xtr_product_types_v where product_auth='Y' and deal_type='NI' order by product_type AR نوع المنتج D Produktart F Type de produit US Product Type ZHS 产品类型 3 30 :p_portfolio LOV Oracle XTR_PORTFOLIO Y select portfolio id, portfolio value, name description from xtr_portfolios_v where company_code=nvl(:$flex$.xtr_company,company_code) order by company_code AR سندات تجارية F Portefeuille US Portfolio ZHS 资产组合 4 40 :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 订约方 5 50 :p_date_from Date AR من تاريخ D Von Datum F Date de début US Date From ZHS 起始日期 6 60 :p_date_to Date AR إلى تاريخ D Bis Datum F Date de fin US Date To ZHS 日期至 7 70 :p_acceptor_code LOV Oracle XTR_ACCEPTOR Y select party_code id, party_code value, short_name description from xtr_parties_v order by party_code AR رمز الموقع بالقبول D Akzeptant F Code accepteur US Acceptor Code ZHS 承兑人代码 8 80 :p_issued_purchased_both LOV Oracle XTR_ISSUED_PURCHASED Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('ISSUED','PURCHASED','ALL') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'ALL' Y AR مُصدر/مشترَى D Emittiert/Erworben F Emis/Acheté US Issued/Purchased ZHS 已发行/已购买 9 90 :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 贴现 :$flex$.xtr_company Company Portfolio