VIEW: APPS.AR_RATE_ADJUSTMENTS_MRC_V

Source

View Text - Preformatted

SELECT PRIMARY.RATE_ADJUSTMENT_ID , MC.OLD_EXCHANGE_RATE , MC.NEW_EXCHANGE_RATE , MC.OLD_EXCHANGE_RATE_TYPE , MC.NEW_EXCHANGE_RATE_TYPE , MC.OLD_EXCHANGE_DATE , MC.NEW_EXCHANGE_DATE , MC.GAIN_LOSS , PRIMARY.CASH_RECEIPT_ID , PRIMARY.CREATED_BY , PRIMARY.CREATION_DATE , PRIMARY.LAST_UPDATED_BY , PRIMARY.LAST_UPDATE_DATE , PRIMARY.LAST_UPDATE_LOGIN , PRIMARY.GL_DATE , PRIMARY.GL_POSTED_DATE , PRIMARY.ATTRIBUTE_CATEGORY , PRIMARY.ATTRIBUTE1 , PRIMARY.ATTRIBUTE2 , PRIMARY.ATTRIBUTE3 , PRIMARY.ATTRIBUTE4 , PRIMARY.ATTRIBUTE5 , PRIMARY.ATTRIBUTE6 , PRIMARY.ATTRIBUTE7 , PRIMARY.ATTRIBUTE8 , PRIMARY.ATTRIBUTE9 , PRIMARY.ATTRIBUTE10 , PRIMARY.POSTING_CONTROL_ID , PRIMARY.ATTRIBUTE11 , PRIMARY.ATTRIBUTE12 , PRIMARY.ATTRIBUTE13 , PRIMARY.ATTRIBUTE14 , PRIMARY.ATTRIBUTE15 , PRIMARY.PROGRAM_APPLICATION_ID , PRIMARY.PROGRAM_ID , PRIMARY.PROGRAM_UPDATE_DATE , PRIMARY.REQUEST_ID , PRIMARY.CREATED_FROM , PRIMARY.ORG_ID FROM AR_RATE_ADJUSTMENTS_ALL PRIMARY, AR_MC_RATE_ADJUSTMENTS MC WHERE PRIMARY.rate_adjustment_id = MC.rate_adjustment_id AND mc.set_of_books_id = NVL(TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO'), 45, 10), ' ')), -99) AND NVL(PRIMARY.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT PRIMARY.RATE_ADJUSTMENT_ID
, MC.OLD_EXCHANGE_RATE
, MC.NEW_EXCHANGE_RATE
, MC.OLD_EXCHANGE_RATE_TYPE
, MC.NEW_EXCHANGE_RATE_TYPE
, MC.OLD_EXCHANGE_DATE
, MC.NEW_EXCHANGE_DATE
, MC.GAIN_LOSS
, PRIMARY.CASH_RECEIPT_ID
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.GL_DATE
, PRIMARY.GL_POSTED_DATE
, PRIMARY.ATTRIBUTE_CATEGORY
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.POSTING_CONTROL_ID
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.REQUEST_ID
, PRIMARY.CREATED_FROM
, PRIMARY.ORG_ID
FROM AR_RATE_ADJUSTMENTS_ALL PRIMARY
, AR_MC_RATE_ADJUSTMENTS MC
WHERE PRIMARY.RATE_ADJUSTMENT_ID = MC.RATE_ADJUSTMENT_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)
AND NVL(PRIMARY.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)