View: OKX_DAILY_RATES_V

Product:	OKX - Contracts Integration
Description:	Daily conversion rates for foreign currency transactions
Implementation/DBA Data:	APPS.OKX_DAILY_RATES_V

View Text

SELECT TO_CHAR(CONVERSION_DATE
, 'MMDDYYYY') ID1
, FROM_CURRENCY || '#' || TO_CURRENCY || '#' || CONVERSION_TYPE ID2
, DR.CONVERSION_TYPE NAME
, DR.FROM_CURRENCY || ' @ ' || DR.CONVERSION_RATE || ' TO '|| DR.TO_CURRENCY || ' ON ' || TO_CHAR(DR.CONVERSION_DATE
, 'DD-MON-YYYY') DESCRIPTION
, 'A' STATUS
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
, DR.CONVERSION_RATE CONVERSION_RATE
, DR.STATUS_CODE STATUS_CODE
FROM GL_DAILY_RATES DR

Columns