MSC_AP_SCHEDULES

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
CALENDAR_CODE CALENDAR_START_DATE CALENDAR_END_DATE SCHEDULE_NAME DESCRIPTION SCHEDULE_TYPE_CODE CATEGORY_CODE QTRLY_TYPE_CODE DELETED_FLAG WEEK_START_DAY PATTERN_STRING

Name

CALENDAR_CODE

CALENDAR_START_DATE

CALENDAR_END_DATE

SCHEDULE_NAME

DESCRIPTION

SCHEDULE_TYPE_CODE

CATEGORY_CODE

QTRLY_TYPE_CODE

DELETED_FLAG

WEEK_START_DAY

PATTERN_STRING

Query

SQL_Statement
SELECT ''\|\|SCHEDULE_ID CALENDAR_CODE, EFFECTIVE_FROM_DATE CALENDAR_START_DATE, EFFECTIVE_TO_DATE CALENDAR_END_DATE, SCHEDULE_NAME , SCHEDULE_DESC DESCRIPTION, SCHEDULE_TYPE_CODE , CATEGORY_CODE, qtrly_type_code, decode(upper(deleted_flag),'Y',1,'N',2), TO_CHAR(EFFECTIVE_FROM_DATE, 'd') week_start_day , MSC_COLL_DB_OBJ_DEPENDENCIES.getSchedulePattern ( Schedule_id ) Pattern_String FROM ZMM_SR_SCHEDULES_VL where schedule_id in ( select distinct org.mfg_calendar FROM RCS_MFG_PARAMETERS org union select distinct wca.schedule_id from wsh_calendar_assignments wca union select distinct inv.schedule_id from inv_org_parameters inv) and length(MSC_COLL_DB_OBJ_DEPENDENCIES.getSchedulePattern ( Schedule_id ) ) = 7

SQL_Statement

SELECT

''||SCHEDULE_ID CALENDAR_CODE,

EFFECTIVE_FROM_DATE CALENDAR_START_DATE,

EFFECTIVE_TO_DATE CALENDAR_END_DATE,

SCHEDULE_NAME ,

SCHEDULE_DESC DESCRIPTION,

SCHEDULE_TYPE_CODE ,

CATEGORY_CODE,

qtrly_type_code,

decode(upper(deleted_flag),'Y',1,'N',2),

TO_CHAR(EFFECTIVE_FROM_DATE, 'd') week_start_day ,

MSC_COLL_DB_OBJ_DEPENDENCIES.getSchedulePattern ( Schedule_id ) Pattern_String

FROM ZMM_SR_SCHEDULES_VL where schedule_id in ( select distinct org.mfg_calendar FROM RCS_MFG_PARAMETERS org

union select distinct wca.schedule_id from wsh_calendar_assignments wca union select distinct inv.schedule_id from inv_org_parameters inv) and length(MSC_COLL_DB_OBJ_DEPENDENCIES.getSchedulePattern ( Schedule_id ) ) = 7