Table: MSC_ST_CALENDAR_SHIFTS | Oracle EBS ETRM Search

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_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: MSC_CALENDARS 12.1.1

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

MSC_CALENDARS stores the definition of your workday calendar.You can follow any of the four following type of quarters for your yearly calendar identified by Quarterly Calendar Type=1. 4-4-5 : quarterly pattern having two 4 weeks followedby

MSC.MSC_CALENDARS·Explore MSC module →

Table: MSC_WORKDAY_PATTERNS 12.1.1

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: 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: MSC_ST_CALENDAR_SHIFTS 12.1.1 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 →

View: BOM_CALENDARS_VIEW 12.2.2

BOM - Bills of Material·32 columns

View of BOM_CALENDARS table

APPS.BOM_CALENDARS_VIEW·↳ BOM_CALENDARS·Explore BOM module →

View: BOM_CALENDARS_VIEW 12.1.1

BOM - Bills of Material·32 columns

View of BOM_CALENDARS table

APPS.BOM_CALENDARS_VIEW·↳ BOM_CALENDARS·Explore BOM module →

Table: MSC_CALENDARS 12.2.2

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

MSC_CALENDARS stores the definition of your workday calendar.You can follow any of the four following type of quarters for your yearly calendar identified by Quarterly Calendar Type=1. 4-4-5 : quarterly pattern having two 4 weeks followedby

MSC.MSC_CALENDARS·Explore MSC module →

Table: MSC_CALENDAR_SHIFTS 12.2.2 hub-leaning

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

Workday calendar shifts

MSC.MSC_CALENDAR_SHIFTS·Explore MSC module →

Table: MSC_ST_CALENDARS 12.2.2 standalone

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

This is an interface table for staging definition of workday calendars from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDARS.You can follow any of the four following type of quar

MSC.MSC_ST_CALENDARS·Explore MSC 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 →

Table: BOM_CALENDAR_SHIFTS 12.2.2 hub-leaning

owner BOM·BOM - Bills of Material·30 columns

Workday calendar shifts

BOM.BOM_CALENDAR_SHIFTS·Explore BOM module →

Table: BOM_CALENDARS 12.2.2 hub-leaning

owner BOM·BOM - Bills of Material·33 columns

Workday calendars

BOM.BOM_CALENDARS·Explore BOM module →

Table: MSC_ST_WORKDAY_PATTERNS 12.1.1 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 →

Table: MSC_ST_CALENDARS 12.1.1 standalone

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

This is an interface table for staging definition of workday calendars from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDARS.You can follow any of the four following type of quar

MSC.MSC_ST_CALENDARS·Explore MSC module →

Table: BOM_CALENDAR_SHIFTS 12.1.1 hub-leaning

owner BOM·BOM - Bills of Material·30 columns

Workday calendar shifts

BOM.BOM_CALENDAR_SHIFTS·Explore BOM module →

Table: BOM_WORKDAY_PATTERNS 12.1.1 link

owner BOM·BOM - Bills of Material·31 columns

On/Off workday patterns for calendars and shifts

BOM.BOM_WORKDAY_PATTERNS·Explore BOM 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