FLA_CURRENCIES_V
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: VIEW
Columns
| Name |
|---|
|
CURRENCY_CODE PRECISION EXTENDED_PRECISION |
Query
| SQL_Statement |
|---|
|
SELECT currency_code, precision, extended_precision FROM ( SELECT currency_code, NVL(precision, 2) precision, NVL(extended_precision, 5) extended_precision, ROW_NUMBER() OVER(PARTITION BY currency_code ORDER BY enterprise_id ASC) priority FROM fnd_currencies_b ) WHERE priority = 1 |