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_FX_WHAT_IFS

Line 546: from XTR_FX_WHAT_IFS

542: group by d.currency;
543: --
544: cursor SELECTED_CCY is
545: select CURRENCY
546: from XTR_FX_WHAT_IFS
547: where UNIQUE_REF_NUMBER = ref_number
548: and REVIEW = 'Y';
549: --
550: cursor DIST_CCY_COMBIN is

Line 554: from XTR_FX_WHAT_IFS

550: cursor DIST_CCY_COMBIN is
551: select distinct CURRENCY_FIRST||'/'||CURRENCY_SECOND
552: from XTR_BUY_SELL_COMBINATIONS
553: where CURRENCY_FIRST IN(select CURRENCY
554: from XTR_FX_WHAT_IFS
555: where UNIQUE_REF_NUMBER = ref_number)
556: or CURRENCY_SECOND IN(select CURRENCY
557: from XTR_FX_WHAT_IFS
558: where UNIQUE_REF_NUMBER = ref_number);

Line 557: from XTR_FX_WHAT_IFS

553: where CURRENCY_FIRST IN(select CURRENCY
554: from XTR_FX_WHAT_IFS
555: where UNIQUE_REF_NUMBER = ref_number)
556: or CURRENCY_SECOND IN(select CURRENCY
557: from XTR_FX_WHAT_IFS
558: where UNIQUE_REF_NUMBER = ref_number);
559: --
560: cursor GET_FX_PERIOD is
561: select currency,nvl(PERIOD_DESC,nvl(PERIOD_FROM,'0')||decode(nvl(TYPE_PERIOD_FROM_MONTH_YEAR,'M'),nvl(TYPE_PERIOD_TO_MONTH_YEAR,'M'),NULL,decode(nvl(TYPE_PERIOD_FROM_MONTH_YEAR,'M'),'M','Months','Years'))||'-'||