ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5603869E053B46B63588994 select d.company_code COMPANY, upper(c.full_name) COMPANY_NAME, nvl(d.company_account,'NOT ALLOCATED TO A/C') ACCT_NOS, d.currency_code CCY, decode(nvl(d.company_account,'NOT ALLOCATED TO A/C') ,'NOT ALLOCATED TO A/C',' ' ,'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)/:amt_unit2 FX_IN, round(sum(decode(t.fx_mm_exp_flag ,'MM',d.amount ,0)),0)/:amt_unit2 MM_IN, round(sum(decode(t.fx_mm_exp_flag ,'EX',d.amount ,0)),0)/:amt_unit2 EXP, round(sum(d.amount),0)/:amt_unit2 NET_FLOW, ' ' INDIC, count(d.transaction_number) NUM_TRANS, XTR_XTRCFACC_XMLP_PKG.open_bal1formula(nvl(d.company_account,'NOT ALLOCATED TO A/C'),d.currency_code,d.company_code) OPEN_BAL1, XTR_XTRCFACC_XMLP_PKG.OPEN_BAL_p OPEN_BAL, XTR_XTRCFACC_XMLP_PKG.rolling_bal1formula(:ACCOUNT_BAL) ROLLING_BAL1, XTR_XTRCFACC_XMLP_PKG.ROLLING_BAL_p ROLLING_BAL from XTR_CASHFLOWS_V d, XTR_DEAL_TYPES_V t, XTR_PARTIES_V c where d.dda_deal_type = t.deal_type and d.company_code = c.party_code and d.amount != 0 and d.dda_deal_type != 'CA' and nvl(d.multiple_settlements,'N') = 'N' and d.company_code like nvl(upper(:COMPANY_CODE2),d.company_code) and d.currency_code like nvl(upper(:CURRENCY2),d.currency_code) and d.trx_date between :SETTLE_FROM_DATE2 and :SETTLE_TO_DATE2 and nvl(d.company_account,'%') like nvl(upper(:ACCOUNT_NUM2),'%') and ((d.dda_deal_type != 'FXO' and nvl(upper(:INCL_CCY_OPT2),'Y') = 'N') or nvl(upper(:INCL_CCY_OPT2),'Y') = 'Y') and ( (nvl(upper(:EXP_TYPES2), 'ALL') = 'ALL') or (upper(:EXP_TYPES2) = 'FIRM' and dda_deal_subtype <> 'INDIC') or (upper(:EXP_TYPES2) = 'INDICATIVE' and dda_deal_subtype = 'INDIC')) 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') group by d.company_code,c.full_name,d.currency_code,nvl(d.company_account,'NOT ALLOCATED TO A/C'), 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.company_code COMPANY, upper(c.full_name) COMPANY_NAME, nvl(r.principal_account_no,'NOT ALLOCATED TO A/C') ACCT_NOS, r.currency CCY, decode(nvl(r.principal_account_no,'NOT ALLOCATED TO A/C') ,'NOT ALLOCATED TO A/C',' ' ,'Opening Balance --->') OPEN_BAL2, decode(nvl(upper(:DAY_WEEK_MONTH2),'WEEK') ,'DAY',:SETTLE_FROM_DATE2 ,'WEEK',trunc(:SETTLE_FROM_DATE2,'WW') + 7 ,last_day(:SETTLE_FROM_DATE2)) ADATE, 'A' ORD_COLUMN, 0 FX_IN, round(sum(decode(r.deal_subtype ,'FUND',(-1) ,1) * r.principal_adjust),0)/:amt_unit2 MM_IN, 0 EXP, 0 NET_FLOW, '*' INDIC, count(r.deal_number) NUM_TRANS, XTR_XTRCFACC_XMLP_PKG.open_bal1formula(nvl(r.principal_account_no,'NOT ALLOCATED TO A/C'),r.currency,r.company_code ) OPEN_BAL1, XTR_XTRCFACC_XMLP_PKG.OPEN_BAL_p OPEN_BAL, XTR_XTRCFACC_XMLP_PKG.rolling_bal1formula(:ACCOUNT_BAL) ROLLING_BAL1, XTR_XTRCFACC_XMLP_PKG.ROLLING_BAL_p ROLLING_BAL /*FROM_DATE2 ,'WEEK',trunc(:SETTLE_FROM_DATE2,'WW') + 7 ,last_day(:SETTLE_FROM_DATE2)) ADATE, 'A' ORD_COLUMN, 0 FX_IN, round(sum(decode(r.deal_subtype ,'FUND',(-1) ,1) * r.principal_adjust),0)/:amt_unit2 MM_IN, 0 EXP, 0 NET_FLOW, '*' INDIC, count(r.deal_number) NUM_TRANS*/ from XTR_ROLLOVER_TRANSACTIONS_V r, XTR_PARTIES_V c where r.deal_type = 'ONC' and r.status_code = 'CURRENT' and r.company_code = c.party_code and r.company_code like nvl(upper(:COMPANY_CODE2),r.company_code) and r.currency like nvl(upper(:CURRENCY2),'%') and r.start_date < :SETTLE_FROM_DATE2 and nvl(r.principal_account_no,'%') like nvl(upper(:ACCOUNT_NUM2),'%') and nvl(r.principal_adjust,0) != 0 and r.maturity_date is NULL and r.company_code = c.party_code group by r.company_code,c.full_name,r.currency,nvl(r.principal_account_no,'NOT ALLOCATED TO A/C'), decode(nvl(upper(:DAY_WEEK_MONTH2),'WEEK') ,'DAY',:SETTLE_FROM_DATE2 ,'WEEK',trunc(:SETTLE_FROM_DATE2,'WW') + 7 ,last_day(:SETTLE_FROM_DATE2)) order by 1,3,6,7 Y XTR XTRCFACC_XML AR XTR المراكز- تقرير تدفقات النقدية حسب الحساب في الخزانة (بتنسيق XML) Application: الخزانة Source: المراكز- تقرير تدفقات النقدية حسب الحساب في الخزانة (بتنسيق XML) Short Name: XTRCFACC_XML DB package: XTR_XTRCFACC_XMLP_PKG D XTR Treasury Cashflows nach Konto Application: Treasury Source: Positionen: Treasury Cashflows nach Konto (XML) Short Name: XTRCFACC_XML DB package: XTR_XTRCFACC_XMLP_PKG F XTR Positions - Etat Mouvements de trésorerie par compte Application: Treasury Source: Positions - Etat Mouvements de trésorerie par compte (XML) Short Name: XTRCFACC_XML DB package: XTR_XTRCFACC_XMLP_PKG US XTR Positions - Treasury Cashflows by Account Application: Treasury Source: Positions - Treasury Cashflows by Account Report (XML) Short Name: XTRCFACC_XML DB package: XTR_XTRCFACC_XMLP_PKG ZHS XTR 头寸 - 按帐户列出的 Oracle Treasury 现金流量报表 Application: 理财管理系统 Source: 头寸 - 按帐户列出的 Oracle Treasury 现金流量报表 (XML) Short Name: XTRCFACC_XML DB package: XTR_XTRCFACC_XMLP_PKG BI Publisher &p_1 :account_bal :account_num2 :amt_unit2 :company_code2 :company_name_header :cp_para :currency2 :currency_code :day_week_month2 :exp_types2 :incl_ccy_opt2 :lp_factor_desc :open_bal :p_1 :p_bank_account_number :p_company :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_short_name :rolling_bal :settle_from_date2 :settle_to_date2 :z1account_nos :z1company :z1currency :z1exp_types :z1incl_ind_exp :z1include_currency_option :z1p_factor :z1parameters :z1settle_from :z1summarise :z1summarise_by_day_week_month :z1to :z2ac_balance :z2account_number :z2cashflows :z2ccy :z2cflows :z2current_cash_deposits :z2current_cash_deposits_msg :z2date_or :z2end_of_report :z2ending :z2net_cashflow :z2net_exposure :z2net_fx :z2net_mm :z2net_totals :z2nos_of :z2page :z2week_month 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_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 F Devise US Currency ZHS 币种 3 30 :p_bank_account_number LOV Oracle XTR_BANK_ACCOUNT Y select account_number id, account_number value, null description from xtr_bank_accounts_v where party_code=nvl(:$flex$.xtr_company,party_code) and currency=nvl(:$flex$.xtr_currency,currency) and nvl(authorised,'N')='Y' order by account_number AR رقم حساب البنك D Kontonummer F Numéro de compte bancaire US Bank Account Number ZHS 银行帐号 4 40 :p_exposure_type LOV Oracle XTR_EXPOSURE_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('FIRM','INDICATIVE','ALL','NONE') order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' and lookup_code = 'FIRM' AR نوع التعرض D Risikoart F Type de risque US Exposure Type ZHS 风险类型 5 50 :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 F Inclure les mouvements jour US Include Intra-Day Transactions ZHS 包括今日事务处理 6 60 :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 F Inclure option de change Achat/Vente US Include FX Option Buy/Sell ZHS 包括 FX 期权的购买/出售 7 70 :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 F Synthèse par US Summarize By ZHS 汇总依据 8 80 :p_period_from Date AR تاريخ التسوية من D Von Abrechnungsdatum F Date de liquidation - Du US Settlement Date From ZHS 结算日期自 9 90 :p_period_to Date AR تاريخ التسوية إلى D Bis Abrechnungsdatum F Date de liquidation - Au US Settlement Date To ZHS 结算日期至 10 100 :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 Bank Account Number :$flex$.xtr_currency Currency Bank Account Number