Results for “valid_ans”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
LM_TECH_DTL is a table owned by the GMD schema within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). Its documented purpose is to store the valid values for technical parameters, acting as the enumerated value set consulted whenever a technical specification or quality result must be validated against an approved list. In practice, the table functions as a controlled vocabulary layer: parent technical header records define which parameters exist, and LM_TECH_DTL defines which answers are legally acceptable for each of those parameters within a given laboratory type, organization, and textual reference context.
Under the heuristic Data Vault classification mined from its foreign key structure, LM_TECH_DTL is best modeled as a link entity. This classification reflects that the table primarily materializes relationships between independent business concepts — a technical parameter, a laboratory type, and a text code — rather than serving as a standalone hub of a single business key or as a descriptive satellite. Modelers should treat the classification as a suggestion; the composite primary key and multiple outbound foreign keys are consistent with link semantics.
Key Information Stored
The documented physical schema contains 14 columns. The most significant are listed below.
- TECH_PARM_ID — Surrogate identifier for the technical parameter. It participates in the composite primary key LM_TECH_DTL_PK and links the detail row to its parameter definition.
- VALID_ANS — The valid answer or value permitted for the associated parameter. It is the second component of the composite primary key, meaning the uniqueness of a row is defined by parameter plus permitted answer.
- LAB_TYPE — Laboratory type, carrying a foreign key to LM_TECH_HDR. It scopes which valid answers apply to which laboratory context.
- TECH_PARM_NAME — The technical parameter name, also resolving through the LM_TECH_HDR relationship, providing a denormalized handle to the parameter descriptor.
- TEXT_CODE — Foreign key to LM_TEXT_HDR, tying the valid answer to reusable text or coded reference content.
- ORGANIZATION_ID — Organization context, supporting multi-org partitioning of valid value sets.
- ORGN_CODE — The organization code, a business-friendly counterpart to the organization identifier.
- DELETE_MARK — Soft-delete flag, standard in Process Manufacturing tables, indicating logically removed rows.
- TRANS_CNT — Transaction counter used for concurrency and change tracking.
- CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing who created and last modified each valid value entry.
The business-key candidate is the pair (TECH_PARM_ID, VALID_ANS), which the primary key enforces. TECH_PARM_ID alone is a foreign-key-style surrogate drawn from the parameter definition, not a unique key of this table.
Common Use Cases and Queries
LM_TECH_DTL is consulted whenever a specification, quality result, or laboratory value must be validated against the approved answer list for a parameter. Typical reporting and validation patterns include retrieving all permitted answers for a parameter, checking whether a submitted result is valid, and enumerating the valid value set for a laboratory type across organizations.
A representative validation query:
SELECT d.TECH_PARM_ID, d.VALID_ANS, d.ORGN_CODE FROM GMD.LM_TECH_DTL d WHERE d.TECH_PARM_ID = :p_parm AND d.DELETE_MARK = 0 AND d.ORGANIZATION_ID = :p_org;SELECT COUNT(*) FROM GMD.LM_TECH_DTL WHERE TECH_PARM_ID = :p_parm AND VALID_ANS = :p_answer AND DELETE_MARK = 0;
Because the table is a link, joins to LM_TECH_HDR and LM_TEXT_HDR are routine in any query that needs the parameter description or the reference text behind an answer.
Related Objects
- LM_TECH_HDR — Referenced via LM_TECH_DTL.LAB_TYPE and LM_TECH_DTL.TECH_PARM_NAME; supplies the laboratory type and technical parameter header context for each valid answer.
- LM_TEXT_HDR — Referenced via LM_TECH_DTL.TEXT_CODE; provides the reusable text/code definition behind a valid answer.
- LM_TECH_DTL_PK — The composite primary key constraint over (TECH_PARM_ID, VALID_ANS), the object implied by the user's search term; it guarantees uniqueness of each parameter/answer pair.
- GMD technical specification tables — Specification and quality result entries that resolve their permitted values against LM_TECH_DTL at validation time.
- Multi-org organization views — Reporting constructs that filter LM_TECH_DTL by ORGANIZATION_ID and ORGN_CODE.
The FK relationships documented above are the authoritative join paths; any dependent query should anchor on TECH_PARM_ID and VALID_ANS when reconciling valid values against parent technical parameter definitions.
-
Valid values for technical parameters
-
Valid values for technical parameters
-
VIEW: GMD.LM_TECH_DTL# 12.2.2
-
VIEW: GMD.LM_TECH_DTL# 12.2.2
-
TABLE: GMD.LM_TECH_DTL 12.2.2
-
TABLE: GMD.LM_TECH_DTL 12.1.1
-
eTRM - GMD Tables and Views 12.2.2
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.1.1
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.1.1
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.2.2
QC Module Text Lines. Descriptive text for all tables in this module.