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_MISC_P dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 611: from XTR_DEAL_DATE_AMOUNTS_V a

607: --
608: cursor get_ca is
609: select a.company_code,a.portfolio_code,a.deal_number,a.transaction_number,a.deal_type,a.deal_subtype,a.currency,a.transaction_rate,a.amount_date start_date,a.amount_date maturity_date,p_to_date to_date,p_from_date from_date,
610: 'FLOAT' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
611: from XTR_DEAL_DATE_AMOUNTS_V a
612: where a.amount_date >=p_from_date
613: and a.company_code like p_company_code and a.currency like p_currency
614: and a.portfolio_code like p_portfolio_code
615: and a.status_code='CURRENT'

Line 652: from XTR_DEAL_DATE_AMOUNTS_V a,

648: 'IROFACEVAL',a.amount,
649: 'BDOFACEVAL',a.amount,
650: 'SWPTNFACEVAL',a.amount,
651: 'FRAFACEVAL',a.amount,0)),0) gross_amount
652: from XTR_DEAL_DATE_AMOUNTS_V a,
653: XTR_DEALS_V b
654: where a.amount_date >= p_from_date
655: and a.currency like p_currency
656: and a.company_code like p_company_code

Line 709: from XTR_DEAL_DATE_AMOUNTS_V a,

705: cursor get_fut is
706: select a.company_code,a.portfolio_code,a.deal_number,a.transaction_number,a.deal_type,
707: a.deal_subtype,a.currency,a.transaction_rate,a.amount_date start_date,a.amount_date maturity_date,p_to_date to_date,p_from_date from_date,
708: 'FIXED' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
709: from XTR_DEAL_DATE_AMOUNTS_V a,
710: XTR_FUTURES b
711: where a.amount_date >=p_from_date
712: and a.company_code like p_company_code
713: and a.currency like p_currency