Results for “pa_currency_uom_v”

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

Overview

PA_CURRENCY_UOM_V is a database view owned by the APPS schema within the Oracle E-Business Suite Projects (PA) module. It is classified in ETRM as VALID and is documented across both Oracle EBS 12.1.1 and 12.2.2 releases. Per its official description, the view is used to configure the currency unit of measure. In practice, it exposes a filtered and derived subset of the PA_LOOKUPS view, restricting the underlying lookup data to a single lookup type and presenting an analytical flag that identifies which records correspond to a monetary (currency) unit of measure.

Because it is a view rather than a base table, PA_CURRENCY_UOM_V does not store data. Instead, it provides a stable, read-only interface that reporting, extensions, and integration layers can query without needing to know the internal filtering logic applied to PA_LOOKUPS. For functional and technical consultants, it serves as the authoritative source for the list of valid unit-of-measure lookup codes and meanings relevant to currency handling in Project Accounting.

Underlying Base Objects

The view is defined over a single documented base object: PA_LOOKUPS, which is itself a view in the APPS schema. PA_LOOKUPS supplies the underlying lookup rows from which PA_CURRENCY_UOM_V derives its content. The view applies a WHERE predicate of LOOKUP_TYPE = 'UNIT', so only lookup codes belonging to the 'UNIT' lookup type are surfaced. It further computes a derived column, CURRENCY_UOM_FLAG, using a DECODE expression that returns 'Y' when the upper-cased MEANING equals 'DOLLARS' and 'N' otherwise. This means the currency designation is inferred from the lookup meaning rather than stored as a separate attribute, a design detail worth noting when the lookup meaning is customized.

Key Columns

• UOM_MEANING — The descriptive meaning of the unit-of-measure lookup, sourced from the MEANING column of PA_LOOKUPS. It provides the human-readable label for the unit.
• UOM_CODE — The lookup code identifying the unit of measure, sourced from LOOKUP_CODE. This is the value typically referenced by other project-related records.
• CURRENCY_UOM_FLAG — A derived indicator computed as DECODE(UPPER(MEANING),'DOLLARS','Y','N'). A value of 'Y' identifies the entry as a currency (Dollars) unit of measure; 'N' indicates a non-currency unit.

Note that the documented view text aliases MEANING and LOOKUP_CODE into the UOM_MEANING and UOM_CODE column names exposed to consumers.

Common Use Cases and Queries

Typical scenarios include validating currency unit-of-measure values in project setup, populating value sets or LOVs for concurrent programs and forms, and joining to project records that reference a UOM code. A frequently issued query retrieves all currency-relevant units:

SELECT uom_code, uom_meaning, currency_uom_flag
FROM apps.pa_currency_uom_v
WHERE currency_uom_flag = 'Y';

A broader listing returns every unit-of-measure lookup:

SELECT uom_code, uom_meaning
FROM apps.pa_currency_uom_v
ORDER BY uom_meaning;

To confirm whether a specific code exists, filter on UOM_CODE:

SELECT uom_code, uom_meaning
FROM apps.pa_currency_uom_v
WHERE uom_code = :p_uom_code;

Because the currency flag depends on the literal meaning 'DOLLARS', implementations that customize lookup meanings should verify the derived flag still returns the expected results. All queries should be executed with the appropriate APPS access grants, as the view resides in the APPS schema.