VIEW: APPS.AR_RGW_RATE_ADJUSTMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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