MSC_AP_PERIOD_START_DATES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_CODE PRD_START_DATE NEXT_DATE PRIOR_DATE SEQ_NUM CALENDAR_START_DATE QTRLY_TYPE_CODE

Query

SQL_Statement
select ''||prd.SCHEDULE_ID CALENDAR_CODE, prd.PRD_START_DATE, prd.NEXT_DATE, prd.PRIOR_DATE, prd.SEQ_NUM, cal.calendar_start_date, cal.qtrly_type_code From ZMM_SR_PRD_START_DATES prd , MSC_AP_SCHEDULES_V cal where ''||prd.SCHEDULE_ID = cal.calendar_code