Results for “currency_code”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JG_ZZ_ENTERED_CURRENCIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the JG product, Regional Localizations, which supplies country-specific statutory and regulatory functionality layered on top of the core EBS financials modules. The view exposes a unified, three-way classification of currency codes so that downstream reports and localization routines can present "entered" currencies in a form that distinguishes standard ISO currencies, the statistical currency, and a special literal placeholder.

Because it is a view rather than a table, it stores no data of its own. Its role is to normalize the contents of the currency master and the general ledger lookup set into a single, consistently shaped result set that other ETRM/regional localization components can consume directly. The object carries a status of VALID and is documented in ETRM as a reporting and integration construct rather than as a transactional entity.

Underlying Base Objects

The view is defined over two documented base objects:

  • FND_CURRENCIES (referenced as a synonym) — the Oracle Application Object Library table that holds every currency enabled for the instance, including its ISO code, precision, and other attributes.
  • GL_LOOKUPS (referenced as a view) — the general ledger lookup view, queried here for the lookup type 'LITERAL' and lookup code 'N/A'.

The definition is a three-branch UNION ALL-free UNION. The first branch selects currency type 'E' (entered) for every FND_CURRENCIES row whose code is not 'STAT'. The second selects type 'S' (statistical) for the single row where the code is 'STAT'. The third selects type 'T' (literal/placeholder) from GL_LOOKUPS, taking the lookup MEANING as the currency code value. The result is a two-column projection of CURRENCY_TYPE and CURRENCY_CODE.

Key Columns

  • CURRENCY_TYPE — A single-character discriminator. 'E' denotes an ordinary entered currency drawn from FND_CURRENCIES; 'S' denotes the statistical currency 'STAT'; 'T' denotes the literal placeholder sourced from GL lookup type 'LITERAL', lookup code 'N/A'.
  • CURRENCY_CODE — The currency identifier itself. For types 'E' and 'S' this is the FND_CURRENCIES.CURRENCY_CODE value; for type 'T' it is the GL_LOOKUPS.MEANING associated with the 'LITERAL'/'N/A' lookup entry.

Together these columns give callers a compact enumeration of every value that may legitimately appear in a currency-entry context, tagged by its semantic category.

Common Use Cases and Queries

This view is typically used to populate currency selection lists, validate entered currency values, and categorize currency data in regional localization reports. A representative query returns the full categorized set:

SELECT currency_type, currency_code FROM apps.jg_zz_entered_currencies_v ORDER BY currency_type, currency_code;

To restrict output to conventional entered currencies only:

SELECT currency_code FROM apps.jg_zz_entered_currencies_v WHERE currency_type = 'E' ORDER BY currency_code;

To retrieve the statistical and literal placeholders specifically:

SELECT currency_type, currency_code FROM apps.jg_zz_entered_currencies_v WHERE currency_type IN ('S','T');

Because the view joins currency master data with a lookup-derived pseudo-currency, it is well suited to reconciliation checks that confirm whether a given value is a valid entered currency, the statistical currency, or a literal placeholder before a localization process proceeds.