Results for “std_um”

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

Overview

SY_UOMS_TYP_V is a valid database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the GMA – Process Manufacturing Systems product family and exposes a consolidated list of unit of measure (UOM) types used throughout the Process Manufacturing application. The view presents one row per base unit of measure class, deriving its content from the core UOM class and unit of measure tables. Because it is a view rather than a table, it carries no independent storage and always reflects the current state of the underlying data at query time.

The object is frequently accessed by reports, concurrent programs, and integration interfaces that need to resolve a UOM class into a descriptive label and a standard unit of measure. Given the user search term "type_desc," the TYPE_DESC column is the primary attribute of interest: it provides a human-readable description of the UOM class, enabling downstream consumers to display meaningful text instead of raw internal codes. The view therefore serves as a lightweight, read-only presentation layer for UOM type reference data.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed in the APPS schema as synonyms:

• MTL_UNITS_OF_MEASURE (SYNONYM) — supplies the UOM code, class assignment, and the BASE_UOM_FLAG used to restrict rows to the base UOM of each class.
• MTL_UOM_CLASSES (SYNONYM) — supplies the UOM class code, the class description, and the standard audit columns.

The defining query joins these two tables on UOM_CLASS and filters with UOM.BASE_UOM_FLAG = 'Y', so only the base unit of measure for each class is returned. This join and filter are the mechanism by which the view normalizes UOM type information into a single, consistent row per class.

Key Columns

• UM_TYPE — the UOM class code (UOMC.UOM_CLASS), identifying the type of unit of measure.
• TYPE_DESC — a truncated (first 40 characters) description of the UOM class, drawn from UOMC.DESCRIPTION.
• LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns tracking the last modification of the class record.
• CREATION_DATE, CREATED_BY — audit columns recording when and by whom the class record was created.
• DELETE_MARK — a derived disable indicator computed via DECODE(SIGN(SYSDATE - UOMC.DISABLE_DATE), 1, 1, 0).
• TEXT_CODE, TRANS_CNT — placeholder columns returned as literal 0 in the view definition.
• STD_UM — the standard unit of measure, derived from UOM.UNIT_OF_MEASURE with a fallback to UOM.UOM_CODE depending on length.

Common Use Cases and Queries

Typical scenarios include populating UOM type lists in Process Manufacturing reports, validating base UOM assignments during integration loads, and resolving "type_desc" lookups for user-facing output. A representative query retrieving the type description for a given class is:

• SELECT um_type, type_desc, std_um FROM apps.sy_uoms_typ_v WHERE um_type = :class_code;
• SELECT um_type, type_desc FROM apps.sy_uoms_typ_v ORDER BY type_desc;
• SELECT v.um_type, v.type_desc, v.std_um FROM apps.sy_uoms_typ_v v WHERE v.delete_mark = 0;

Because the view always reflects live base-table data, queries return the current description and standard UOM without additional maintenance, making it suitable for both ad hoc reporting and embedded reference lookups in PL/SQL and OA Framework pages.