ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472D151A9E05362FB09050512Y select d.currency_code CCY, 'Opening Balance' OPEN_BAL2, decode(nvl(upper(:DAY_WEEK_MONTH2),'WEEK') ,'DAY',d.trx_date ,'WEEK',trunc(d.trx_date,'WW') + 7 ,last_day(d.trx_date)) ADATE, 'B' ORD_COLUMN, round(sum(decode(t.fx_mm_exp_flag ,'FX',d.amount ,0)),0)/:L_amt_unit2 FX_IN, round(sum(decode(t.fx_mm_exp_flag ,'MM',d.amount, 'EM', d.amount ,0)),0)/:L_AMT_UNIT2 MM_IN, round(sum(decode(t.fx_mm_exp_flag ,'EX',d.amount ,0)),0)/:L_AMT_UNIT2 EXP, round(sum(d.amount),0)/:L_AMT_UNIT2 NET_FLOW, ' ' INDIC, count(d.transaction_number) NUM_TRANS, XTR_XTRCFCON_XMLP_PKG.open_bal1formula(d.currency_code) OPEN_BAL1, XTR_XTRCFCON_XMLP_PKG.OPEN_BAL_p OPEN_BAL, XTR_XTRCFCON_XMLP_PKG.rolling_bal1formula() ROLLING_BAL1, XTR_XTRCFCON_XMLP_PKG.ROLLING_BAL_p ROLLING_BAL from XTR_CASHFLOWS_V d, XTR_DEAL_TYPES_V t where d.dda_deal_type = t.deal_type and d.amount != 0 and d.dda_deal_type != 'CA' and nvl(d.multiple_settlements,'N') = 'N' and d.currency_code like nvl(upper(:CURRENCY2),'%') and ((d.dda_deal_type != 'FXO' and nvl(upper(:INCL_CCY_OPT2),'Y') = 'N') or nvl(upper(:INCL_CCY_OPT2),'Y') = 'Y') and (d.dda_DEAL_TYPE not in('EXP','EXT') or (d.dda_DEAL_TYPE in ('EXP','EXT') &P_1 ) ) and ((d.dda_deal_type != 'FXO' and nvl(upper(:INCL_CCY_OPT2),'Y') = 'N') or (d.dda_deal_type = 'FXO' and d.type_of_amount = 'PREMIUM' and nvl(upper(:INCL_CCY_OPT2),'Y') = 'N') or nvl(upper(:INCL_CCY_OPT2),'Y') = 'Y') and d.trx_date between :SETTLE_FROM_DATE2 and :SETTLE_TO_DATE2 group by d.currency_code,decode(nvl(upper(:DAY_WEEK_MONTH2),'WEEK') ,'DAY',d.trx_date ,'WEEK',trunc(d.trx_date,'WW') + 7 ,last_day(d.trx_date)) UNION select r.currency CCY, 'Opening Balance' OPEN_BAL2, decode(nvl(upper(:DAY_WEEK_MONTH2),'WEEK') ,'DAY',trunc(:SETTLE_FROM_DATE2) ,'WEEK',trunc(trunc(:SETTLE_FROM_DATE2),'WW') + 7 ,last_day(trunc(:SETTLE_FROM_DATE2))) ADATE, 'A' ORD_COLUMN, 0 FX_IN, round(sum(decode(r.deal_subtype ,'FUND',(-1) ,1) * r.principal_adjust),0)/:L_AMT_UNIT2 MM_IN, 0 EXP, 0 NET_FLOW, '*' INDIC, count(r.deal_number) NUM_TRANS, XTR_XTRCFCON_XMLP_PKG.open_bal1formula(r.currency) OPEN_BAL1, XTR_XTRCFCON_XMLP_PKG.OPEN_BAL_p OPEN_BAL, XTR_XTRCFCON_XMLP_PKG.rolling_bal1formula() ROLLING_BAL1, XTR_XTRCFCON_XMLP_PKG.ROLLING_BAL_p ROLLING_BAL from XTR_ROLLOVER_TRANSACTIONS_V r where r.deal_type = 'ONC' and r.status_code = 'CURRENT' and r.currency like nvl(upper(:CURRENCY2),'%') and r.start_date < :SETTLE_FROM_DATE2 and nvl(r.principal_adjust,0) != 0 and r.maturity_date is NULL group by r.currency,decode(nvl(upper(:DAY_WEEK_MONTH2),'WEEK') ,'DAY',trunc(:SETTLE_FROM_DATE2) ,'WEEK',trunc(trunc(:SETTLE_FROM_DATE2),'WW') + 7 ,last_day(trunc(:SETTLE_FROM_DATE2))) order by 1,3,4 XTR XTRCFCON_XML AR XTR المراكز - تقرير تدفقات النقدية المجمعة في الخزانة (بتنسيق XML) Imported from BI Publisher Description: المراكز - تقرير تدفقات النقدية المجمعة في الخزانة Application: الخزانة Source: المراكز - تقرير تدفقات النقدية المجمعة في الخزانة (بتنسيق XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG D XTR Treasury Cashflows - konsolidiert Imported from BI Publisher Description: Auswertung "Positionen: Treasury Cashflows - konsolidiert" Application: Treasury Source: Positionen: Treasury Cashflows - konsolidiert (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG E XTR Posiciones - Informe de Flujos de Efectivo Consolidados de Tesorería Imported from BI Publisher Description: Posiciones - Informe de Flujos de Efectivo Consolidados de Tesorería Application: Treasury Source: Posiciones - Informe de Flujos de Efectivo Consolidados de Tesorería (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG F XTR Positions - Etat Mouvements de trésorerie consolidés Imported from BI Publisher Description: Positions - Etat Mouvements de trésorerie consolidés Application: Treasury Source: Positions - Etat Mouvements de trésorerie consolidés (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG I XTR Posizioni - Rapporto Flussi contante consolidati Treasury Imported from BI Publisher Description: Posizioni - rapporto dei flussi contante consolidati di Treasury Application: Treasury Source: Posizioni - Rapporto Flussi contante consolidati Treasury (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG JA XTR ポジション - Treasury連結キャッシュフロー・レポート Imported from BI Publisher Description: ポジション - Treasury連結キャッシュフロー・レポート Application: Treasury Source: ポジション - Treasury連結キャッシュフロー・レポート(XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG KO XTR 포지션 - Treasury 통합 현금 흐름 보고서 Imported from BI Publisher Description: 포지션 - Treasury 통합 현금 흐름 보고서 Application: Treasury Source: 포지션 - Treasury 통합 현금 흐름 보고서(XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG PTB XTR Posições - Relatório de Caixas de Fluxo Consolidado de Tesouraria Imported from BI Publisher Description: Posições - Relatório de Caixas de Fluxo Consolidado de Tesouraria Application: Treasury Source: Posições - Relatório de Caixas de Fluxo Consolidado de Tesouraria (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG RU XTR Позиции - консолидированный отчет о потоках денежных средств Казначейства Imported from BI Publisher Description: Позиции - консолидированный отчет о потоках денежных средств Казначейства Application: Казначейство Source: Позиции - консолидированный отчет о потоках денежных средств Казначейства (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG S XTR Positioner - Finansförvaltning: Konsoliderade kassaflöden - rapport Imported from BI Publisher Description: Positioner - konsoliderade kassaflöden i Treasury - rapport Application: Treasury Source: Positioner - Finansförvaltning: Konsoliderade kassaflöden - rapport (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG TR XTR Pozisyonlar - Hazine Konsolide Nakit Akışları Raporu Imported from BI Publisher Description: Pozisyonlar - Hazine Konsolide Nakit Akışları Raporu Application: Hazine Yönetimi Source: Pozisyonlar - Hazine Konsolide Nakit Akışları Raporu (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG US XTR Positions - Treasury Consolidated Cashflows Imported from BI Publisher Description: Positions - Treasury Consolidated Cashflows Report Application: Treasury Source: Positions - Treasury Consolidated Cashflows Report (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG ZHS XTR 头寸 - 合并 Oracle Treasury 现金流量报表 Imported from BI Publisher Description: 头寸 - 合并 Oracle Treasury 现金流量报表 Application: 理财管理系统 Source: 头寸 - 合并 Oracle Treasury 现金流量报表 (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG BI Publisher &p_1 :amt_unit2 :company_name_header :cp_para :currency2 :currency_code :day_week_month :day_week_month2 :exp_types :exp_types2 :incl_ccy_opt :incl_ccy_opt2 :l_amt_unit2 :lp_factor_desc :lp_period_from :lp_period_to :open_bal :p_1 :p_conc_request_id :p_currency :p_display_debug :p_exposure_type :p_factor :p_include_fx_option_buy_sell :p_period_from :p_period_to :p_sql_trace :p_summarize_by :report_date :report_date2 :report_short_name :report_short_name2 :rolling_bal :settle_from_date :settle_from_date2 :settle_to_date :settle_to_date2 :use_defaults :z1currency :z1exp_types :z1incl_ind_exp :z1include_ccy_option :z1p_factor :z1parameters :z1settle_from :z1summarise_by_day_week_month :z1summarised :z1to :z2ac_balance :z2cashflows :z2ccy :z2current_cash_deposits :z2current_cash_deposits_msg :z2date_or :z2end_of_report :z2ending :z2net_cashflow :z2net_exposure :z2net_fx :z2net_mm :z2net_totals :z2number_of :z2page :z2week_month :zrcurrent_cash_deposit 1 -40 :p_incl_ind_exp LOV Oracle XTR_YN Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='YES_NO' order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'YES_NO' AND lookup_code = 'N' AR تضمين التعرضات ذات الدلالة تضمين التعرضات ذات الدلالة D Mit potenziellen Risikopositionen Mit potenziellen Risikopositionen E Incluir Exposiciones Indicativas Incluir Exposiciones Indicativas F Inclure positions de change indicatives Inclure positions de change indicatives I Includi esposizioni indicative Include le esposizioni indicative JA 予想エクスポージャを含む 予想エクスポージャを含む KO 암시적 익스포주어 포함 암시적 익스포주어 포함 PTB Incluir Exposições Indicativas Incluir Exposições Indicativas RU Включить условные открытые позиции Включить условные открытые позиции S Inkludera indikativa exponeringar Inkludera indikativa exponeringar TR Bildirim Niteliğindeki Açık Pozisyonları Dahil Et Bildirim Niteliğindeki Açık Pozisyonları Dahil Et US Include Indicative Exposures Include Indicative Exposures ZHS 包括预示风险 包括预示风险 2 -30 :p_sql_trace Char N AR تتبع SQL تتبع SQL D SQL-Trace SQL-Trace E Rastreo SQL Rastreo SQL I SQL trace SQL trace JA SQLトレース SQLトレース KO SQL 추적 SQL 추적 PTB Rastreamento SQL Rastreamento SQL RU Трассировка SQL Трассировка SQL S SQL-spårning SQL-spårning TR SQL İzleme SQL İzleme US SQL Trace SQL Trace ZHS SQL 跟踪 SQL 跟踪 3 -20 :p_display_debug Char N AR عرض معالجة الأخطاء عرض معالجة الأخطاء D Debug anzeigen Debug anzeigen E Mostrar Depuración Mostrar Depuración F Afficher diagnostic Afficher diagnostic I Visualizza debug Visualizza debug JA デバッグ表示 デバッグ表示 KO 디버그 표시 디버그 표시 PTB Exibir Depuração Exibir Depuração RU Вывод отладочных сообщений Вывод отладочных сообщений S Visa felsökning Visa felsökning TR Hata Ayıklamayı Görüntüle Hata Ayıklamayı Görüntüle US Display Debug Display Debug ZHS 显示调试 显示调试 4 10 :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 Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 5 20 :p_include_intra_day_trx LOV Oracle XTR_YN Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='YES_NO' order by meaning AR تضمين حركات اليوم تضمين حركات اليوم D Mit Intraday-Transaktionen Mit Intraday-Transaktionen E Incluir Transacciones de Día en Curso Incluir Transacciones de Día en Curso F Inclure les mouvements jour Inclure les mouvements jour I Includi transazioni del giorno Includi transazioni del giorno JA 日中取引を含む 日中取引を含む KO 내부 일별 거래 포함 내부 일별 거래 포함 PTB Incluir Transações Intra-dia Incluir Transações Intra-dia RU Включить транзакции за текущий день Включить транзакции за текущий день S Inkludera dagens transaktioner Inkludera dagens transaktioner TR Gün İçi İşlemleri Dahil Et Gün İçi İşlemleri Dahil Et US Include Intra-Day Transactions Include Intra-Day Transactions ZHS 包括今日事务处理 包括今日事务处理 6 30 :p_include_fx_option_buy_sell LOV Oracle XTR_YN Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='YES_NO' order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR تضمين شراء/بيع خيار الصرف الأجنبي تضمين شراء/بيع خيار الصرف الأجنبي D Mit Devisenoptionen Mit Devisenoptionen E Incluir Compra/Venta de Opciones FX Incluir Compra/Venta de Opciones FX F Inclure option de change Achat/Vente Inclure option de change Achat/Vente I Includi opzione Acquista/vendi divisa estera Include le opzione di acquisto/vendita in divisa estera JA FXオプション買い/売りを含む FXオプション買い/売りを含む KO 외환 옵션 매도/매입 포함 외환 옵션 매도/매입 포함 PTB Incluir Opção de Câmbio de Compra/Venda Incluir Opção de Câmbio de Compra/Venda RU Включить покупки и продажи валютн. опционов Включить покупки и продажи валютных опционов S Inkludera valutaoption Köp/Sälj Inkludera valutaoption Köp/Sälj TR Döviz Opsiyonlu Alış/Satış Dahil Döviz Opsiyonlu Alış/Satış Dahil US Include FX Option Buy/Sell Include FX Option Buy/Sell ZHS 包括 FX 期权的购买/出售 包括 FX 期权的购买/出售 7 40 :p_summarize_by LOV Oracle XTR_SUMMARIZE_BY Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('DAY','WEEK','MONTH') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'DAY' Y AR تلخيص حسب إجمالي بواسطة D Zusammenfassen nach Zusammenfassen nach E Resumir por Resumir por F Synthèse par Synthèse par I Sintetizza per Sintetizza per JA 集計単位 集計単位 KO 요약 기준 요약 기준 PTB Sumariar por Sumariar por RU Сводка по Сводка по S Summera per Summera per TR Özetleme Esası Özet Bazı US Summarize By Summarize By ZHS 汇总依据 汇总依据 8 50 :p_period_from Date AR تاريخ التسوية من تاريخ التسوية من D Von Abrechnungsdatum Von Abrechnungsdatum E De Fecha de Liquidación De Fecha de Liquidación F Date de liquidation - Du Date de liquidation - Du I Data liquidazione - Da Data liquidazione - Da JA 決済日:自 決済日:自 KO 결산 일자: 부터 결산 일자: 부터 PTB Data da Liquidação - De Data da Liquidação - De RU Расчетный день с Расчетный день с S Betalningsdatum från Betalningsdatum från TR Ödeme Başlangıç Tarihi Ödeme Başlangıç Tarihi US Settlement Date From Settlement Date From ZHS 结算日期自 结算日期自 9 60 :p_period_to Date AR تاريخ التسوية إلى تاريخ التسوية إلى D Bis Abrechnungsdatum Bis Abrechnungsdatum E A Fecha de Liquidación A Fecha de Liquidación F Date de liquidation - Au Date de liquidation - Au I Data liquidazione - A Data liquidazione - A JA 決済日:至 決済日:至 KO 결산 일자: 까지 결산 일자: 까지 PTB Data da Liquidação - Até Data da Liquidação - Até RU Расчетный день по Расчетный день по S Betalningsdatum till Betalningsdatum till TR Ödeme Bitiş Tarihi Ödeme Bitiş Tarihi US Settlement Date To Settlement Date To ZHS 结算日期至 结算日期至 10 70 :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 Faktor F Facteur Facteur I Fattore Fattore JA ファクタ ファクタ KO 단위 단위 PTB Fator Fator RU Множитель Множитель S Faktor Faktor TR Faktör Faktör US Factor Factor ZHS 贴现 贴现