Search Results uom_meaning




Overview
Explore in AI Chat

Overview

APPS.PA_CURRENCY_UOM_V is a seeded Oracle E-Business Suite view owned by the APPS schema and registered in Oracle Applications as FND Design Data object PA.PA_CURRENCY_UOM_V. It is classified as an internal view type and carries the standard Oracle restriction that it is intended for use by standard Oracle Applications programs only; direct customer access to the underlying data is not supported. The view exposes a small, purpose-built projection of Oracle Projects lookup data that identifies which units of measure are treated as currency units of measure within the Projects (PA) application.

The object is central to the Projects budgeting and grants accounting code paths. It is referenced by PA_BUDGET_UTILS and GMS_BUDGET_UTILS, both of which rely on it to distinguish currency-denominated units of measure from quantity units of measure during budget processing, amount validation, and currency conversion logic. As a result, its most frequently searched column, UOM_MEANING, is the human-readable description of a unit of measure that also carries a currency designation.

Underlying Base Objects

Per the documented dependency metadata, PA_CURRENCY_UOM_V is defined over a single referenced base object: the view PA_LOOKUPS. PA_LOOKUPS is the Oracle Projects view layer over the FND_LOOKUPS lookup table, exposing lookup codes, meanings, descriptions, and tag information for lookup types maintained under the Oracle Projects application.

PA_CURRENCY_UOM_V therefore does not define its own persistence. It filters and reshapes PA_LOOKUPS so that only lookup rows identifying currency units of measure are returned, projecting the lookup meaning, the lookup code, and a currency indicator flag. Downstream dependencies are limited to the two utility packages noted above, PA_BUDGET_UTILS and GMS_BUDGET_UTILS, both of which consume the view at runtime rather than at installation time.

Key Columns

  • UOM_MEANING (VARCHAR2, 80) — The descriptive meaning of the unit of measure as maintained in the Projects lookup definition. This is the column most commonly matched when a user searches for "uom_meaning," and it supplies the token used in Reports, PL/SQL validation messages, and Oracle Projects forms.
  • UOM_CODE (VARCHAR2, 30) — The short lookup code that uniquely identifies the currency unit of measure. It is the code used for joins to unit-of-measure reference data and to transactional amount columns elsewhere in Oracle Projects.
  • CURRENCY_UOM_FLAG (VARCHAR2) — A flag column that indicates the currency classification of the unit of measure within the lookup-driven set returned by the view.

No mandatory columns are documented, and no primary key is declared, since the view is a filtered lookup projection rather than an entity view.

Common Use Cases and Queries

The primary use case is resolving the currency unit-of-measure code and its descriptive meaning during budget and grants processing, where PA_BUDGET_UTILS and GMS_BUDGET_UTILS must determine whether a budget line is expressed in a currency or a quantity unit. Reporting and integration use cases include validating that a unit of measure supplied by an external interface is currency-capable, and joining the view to transaction or budget tables on UOM_CODE.

A basic retrieval returns all three columns exactly as documented:

  • Simple listing: SELECT UOM_MEANING, UOM_CODE, CURRENCY_UOM_FLAG FROM APPS.PA_CURRENCY_UOM_V;
  • Targeted lookup: SELECT UOM_CODE FROM APPS.PA_CURRENCY_UOM_V WHERE UOM_MEANING = :p_meaning;
  • Flag filter: SELECT UOM_MEANING, UOM_CODE FROM APPS.PA_CURRENCY_UOM_V WHERE CURRENCY_UOM_FLAG = 'Y';

Because the object is marked Oracle Internal Use Only and is not supported for direct access outside standard Oracle Applications programs, any custom query or integration should be treated as an unsupported extension. Where possible, the documented public application programming interfaces in the Budget Utilities packages should be used instead of querying the view directly.