GMD Views (79)

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

View	Description
`FM_FORM_EFF_VW1`	Item Effectivity View
`FM_FORM_EFF_VW3`
`FM_FORM_EFF_VW3_OLD`	Item Effectivity view
`FM_FORM_MST_V1`	Formula Numbers View
`FM_FORM_MST_V2`	Formula Version View
`FM_FORM_MST_VL`	Form Version view
`FM_OPRN_DTL_VW1`	Operation detail view
`FM_OPRN_MST_VW1`	Operation master view
`FM_ROUT_DTL_V1`	Routingstep Number View
`FM_ROUT_HDR_V1`	Routing Number View
`FM_ROUT_HDR_V2`	Routing Version View
`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.
`FM_TEXT_TBL_VL`	Formula Management Text View
`GMD_ACTIONS_VL`	OPM Quality Actions View
`GMD_ACTIVITIES_VL`	GMD_ACTIVITIES_VL is view of GMD_ACTIVITIES_B AND GMD_ACTIVITIES_TL
`GMD_ALL_SPEC_VRS_VL`
`GMD_COM_SPEC_VRS_VL`	View of base columns of all Specification Validity Rules tables
`GMD_CUSTOMER_TESTS_VL`	OPM Quality Customer tests View
`GMD_CUST_VEND_MST_V1`	Displays customer number and vendor number depednig on the report type selected by the user
`GMD_CUST_VEND_MST_V2`	View of customer and vendors for value set of Customer/Vendor Test Result report
`GMD_ERES_MATERIALS_VW`	View of recipe material association
`GMD_ERES_RECIPES_VW`
`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 informatio
`GMD_GRADES_VL`	QC GRADES Translation View
`GMD_HOLD_REASONS_VL`	OPM Quality Hold reasons
`GMD_ITEM_SUBSTITUTION_HDR_VL`
`GMD_MATERIAL_EFFECTIVITIES_VW`
`GMD_MBR_MATERIAL_V1`
`GMD_MBR_OPRN_ACTIVITIY_V1`	This view is used to retrieve Operation Activities information for Master BAtch Record XML generation
`GMD_MBR_RECIPE_HEADER_V1`	This view is used to generate XML for Recipe Header information in Master Batch Record Generation
`GMD_MBR_RECIPE_RSRC_V1`	This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
`GMD_MBR_STEP_MATERIAL_V1`
`GMD_MBR_STEP_OPRN_V1`	This view is used to retrieve Step information to generate Master Batch Record XML
`GMD_OPERATIONS_VL`	Operations view
`GMD_OPERATION_CLASS_VL`	View for Operation Class Base and translation tables
`GMD_OPRN_PROCESS_PARAMETERS_V1`	View of joining the overrides from operation resource and generic resource
`GMD_ORG_ACCESS_VW`	View that can be used in place of org_access_view for performance tuning
`GMD_QC_E_ALL_SPEC_VRS_DISP_V`
`GMD_QC_E_COMPOSITE_RESULTS_V`
`GMD_QC_E_CUST_SAMPLE_DTLS_V`
`GMD_QC_E_CUST_SMPEVT_DTLS_V`
`GMD_QC_E_RESULTS_V`
`GMD_QC_E_SAMPLES_USED_V`
`GMD_QC_E_SAMPLE_RESULTS_V`
`GMD_QC_E_SPEC_TESTS_V`
`GMD_QC_E_SUPP_SAMPLE_DTLS_V`
`GMD_QC_E_SUPP_SMPEVT_DTLS_V`
`GMD_QC_E_TEST_INSTANCE_V`
`GMD_QC_E_WIP_SAMPLE_DTLS_V`
`GMD_QC_E_WIP_SMPEVT_DTLS_V`
`GMD_QC_STATUS_VL`	OPM Quality Status View
`GMD_QC_TESTS_VL`	OPM Quality Manangement Tests View
`GMD_QC_TEST_VALUES_VL`	OPM Test values view
`GMD_QM_E_MATERIAL_SOURCES_V`
`GMD_QM_E_STABILITY_STUDIES_V`
`GMD_QM_E_TIMEPOINTS_V`	OPM Quality Timepoint ERES View
`GMD_RECIPES_VL`
`GMD_ROUTINGS_VL`	View for Routing header Base and translation tables
`GMD_ROUTING_CLASS_VL`	View for Routing Class Base and translation tables
`GMD_SAMPLING_PLANS_VL`	View for Sampling plans
`GMD_SPECIFICATIONS_VL`
`GMD_SPEC_SUMMARY`	View for Summary of Specifications
`GMD_SPEC_TESTS_VL`	OPM Specification tests View
`GMD_STABILITY_STUDIES_VL`
`GMD_STATUS_VL`	Status view
`GMD_STORAGE_PLANS_VL`	Multi-Lingual View for GMD_STORAGE_PLANS
`GMD_TECHNICAL_DATA_VL`
`GMD_TECHNICAL_SEQUENCE_VL`
`GMD_TECH_PARAMETERS_VL`
`GMD_TESTS_VL`
`GMD_TEST_CLASSES_VL`	OPM Quality Test Classes
`GMD_TEST_INTERVAL_PLANS_VL`	Multi-Lingual View for GMD_TEST_INTERVAL_PLANS
`GMD_TEST_METHODS_VL`	OPM QC Test Methods
`GMD_TEST_VALUES_VL`
`GMD_UNITS_VL`	QC Units Translation View
`LM_TEXT_TBL_VL`	Laboratory Management Text View
`QC_TEXT_TBL_VL`	QC Text View
`QC_TRAN_VW1`	Lot source view.
`QC_TRAN_VW2`	Where-used view.