Search Results yes_no_never

Overview

APPS.OKL_CURRENCIES_UV is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2, owned by the APPS schema and defined within the Oracle Lease and Finance Management (OKL) product family. It presents a language-aware, presentation-ready list of currencies maintained in Oracle General Ledger, augmenting the raw FND_CURRENCIES columns with translated currency names and descriptions sourced from FND_CURRENCIES_TL. Its distinguishing feature is the transformation of the native ENABLED_FLAG (a single-character Y/N column) into a human-readable lookup meaning drawn from the YES_NO_NEVER lookup type via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING.

This view is therefore intended for LOVs, reports, and integration extracts where currency data must be displayed in the user's session language and where the enabled status must be readable rather than a raw code. It is a synonym-based presentation layer, not a table of record.

Underlying Base Objects

The view is defined over two documented base objects, both exposed as synonyms:

• FND_CURRENCIES — the base (non-translated) currency definitions table, providing CURRENCY_CODE, ENABLED_FLAG, PRECISION, EXTENDED_PRECISION, SYMBOL, START_DATE_ACTIVE, END_DATE_ACTIVE, and ROWID.
• FND_CURRENCIES_TL — the translation table supplying NAME and DESCRIPTION for the session language.
• OKL_ACCOUNTING_UTIL — an OKL PL/SQL package whose GET_LOOKUP_MEANING function resolves the YES_NO_NEVER lookup code to its displayed meaning.

The join is on CURRENCY_CODE, restricted by T.LANGUAGE = USERENV('LANG'), so only the row matching the current session language is returned per currency. B.ROWID is exposed as ROW_ID, enabling row identification in Oracle Forms-based clients.

Key Columns

• CURRENCY_CODE — the ISO currency identifier; the join key between the base and translation tables.
• ENABLED_FLAG — the lookup meaning for the YES_NO_NEVER lookup, derived from NVL(B.ENABLED_FLAG, 'N'). Currencies with no explicit flag default to the "N" (No) meaning.
• PRECISION / EXTENDED_PRECISION — the number of decimal places for standard and extended (journal/EMU) precision.
• SYMBOL — the display symbol for the currency.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range during which the currency is available.
• NAME / DESCRIPTION — translated currency name and description for the session language.
• ROW_ID — the underlying FND_CURRENCIES.ROWID, used for direct row addressing.

Common Use Cases and Queries

Typical uses include currency selection LOVs in lease and finance forms, listings of active versus inactive currencies, and language-aware extracts feeding downstream integrations. A representative query returns active currencies displayed in the user's language:

• SELECT currency_code, name, enabled_flag, symbol, precision FROM apps.okl_currencies_uv WHERE enabled_flag = 'Yes' ORDER BY currency_code;
• SELECT currency_code, name, enabled_flag FROM apps.okl_currencies_uv WHERE currency_code = 'USD';
• SELECT currency_code, name, start_date_active, end_date_active FROM apps.okl_currencies_uv WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

Because the view is translated, callers should be aware that results depend on USERENV('LANG'); concurrent or background jobs assume the language of the invoking session. Filtering by enabled_flag should accordingly use the lookup meaning rather than the raw 'Y'/'N' code.