FND_CURRENCIES_VL

Details

• Schema: REFDATA

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID NAME DESCRIPTION DERIVE_EFFECTIVE DERIVE_TYPE DERIVE_FACTOR CURRENCY_CODE ENABLED_FLAG CURRENCY_FLAG ISSUING_TERRITORY_CODE PRECISION EXTENDED_PRECISION SYMBOL START_DATE_ACTIVE END_DATE_ACTIVE MINIMUM_ACCOUNTABLE_UNIT CONTEXT ISO_FLAG DIGITAL_CURRENCY_CODE ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_TIMESTAMP1 GLOBAL_ATTRIBUTE_TIMESTAMP2 GLOBAL_ATTRIBUTE_TIMESTAMP3 GLOBAL_ATTRIBUTE_TIMESTAMP4 GLOBAL_ATTRIBUTE_TIMESTAMP5 GLOBAL_ATTRIBUTE_CATEGORY LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID , T.NAME , T.DESCRIPTION , B.DERIVE_EFFECTIVE , B.DERIVE_TYPE , B.DERIVE_FACTOR , B.CURRENCY_CODE, B.ENABLED_FLAG , B.CURRENCY_FLAG , B.ISSUING_TERRITORY_CODE , B.PRECISION , B.EXTENDED_PRECISION , B.SYMBOL , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.MINIMUM_ACCOUNTABLE_UNIT , B.CONTEXT , B.ISO_FLAG , B.DIGITAL_CURRENCY_CODE, B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_DATE6, B.ATTRIBUTE_DATE7, B.ATTRIBUTE_DATE8, B.ATTRIBUTE_DATE9, B.ATTRIBUTE_DATE10, B.ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5, B.ATTRIBUTE_TIMESTAMP6, B.ATTRIBUTE_TIMESTAMP7, B.ATTRIBUTE_TIMESTAMP8, B.ATTRIBUTE_TIMESTAMP9, B.ATTRIBUTE_TIMESTAMP10, B.GLOBAL_ATTRIBUTE1 , B.GLOBAL_ATTRIBUTE2 , B.GLOBAL_ATTRIBUTE3 , B.GLOBAL_ATTRIBUTE4 , B.GLOBAL_ATTRIBUTE5 , B.GLOBAL_ATTRIBUTE6 , B.GLOBAL_ATTRIBUTE7 , B.GLOBAL_ATTRIBUTE8 , B.GLOBAL_ATTRIBUTE9 , B.GLOBAL_ATTRIBUTE10 , B.GLOBAL_ATTRIBUTE11 , B.GLOBAL_ATTRIBUTE12 , B.GLOBAL_ATTRIBUTE13 , B.GLOBAL_ATTRIBUTE14 , B.GLOBAL_ATTRIBUTE15 , B.GLOBAL_ATTRIBUTE16 , B.GLOBAL_ATTRIBUTE17 , B.GLOBAL_ATTRIBUTE18 , B.GLOBAL_ATTRIBUTE19 , B.GLOBAL_ATTRIBUTE20, B.GLOBAL_ATTRIBUTE_NUMBER1, B.GLOBAL_ATTRIBUTE_NUMBER2, B.GLOBAL_ATTRIBUTE_NUMBER3, B.GLOBAL_ATTRIBUTE_NUMBER4, B.GLOBAL_ATTRIBUTE_NUMBER5, B.GLOBAL_ATTRIBUTE_DATE1, B.GLOBAL_ATTRIBUTE_DATE2, B.GLOBAL_ATTRIBUTE_DATE3, B.GLOBAL_ATTRIBUTE_DATE4, B.GLOBAL_ATTRIBUTE_DATE5, B.GLOBAL_ATTRIBUTE_TIMESTAMP1, B.GLOBAL_ATTRIBUTE_TIMESTAMP2, B.GLOBAL_ATTRIBUTE_TIMESTAMP3, B.GLOBAL_ATTRIBUTE_TIMESTAMP4, B.GLOBAL_ATTRIBUTE_TIMESTAMP5, B.GLOBAL_ATTRIBUTE_CATEGORY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN FROM FND_CURRENCIES_TL T, FND_CURRENCIES_B B WHERE B.CURRENCY_CODE = T.CURRENCY_CODE AND T.LANGUAGE = USERENV('LANG')