GMP Views (33)

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

ViewDescription
CR_RSRC_CLS_VL Resource Class view
CR_RSRC_DTL_VW1 Not currently used
CR_RSRC_DTL_VW2 Not currently used.
CR_RSRC_MST_VL Resource Master view
CR_SQDS_TBL_V Not currently used.
CR_SQDT_CLS_VW Not currently used.
CR_TEXT_TBL_VL CR text table view
FC_TEXT_TBL_VL FC text table view
GMP_EAM_EQUIP_RESOURCES_V Equipment to resource mapping view
GMP_EAM_JOBS_RESOURCES_V View for eAM jobs on OPM resources
GMP_MFG_TIME_WEEKS_V The query selects all calendar defined in OPM process manufacturing module and prepare week data for GMP_SR_MFG_TIME_V view.This view is int
GMP_NETTABLE_ONHANDS_V Onhand quantities that are nettable
GMP_PARAMETER_VALUES_VL Parameter value view
GMP_PDR_BUYER_V Unique list of buyers from msc_system_items in each organization for an instance and plan
GMP_PDR_CATEGORY_V Unique list of categories from msc_item_categories in each organization for an instance.
GMP_PLAN_ORGANIZATION_V List of all Organizations from plan along with additional entry for All as organization. When All is selected, Planning Detail Report will c
GMP_PROCESS_PARAMETERS_VL Process parameter view
GMP_PROCESS_PARAMETER_SET_VL Process parameter set view
GMP_RESOURCE_AVAIL_V Resource Availability view
GMP_RSRC_CAL_V Resource calendar view
GMP_RSRC_UNAVAIL_DTL_V Resource Unavailable Detail view
GMP_SCHEDULING_EXCEPTIONS_V Scheduling Exceptions for OPM Batches
GMP_SR_BG_ALL_V Business Groups for OPM - Demand Planner
GMP_SR_BOOKING_DATA_V OPM Orders Booking data - Demand Planner
GMP_SR_LE_BG_V OPM Legal ENtities to Business Groups for Demand Planner
GMP_SR_MFG_FCST_V Manufacturing Forecast for Demand Planner
GMP_SR_MFG_TIME_V Manfacturing calendar / time view for Demand Planner
GMP_SR_ORG_OU_V Organizations to Operating Units view for Demand Planner
GMP_SR_OU_LE_V Operating Units to Legal Entities view for Demand Planner
GMP_SR_SHIPMENT_DATA_V Shipment data view for Demand Planner
MR_TEXT_TBL_VL MR text table view
PS_PLNG_CLS_VW Planning class view
PS_TEXT_TBL_VL PS text table view