Search Results lm_item_dat




Overview
Explore in AI Chat

Overview

The LM_ITEM_DAT table is a core data repository within the GMD (Process Manufacturing Product Development) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is designed to store laboratory management item data, serving as a central table that links key manufacturing entities—specifically items, lots, formulas, and technical parameters—within the context of laboratory analysis and development. Its primary role is to establish and maintain the relationships between these discrete master data elements, enabling comprehensive tracking and management of materials throughout the product development lifecycle in a process manufacturing environment.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. Its primary key (LM_ITEM_DAT_U1) is a composite key, uniquely identifying a record through a combination of five columns: ORGN_CODE, ITEM_ID, LOT_ID, FORMULA_ID, and TECH_PARM_NAME. This indicates that the table stores specific data points for a unique intersection of organization, inventory item, lot number, formula, and a technical parameter name. The column LM_ITEM_DAT_ID serves as an alternate primary key (LM_ITEM_DAT_PK). Other significant columns include LAB_TYPE and TEXT_CODE, which link to laboratory technical headers and text headers, respectively. The metadata explicitly states this table is "Not implemented in this database," which typically indicates it is a delivered seed data table or a legacy structure not populated in a standard, fresh installation.

Common Use Cases and Queries

This table supports scenarios where laboratory results or specifications must be queried or reported against a specific combination of item, lot, and formula. A common use case is retrieving all laboratory parameters defined for a particular production lot of a finished good. A typical query would join LM_ITEM_DAT to its referenced master tables to fetch descriptive information.

  • Sample Query: To list technical parameters for a specific item and lot, one might use: SELECT dat.tech_parm_name, hdr.description FROM lm_item_dat dat, lm_tech_hdr hdr WHERE dat.lab_type = hdr.lab_type AND dat.tech_parm_name = hdr.tech_parm_name AND dat.item_id = :p_item_id AND dat.lot_id = :p_lot_id AND dat.orgn_code = :p_org_code;
  • Reporting Use Case: Generating a laboratory data sheet that consolidates item details from IC_ITEM_MST, lot details from IC_LOTS_MST, and associated formula and parameter data via joins through LM_ITEM_DAT.

Related Objects

LM_ITEM_DAT is a hub table with multiple foreign key dependencies, as documented in the ETRM. Its integrity is tied to several master tables:

  • IC_ITEM_MST_B / IC_ITEM_MST: References the ITEM_ID to the Inventory Catalog (Item Master) tables.
  • IC_LOTS_MST: References both ITEM_ID and LOT_ID to the Lot Master table.
  • LM_FORM_MST: References the FORMULA_ID to the Formula Master table.
  • LM_TECH_HDR: References LAB_TYPE and TECH_PARM_NAME to the Laboratory Technical Header.
  • LM_TEXT_HDR: References TEXT_CODE to the Laboratory Text Header, likely for storing descriptive notes or specifications.

These relationships position LM_ITEM_DAT as a critical junction table for integrating inventory, lot control, and process development data within the GMD laboratory management framework.