Search Results db_object_reference_id




Overview
Explore in AI Chat

Overview

The WMS_DB_OBJECT_REFERENCES table is a core metadata repository within the Oracle E-Business Suite Warehouse Management (WMS) module. It functions as a central registry for defining and managing logical groupings of database objects, such as tables, views, and packages, that are related to specific WMS functional areas or processes. Its primary role is to provide a structured mechanism for referencing these object groups from other parts of the application, enabling configuration, parameterization, and dynamic execution logic. This table is fundamental to the modular and extensible architecture of WMS, allowing for the organized association of database logic with business rules.

Key Information Stored

While the provided ETRM metadata does not list individual column details, the table's primary key and its relationships define its core structure. The central column is DB_OBJECT_REFERENCE_ID, which serves as the unique identifier (Primary Key: WMS_DB_OBJECT_REFERENCE_PK) for each defined object group. Based on its name and functional role, the table likely contains additional descriptive columns to specify the purpose of each reference group, such as a name, type, or module association. The table's design is focused on maintaining a master list of these referenceable groups, with the detailed membership—the specific database objects belonging to each group—stored in the related child table, WMS_DB_OBJ_REF_MEMBERS.

Common Use Cases and Queries

This table is primarily used for administrative and configuration purposes within the WMS module. A common use case involves setting up or reviewing which database objects are associated with a particular WMS parameter or functional flow. For instance, a parameter defined in WMS_PARAMETERS_B may point to a DB_OBJECT_REFERENCE_ID to dynamically determine the program units or validation logic to execute. Database administrators or functional implementers might query this table to understand dependencies before modifying underlying objects. A typical query would join to the member table to list all objects in a group:

SELECT r.db_object_reference_id, m.*
FROM wms_db_object_references r,
wms_db_obj_ref_members m
WHERE r.db_object_reference_id = m.db_object_reference_id
AND r.db_object_reference_id = :ref_id;

Related Objects

The WMS_DB_OBJECT_REFERENCES table maintains documented foreign key relationships with two key WMS tables, establishing it as a referenced parent entity.

  • WMS_DB_OBJ_REF_MEMBERS: This is a direct child table. The foreign key WMS_DB_OBJ_REF_MEMBERS.DB_OBJECT_REFERENCE_ID references the primary key of WMS_DB_OBJECT_REFERENCES. It stores the detailed list of individual database objects (e.g., table names, procedure names) that constitute each logical group defined in the parent table.
  • WMS_PARAMETERS_B: This core parameters table references WMS_DB_OBJECT_REFERENCES via the foreign key column WMS_PARAMETERS_B.DB_OBJECT_REFERENCE_ID. This relationship allows WMS configuration parameters to be linked to specific groups of database logic, enabling parameter-driven behavior within the application.