ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5623869E053B46B63588994Y select hs.objective_code,hs.strategy_code strategy_code,hs.strategy_name, hs.description, hs.risk_type,hs.policy_reference,hs.derivative_disclosure,hs.hedge_type, ha.hedge_attribute_id hedge_no,ha.start_date,ha.end_date, ha.hedge_currency,ha.company_code, ha.hedge_status, hs.hedge_approach, ha.hedge_amount, XTR_XTRDDHTY_XMLP_PKG.company_nameformula(ha.company_code) COMPANY_NAME, XTR_XTRDDHTY_XMLP_PKG.hedge_type_dspformula(hs.hedge_type) HEDGE_TYPE_DSP, XTR_XTRDDHTY_XMLP_PKG.rpt_ccyformula(ha.company_code) rpt_ccy, XTR_XTRDDHTY_XMLP_PKG.objective_nameformula(hs.objective_code) objective_name, XTR_XTRDDHTY_XMLP_PKG.objective_descformula(hs.objective_code) objective_desc, XTR_XTRDDHTY_XMLP_PKG.risk_type_dspformula(hs.risk_type) risk_type_dsp, XTR_XTRDDHTY_XMLP_PKG.hitem_amtformula(ha.hedge_attribute_id, hs.hedge_approach, ha.hedge_amount) HITEM_AMT, XTR_XTRDDHTY_XMLP_PKG.chinst_amtformula(ha.hedge_attribute_id) CHINST_AMT, XTR_XTRDDHTY_XMLP_PKG.hinst_amtformula(XTR_XTRDDHTY_XMLP_PKG.chinst_amtformula(ha.hedge_attribute_id)) HINST_AMT, XTR_XTRDDHTY_XMLP_PKG.hitem_rccyformula(ha.company_code, ha.hedge_currency,XTR_XTRDDHTY_XMLP_PKG.hinst_amtformula(XTR_XTRDDHTY_XMLP_PKG.chinst_amtformula(ha.hedge_attribute_id))) HITEM_RCCY, XTR_XTRDDHTY_XMLP_PKG.hinst_rccyformula(ha.company_code, ha.hedge_currency,XTR_XTRDDHTY_XMLP_PKG.hinst_amtformula(XTR_XTRDDHTY_XMLP_PKG.chinst_amtformula(ha.hedge_attribute_id))) HINST_RCCY, XTR_XTRDDHTY_XMLP_PKG.starformula(ha.hedge_status) STR from xtr_hedge_attributes ha, xtr_hedge_strategies hs where hs.strategy_code = ha.strategy_code and ha.company_code = nvl(:p_company, ha.company_code) and hs.risk_type = nvl(:p_risk_type,hs.risk_type) and hs.hedge_type = nvl(:p_hedge_type, hs.hedge_type) and hs.objective_code = nvl(:p_objective, hs.objective_code) and hs.strategy_code = nvl(:p_strategy, hs.strategy_code) and ha.hedge_status = decode(:p_hedge_status,'CURRENT', 'CURRENT',ha.hedge_status) and ha.hedge_status <> 'CANCELLED' 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 ha.company_code in (select party_code from xtr_parties_v where party_type = 'C') order by company_code, hedge_type, objective_code, strategy_code, hedge_attribute_id XTR XTRDDHTY_XML AR XTR المراكز - تقرير إيضاح المشتقات حسب نوع تغطية المركز (بتنسيق XML) Application: الخزانة Source: المراكز - تقرير إيضاح المشتقات حسب نوع تغطية المركز (بتنسيق XML) Short Name: XTRDDHTY_XML DB package: XTR_XTRDDHTY_XMLP_PKG D XTR Derivate nach Hedgingart offenlegen Application: Treasury Source: Positionen: Derivate nach Hedgingart offenlegen (XML) Short Name: XTRDDHTY_XML DB package: XTR_XTRDDHTY_XMLP_PKG F XTR Positions - Etat Publication d'instruments dérivés par type de couverture Application: Treasury Source: Positions - Etat Publication d'instruments dérivés par type de couverture (XML) Short Name: XTRDDHTY_XML DB package: XTR_XTRDDHTY_XMLP_PKG US XTR Positions - Derivatives Disclosure by Hedge Type Application: Treasury Source: Positions - Derivatives Disclosure by Hedge Type Report (XML) Short Name: XTRDDHTY_XML DB package: XTR_XTRDDHTY_XMLP_PKG ZHS XTR 头寸 - 按套期交易类型列出的衍生披露报表 Application: 理财管理系统 Source: 头寸 - 按套期交易类型列出的衍生披露报表 (XML) Short Name: XTRDDHTY_XML DB package: XTR_XTRDDHTY_XMLP_PKG BI Publisher :cp_no_gl_rate :cp_not_current :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_risk_type :p_strategy :p_unit :report_name :rp_company_name :rp_factor :rp_hedge_status :rp_hedge_type :rp_objective :rp_risk_type :rp_strategy_name :z1amount :z1as_of_date :z1ccy :z1company :z1cur_hedge :z1der_discl :z1end_date :z1equi :z1factor :z1gt_sysdate :z1hedge :z1hedge_inst :z1hedge_item :z1hedge_type :z1hstgy_total :z1htype_total :z1inst_amount :z1item_amount :z1number :z1objective :z1objective_desc :z1parameters :z1policy_ref :z1report_ccy :z1risk_type :z1start_date :z1strategy :z1strategy_name :z2end_of_report :z2hedge_status :z2no_data_found :z2page :z2report_date :z2strategy 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_risk_type LOV Oracle XTR_HEDGE_RISK_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_HEDGE_RISK_TYPES' order by lookup_code AR نوع المخاطرة D Risikoart F Type de risque US Risk Type ZHS 风险类型 3 30 :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 套期交易类型 4 40 :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 套期交易目标 5 50 :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 套期交易策略 6 60 :p_hedge_status LOV Oracle XTR_CA_HEDGE_STATUS Y select lookup_code id, meaning value, description description from fnd_lookups where (lookup_type='XTR_HEDGE_STATUS' and lookup_code='CURRENT') or (lookup_type='XTR_HEDGE_MISC' and lookup_code='ALLXCANC') order by lookup_code select meaning from fnd_lookups where lookup_type = 'XTR_HEDGE_MISC' and lookup_code = 'ALLXCANC' Y AR موقف تغطية المركز D Hedgingstatus F Statut de couverture US Hedge Status ZHS 套期交易状态 7 70 :p_as_of_date Date select sysdate from dual Y AR اعتباراً من تاريخ D Vom F En date du US As of Date ZHS 截止日期 8 80 :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 报表币种 9 90 :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 贴现