Search Results lm_sprd_dtl




Overview
Explore in AI Chat

Overview

The LM_SPRD_DTL table is a core data structure within Oracle E-Business Suite (EBS) Process Manufacturing (Product Development) module. Its primary function is to store detailed line-level information for a Lab Spreadsheet, a key document used in the formulation and development of products, recipes, and processes. This table acts as the transactional child record to the header information stored in LM_SPRD_FLS, capturing the specific ingredients, components, or instructions that constitute a formulation or experimental batch being designed or analyzed within the laboratory management system.

Key Information Stored

The table's structure is designed to capture the composition and properties of a lab spreadsheet. The primary key is the LINE_ID column, which uniquely identifies each row. Based on the documented foreign key relationships, other critical columns include SPRD_ID, which links the detail line to its parent header record in LM_SPRD_FLS. The ITEM_ID column stores the identifier for the specific inventory item (raw material, intermediate, or product) used on the line, linked to IC_ITEM_MST and IC_ITEM_MST_B. LAB_TYPE references a code from LM_LTYP_MST, classifying the line's purpose within the lab context. The table also stores unit of measure information (ITEM_UM, linked to SY_UOMS_MST) for the item quantity and TEXT_CODE (linked to LM_TEXT_HDR) for associating descriptive notes or specifications.

Common Use Cases and Queries

This table is central to queries involving the detailed composition of lab formulations. Common use cases include generating a Bill of Materials for a developmental recipe, analyzing material usage across experiments, and creating audit trails for product development. A typical query would join LM_SPRD_DTL to its related tables to retrieve a comprehensive spreadsheet view.

  • Retrieve Spreadsheet Details: SELECT d.*, i.item_no, h.spreadsheet_name FROM gmd.lm_sprd_dtl d, gmd.lm_sprd_fls h, ic_item_mst i WHERE d.sprd_id = h.sprd_id AND d.item_id = i.item_id AND h.sprd_id = :p_spreadsheet_id ORDER BY d.line_id;
  • Component Analysis: Queries aggregating quantities by ITEM_ID across multiple spreadsheets to understand raw material demand in R&D.
  • Data Migration/Integration: This table is a critical target when loading historical formulation data or integrating with external Laboratory Information Management Systems (LIMS).

Related Objects

LM_SPRD_DTL has integral relationships with several key EBS tables, as defined by its foreign keys. The primary parent table is LM_SPRD_FLS, which stores the spreadsheet header. For item master data, it references both IC_ITEM_MST and IC_ITEM_MST_B. Laboratory-specific types are validated against LM_LTYP_MST, while units of measure are validated against SY_UOMS_MST. Descriptive text is managed via LM_TEXT_HDR. Given its role, this table is also likely referenced by various Process Manufacturing product development forms, reports, and APIs (e.g., in the GMD or LM schemas) that create, update, or query lab spreadsheet details.