Table: JTF_CAL_SHIFTS_TL | Oracle EBS ETRM Search

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_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_RESOURCE_SHIFTS 12.2.2 standalone

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

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

MSC.MSC_ST_RESOURCE_SHIFTS·Explore MSC module →

Table: MTH_WORKDAY_SHIFTS_ERR 12.1.1 standalone

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

MTH.MTH_WORKDAY_SHIFTS_ERR·Explore MTH module →

Table: MTH_WORKDAY_SHIFTS_D 12.2.2 standalone

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

This table stores the workday shifts definition for the time dimension. It provides information like Shift date, Shift From Time, Shift To Time, Shift name and Shift number.

MTH.MTH_WORKDAY_SHIFTS_D·Explore MTH module →

View: JTF_CAL_SHIFT_ASSIGN_V 12.1.1

JTF - CRM Foundation·30 columns

View for table JTF_CAL_SHIFT_ASSIGN, and view JTF_CAL_SHIFTS_VL.

APPS.JTF_CAL_SHIFT_ASSIGN_V·↳ JTF_CAL_SHIFTS_VL·↳ JTF_CAL_SHIFT_ASSIGN·Explore JTF module →

Table: MSC_CALENDAR_SHIFTS 12.1.1 hub-leaning

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

Workday calendar shifts

MSC.MSC_CALENDAR_SHIFTS·Explore MSC module →

Table: MSC_ST_RESOURCE_CHANGES 12.2.2 standalone

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

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

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

View: HXT_SUM_HOURS_WORKED_D 12.1.1

HXT - Time and Labor·25 columns

APPS.HXT_SUM_HOURS_WORKED_D·↳ FND_GLOBAL·↳ FND_PROFILE·↳ FND_USER_VIEW·Explore HXT 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: HXTFV_SHIFT_POLICY 12.1.1

HXT - Time and Labor·21 columns

APPS.HXTFV_SHIFT_POLICY·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_SECURITY·Explore HXT module →

View: JTF_CAL_SHIFTS_VL 12.1.1