VIEW: APPS.AR_ALL_ENABLED_CURRENCIES_V

Source

View Text - Preformatted

SELECT FC.CURRENCY_CODE , FC.NAME , FC.DESCRIPTION , FC.PRECISION , FC.EXTENDED_PRECISION , FC.MINIMUM_ACCOUNTABLE_UNIT , FC.START_DATE_ACTIVE , FC.END_DATE_ACTIVE , FC.ISSUING_TERRITORY_CODE , FC.SYMBOL , FC.LAST_UPDATE_DATE , FC.LAST_UPDATED_BY , FC.CREATION_DATE , FC.CREATED_BY , FC.LAST_UPDATE_LOGIN , FC.CONTEXT , FC.ATTRIBUTE1 , FC.ATTRIBUTE2 , FC.ATTRIBUTE3 , FC.ATTRIBUTE4 , FC.ATTRIBUTE5 , FC.ATTRIBUTE6 , FC.ATTRIBUTE7 , FC.ATTRIBUTE8 , FC.ATTRIBUTE9 , FC.ATTRIBUTE10 , FC.ATTRIBUTE11 , FC.ATTRIBUTE12 , FC.ATTRIBUTE13 , FC.ATTRIBUTE14 , FC.ATTRIBUTE15 FROM FND_CURRENCIES_VL FC, AR_SYSTEM_PARAMETERS SP, GL_SETS_OF_BOOKS SB WHERE FC.CURRENCY_FLAG = 'Y' AND SP.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID AND FC.ENABLED_FLAG = 'Y' AND FC.CURRENCY_CODE = DECODE(SP.CODE_COMBINATION_ID_GAIN, '', SB.CURRENCY_CODE, FC.CURRENCY_CODE)

View Text - HTML Formatted

SELECT FC.CURRENCY_CODE
, FC.NAME
, FC.DESCRIPTION
, FC.PRECISION
, FC.EXTENDED_PRECISION
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.START_DATE_ACTIVE
, FC.END_DATE_ACTIVE
, FC.ISSUING_TERRITORY_CODE
, FC.SYMBOL
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATED_BY
, FC.CREATION_DATE
, FC.CREATED_BY
, FC.LAST_UPDATE_LOGIN
, FC.CONTEXT
, FC.ATTRIBUTE1
, FC.ATTRIBUTE2
, FC.ATTRIBUTE3
, FC.ATTRIBUTE4
, FC.ATTRIBUTE5
, FC.ATTRIBUTE6
, FC.ATTRIBUTE7
, FC.ATTRIBUTE8
, FC.ATTRIBUTE9
, FC.ATTRIBUTE10
, FC.ATTRIBUTE11
, FC.ATTRIBUTE12
, FC.ATTRIBUTE13
, FC.ATTRIBUTE14
, FC.ATTRIBUTE15
FROM FND_CURRENCIES_VL FC
, AR_SYSTEM_PARAMETERS SP
, GL_SETS_OF_BOOKS SB
WHERE FC.CURRENCY_FLAG = 'Y'
AND SP.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND FC.ENABLED_FLAG = 'Y'
AND FC.CURRENCY_CODE = DECODE(SP.CODE_COMBINATION_ID_GAIN
, ''
, SB.CURRENCY_CODE
, FC.CURRENCY_CODE)