Results for “opm_whse_code”

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

Overview

The GMI.GMI_DISCRETE_TRANSFER_LINES table is a Process Manufacturing Inventory object that stores line-level detail for inventory transfers executed between Oracle Process Manufacturing (OPM) and Oracle Discrete Manufacturing (ODM) organizations. While OPM and Discrete Inventory maintain separate item, warehouse, lot, and cost models, this table serves as the bridge that records each material line of a cross-model transfer, capturing both the source (OPM-prefixed) and destination (ODM-prefixed) attributes on a single row. The parent transfer header is presumed to reside on a corresponding GMI_DISCRETE_TRANSFER_HEADERS table keyed by TRANSFER_ID.

The object is classified as VALID in the GMI schema and contains 68 documented physical columns in ETRM 12.2.2. Its heuristic Data Vault classification, mined from foreign-key structure, is standalone — meaning the table is modeled as an independent entity rather than as a hub, link, or satellite. In practice, the dual-domain column families (OPM_* and ODM_*) suggest a natural composite key of TRANSFER_ID plus LINE_ID, which is exactly how the primary key is defined.

Key Information Stored

The primary key is the composite GMI_DISCRETE_TRANSFER_LINES_PK on (TRANSFER_ID, LINE_ID). There is no separate surrogate key column documented; the unique index on these two columns is the sole business-key candidate. Notable columns include:

• TRANSFER_ID — foreign key to the transfer header; identifies the transfer transaction.
• LINE_ID — sequence identifier unique within a transfer; combined with TRANSFER_ID forms the PK.
• LINE_NO — user-visible line number for reporting and UI ordering.
• OPM_ITEM_ID / OPM_WHSE_CODE / OPM_LOCATION / OPM_LOT_ID — source-side Process Manufacturing item, warehouse, location, and lot identifiers.
• OPM_LOT_EXPIRATION_DATE / OPM_LOT_STATUS / OPM_GRADE — lot quality and shelf-life attributes carried from the OPM side.
• ODM_INV_ORGANIZATION_ID / ODM_ITEM_ID / ODM_SUBINVENTORY / ODM_LOCATOR_ID — destination-side Discrete organization, item, subinventory, and locator.
• ODM_LOT_NUMBER / ODM_LOT_EXPIRATION_DATE / ODM_ITEM_REVISION — destination lot and revision attributes.
• QUANTITY / QUANTITY_UM / OPM_PRIMARY_QUANTITY / ODM_PRIMARY_QUANTITY — transaction quantity, unit of measure, and the dual primary-quantity conversions required when the two models' UOM conventions differ.
• ODM_UNIT_COST / ODM_PERIOD_ID / ODM_CHARGE_ACCOUNT_ID / OPM_CHARGE_ACCT_ID — costing, accounting period, and charge account columns used for valuation and accounting entry generation.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard WHO audit columns.
• DELETE_MARK / TEXT_CODE / ATTRIBUTE1–30 — soft-delete flag, descriptive code, and the standard DFF attribute set retained for extensibility.

Common Use Cases and Queries

Typical reporting use cases include auditing cross-model transfer volumes, reconciling OPM-to-ODM lot and quantity balances, and validating that costing amounts were properly recorded for both sides. A representative query lists transfers for a specific item and period:

• SELECT TRANSFER_ID, LINE_NO, OPM_ITEM_ID, ODM_ITEM_ID, QUANTITY, QUANTITY_UM FROM GMI.GMI_DISCRETE_TRANSFER_LINES WHERE OPM_ITEM_ID = :item_id AND DELETE_MARK = 0 ORDER BY TRANSFER_ID, LINE_NO;
• Join to the header table (or to GMI_DISCRETE_TRANSFER_HEADERS if present) on TRANSFER_ID to obtain transfer date and status.
• Aggregate ODM_PRIMARY_QUANTITY by ODM_INV_ORGANIZATION_ID and ODM_PERIOD_ID to reconcile Discrete inventory receipt totals.
• Filter on LINE_ID to isolate individual lines for correction when a transfer is partially processed.

Related Objects

The following objects are the most significant join partners or dependencies:

• GMI_DISCRETE_TRANSFER_HEADERS — parent table joined on TRANSFER_ID, supplying transfer-level context.
• GMI_ITEMS (OPM item master) — referenced via OPM_ITEM_ID.
• GMI_LOTS — referenced via OPM_LOT_ID for source lot attributes.
• MTL_SYSTEM_ITEMS_B (Discrete item master) — referenced via ODM_ITEM_ID.
• MTL_LOT_NUMBERS — referenced for Discrete lot information via ODM_LOT_NUMBER.
• ORG_ORGANIZATION_DEFINITIONS — resolves ODM_INV_ORGANIZATION_ID to organization names.
• GL_CODE_COMBINATIONS — resolves charge account identifiers on both OPM and ODM sides.