Results for “lm_item_dat”

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

Overview

LM_ITEM_DAT is the laboratory management item data table within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). It stores quality and laboratory specification data captured against specific inventory items, lots, and formulas, linking technical parameters to the materials they describe. The table functions as the operational intersection between quality specifications defined in laboratory technical headers and the physical inventory records maintained in the Oracle Inventory tables.

The ETRM metadata records that the table is not implemented in this database instance. This status is consistent with installations that have not licensed or configured the Process Manufacturing Product Development laboratory management functionality. In environments where the module is active, LM_ITEM_DAT provides the persistence layer for technical parameter values recorded per item, lot, and formula combination.

The heuristic Data Vault classification mined from the foreign key structure is link. This suggests the table should be modeled as an associative structure resolving relationships among items, lots, formulas, and technical parameter definitions, rather than as a standalone descriptive hub. Because the metadata labels this classification as heuristic, it is best treated as a modeling suggestion, subject to validation against the actual application usage and reporting requirements.

Key Information Stored

The table operates under two documented keys. LM_ITEM_DAT_PK is the surrogate primary key defined on LM_ITEM_DAT_ID, a system-generated identifier that uniquely distinguishes each row. LM_ITEM_DAT_U1 is a unique index that serves as the principal business-key candidate, defined across ORGN_CODE, ITEM_ID, LOT_ID, FORMULA_ID, and TECH_PARM_NAME. This composite uniqueness constraint enforces that only one value may exist per organization, item, lot, formula, and technical parameter combination.

• LM_ITEM_DAT_ID — Surrogate primary key; system-assigned row identifier.
• ORGN_CODE — Organization code, establishing the multi-org context for the specification record.
• ITEM_ID — Reference to the inventory item in the item master.
• LOT_ID — Reference to the specific lot when parameter values are lot-specific rather than item-level.
• FORMULA_ID — Reference to the formula associated with the technical parameter value.
• TECH_PARM_NAME — The technical parameter name; identifies which specification or test the row records.
• LAB_TYPE — Laboratory type, joining to the technical header definition.
• TEXT_CODE — Text code reference joining to the text header table, supporting descriptive or coded results.

Common Use Cases and Queries

Reporting and integration scenarios typically retrieve technical parameter values for a given item or lot, compare specification results across organizations, and expose laboratory data to quality management dashboards. A common query pattern joins LM_ITEM_DAT to the item, lot, and formula masters using the documented foreign key columns.

• Retrieve all technical parameters recorded for a specific item in an organization by filtering on ORGN_CODE and ITEM_ID, then joining TECH_PARM_NAME to LM_TECH_HDR.
• Report lot-level quality results by joining LM_ITEM_DAT to IC_LOTS_MST and IC_ITEM_MST on ITEM_ID and LOT_ID.
• Trace formula-linked specifications by joining FORMULA_ID to LM_FORM_MST.
• Resolve descriptive or coded parameter results by joining TEXT_CODE to LM_TEXT_HDR.
• Extract change and audit data by driving lookups through the LM_ITEM_DAT_U1 composite unique key.

Related Objects

The documented foreign keys anchor LM_ITEM_DAT to several significant tables across inventory and process manufacturing.

• IC_ITEM_MST — Joined on ITEM_ID; the primary item master.
• IC_ITEM_MST_B — Joined on ITEM_ID; the item master baseline table.
• IC_LOTS_MST — Joined on ITEM_ID and LOT_ID; the lot master.
• LM_FORM_MST — Joined on FORMULA_ID; the formula master.
• LM_TECH_HDR — Joined on LAB_TYPE and TECH_PARM_NAME; the technical parameter header.
• LM_TEXT_HDR — Joined on TEXT_CODE; the text header definition.

Collectively these relationships position LM_ITEM_DAT as the associative record that binds laboratory technical results to the operational inventory, lot, and formula entities they describe.