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 624: from XTR_DEAL_DATE_AMOUNTS_V a

620: --
621: cursor get_ca is
622: 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,
623: 'FLOAT' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
624: from XTR_DEAL_DATE_AMOUNTS_V a
625: where a.amount_date >=p_from_date
626: and a.company_code like p_company_code and a.currency like p_currency
627: and a.portfolio_code like p_portfolio_code
628: and a.status_code='CURRENT'

Line 665: from XTR_DEAL_DATE_AMOUNTS_V a,

661: 'IROFACEVAL',a.amount,
662: 'BDOFACEVAL',a.amount,
663: 'SWPTNFACEVAL',a.amount,
664: 'FRAFACEVAL',a.amount,0)),0) gross_amount
665: from XTR_DEAL_DATE_AMOUNTS_V a,
666: XTR_DEALS_V b
667: where a.amount_date >= p_from_date
668: and a.currency like p_currency
669: and a.company_code like p_company_code

Line 722: from XTR_DEAL_DATE_AMOUNTS_V a,

718: cursor get_fut is
719: select a.company_code,a.portfolio_code,a.deal_number,a.transaction_number,a.deal_type,
720: 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,
721: 'FIXED' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
722: from XTR_DEAL_DATE_AMOUNTS_V a,
723: XTR_FUTURES b
724: where a.amount_date >=p_from_date
725: and a.company_code like p_company_code
726: and a.currency like p_currency