Search Results gmo_dispense_storage_subinvs

Overview

GMO_DISPENSE_STORAGE_SUBINVS is a table owned by the GMO schema, the manufacturing execution component of Oracle Process Manufacturing (OPM). It is delivered as part of the Oracle E-Business Suite 12.1.1 and 12.2.2 release streams and carries a VALID status in the ETRM data dictionary. The object defines the physical storage destinations available for dispensing operations: it associates a dispensing area with the subinventories that may receive dispensed material.

From a dimensional modeling perspective, the mined foreign key structure suggests a standalone classification under the heuristic Data Vault taxonomy. The only documented outbound foreign key points from DISPENSE_AREA_ID to GMO_DISPENSE_AREA_B, which means the table does not itself resolve into a classic hub-and-satellite chain within the metadata. This classification is offered as a modeling suggestion only; the table behaves operationally as a configuration cross-reference between a dispensing area and an inventory subinventory.

Key Information Stored

The physical schema documents eight columns, of which the following are the most significant:

• DISPENSE_AREA_ID — Identifier of the dispensing area to which the storage rule applies. This column is the leading component of the composite primary key and the target of the foreign key to GMO_DISPENSE_AREA_B.
• SUBINVENTORY_CODE — The inventory subinventory code recognized as a valid storage destination within the given dispensing area. It is the second component of the composite primary key.
• STORAGE_TYPE — Classifies the storage role or characteristic of the subinventory in the dispensing context, allowing multiple storage behaviors to be distinguished for the same area.
• CREATED_BY, CREATION_DATE — Standard audit columns recording the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification, including the login session that performed it.

There is no separately generated surrogate numeric key documented for this table. The business key is the composite unique index GMO_DISP_STORAGE_SUBINVS_PK, defined over (DISPENSE_AREA_ID, SUBINVENTORY_CODE). This composite index is the clearest documented candidate for the natural business key, and it enforces the rule that a given subinventory appears once per dispensing area.

Common Use Cases and Queries

This table is typically queried during dispensing transaction validation and during setup review. A common pattern lists all subinventories enabled for a specific dispensing area:

SELECT subinventory_code, storage_type FROM gmo.gmo_dispense_storage_subinvs WHERE dispense_area_id = :p_area_id ORDER BY subinventory_code;

A second pattern joins upward to resolve the dispensing area name for reporting:

SELECT a.dispense_area_name, s.subinventory_code, s.storage_type FROM gmo.gmo_dispense_storage_subinvs s, gmo.gmo_dispense_area_b a WHERE s.dispense_area_id = a.dispense_area_id;

Reverse lookups are equally common: given a subinventory code, determine which dispensing areas permit it as a storage destination. This supports troubleshooting when a dispense transaction fails validation because the target subinventory is not configured for the selected area. Audit-oriented reporting uses CREATION_DATE and LAST_UPDATE_DATE to track configuration drift over time, and LAST_UPDATED_BY to attribute changes to specific administrators during controlled setup reviews or validation exercises.

Related Objects

The FK metadata documents one direct parent relationship, and the remaining significant dependencies derive from the schema's functional role:

• GMO_DISPENSE_AREA_B — Parent table; joined on DISPENSE_AREA_ID = DISPENSE_AREA_ID. Provides the dispensing area definition referenced by each storage row.
• GMO_DISPENSE_AREA_TL — Translation table for dispensing area names and descriptions, joined indirectly through GMO_DISPENSE_AREA_B for multilingual reporting.
• MTL_SUBINVENTORIES — Inventory master for subinventories; joined on SUBINVENTORY_CODE = SECONDARY_INVENTORY_NAME to resolve descriptions and validate that the configured code exists.
• MTL_SECONDARY_INVENTORIES — Alternate historical name for the subinventory master in earlier 11i-derived schemas; useful when reconciling against older installations.
• GMO_DISPENSE_HEADERS / GMO_DISPENSE_DETAILS — Dispensing transaction tables whose validation logic consults the area-to-subinventory mapping before allowing material to be staged.
• GMO_DISPENSE_AREA_B's own PK index — GMO_DISPENSE_AREA_PK, used by the optimizer when joining storage rules back to their parent area.

Because the table has no documented child foreign keys, deletion or modification of rows here does not cascade to dependent objects; referential integrity is enforced only in the direction of GMO_DISPENSE_AREA_B.