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.

[Home] [Help]

VIEW: APPS.HRI_OBI_CS_CURR_CONV_V

Source

View Text - Preformatted


SELECT day.REPORT_DATE CURR_CONV_TIME_DAY_FK, conv.CONVERSION_RATE CURR_CONV_CONVERSION_RATE, conv.FROM_CURRENCY CURR_CONV_FROM_CURRENCY_FK, conv.TO_CURRENCY CURR_CONV_TO_CURRENCY_FK, conv.CONVERSION_TYPE CURR_CONV_RATE_TYPE, conv.currency_type CURRENCY_TYPE FROM FII_CURR_CONV_RATES conv, FII_TIME_DAY day, FII_TIME_MONTH month WHERE ( conv.period_id = month.month_id and to_char(day.report_date,'YYYYQMM') = month.month_id ) WITH READ ONLY

View Text - HTML Formatted

SELECT DAY.REPORT_DATE CURR_CONV_TIME_DAY_FK
, CONV.CONVERSION_RATE CURR_CONV_CONVERSION_RATE
, CONV.FROM_CURRENCY CURR_CONV_FROM_CURRENCY_FK
, CONV.TO_CURRENCY CURR_CONV_TO_CURRENCY_FK
, CONV.CONVERSION_TYPE CURR_CONV_RATE_TYPE
, CONV.CURRENCY_TYPE CURRENCY_TYPE
FROM FII_CURR_CONV_RATES CONV
, FII_TIME_DAY DAY
, FII_TIME_MONTH MONTH
WHERE ( CONV.PERIOD_ID = MONTH.MONTH_ID
AND TO_CHAR(DAY.REPORT_DATE
, 'YYYYQMM') = MONTH.MONTH_ID ) WITH READ ONLY