MSC_AP_GL_DAILY_RATES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CONVERSION_TYPE FROM_CURRENCY TO_CURRENCY CONVERSION_RATE CONVERSION_DATE CREATION_DATE

Query

SQL_Statement

SELECT GL.CONVERSION_TYPE, GL.FROM_CURRENCY, GL.TO_CURRENCY, GL.CONVERSION_RATE, GL.CONVERSION_DATE,GL.CREATION_DATE FROM GL_DAILY_RATES GL, (SELECT FROM_CURRENCY, TO_CURRENCY,CONVERSION_TYPE, CONVERSION_DATE CONV_DATE, ROW_NUMBER() OVER (PARTITION BY FROM_CURRENCY,TO_CURRENCY,CONVERSION_TYPE ORDER BY CONVERSION_DATE desc) latest FROM GL_DAILY_RATES WHERE CONVERSION_DATE < trunc(SYSDATE)+1 ) MAXGL WHERE GL.CONVERSION_TYPE = MAXGL.CONVERSION_TYPE AND GL.FROM_CURRENCY = MAXGL.FROM_CURRENCY AND GL.CONVERSION_DATE = MAXGL.CONV_DATE AND GL.TO_CURRENCY = MAXGL.TO_CURRENCY AND MAXGL.latest=1