Table: GMP_CALENDAR_DETAIL_GTMP | Oracle EBS ETRM Search

MSC_WORKDAY_PATTERNS stores the days on/days off patterns for your calendar and your shifts. You can define multiple days on/days off to form a repetitive pattern. The calendar compile program (MSCPCL) will create a workday calendar based o

MSC.MSC_WORKDAY_PATTERNS·Explore MSC 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: AHL_DEPARTMENT_SHIFTS 12.1.1 satellite-leaning

owner AHL·AHL - Complex Maintenance Repair and Overhaul·30 columns

This table stores information about department shifts

AHL.AHL_DEPARTMENT_SHIFTS·Explore AHL module →

Table: MTH_WORKDAY_SHIFTS_DIS_I_STG 12.1.1

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

MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG·Explore MTH module →

View: BOM_ORG_SHIFT_DATES_VIEW 12.2.2

BOM - Bills of Material·8 columns

Shift dates for an organization's calendar - used in Calendar window

APPS.BOM_ORG_SHIFT_DATES_VIEW·↳ BOM_SHIFT_DATES·↳ MTL_PARAMETERS·Explore BOM module →

Table: MSC_SHIFT_TIMES 12.2.2 standalone

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

Workday calendar shift times

MSC.MSC_SHIFT_TIMES·Explore MSC module →

Table: AHL_DEPARTMENT_SHIFTS 12.2.2 satellite-leaning

owner AHL·AHL - Complex Maintenance Repair and Overhaul·32 columns

This table stores information about department shifts

AHL.AHL_DEPARTMENT_SHIFTS·Explore AHL module →

View: BOM_SHIFT_WEEKS_VIEW 12.2.2

BOM - Bills of Material·21 columns

Shift calendar dates - used in calendar window

APPS.BOM_SHIFT_WEEKS_VIEW·↳ BOM_SHIFT_DATES·Explore BOM module →

Table: MSC_ST_SHIFT_DATES 12.2.2 standalone

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

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

MSC.MSC_ST_SHIFT_DATES·Explore MSC module →

View: BOM_SHIFT_WEEKS_VIEW 12.1.1

BOM - Bills of Material·21 columns

Shift calendar dates - used in calendar window

APPS.BOM_SHIFT_WEEKS_VIEW·↳ BOM_SHIFT_DATES·Explore BOM module →

Table: MSC_ST_SHIFT_DATES 12.1.1 standalone

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

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

MSC.MSC_ST_SHIFT_DATES·Explore MSC module →

Table: WIP_INDICATORS_TEMP 12.1.1 standalone

owner WIP·WIP - Work in Process·35 columns

Temporary table used for calculating the production indicators from the transaction information

WIP.WIP_INDICATORS_TEMP·Explore WIP module →

Table: WIP_BIS_EFF_TEMP 12.2.2 standalone

owner WIP·WIP - Work in Process·35 columns

WIP.WIP_BIS_EFF_TEMP·Explore WIP 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: MTH_WORKDAY_SHIFTS_ERR 12.2.2 standalone

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

Error table for MTH_WORKDAY_SHIFTS_D

MTH.MTH_WORKDAY_SHIFTS_ERR·Explore MTH module →

Table: BOM_RESOURCE_CHANGES 12.2.2 satellite-leaning

owner BOM·BOM - Bills of Material·37 columns

Resource capacity modifications

BOM.BOM_RESOURCE_CHANGES·Explore BOM module →

Table: MSC_RESOURCE_CHANGES 12.1.1 standalone

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

Resource capacity modifications

MSC.MSC_RESOURCE_CHANGES·Explore MSC 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_SITE_SHIFT_DEFINITIONS 12.2.2

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

This table stores the definition of the shift template for a site in order to generate shift for all entities belonging to the site as well as the site itself

MTH.MTH_SITE_SHIFT_DEFINITIONS·Explore MTH 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: MSC_ST_CALENDAR_SHIFTS 12.2.2 standalone

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

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

MSC.MSC_ST_CALENDAR_SHIFTS·Explore MSC module →

Table: BOM_RES_INSTANCE_CHANGES 12.2.2 standalone

owner BOM·BOM - Bills of Material·40 columns

Resource Instances modifications

BOM.BOM_RES_INSTANCE_CHANGES·Explore BOM module →

Table: BOM_RES_INSTANCE_CHANGES 12.1.1 standalone

owner BOM·BOM - Bills of Material·40 columns

Resource Instances modifications

BOM.BOM_RES_INSTANCE_CHANGES·Explore BOM module →

Table: MSC_ST_WORKDAY_PATTERNS 12.2.2 standalone

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

This is an interface table for staging days on/days off patterns for your calendar and your shifts from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_WORKDAY_PATTERNS.SEQ_NUM is the ord

MSC.MSC_ST_WORKDAY_PATTERNS·Explore MSC module →

View: AHL_DEPARTMENT_SHIFTS_V 12.2.2

AHL - Complex Maintenance Repair and Overhaul·42 columns

This view stores the query relating to Department Shifts

APPS.AHL_DEPARTMENT_SHIFTS_V·↳ AHL_DEPARTMENT_SHIFTS·↳ BOM_CALENDARS·↳ BOM_DEPARTMENTS_V·Explore AHL module →

Table: BOM_WORKDAY_PATTERNS 12.2.2 link

owner BOM·BOM - Bills of Material·31 columns

On/Off workday patterns for calendars and shifts

BOM.BOM_WORKDAY_PATTERNS·Explore BOM module →

Table: CRP_CAL_SHIFT_DELTA 12.2.2 link

owner CRP·CRP - Capacity·14 columns

Deltas between the primary calendar and shift calendars

CRP.CRP_CAL_SHIFT_DELTA·Explore CRP module →

Table: MSC_WORKDAY_PATTERNS 12.2.2

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

MSC_WORKDAY_PATTERNS stores the days on/days off patterns for your calendar and your shifts. You can define multiple days on/days off to form a repetitive pattern. The calendar compile program (MSCPCL) will create a workday calendar based o

MSC.MSC_WORKDAY_PATTERNS·Explore MSC module →

Table: GMP_RESOURCE_AVAIL 12.1.1

owner GMP·GMP - Process Manufacturing Process Planning·17 columns

Table for Resource Availability

GMP.GMP_RESOURCE_AVAIL·Explore GMP module →

Table: BOM_RESOURCE_SHIFTS 12.2.2 satellite-leaning

owner BOM·BOM - Bills of Material·29 columns

Resource shift information

BOM.BOM_RESOURCE_SHIFTS·Explore BOM module →

Table: BOM_RESOURCE_SHIFTS 12.1.1 satellite-leaning

owner BOM·BOM - Bills of Material·29 columns

Resource shift information