eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_EXP_SUMM_P dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 71: XTR_ROLLOVER_TRANSACTIONS_V r

67: --
68: cursor GET_ONC_BALS is
69: select sum((-1) * d.cashflow_amount) CASH_ON_HAND
70: from XTR_DEAL_DATE_AMOUNTS_V d,
71: XTR_ROLLOVER_TRANSACTIONS_V r
72: where d.STATUS_CODE = 'CURRENT'
73: and d.DEAL_TYPE = 'ONC'
74: and d.COMPANY_CODE = l_company
75: and d.CURRENCY like upper(nvl(sel_ccy,'%'))

Line 531: XTR_ROLLOVER_TRANSACTIONS_V r

527: --
528: cursor GET_ONC_BALS is
529: select d.currency,sum((-1) * d.cashflow_amount) CASH_ON_HAND
530: from XTR_DEAL_DATE_AMOUNTS_V d,
531: XTR_ROLLOVER_TRANSACTIONS_V r
532: where d.STATUS_CODE = 'CURRENT'
533: and d.DEAL_TYPE = 'ONC'
534: and d.COMPANY_CODE = l_company
535: and d.CURRENCY like upper(nvl(sel_ccy,'%'))

Line 982: XTR_ROLLOVER_TRANSACTIONS_V b

978: round(sum(nvl(a.amount_indic,1)*nvl(a.amount,0)),0) gross_principal,
979: round(sum(nvl(a.amount_indic,1)*nvl(a.amount,0)*nvl(a.transaction_rate,0)/100),0) weighted_amt,
980: count(distinct decode(a.deal_type,'ONC',a.transaction_number,a.deal_number)) no_of_deals
981: from XTR_MIRROR_DDA_LIMIT_ROW_V a,
982: XTR_ROLLOVER_TRANSACTIONS_V b
983: where a.deal_type in('ONC','CMF','IG')
984: and a.deal_number=b.deal_number
985: and a.transaction_number=b.transaction_number
986: and nvl(b.start_date,l_date) <=l_date

Line 1021: from XTR_rollover_transactions_V

1017: l_rowid varchar2(30);
1018: --
1019: cursor get_tmm_rate is
1020: select INTEREST_RATE
1021: from XTR_rollover_transactions_V
1022: where deal_number=l_deal_no
1023: and deal_type='TMM'
1024: and start_date<=l_date
1025: and maturity_date>l_date