Search Results gmd_ss_material_sources_pk

Overview

GMD_SS_MATERIAL_SOURCES is a Process Manufacturing Product Development table in the GMD schema that stores the material sources associated with stability studies. A stability study establishes the conditions and duration under which samples of a product or material are monitored for quality attributes over time. The material sources records define the specific plant, batch, lot, recipe, and sampling event from which the stability samples were drawn, thereby anchoring each study to the actual production or laboratory material that is being monitored.

The table is registered as VALID in Oracle EBS 12.1.1 and 12.2.2 and is owned by GMD. Its primary key is GMD_SS_MATERIAL_SOURCES_PK, defined on the SOURCE_ID column. The heuristic Data Vault classification mined from the foreign key structure is standalone, which suggests a modeling recommendation that this object behaves as an independent entity rather than being subsumed into a broader hub or satellite construct. In practical ETRM designs, it functions as a detail table linked to the parent stability study header.

Key Information Stored

The table contains fifty-four documented columns. The most significant include the following:

SOURCE_ID — the surrogate primary key, uniquely identifying each material source row.
SS_ID — foreign key to GMD_STABILITY_STUDIES_B, linking the material source to its parent stability study.
RECIPE_ID — foreign key to GMD_RECIPES_B, identifying the recipe used to produce the material.
SAMPLING_EVENT_ID — foreign key to GMD_SAMPLING_EVENTS, tying the source to the sampling activity that generated the sample.
PLANT_CODE — the manufacturing or laboratory plant where the material originated.
BATCH_ID and BATCH_ID-related fields — identifying the production batch.
LOT_ID, LOT_NO, and LOT_NUMBER — lot identification values for traceability.
YIELD_DATE — the date on which the batch or lot yield occurred.
SAMPLE_QTY and SAMPLE_QTY_UOM (with SAMPLE_QUANTITY_UOM) — the quantity and unit of measure of the sample taken.
RECIPE_NO — the recipe number for display and reporting convenience.
TEXT_CODE — a descriptive or reference code associated with the source.
SOURCE_ORGANIZATION_ID — the inventory organization owning the source material.
MIGRATED_IND — indicates whether the row was migrated from a legacy system.
ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the standard Oracle flexfield descriptive columns.
DELETE_MARK and the standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — supporting soft deletion and audit tracking.

The only documented unique index is the primary key on SOURCE_ID; no additional business-key unique indexes are listed, although SS_ID combined with batch and lot attributes commonly forms a logical business key.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all material sources for a given stability study, tracing a lot back to its stability studies, and reconciling sample quantities by plant or organization. A representative query joining the parent study follows:

SELECT s.SOURCE_ID, s.SS_ID, s.PLANT_CODE, s.BATCH_ID, s.LOT_NO, s.SAMPLE_QTY, s.SAMPLE_QTY_UOM FROM GMD_SS_MATERIAL_SOURCES s WHERE s.SS_ID = :study_id AND NVL(s.DELETE_MARK, 0) = 0;
Joining to GMD_RECIPES_B on RECIPE_ID to report the recipe associated with each stability sample.
Joining to GMD_SAMPLING_EVENTS on SAMPLING_EVENT_ID to analyze sampling frequency versus material sources.

Related Objects

GMD_STABILITY_STUDIES_B — parent header, joined on SS_ID.
GMD_RECIPES_B — recipe definition, joined on RECIPE_ID.
GMD_SAMPLING_EVENTS — sampling activity, joined on SAMPLING_EVENT_ID.

These relationships reflect the documented foreign keys and establish GMD_SS_MATERIAL_SOURCES as the traceability detail for stability studies within Process Manufacturing Product Development.

INDEX: GMD.GMD_SS_MATERIAL_SOURCES_PK 12.2.2
owner:GMD, object_type:INDEX, object_name:GMD_SS_MATERIAL_SOURCES_PK, status:VALID,
Table: GMD_SS_MATERIAL_SOURCES 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_SS_MATERIAL_SOURCES, object_name:GMD_SS_MATERIAL_SOURCES, status:VALID, product: GMD - Process Manufacturing Product Development , description: Stability Study Material Sources , implementation_dba_data: GMD.GMD_SS_MATERIAL_SOURCES ,
Table: GMD_SS_MATERIAL_SOURCES 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_SS_MATERIAL_SOURCES, object_name:GMD_SS_MATERIAL_SOURCES, status:VALID, product: GMD - Process Manufacturing Product Development , description: Stability Study Material Sources , implementation_dba_data: GMD.GMD_SS_MATERIAL_SOURCES ,
INDEX: GMD.GMD_SS_MATERIAL_SOURCES_PK 12.1.1
owner:GMD, object_type:INDEX, object_name:GMD_SS_MATERIAL_SOURCES_PK, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
TABLE: GMD.GMD_SS_MATERIAL_SOURCES 12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_SS_MATERIAL_SOURCES, object_name:GMD_SS_MATERIAL_SOURCES, status:VALID,
TABLE: GMD.GMD_SS_MATERIAL_SOURCES 12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_SS_MATERIAL_SOURCES, object_name:GMD_SS_MATERIAL_SOURCES, status:VALID,
eTRM - GMD Tables and Views 12.2.2
description: QC Module Text Lines. Descriptive text for all tables in this module. ,
eTRM - GMD Tables and Views 12.1.1
description: QC Module Text Lines. Descriptive text for all tables in this module. ,
eTRM - GMD Tables and Views 12.1.1
description: QC Module Text Lines. Descriptive text for all tables in this module. ,
eTRM - GMD Tables and Views 12.2.2
description: QC Module Text Lines. Descriptive text for all tables in this module. ,