Table: GMP_CALENDAR_DETAIL_GTMP | Oracle EBS ETRM Search

This table stores actual meter values based on the tag readings from MTH_METER_READINGS_RAW or laded from CSV file and calculated values for virtual meters

MTH.MTH_METER_READINGS·Explore MTH module →

Table: MTH_METER_READINGS_STG 12.2.2

owner MTH·MTH - Oracle Manufacturing Operations Center·5 columns

MTH.MTH_METER_READINGS_STG·Explore MTH module →

Table: MSC_ST_NET_RES_INST_AVAIL 12.1.1 standalone

owner MSC·MSC - Advanced Supply Chain Planning·23 columns

MSC.MSC_ST_NET_RES_INST_AVAIL·Explore MSC module →

Table: MSC_ST_SHIFT_TIMES 12.2.2 standalone

owner MSC·MSC - Advanced Supply Chain Planning·25 columns

The staging table used by the collection program to validate and process data for table MSC_SHIFT_TIMES.

MSC.MSC_ST_SHIFT_TIMES·Explore MSC module →

Table: MTH_ENTITY_PLANNED_USAGE_HR_MV 12.2.2

MTH - Oracle Manufacturing Operations Center·26 columns

APPS.MTH_ENTITY_PLANNED_USAGE_HR_MV·Explore MTH module →

Table: MTH_ENTITY_SUSTAIN_ASPECT_HOUR 12.2.2

owner MTH·MTH - Oracle Manufacturing Operations Center·27 columns

MTH_ENTITY_SUSTAIN_ASPECT_HOUR aggregates data from MTH_ENTITY_SUSTAIN_ASPECT by hour.

MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR·Explore MTH module →

Table: MTH_EQUIP_PROD_PERF_DETAIL_F 12.2.2

owner MTH·MTH - Oracle Manufacturing Operations Center·27 columns

It contains similar information in equipment production performace with more granular status information.

MTH.MTH_EQUIP_PROD_PERF_DETAIL_F·Explore MTH module →

Table: MRP_AD_RES_CHNGS 12.1.1 standalone

owner MRP·MRP - Master Scheduling/MRP·19 columns

MRP.MRP_AD_RES_CHNGS·Explore MRP module →

Table: BOM_SHIFT_TIMES 12.2.2 satellite-leaning

owner BOM·BOM - Bills of Material·29 columns

Workday calendar shift times

BOM.BOM_SHIFT_TIMES·Explore BOM module →

Table: BOM_RESOURCE_CHANGES 12.1.1 satellite-leaning

owner BOM·BOM - Bills of Material·37 columns

Resource capacity modifications

BOM.BOM_RESOURCE_CHANGES·Explore BOM module →

View: BOM_RESOURCE_CHANGES_V 12.1.1

BOM - Bills of Material·38 columns

Resource capacity modifications

APPS.BOM_RESOURCE_CHANGES_V·↳ BOM_RESOURCE_CHANGES·Explore BOM module →

Table: MSC_ST_SHIFT_TIMES 12.1.1 standalone

owner MSC·MSC - Advanced Supply Chain Planning·25 columns

The staging table used by the collection program to validate and process data for table MSC_SHIFT_TIMES.

MSC.MSC_ST_SHIFT_TIMES·Explore MSC module →

Table: MTH_METER_READINGS_ERR 12.2.2

owner MTH·MTH - Oracle Manufacturing Operations Center·18 columns

This table stores the error rows when processing the data from MTH_METER_READINGS_RAW, when loading data from CSV to MTH_METER_READINGS, and when loading data from MTH_METER_READINGS to MTH_ENTITY_SUSTAIN_ASPECT.

MTH.MTH_METER_READINGS_ERR·Explore MTH module →

Table: BOM_SHIFT_TIMES 12.1.1 satellite-leaning

owner BOM·BOM - Bills of Material·29 columns

Workday calendar shift times

BOM.BOM_SHIFT_TIMES·Explore BOM module →

Table: MSC_NET_RESOURCE_AVAIL 12.1.1 satellite-leaning

owner MSC·MSC - Advanced Supply Chain Planning·43 columns

This table stores the resource availability profile of the different resources.

MSC.MSC_NET_RESOURCE_AVAIL·Explore MSC module →

Table: MSC_NET_RES_INST_AVAIL 12.2.2 standalone

owner MSC·MSC - Advanced Supply Chain Planning·45 columns

MSC.MSC_NET_RES_INST_AVAIL·Explore MSC module →