VIEW: APPS.GL_DAILY_RATES_V

Source

View Text - Preformatted

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 || ''

View Text - HTML Formatted

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 || ''