GMD Tables (182)

GMD - Process Manufacturing Product Development — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
FM_ARES_MST	14	Operation-specific alternate resource factors
FM_CONF_TBL	14	FM effectivity configuration. Controls how formula effectivities are created.
FM_FMCT_CLS	10	Formula control classes -NOT USED-
FM_FORM_MST_B	60	Formula header base table
FM_FORM_MST_TL	10	Formula header translation table
FM_IBOM_DTL	18	Detail table for Indented Bill of Materials Report
FM_IBOM_HDR	25	Header table used for Indented Bill Of Materials report
FM_MATL_DTL	66	Formula material details - contains products,byproducts and ingredient information
FM_ROUT_DEP	19	Routing step dependencies
FM_ROUT_DTL	46	Routing details
FM_ROUT_MTL	10	Routing Steps to Formula Lines Association
FM_TEXT_HDR	6	Table used to store text types for Formula Model
FM_TEXT_TBL_TL	13	FM Module Text Lines. Descriptive text for all tables in this module.
GMD_ACTIONS_B	41	OPM Quality Actions
GMD_ACTIONS_TL	9	OPM Quality Translation table
GMD_ACTIVITIES_B	11	Activities base table. Defines activities which are performed in operations.
GMD_ACTIVITIES_TL	9	Activities Translation Table
GMD_CHANGE_DISPOSITION	17	Change Disposition form history table
GMD_CHANGE_LOTS	9	Change Disposition form history - Lots affected
GMD_COA_DETAILS	21	Certificate of Analysis report details information
GMD_COA_HEADERS	52	Certificate of Analysis report header information
GMD_COA_RSLT_TEXT	5	Certificate of Analysis result text
GMD_COA_SPEC_HDR_TEXT	5	Certificate of Analysis report header text information
GMD_COA_SPEC_TEXT	5	Certificate of Analysis Specification text
GMD_COMPOSITE_RESULTS	59	OPM Quality Composite results
GMD_COMPOSITE_RESULT_ASSOC	8	OPM Quality Composite Result Association
GMD_COMPOSITE_SPEC_DISP	12	OPM Quality Composite Specification Display
GMD_COMPOSITIONAL_REQS	14	LCF - Compositional Requirements Table
GMD_CUSTOMER_SPEC_VRS	60	OPM Work-in-Process Specification validity rules
GMD_CUSTOMER_TESTS_B	9	Customer Tests
GMD_CUSTOMER_TESTS_TL	10	Customer Tests Translation table
GMD_EVENT_SPEC_DISP	12	OPM Quality Event Specification Display
GMD_FORMULATION_SPECS	25	LCF - Formulation Specification table
GMD_FORMULA_ANALYSIS_DTL	17	Formula analysis detail table
GMD_FORMULA_ANALYSIS_HDR	13	Formula Analysis Header table.
GMD_FORMULA_CLASS_B	10	Formula classes base table - used to group formulas.
GMD_FORMULA_CLASS_TL	9	Formula Class translation table
GMD_FORMULA_SECURITY	14	Formula Security table
GMD_FORMULA_SECURITY_TEMP	10
GMD_FORMULA_SUBSTITUTION	9	Formula Substitution table holds the valid formulas which are valid for the context item substitution
GMD_GRADES_B	42	QC grade code master.
GMD_GRADES_TL	9	QC Units Translation Table
GMD_HOLD_REASONS_B	39	OPM Quality Hold reasons
GMD_HOLD_REASONS_TL	9	OPM Quality Hold Reasons
GMD_INVENTORY_SPEC_VRS	72	OPM Quality Inventory Specification Validity Rules
GMD_ITEM_SUBSTITUTION_DTL	12	Substitution Detail table holds the replacement item(s) for the original item in the Substitution Table
GMD_ITEM_SUBSTITUTION_HDR_B	51	This is master table for the Item Substitution, which holds the item substitution details
GMD_ITEM_SUBSTITUTION_HDR_TL	9	This is translate table for the Item Substitution
GMD_LAB_FORMULA_ASSOC	9	Association for lab values that get converted to formulas
GMD_LAB_ORGN_ASSOC	2	Association for lab types that get converted to orgn codes
GMD_LCF_CATEGORY_DTL_GTMP	4
GMD_LCF_CATEGORY_HDR_GTMP	6
GMD_LCF_DETAILS_GTMP	39
GMD_LCF_EXTERNAL_COST	14	Source for, external cost values
GMD_LCF_TECH_DATA_GTMP	6
GMD_MASS_RESULTS_GT	83
GMD_MASS_SAMPLES	2	Sample IDs for Mass Results Entry
GMD_MATERIAL_DETAILS_GTMP	72
GMD_MATERIAL_HEADER_GTMP	25
GMD_MATERIAL_REQS	14	LCF - Material Requirements Table
GMD_MIGRATE_PARMS	6	Quality Migration Setup Table
GMD_MIGRATION	6	Stores error messages during data migration from 11i to 11i+
GMD_MONITORING_SPEC_VRS	57	OPM Quality for Monitoring Spec Validity Rule
GMD_MSNR_RESULTS	8	GMD Mass Search and Replace table for storing query results
GMD_OPERATIONS_B	54	Operations base table.
GMD_OPERATIONS_TL	9	Operations translation table.
GMD_OPERATION_ACTIVITIES	47	Operation Activity details
GMD_OPERATION_CLASS_B	10	Operation class base table. Used to group operations.
GMD_OPERATION_CLASS_TL	9	Translation table for Operation Class
GMD_OPERATION_RESOURCES	61	Operation Resource details
GMD_OPRN_PROCESS_PARAMETERS	11	Table associating process parameters to operation resource
GMD_OPTIMIZER_HDR_GTMP	7
GMD_OPTIMIZER_LINE_GTMP	32
GMD_PARAMETERS	12	Stores the default statuses for Organization
GMD_PARAMETERS_DTL	10	GMD parameters line table
GMD_PARAMETERS_HDR	9	used instead of profiles
GMD_PARSED_EXPRESSION	11	This table stores the parsed expression for the technical parameter
GMD_PROCESS_LOSS	9	Routing Process Loss
GMD_QC_ASSAY_CLASS	41	Quality Assay Class. Assay classes are quality test groupings.
GMD_QC_SPEC_MST_GTMP	101
GMD_QC_STATUS_B	43	OPM Quality Status
GMD_QC_STATUS_NEXT	11	OPM Quality target Status codes
GMD_QC_STATUS_TL	12	OPM Quality Status translation
GMD_QC_TESTS_B	64	OPM QC Test
GMD_QC_TESTS_TL	9	OPM QC Test
GMD_QC_TEST_VALUES_B	44	OPM Test values
GMD_QC_TEST_VALUES_TL	10	OPM Test values Translation table
GMD_QUALITY_CONFIG	38	OPM Quality Configuration
GMD_RECIPES_B	59	Recipe header base table.
GMD_RECIPES_TL	9	Recipe Translation Table
GMD_RECIPE_CUSTOMERS	11	This table stores recipe customer data
GMD_RECIPE_EFF_ASSOC	27	Recipe-Effectivity Association Table
GMD_RECIPE_GENERATION	22	Recipe Generation for automatic creation
GMD_RECIPE_ORGN_ACTIVITIES	43	This table stores updates to operation activity details at the recipe level.
GMD_RECIPE_ORGN_RESOURCES	56	This table stores updates to operation resources at the recipe level.
GMD_RECIPE_PROCESS_LOSS	14	Stores process loss at the recipe level.
GMD_RECIPE_PROCESS_PARAMETERS	15	Table associating process parameters to Recipe orgn resource
GMD_RECIPE_ROUTING_STEPS	46	This table stores updates to routing steps at the recipe level.
GMD_RECIPE_STEP_MATERIALS	43	This table stores step material information at the recipe level.
GMD_RECIPE_VALIDITY_RULES	61	Stores quantity and effective dates for variou uses and/or organizations (formerly effectivities).
GMD_REPLACE	2	Used for Mass Search and Replace
GMD_RESULTS	75	OPM Quality Results
GMD_ROUTINGS_B	60	Routing header base table.
GMD_ROUTINGS_TL	9	Routings header translations table
GMD_ROUTING_CLASS_B	13	Routing class base table - used to group routings.
GMD_ROUTING_CLASS_TL	9	Translation Table for routing class
GMD_SAMPLES	119	OPM Quality Samples
GMD_SAMPLES_LAB	39	OPM Quality Samples Lab
GMD_SAMPLE_REPLICATES_GT	5
GMD_SAMPLE_SPEC_DISP	9	OPM Quality Sample Specification Display
GMD_SAMPLING_EVENTS	69	OPM Quality Sampling Event
GMD_SAMPLING_PLANS_B	52	OPM Quality Sampling Plan
GMD_SAMPLING_PLANS_TL	9	OPM Quality Sampling Plan translation table
GMD_SECURITY_CONTROL	10	Defines the level Formula Security is contorlled per OPM Organization
GMD_SECURITY_PROFILES	15	Security Profiles give access to the object specified data. For example, a Security Profile gives access to a User for Formula data.
GMD_SPECIFICATIONS_B	55	OPM Quality Specifications
GMD_SPECIFICATIONS_TL	9	OPM Quality Specifications Translation
GMD_SPECIFICATION_ATTRIBUTES	9	LCF - Formulation Specification Attributes Table
GMD_SPEC_MAPPING	8	Table used to map old spec definition to new definition
GMD_SPEC_MAPPING_GTMP	8
GMD_SPEC_RESULTS	15	OPM Quality Specification Results
GMD_SPEC_TESTS_B	82	OPM Specification tests
GMD_SPEC_TESTS_TL	10	OPM Specification tests
GMD_SPREAD_ERRORS_GTMP	14
GMD_SS_MATERIAL_SOURCES	54	Stability Study Material Sources
GMD_SS_STORAGE_HISTORY	49	Stability Study Variant Storage History
GMD_SS_STORAGE_PACKAGE	49	Stability Study Variant Storage Package
GMD_SS_TIME_POINTS	54	Stability Study Time Points
GMD_SS_VARIANTS	63	Stability Study Variants
GMD_STABILITY_SPEC_VRS	12	Stability Study Validity Rules
GMD_STABILITY_STUDIES_B	68	Stability Study
GMD_STABILITY_STUDIES_TL	9	Stability Study Translation table
GMD_STATUS_B	42	Base table for status code definitions.
GMD_STATUS_NEXT	10	This table stores information in regards to which status codes the current status can be changed to.
GMD_STATUS_TL	11	Status Code Translation Table
GMD_STORAGE_PLANS_B	41	Stability Study Storage Plan
GMD_STORAGE_PLANS_TL	9	Stability Study Storage Plan Translation table
GMD_STORAGE_PLAN_DETAILS	48	Stability Study Storage Plan Details
GMD_SUPPLIER_SPEC_VRS	68	OPM Work-in-Process Specification validity rules
GMD_TECHNICAL_DATA_DTL	12	Technical Parameter data detail
GMD_TECHNICAL_DATA_HDR	17	Technical Parameter data header
GMD_TECHNICAL_REQS	11	LCF - Technical Requirements Table
GMD_TECHNICAL_SEQUENCE_DTL	9	Technical Parameter Sort Sequence Detail Table
GMD_TECHNICAL_SEQUENCE_HDR	13	Technical Parameter Sort Sequence Table
GMD_TECH_PARAMETERS_B	59	Technical parameters header base table
GMD_TECH_PARAMETERS_TL	11	Technical parameters header translation table
GMD_TESTS_B	62
GMD_TESTS_TL	10
GMD_TEST_CLASSES_B	40	OPM Quality Test Classes
GMD_TEST_CLASSES_TL	9	OPM Quality test classes translation
GMD_TEST_GROUP_GT	11
GMD_TEST_INTERVAL_PLANS_B	42	Base table for test interval plans
GMD_TEST_INTERVAL_PLANS_TL	9	Translation table for test interval plans
GMD_TEST_INTERVAL_PLAN_PERIODS	48	Table for test interval plan periods
GMD_TEST_METHODS_B	56	OPM Quality Test Methods
GMD_TEST_METHODS_TL	10	OPM Quality test methods
GMD_TEST_VALUES_B	48
GMD_TEST_VALUES_TL	11
GMD_UNITS_B	41	Units of measure for QC assays.
GMD_UNITS_TL	9	QC Units Translation Table
GMD_UOM_CONVERSIONS	23	UOM Conversions Based on Quality Results.
GMD_VAL_RULE_GTMP	61
GMD_VPD_SECURITY	6	Reflects whether NPD Security is Active or Inactive
GMD_WIP_SPEC_VRS	83	OPM Work-in-Process Specification validity rules
LM_FORM_DAT	16	OBSOLETE as of 11.5.6 (OPM PF.G)
LM_FORM_DTL	51	OBSOLETE as of 11.5.6 (OPM PF.G)
LM_FORM_MST	49	OBSOLETE as of 11.5.6 (OPM PF.G)
LM_LTYP_MST	44	Laboratory type master
LM_SPRD_DTL	44	Table to store Lab Spreadsheet detail
LM_SPRD_FLS	18	Laboratory Spreadsheets files
LM_SPRD_PRM	21	Table used to store the technical paramter definitions that belong with the spreadsheet
LM_SPRD_TEC	16	Table used to store the values of the technical parameters on the spreadsheet
LM_TECH_DTL	14	Valid values for technical parameters
LM_TEXT_HDR	6	Holds text types defined for Lab module
LM_TEXT_TBL_TL	13	LM Module Text Lines. Descriptive text for all tables in this module.
QC_ACTN_MST	43	QC action codes.
QC_HRES_MST	42	QC hold reason code master.
QC_RSLT_MST	78	QC results master.
QC_SMPL_MST	76	QC sample master.
QC_SPEC_MST	101	QC specification master.
QC_TEXT_HDR	6	Holds text types defined for QC module
QC_TEXT_TBL_TL	13	QC Module Text Lines. Descriptive text for all tables in this module.