Results for “wms_objects_vl”

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

Overview

WMS_OBJECTS_VL is a multilingual (MLS) view owned by the APPS schema in Oracle E-Business Warehouse Management (WMS). It presents the translation-aware definition of WMS business objects, joining the base object table to its translation table and exposing a single, language-filtered row per object for the current session language. The view is documented in ETRM metadata for Oracle EBS 12.1.1 and 12.2.2 and carries a VALID status.

The view is central to the strategy assignment framework within WMS. Among its columns is STRAT_ASGMT_LOV_SQL, the stored SQL text that defines the list of values used when assigning a strategy to a business object. Users and developers searching for the term "strat_asgmt_lov_sql" are typically investigating how the strategy assignment LOV is resolved at runtime, or diagnosing why a strategy LOV returns unexpected values. Because WMS_OBJECTS_VL surfaces this column alongside the object name and description effective for the user's language, it is the natural reporting and integration point for that investigation.

Underlying Base Objects

The ETRM metadata documents the view as defined over two base objects, accessed through synonyms:

• WMS_OBJECTS_B — the base table (alias WOB in the view text) holding language-independent attributes, including OBJECT_ID, the audit columns, STRAT_ASGMT_DB_OBJECT_ID, STRAT_ASGMT_LOV_SQL, USER_DEFINED_FLAG, and the ATTRIBUTE1–ATTRIBUTE15 flexfield columns.
• WMS_OBJECTS_TL — the translation table (alias WOTL) supplying NAME and DESCRIPTION by LANGUAGE.

The join is on OBJECT_ID, with the translation row restricted by WOTL.LANGUAGE = USERENV('LANG'). This pattern is the standard Oracle MLS construct: one row per object is returned, with NAME and DESCRIPTION rendered for the session language. ROWID is projected from the base table (WOB.ROWID).

Key Columns

• OBJECT_ID — primary identifier of the WMS business object; the join key between the base and translation tables.
• NAME / DESCRIPTION — translated object name and description, sourced from WMS_OBJECTS_TL for the session language.
• STRAT_ASGMT_DB_OBJECT_ID — identifies the database object referenced by the strategy assignment.
• STRAT_ASGMT_LOV_SQL — the SQL statement text used to populate the strategy assignment list of values.
• USER_DEFINED_FLAG — indicates whether the object definition is seeded (Oracle-delivered) or user-defined.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield (DFF) columns for extensibility.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include confirming the LOV SQL configured for a given object, auditing user-defined versus seeded objects, and joining object definitions to strategy assignments. A basic query:

SELECT object_id, name, description, strat_asgmt_lov_sql, user_defined_flag
FROM apps.wms_objects_vl
WHERE user_defined_flag = 'Y';

To isolate objects whose LOV SQL references a particular table or clause:

SELECT object_id, name, strat_asgmt_lov_sql
FROM apps.wms_objects_vl
WHERE UPPER(strat_asgmt_lov_sql) LIKE '%MY_TABLE%';

Because translation is handled internally, callers should query the view rather than the TL table directly, and should ensure the session language is set so that NAME and DESCRIPTION return correctly.