View: AR_RGW_RATE_ADJUSTMENTS_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AR_RGW_RATE_ADJUSTMENTS_V

View Text

SELECT RADJ.ROWID ROW_ID
, RADJ.RATE_ADJUSTMENT_ID RATE_ADJUSTMENT_ID
, RADJ.CASH_RECEIPT_ID CASH_RECEIPT_ID
, RADJ.OLD_EXCHANGE_RATE OLD_EXCHANGE_RATE
, RADJ.NEW_EXCHANGE_RATE NEW_EXCHANGE_RATE
, RADJ.OLD_EXCHANGE_RATE_TYPE OLD_EXCHANGE_RATE_TYPE
, DCT_OLD.USER_CONVERSION_TYPE OLD_EXCHANGE_RATE_TYPE_DSP
, RADJ.NEW_EXCHANGE_RATE_TYPE NEW_EXCHANGE_RATE_TYPE
, DCT_NEW.USER_CONVERSION_TYPE NEW_EXCHANGE_RATE_TYPE_DSP
, RADJ.OLD_EXCHANGE_DATE OLD_EXCHANGE_DATE
, RADJ.NEW_EXCHANGE_DATE NEW_EXCHANGE_DATE
, RADJ.GAIN_LOSS GAIN_LOSS
, RADJ.GL_DATE GL_DATE
, RADJ.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RADJ.ATTRIBUTE1 ATTRIBUTE1
, RADJ.ATTRIBUTE2 ATTRIBUTE2
, RADJ.ATTRIBUTE3 ATTRIBUTE3
, RADJ.ATTRIBUTE4 ATTRIBUTE4
, RADJ.ATTRIBUTE5 ATTRIBUTE5
, RADJ.ATTRIBUTE6 ATTRIBUTE6
, RADJ.ATTRIBUTE7 ATTRIBUTE7
, RADJ.ATTRIBUTE8 ATTRIBUTE8
, RADJ.ATTRIBUTE9 ATTRIBUTE9
, RADJ.ATTRIBUTE10 ATTRIBUTE10
, RADJ.ATTRIBUTE11 ATTRIBUTE11
, RADJ.ATTRIBUTE12 ATTRIBUTE12
, RADJ.ATTRIBUTE13 ATTRIBUTE13
, RADJ.ATTRIBUTE14 ATTRIBUTE14
, RADJ.ATTRIBUTE15 ATTRIBUTE15
FROM AR_RATE_ADJUSTMENTS RADJ
, GL_DAILY_CONVERSION_TYPES DCT_NEW
, GL_DAILY_CONVERSION_TYPES DCT_OLD
WHERE DCT_NEW.CONVERSION_TYPE = RADJ.NEW_EXCHANGE_RATE_TYPE
AND DCT_OLD.CONVERSION_TYPE = RADJ.OLD_EXCHANGE_RATE_TYPE

Columns