Search Results consist_string

Overview

INV.MTL_AVAILABLE_INVENTORY_TEMP is a global temporary table (GTT) within the Oracle E-Business Suite Inventory (INV) schema. It is used by the material availability and move-order processing engine to hold transient, session-scoped inventory supply records while the system evaluates on-hand quantities, sourcing rules, locators, lots, and serial numbers against demand. Because it is defined as a global temporary table with a data duration of SYS$SESSION, rows inserted by a given session are visible only to that session and are automatically purged when the session terminates. This design makes the object suitable for high-concurrency processing without contention, since parallel sessions operate on logically isolated data sets.

The table serves as an intermediate staging structure rather than a persistent transactional record. It is populated during availability checks, move-order generation, picking, and reservation activities, and its rows typically represent candidate supply that may or may not be consumed by the calling process. The documented database relationship metadata classifies this object heuristically as standalone, suggesting that it may be modeled as a standalone fact or staging structure rather than as a strict Data Vault hub, link, or satellite.

Key Information Stored

The table contains 29 documented columns. The most operationally significant include:

• SOURCE_LINE_ID and MOVE_ORDER_LINE_ID — numeric identifiers tying each staged supply row back to the originating move-order or source line driving demand.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, and LOCATOR_ID — the core inventory triple identifying the warehouse, item, and storage location of the available supply.
• ONHAND_QTY and SECONDARY_ONHAND_QTY — the quantity currently available in primary and secondary units of measure.
• TRANSACTION_QTY and SECONDARY_TRANSACTION_QTY — the quantity the process intends to move or allocate.
• TRANSACTION_UOM and SECONDARY_UOM — the units of measure governing the quantity values.
• LOT_NUMBER, LOT_EXPIRATION_DATE, GRADE_CODE, and REVISION — lot, grade, and revision attributes used for lot-controlled and revision-controlled items.
• SERIAL_NUMBER — the serial attribute for serial-controlled items.
• SUBINVENTORY_CODE — the subinventory in which supply resides.
• CONSIST_STRING and ORDER_BY_STRING — string columns (length 2000) used to hold consistency and ordering expressions consumed by the availability and sequencing logic.
• WMS_RULE_ID and LPN_ID — warehouse management rule and license plate number references used in WMS-enabled organizations.
• COST_GROUP_ID — the cost group associated with the item, useful for costed availability evaluation.

No surrogate primary key or unique business key is documented for this table, which is consistent with its role as a transient staging structure. Candidate business keys would be composites such as ORGANIZATION_ID, INVENTORY_ITEM_ID, LOCATOR_ID, and LOT_NUMBER, but uniqueness is not enforced at the schema level.

Common Use Cases and Queries

Typical uses include diagnosing move-order shortages, verifying lot and locator selection, and auditing how the availability engine distributes supply across subinventories. A basic inspection query follows the documented pattern:

• SELECT ORGANIZATION_ID, INVENTORY_ITEM_ID, LOCATOR_ID, LOT_NUMBER, ONHAND_QTY, TRANSACTION_QTY FROM INV.MTL_AVAILABLE_INVENTORY_TEMP;
• Join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID to resolve item descriptions.
• Filter by SESSION-scoped rows only; results are invisible to other sessions and disappear at session end.

Because the contents are session-specific and short-lived, the table is not suitable for historical reporting. It is best queried interactively during troubleshooting or from within the same database session that populated it.

Related Objects

• MTL_RESERVATIONS — referenced via RESERVATION_ID, linking staged supply to reservation records.
• MTL_TXN_SOURCE_TYPES — referenced via TRANSACTION_SOURCE_TYPE_ID, defining the transaction source classification.
• CST_COST_GROUPS — referenced via COST_GROUP_ID, providing cost grouping context.
• MTL_SYSTEM_ITEMS_B and MTL_ITEM_LOCATIONS — joined by item and locator for resolution of descriptive attributes.
• MTL_MATERIAL_TRANSACTIONS — the downstream target of the moves staged here.