ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5733869E053B46B63588994Y select d.company_code, nvl(hs.hedge_type,'UNASSIGNED') hedge_type, d.deal_no, hr.hedge_attribute_id hedge_no, d.deal_type, udt.user_deal_type user_deal_type, decode(d.deal_type, 'IRS', to_char(d.deal_no), ust.user_deal_subtype) dummy, ust.user_deal_subtype user_deal_subtype, hs.objective_code, hs.strategy_code, ha.hedge_currency, hr.reference_amount/nvl(:p_unit, 1) hedge_amount, XTR_XTROHINS_XMLP_PKG.company_nameformula(d.company_code) company_name, XTR_XTROHINS_XMLP_PKG.hedge_type_dspformula(nvl ( hs.hedge_type , 'UNASSIGNED' )) hedge_type_dsp, XTR_XTROHINS_XMLP_PKG.rpt_ccyformula(d.company_code) rpt_ccy, XTR_XTROHINS_XMLP_PKG.objective_dspformula(hs.objective_code) objective_dsp, XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency) currency_dsp, XTR_XTROHINS_XMLP_PKG.contra_ccy_dspformula(d.deal_no, nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency, d.deal_type) contra_ccy_dsp, XTR_XTROHINS_XMLP_PKG.chedge_amountformula(hr.hedge_attribute_id) chedge_amount, XTR_XTROHINS_XMLP_PKG.deal_amtformula(d.deal_no, XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency), nvl ( hs.hedge_type , 'UNASSIGNED' ), d.deal_type, ha.hedge_currency) deal_amt, XTR_XTROHINS_XMLP_PKG.hdg_contra_amtformula(d.deal_no, XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency), nvl ( hs.hedge_type , 'UNASSIGNED' ),XTR_XTROHINS_XMLP_PKG.chedge_amountformula(hr.hedge_attribute_id), d.deal_type) hdg_contra_amt, XTR_XTROHINS_XMLP_PKG.rccy_amtformula(nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency,XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency), d.company_code,XTR_XTROHINS_XMLP_PKG.hdg_contra_amtformula(d.deal_no, XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, nvl ( hs.hedge_type , 'UNASSIGNED' ), ha.hedge_currency), nvl ( hs.hedge_type , 'UNASSIGNED' ),XTR_XTROHINS_XMLP_PKG.chedge_amountformula(hr.hedge_attribute_id), d.deal_type)) rccy_amt from xtr_deals_v d, xtr_hedge_relationships hr, xtr_hedge_attributes ha, xtr_hedge_strategies hs, xtr_deal_types udt, xtr_deal_subtypes ust,xtr_deal_statuses ds where d.deal_no = hr.primary_code(+) and hr.hedge_attribute_id = ha.hedge_attribute_id(+) and ha.strategy_code = hs.strategy_code(+) and ha.hedge_status <> 'CANCELLED' and d.deal_type = udt.deal_type and d.deal_type = ust.deal_type and d.deal_subtype = ust.deal_subtype and d.deal_type = ds.deal_type and d.status_code = ds.status_code and hr.instrument_item_flag(+) = 'U' and (d.deal_type in ('BDO','FRA','FXO','IRO','IRS','SWPTN') or (d.deal_type = 'FX' and d.deal_subtype = 'FORWARD')) and d.status_code <> 'CANCELLED' and d.company_code = nvl(:p_company, d.company_code) and nvl(hs.hedge_type,'@') = nvl(:p_hedge_type, nvl(hs.hedge_type,'@')) and nvl(hs.objective_code,'@') = nvl(:p_objective, nvl(hs.objective_code,'@')) and nvl(hs.strategy_code, '@') = nvl(:p_strategy, nvl(hs.strategy_code, '@')) and :p_date between ha.start_date and nvl(least(nvl(ha.end_date,ha.discontinue_date), nvl(ha.discontinue_date,ha.end_date)), :p_date+2) and d.deal_date <= nvl(:p_date,d.deal_date) and decode(d.deal_type, 'FX', d.value_date, 'IRS', d.maturity_date, 'FRA', d.start_date, d.expiry_date) >:p_date and (( d.deal_type in ( 'FXO','BDO','IRO','SWPTN','FRA') and nvl(decode(d.status_code,'CURRENT',:p_date+2,d.settle_date),:p_date +2) > :p_date) or d.deal_type not in ( 'FXO','BDO','IRO','SWPTN','FRA')) UNION ALL select d.company_code, 'UNASSIGNED' hedge_type, d.deal_no, to_number(NULL) hedge_no, d.deal_type, udt.user_deal_type user_deal_type, decode(d.deal_type, 'IRS', to_char(d.deal_no), ust.user_deal_subtype) dummy, ust.user_deal_subtype user_deal_subtype, NULL objective_code, NULL strategy_code, NULL hedge_currency, to_number(NULL) hedge_amount , XTR_XTROHINS_XMLP_PKG.company_nameformula(d.company_code) company_name, XTR_XTROHINS_XMLP_PKG.hedge_type_dspformula('UNASSIGNED') hedge_type_dsp, XTR_XTROHINS_XMLP_PKG.rpt_ccyformula(d.company_code) rpt_ccy, XTR_XTROHINS_XMLP_PKG.objective_dspformula(null) objective_dsp, XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, 'UNASSIGNED', NULL) currency_dsp, XTR_XTROHINS_XMLP_PKG.contra_ccy_dspformula(d.deal_no, 'UNASSIGNED', NULL, d.deal_type) contra_ccy_dsp, XTR_XTROHINS_XMLP_PKG.chedge_amountformula(to_number(NULL)) chedge_amount, XTR_XTROHINS_XMLP_PKG.deal_amtformula(d.deal_no,XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, 'UNASSIGNED', NULL), 'UNASSIGNED', d.deal_type,NULL) deal_amt, XTR_XTROHINS_XMLP_PKG.hdg_contra_amtformula(d.deal_no,XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, 'UNASSIGNED', NULL), 'UNASSIGNED',XTR_XTROHINS_XMLP_PKG.chedge_amountformula(to_number(NULL)), d.deal_type) hdg_contra_amt, XTR_XTROHINS_XMLP_PKG.rccy_amtformula('UNASSIGNED', NULL,XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, 'UNASSIGNED', NULL), d.company_code,XTR_XTROHINS_XMLP_PKG.hdg_contra_amtformula(d.deal_no,XTR_XTROHINS_XMLP_PKG.currformula(d.deal_no, d.deal_type, 'UNASSIGNED', NULL), 'UNASSIGNED',XTR_XTROHINS_XMLP_PKG.chedge_amountformula(to_number(NULL)), d.deal_type)) rccy_amt from xtr_deals_v d, xtr_deal_types udt, xtr_deal_subtypes ust,xtr_deal_statuses ds where d.deal_type = udt.deal_type and d.deal_type = ust.deal_type and d.deal_subtype = ust.deal_subtype and d.deal_type = ds.deal_type and d.status_code = ds.status_code and (d.deal_type in ('BDO','FRA','FXO','IRO','IRS','SWPTN') or (d.deal_type = 'FX' and d.deal_subtype = 'FORWARD')) and d.status_code <> 'CANCELLED' and d.company_code = nvl(:p_company, d.company_code) and d.deal_date <= nvl(:p_date,d.deal_date) and decode(d.deal_type, 'FX', d.value_date, 'IRS', d.maturity_date, 'FRA', d.start_date, d.expiry_date) >:p_date and (( d.deal_type in ( 'FXO','BDO','IRO','SWPTN','FRA') and nvl(decode(d.status_code,'CURRENT',:p_date+2,d.settle_date),:p_date+2) > :p_date)or d.deal_type not in ( 'FXO','BDO','IRO','SWPTN','FRA')) order by company_code, hedge_type, objective_code, strategy_code, hedge_no, user_deal_type, dummy, user_deal_subtype, deal_no XTR XTROHINS_XML AR XTR المناصب - تقرير الوثائق المالية لتغطية المركز المستحقة (بتنسيق XML) Application: الخزانة Source: المناصب - تقرير الوثائق المالية لتغطية المركز المستحقة (بتنسيق XML) Short Name: XTROHINS_XML DB package: XTR_XTROHINS_XMLP_PKG D XTR Offene Hedging-Instrumente Application: Treasury Source: Positionen: Offene Hedging-Instrumente (XML) Short Name: XTROHINS_XML DB package: XTR_XTROHINS_XMLP_PKG F XTR Positions - Etat des instruments de couverture en cours Application: Treasury Source: Positions - Etat des instruments de couverture en cours (XML) Short Name: XTROHINS_XML DB package: XTR_XTROHINS_XMLP_PKG US XTR Positions - Outstanding Hedge Instruments Application: Treasury Source: Positions - Outstanding Hedge Instruments Report (XML) Short Name: XTROHINS_XML DB package: XTR_XTROHINS_XMLP_PKG ZHS XTR 头寸 - 未清套期交易票据报表 Application: 理财管理系统 Source: 头寸 - 未清套期交易票据报表 (XML) Short Name: XTROHINS_XML DB package: XTR_XTROHINS_XMLP_PKG BI Publisher :cp_irs_note :cp_no_gl_rate :p_as_of_date :p_as_of_date_1 :p_company :p_conc_request_id :p_date :p_factor :p_hedge_status :p_hedge_type :p_objective :p_report_ccy :p_strategy :p_unit :report_name :rp_company_name :rp_factor :rp_hedge_obj :rp_hedge_type :z1as_of_date :z1ccy :z1company :z1contra :z1current :z1deal :z1deal_amount :z1end_of_report :z1equi :z1factor :z1gt_sysdate :z1hedge :z1hedge_amount :z1hedge_num :z1hedge_obj :z1hedge_strategy :z1hedge_type :z1hitem_total :z1htype_total :z1no_data_found :z1no_hinst_found :z1number :z1objective :z1page :z1parameters :z1report_ccy :z1report_date :z1strategy :z1subtype :z1type :z1unassigned 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_hedge_type LOV Oracle XTR_HEDGE_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_HEDGE_TYPES' order by meaning AR نوع تغطية المركز D Hedgingart F Type de couverture US Hedge Type ZHS 套期交易类型 3 30 :p_objective LOV Oracle XTR_HEDGE_OBJECTIVE_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_HEDGE_OBJECTIVE_TYPES' order by lookup_code AR هدف تغطية المركز D Hedging-Ziel F Objectif de couverture US Hedge Objective ZHS 套期交易目标 4 40 :p_strategy LOV Oracle XTR_HEDGE_STRATEGY_DEP_OBJ Y select strategy_code id, strategy_code value, strategy_name description from xtr_hedge_strategies where objective_code=nvl(:$flex$.xtr_hedge_objective_type:null,objective_code) and company_code=nvl(:$flex$.xtr_company:null,company_code) and (company_code is not null and company_code in (select party_code from xtr_parties_v where party_type='C')) or (company_code is null) order by strategy_code AR استراتيجية تغطية المركز D Hedgingstrategie F Stratégie de couverture US Hedge Strategy 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_report_ccy 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 Auswertungswährung F Devise de reporting US Report Currency ZHS 报表币种 7 70 :p_factor LOV Oracle XTR_NUM_FACTOR Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_NUM_FACTOR' and nvl(enabled_flag,'N')='Y' order by lookup_code select meaning from fnd_lookups where lookup_type = 'XTR_NUM_FACTOR' and lookup_code = '0' Y AR المعامل D Faktor F Facteur US Factor ZHS 贴现