Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_GL_DAILY_RATES_UV |
SELECT PRI.FROM_CURRENCY FROM_CURRENCY
, PRI.TO_CURRENCY TO_CURRENCY
, PRI.CONVERSION_DATE CONVERSION_DATE
, CT.USER_CONVERSION_TYPE USER_CONVERSION_TYPE
, ROUND(PRI.CONVERSION_RATE
, 10) SHOW_CONVERSION_RATE
, ROUND(SEC.CONVERSION_RATE
, 10) SHOW_INVERSE_CON_RATE
, PRI.CONVERSION_RATE CONVERSION_RATE
, SEC.CONVERSION_RATE INVERSE_CONVERSION_RATE
, PRI.ROWID ROW_ID
, SEC.ROWID INVERSE_ROW_ID
, PRI.STATUS_CODE STATUS_CODE
, PRI.CONVERSION_TYPE CONVERSION_TYPE
, PRI.ATTRIBUTE1 ATTRIBUTE1
, PRI.ATTRIBUTE2 ATTRIBUTE2
, PRI.ATTRIBUTE3 ATTRIBUTE3
, PRI.ATTRIBUTE4 ATTRIBUTE4
, PRI.ATTRIBUTE5 ATTRIBUTE5
, PRI.ATTRIBUTE6 ATTRIBUTE6
, PRI.ATTRIBUTE7 ATTRIBUTE7
, PRI.ATTRIBUTE8 ATTRIBUTE8
, PRI.ATTRIBUTE9 ATTRIBUTE9
, PRI.ATTRIBUTE10 ATTRIBUTE10
, PRI.ATTRIBUTE11 ATTRIBUTE11
, PRI.ATTRIBUTE12 ATTRIBUTE12
, PRI.ATTRIBUTE13 ATTRIBUTE13
, PRI.ATTRIBUTE14 ATTRIBUTE14
, PRI.ATTRIBUTE15 ATTRIBUTE15
, PRI.CONTEXT CONTEXT
, PRI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PRI.LAST_UPDATED_BY LAST_UPDATED_BY
, PRI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRI.CREATED_BY CREATED_BY
, PRI.CREATION_DATE CREATION_DATE
FROM GL_DAILY_RATES SEC
, GL_DAILY_RATES PRI
, GL_DAILY_CONVERSION_TYPES CT
WHERE SEC.TO_CURRENCY = PRI.FROM_CURRENCY || ''
AND SEC.FROM_CURRENCY = PRI.TO_CURRENCY || ''
AND SEC.CONVERSION_DATE = PRI.CONVERSION_DATE + 0
AND SEC.CONVERSION_TYPE = PRI.CONVERSION_TYPE || ''
AND CT.CONVERSION_TYPE = PRI.CONVERSION_TYPE || ''