View: GL_DAILY_RATES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_DAILY_RATES_V

View Text

SELECT PRIMARY.FROM_CURRENCY
, PRIMARY.TO_CURRENCY
, PRIMARY.CONVERSION_DATE
, CT.USER_CONVERSION_TYPE
, ROUND(PRIMARY.CONVERSION_RATE
, 18)
, ROUND(SECONDARY.CONVERSION_RATE
, 10)
, PRIMARY.CONVERSION_RATE
, SECONDARY.CONVERSION_RATE
, PRIMARY.ROWID
, SECONDARY.ROWID
, PRIMARY.STATUS_CODE
, PRIMARY.CONVERSION_TYPE
, DECODE(CT.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RATE_TYPES_V'
, 'GL_DAS_RATE_TYPES'
, CT.CONVERSION_TYPE
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y')
, DECODE(CT.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RATE_TYPES_U'
, 'GL_DAS_RATE_TYPES'
, CT.CONVERSION_TYPE
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y')
, DECODE(CT.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RATE_TYPES_M'
, 'GL_DAS_RATE_TYPES'
, CT.CONVERSION_TYPE
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y')
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.CONTEXT
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
FROM GL_DAILY_RATES SECONDARY
, GL_DAILY_RATES PRIMARY
, GL_DAILY_CONVERSION_TYPES CT
WHERE SECONDARY.TO_CURRENCY = PRIMARY.FROM_CURRENCY || ''
AND SECONDARY.FROM_CURRENCY = PRIMARY.TO_CURRENCY || ''
AND SECONDARY.CONVERSION_DATE = PRIMARY.CONVERSION_DATE + 0
AND SECONDARY.CONVERSION_TYPE = PRIMARY.CONVERSION_TYPE || '' AND CT.CONVERSION_TYPE = PRIMARY.CONVERSION_TYPE || ''

Columns