Oracle Process Manufacturing Product Development and Process ExecutionTables, Views

	Oracle Process Manufacturing Process Execution – List of database tables GME_BATCH_HEADER GME_BATCH_HEADER_MIG GME_BATCH_HISTORY GME_BATCH_MAPPING_MIG GME_BATCH_SALES_ORDERS GME_BATCH_STEPS GME_BATCH_STEPS_MIG GME_BATCH_STEP_ACTIVITIES GME_BATCH_STEP_ACTIV_MIG GME_BATCH_STEP_CHARGES GME_BATCH_STEP_CHARGES_MIG GME_BATCH_STEP_DEPENDENCIES GME_BATCH_STEP_DEP_MIG GME_BATCH_STEP_ITEMS GME_BATCH_STEP_ITEMS_MIG GME_BATCH_STEP_RESOURCES GME_BATCH_STEP_RESOURCES_MIG GME_BATCH_STEP_RSRC_SUMMARY GME_BATCH_STEP_TRANSFERS GME_BATCH_STEP_TRANSFERS_MIG GME_BATCH_TXNS_MIG GME_ERES_GTMP GME_EXCEPTIONS_GTMP GME_GANTT_DOCUMENT_FILTER GME_INVENTORY_TXNS_GTMP GME_LAB_BATCH_LOTS GME_MATERIAL_DETAILS GME_MATERIAL_DETAILS_MIG GME_MATERIAL_DISPENSING_GTMP GME_MIGRATION_CONTROL GME_PARAMETERS GME_PENDING_PRODUCT_LOTS GME_PROCESS_PARAMETERS GME_PROCESS_PARAMETERS_MIG GME_RESOURCE_TXNS GME_RESOURCE_TXNS_GTMP GME_RESOURCE_TXNS_MIG GME_RESOURCE_TXNS_SUMMARY GME_SCALE_DETAIL GME_TEMP_EXCEPTIONS GME_TEXT_HEADER GME_TEXT__TL GME_TRANSACTION_PAIRS GME_UNALLOCATED_ITEMS_GTMP OPM Product Development Tables:
Sl.No	VIEW NAME	DESCRIPTION
1	FM_ACTV_MST	Activity master. Defines activities which are performed in operations.
2	FM_ARES_MST	Operation-specific alternate resource factors
3	FM_CONF_TBL	FM effectivity configuration.  Controls how formula effectivities are created.
4	FM_FMCT_CLS	Formula control classes -NOT USED-
5	FM_FORM_CLS	Formula classes - used to group formulas.
6	FM_FORM_EFF	Formula/routing effectivities. Conditions under which a Formula/Routing can be used
7	FM_FORM_MST	Formula header table
8	FM_FORM_MST_B	Formula header base table
9	FM_FORM_MST_TL	Formula header translation table
10	FM_IBOM_DTL	Detail table for Indented Bill of Materials Report
11	FM_IBOM_HDR	Header table used for Indented Bill Of Materials report
12	FM_MATL_DTL	Formula material details - contains products,byproducts and ingredient information
13	FM_OPRN_CLS	Formula operation class.  Used to group operations.
14	FM_OPRN_DTL	Operation details.  Specifies the resources, activities and their usage.
15	FM_OPRN_MST	Operation  master
16	FM_ROUT_CLS	Routing class - used to group routings.
17	FM_ROUT_DEP	Routing step dependencies
18	FM_ROUT_DTL	Routing details
19	FM_ROUT_HDR	Routing header
20	FM_ROUT_MTL	Routing Steps to Formula Lines Association
21	FM_TEXT_HDR	Table used to store text types for Formula Model
22	FM_TEXT_TBL_TL	FM Module Text Lines. Descriptive text for all tables in this module.
23	GMD_ACTIONS_B	OPM Quality Actions
24	GMD_ACTIONS_TL	OPM Quality Translation table
25	GMD_ACTIVITIES_B	Activities base table. Defines activities which are performed in operations.
26	GMD_ACTIVITIES_TL	Activities Translation Table
27	GMD_CHANGE_DISPOSITION	Change Disposition form history table
28	GMD_CHANGE_LOTS	Change Disposition form history - Lots affected
29	GMD_COA_DETAILS	Certificate of Analysis report details information
30	GMD_COA_HEADERS	Certificate of Analysis report header information
31	GMD_COA_RSLT_TEXT	Certificate of Analysis result text
32	GMD_COA_SPEC_HDR_TEXT	Certificate of Analysis report header text information
33	GMD_COA_SPEC_TEXT	Certificate of Analysis Specification text
34	GMD_COMPOSITE_RESULT_ASSOC	OPM Quality Composite Result Association
35	GMD_COMPOSITE_RESULTS	OPM Quality Composite results
36	GMD_COMPOSITE_SPEC_DISP	OPM Quality Composite Specification Display
37	GMD_COMPOSITIONAL_REQS	LCF - Compositional Requirements Table
38	GMD_CUSTOMER_SPEC_VRS	OPM Work-in-Process Specification validity rules
39	GMD_CUSTOMER_TESTS_B	Customer Tests
40	GMD_CUSTOMER_TESTS_TL	Customer Tests Translation table
41	GMD_EVENT_SPEC_DISP	OPM Quality Event Specification Display
42	GMD_FORMULA_ANALYSIS_DTL	Formula analysis detail table
43	GMD_FORMULA_ANALYSIS_HDR	Formula Analysis Header table.
44	GMD_FORMULA_CLASS_B	Formula classes base table - used to group formulas.
45	GMD_FORMULA_CLASS_TL	Formula Class translation table
46	GMD_FORMULA_SECURITY	Formula Security table
47	GMD_FORMULA_SECURITY_PROFILES	Formula Security Profiles
48	GMD_FORMULA_SECURITY_TEMP
49	GMD_FORMULA_SUBSTITUTION	Formula Substitution table holds the valid formulas which are valid for the context item substitution
50	GMD_FORMULATION_SPECS	LCF - Formulation Specification table
51	GMD_GRADES_B	QC grade code master.
52	GMD_GRADES_TL	QC Units Translation Table
53	GMD_HOLD_REASONS_B	OPM Quality Hold reasons
54	GMD_HOLD_REASONS_TL	OPM Quality Hold Reasons
55	GMD_INVENTORY_SPEC_VRS	OPM Quality Inventory Specification Validity Rules
56	GMD_ITEM_SUBSTITUTION_DTL	Substitution Detail table holds the replacement item(s) for the original item in the Substitution Table
57	GMD_ITEM_SUBSTITUTION_HDR_B	This is master table for the Item Substitution, which holds the item substitution details
58	GMD_ITEM_SUBSTITUTION_HDR_TL	This is translate table for the Item Substitution
59	GMD_LAB_FORMULA_ASSOC	Association for lab values that get converted to formulas
60	GMD_LAB_ORGN_ASSOC	Association for lab types that get converted to orgn codes
61	GMD_LCF_CATEGORY_DTL_GTMP
62	GMD_LCF_CATEGORY_HDR_GTMP
63	GMD_LCF_DETAILS_GTMP
64	GMD_LCF_EXTERNAL_COST	Source for, external cost values
65	GMD_LCF_TECH_DATA_GTMP
66	GMD_MASS_RESULTS_GT
67	GMD_MASS_SAMPLES	Sample IDs for Mass Results Entry
68	GMD_MATERIAL_DETAILS_GTMP
69	GMD_MATERIAL_HEADER_GTMP
70	GMD_MATERIAL_REQS	LCF - Material Requirements Table
71	GMD_MIGRATE_PARMS	Quality Migration Setup Table
72	GMD_MIGRATION	Stores error messages during data migration from 11i to 11i+
73	GMD_MONITORING_SPEC_VRS	OPM Quality for Monitoring Spec Validity Rule
74	GMD_MSNR_RESULTS	GMD Mass Search and Replace table for storing query results
75	GMD_OPERATION_ACTIVITIES	Operation Activity details
76	GMD_OPERATION_CLASS_B	Operation class base table.  Used to group operations.
77	GMD_OPERATION_CLASS_TL	Translation table for Operation Class
78	GMD_OPERATION_RESOURCES	Operation Resource details
79	GMD_OPERATIONS_B	Operations base table.
80	GMD_OPERATIONS_TL	Operations translation table.
81	GMD_OPRN_PROCESS_PARAMETERS	Table associating process parameters to operation resource
82	GMD_OPTIMIZER_HDR_GTMP
83	GMD_OPTIMIZER_LINE_GTMP
84	GMD_PARAMETERS	Stores the default statuses for Organization
85	GMD_PARAMETERS_DTL	GMD parameters line table
86	GMD_PARAMETERS_HDR	used instead of profiles
87	GMD_PARSED_EXPRESSION	This table stores the parsed expression for the technical parameter
88	GMD_PROCESS_LOSS	Routing Process Loss
89	GMD_QC_ASSAY_CLASS	Quality Assay Class.  Assay classes are quality test groupings.
90	GMD_QC_SPEC_MST_GTMP
91	GMD_QC_STATUS_B	OPM Quality Status
92	GMD_QC_STATUS_NEXT	OPM Quality target Status codes
93	GMD_QC_STATUS_TL	OPM Quality Status translation
94	GMD_QC_TEST_VALUES_B	OPM Test values
95	GMD_QC_TEST_VALUES_TL	OPM Test values Translation table
96	GMD_QC_TESTS_B	OPM QC Test
97	GMD_QC_TESTS_TL	OPM QC Test
98	GMD_QUALITY_CONFIG	OPM Quality Configuration
99	GMD_RECIPE_CUSTOMERS	This table stores recipe customer data
100	GMD_RECIPE_EFF_ASSOC	Recipe-Effectivity Association Table
101	GMD_RECIPE_GENERATION	Recipe Generation for automatic creation
102	GMD_RECIPE_ORGN_ACTIVITIES	This table stores updates to operation activity details  at the recipe level.
103	GMD_RECIPE_ORGN_RESOURCES	This table stores updates to operation resources at the recipe level.
104	GMD_RECIPE_PROCESS_LOSS	Stores process loss at the recipe level.
105	GMD_RECIPE_PROCESS_PARAMETERS	Table associating process parameters to Recipe orgn resource
106	GMD_RECIPE_ROUTING_STEPS	This table stores updates to routing steps at the recipe level.
107	GMD_RECIPE_STEP_MATERIALS	This table stores step material information at the recipe level.
108	GMD_RECIPE_VALIDITY_RULES	Stores quantity and effective dates for variou uses and/or organizations (formerly effectivities).
109	GMD_RECIPES_B	Recipe header base table.
110	GMD_RECIPES_TL	Recipe Translation Table
111	GMD_REPLACE	Used for Mass Search and Replace
112	GMD_RESULTS	OPM Quality Results
113	GMD_ROUTING_CLASS_B	Routing class base table - used to group routings.
114	GMD_ROUTING_CLASS_TL	Translation Table for routing class
115	GMD_ROUTINGS_B	Routing header base table.
116	GMD_ROUTINGS_TL	Routings header translations table
117	GMD_SAMPLE_REPLICATES_GT
118	GMD_SAMPLE_SPEC_DISP	OPM Quality Sample Specification Display
119	GMD_SAMPLES	OPM Quality Samples
120	GMD_SAMPLES_LAB	OPM Quality Samples Lab
121	GMD_SAMPLING_EVENTS	OPM Quality Sampling Event
122	GMD_SAMPLING_PLANS_B	OPM Quality Sampling Plan
123	GMD_SAMPLING_PLANS_TL	OPM Quality Sampling Plan translation table
124	GMD_SECURITY_CONTROL	Defines the level Formula Security is contorlled per OPM Organization
125	GMD_SECURITY_PROFILES	Security Profiles give access to the object specified data.  For example, a Security Profile gives access to a User for Formula data.
126	GMD_SPEC_MAPPING	Table used to map old spec definition to new definition
127	GMD_SPEC_MAPPING_GTMP
128	GMD_SPEC_RESULTS	OPM Quality Specification Results
129	GMD_SPEC_TESTS_B	OPM Specification tests
130	GMD_SPEC_TESTS_TL	OPM Specification tests
131	GMD_SPECIFICATION_ATTRIBUTES	LCF - Formulation Specification Attributes Table
132	GMD_SPECIFICATIONS_B	OPM Quality Specifications
133	GMD_SPECIFICATIONS_TL	OPM Quality Specifications Translation
134	GMD_SPREAD_ERRORS_GTMP
135	GMD_SS_MATERIAL_SOURCES	Stability Study Material Sources
136	GMD_SS_STORAGE_HISTORY	Stability Study Variant Storage History
137	GMD_SS_STORAGE_PACKAGE	Stability Study Variant Storage Package
138	GMD_SS_TIME_POINTS	Stability Study Time Points
139	GMD_SS_VARIANTS	Stability Study Variants
140	GMD_STABILITY_SPEC_VRS	Stability Study Validity Rules
141	GMD_STABILITY_STUDIES_B	Stability Study
142	GMD_STABILITY_STUDIES_TL	Stability Study Translation table
143	GMD_STATUS_B	Base table for status code definitions.
144	GMD_STATUS_NEXT	This table stores information in regards to which status codes the current status can be changed to.
145	GMD_STATUS_TL	Status Code Translation Table
146	GMD_STORAGE_PLAN_DETAILS	Stability Study Storage Plan Details
147	GMD_STORAGE_PLANS_B	Stability Study Storage Plan
148	GMD_STORAGE_PLANS_TL	Stability Study Storage Plan Translation table
149	GMD_SUPPLIER_SPEC_VRS	OPM Work-in-Process Specification validity rules
150	GMD_TECH_PARAMETERS_B	Technical parameters header base table
151	GMD_TECH_PARAMETERS_TL	Technical parameters header translation  table
152	GMD_TECHNICAL_DATA_DTL	Technical Parameter data detail
153	GMD_TECHNICAL_DATA_HDR	Technical Parameter data header
154	GMD_TECHNICAL_REQS	LCF - Technical Requirements Table
155	GMD_TECHNICAL_SEQUENCE_DTL	Technical Parameter Sort Sequence Detail Table
156	GMD_TECHNICAL_SEQUENCE_HDR	Technical Parameter Sort Sequence Table
157	GMD_TEST_CLASSES_B	OPM Quality Test Classes
158	GMD_TEST_CLASSES_TL	OPM Quality test classes translation
159	GMD_TEST_GROUP_GT
160	GMD_TEST_INTERVAL_PLAN_PERIODS	Table for test interval plan periods
161	GMD_TEST_INTERVAL_PLANS_B	Base table for test interval plans
162	GMD_TEST_INTERVAL_PLANS_TL	Translation table for test interval plans
163	GMD_TEST_METHODS_B	OPM Quality Test Methods
164	GMD_TEST_METHODS_TL	OPM Quality test methods
165	GMD_TEST_VALUES_B
166	GMD_TEST_VALUES_TL
167	GMD_TESTS_B
168	GMD_TESTS_TL
169	GMD_UNITS_B	Units of measure for QC assays.
170	GMD_UNITS_TL	QC Units Translation Table
171	GMD_UOM_CONVERSIONS	UOM Conversions Based on Quality Results.
172	GMD_VAL_RULE_GTMP
173	GMD_VPD_SECURITY	Reflects whether NPD Security is Active or Inactive
174	GMD_WIP_SPEC_VRS	OPM Work-in-Process Specification validity rules
175	LM_FORM_DAT	OBSOLETE as of 11.5.6 (OPM PF.G)
176	LM_FORM_DTL	OBSOLETE as of 11.5.6 (OPM PF.G)
177	LM_FORM_MST	OBSOLETE as of 11.5.6 (OPM PF.G)
178	LM_ITEM_DAT	Laboratory management item data
179	LM_LTYP_MST	Laboratory type master
180	LM_PRLT_ASC	Laboratory technical parameter association
181	LM_SPRD_DTL	Table to store Lab Spreadsheet detail
182	LM_SPRD_FLS	Laboratory Spreadsheets files
183	LM_SPRD_PRM	Table used to store the technical paramter definitions that belong with the spreadsheet
184	LM_SPRD_TEC	Table used to store the values of the technical parameters on the spreadsheet
185	LM_TECH_DTL	Valid values for technical parameters
186	LM_TECH_HDR	Technical parameters header
187	LM_TEXT_HDR	Holds text types defined for Lab module
188	LM_TEXT_TBL_TL	LM Module Text Lines. Descriptive text for all tables in this module.
189	QC_ACTN_MST	QC action codes.
190	QC_ASSY_TYP	QC assay master.
191	QC_ASSY_VAL	Valid QC assay values.
192	QC_GRAD_MST	QC grade code master.
193	QC_HRES_MST	QC hold reason code master.
194	QC_RSLT_MST	QC results master.
195	QC_SMPL_MST	QC sample master.
196	QC_SPEC_MST	QC specification master.
197	QC_TEXT_HDR	Holds text types defined for QC module
198	QC_TEXT_TBL_TL	QC Module Text Lines. Descriptive text for all tables in this module.
199	QC_UNIT_MST	Units of measure for QC assays.
200
201	OPM Product Development Views:
202	VIEW NAME	DESCRIPTION
203	FM_FORM_EFF_VW1	Item Effectivity View
204	FM_FORM_EFF_VW3
205	FM_FORM_EFF_VW3_OLD	Item Effectivity view
206	FM_FORM_MST_V1	Formula Numbers View
207	FM_FORM_MST_V2	Formula Version View
208	FM_FORM_MST_VL	Form Version view
209	FM_OPRN_DTL_VW1	Operation detail view
210	FM_OPRN_MST_VW1	Operation master view
211	FM_ROUT_DTL_V1	Routingstep Number View
212	FM_ROUT_HDR_V1	Routing Number View
213	FM_ROUT_HDR_V2	Routing Version View
214	FM_ROUT_MTL_VW1	Backward compatibility view so existing GME code can continue looking at the FM_ROUT_MTL table rather than at GMD_RECIPE_STEP_MATERIALS.
215	FM_TEXT_TBL_VL	Formula Management Text View
216	GMD_ACTIONS_VL	OPM Quality Actions View
217	GMD_ACTIVITIES_VL	GMD_ACTIVITIES_VL is view of GMD_ACTIVITIES_B AND GMD_ACTIVITIES_TL
218	GMD_ALL_SPEC_VRS_VL
219	GMD_COM_SPEC_VRS_VL	View of base columns of all Specification Validity Rules tables
220	GMD_CUSTOMER_TESTS_VL	OPM Quality Customer tests View
221	GMD_CUST_VEND_MST_V1	Displays customer number and  vendor number depednig on the report type selected by the user
222	GMD_CUST_VEND_MST_V2	View of customer and vendors for value set of Customer/Vendor Test Result report
223	GMD_ERES_MATERIALS_VW	View of recipe material association
224	GMD_ERES_RECIPES_VW
225	GMD_FORMULA_CLASS_VL	View for Tables GMD_FORMULA_CLASS_B and GMD_FORMULA_CLASS_TL, basically holds the Formula Class Table information and MLS related information
226	GMD_GRADES_VL	QC GRADES Translation View
227	GMD_HOLD_REASONS_VL	OPM Quality Hold reasons
228	GMD_ITEM_SUBSTITUTION_HDR_VL
229	GMD_MATERIAL_EFFECTIVITIES_VW
230	GMD_MBR_MATERIAL_V1
231	GMD_MBR_OPRN_ACTIVITIY_V1	This view is used to retrieve Operation Activities information for Master BAtch Record XML generation
232	GMD_MBR_RECIPE_HEADER_V1	This view is used to generate XML for Recipe Header information in Master Batch Record Generation
233	GMD_MBR_RECIPE_RSRC_V1	This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
234	GMD_MBR_STEP_MATERIAL_V1
235	GMD_MBR_STEP_OPRN_V1	This view is used to retrieve Step information to generate Master Batch Record XML
236	GMD_OPERATIONS_VL	Operations view
237	GMD_OPERATION_CLASS_VL	View for Operation Class Base and translation tables
238	GMD_OPRN_PROCESS_PARAMETERS_V1	View of joining the overrides from operation resource and generic resource
239	GMD_ORG_ACCESS_VW	View that can be used in place of org_access_view for performance tuning
240	GMD_QC_E_ALL_SPEC_VRS_DISP_V
241	GMD_QC_E_COMPOSITE_RESULTS_V
242	GMD_QC_E_CUST_SAMPLE_DTLS_V
243	GMD_QC_E_CUST_SMPEVT_DTLS_V
244	GMD_QC_E_RESULTS_V
245	GMD_QC_E_SAMPLES_USED_V
246	GMD_QC_E_SAMPLE_RESULTS_V
247	GMD_QC_E_SPEC_TESTS_V
248	GMD_QC_E_SUPP_SAMPLE_DTLS_V
249	GMD_QC_E_SUPP_SMPEVT_DTLS_V
250	GMD_QC_E_TEST_INSTANCE_V
251	GMD_QC_E_WIP_SAMPLE_DTLS_V
252	GMD_QC_E_WIP_SMPEVT_DTLS_V
253	GMD_QC_STATUS_VL	OPM Quality Status View
254	GMD_QC_TESTS_VL	OPM Quality Manangement Tests View
255	GMD_QC_TEST_VALUES_VL	OPM Test values view
256	GMD_QM_E_MATERIAL_SOURCES_V
257	GMD_QM_E_STABILITY_STUDIES_V
258	GMD_QM_E_TIMEPOINTS_V	OPM Quality Timepoint ERES View
259	GMD_RECIPES_VL
260	GMD_ROUTINGS_VL	View for Routing header Base and translation tables
261	GMD_ROUTING_CLASS_VL	View for Routing Class Base and translation tables
262	GMD_SAMPLING_PLANS_VL	View for Sampling plans
263	GMD_SPECIFICATIONS_VL
264	GMD_SPEC_SUMMARY	View for Summary of Specifications
265	GMD_SPEC_TESTS_VL	OPM Specification tests View
266	GMD_STABILITY_STUDIES_VL
267	GMD_STATUS_VL	Status view
268	GMD_STORAGE_PLANS_VL	Multi-Lingual View for GMD_STORAGE_PLANS
269	GMD_TECHNICAL_DATA_VL
270	GMD_TECHNICAL_SEQUENCE_VL
271	GMD_TECH_PARAMETERS_VL
272	GMD_TESTS_VL
273	GMD_TEST_CLASSES_VL	OPM Quality Test Classes
274	GMD_TEST_INTERVAL_PLANS_VL	Multi-Lingual View for GMD_TEST_INTERVAL_PLANS
275	GMD_TEST_METHODS_VL	OPM QC Test Methods
276	GMD_TEST_VALUES_VL
277	GMD_UNITS_VL	QC Units Translation View
278	LM_TEXT_TBL_VL	Laboratory Management Text View
279	QC_TEXT_TBL_VL	QC Text View
280	QC_TRAN_VW1	Lot source view.
281	QC_TRAN_VW2	Where-used view.