MSC_AP_FISCAL_CAL_MONTHS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_NAME SR_CALENDAR_CODE DESCRIPTION YEAR YEAR_START_DATE YEAR_END_DATE YEAR_DESCRIPTION QUARTER QUARTER_SEQ_NUM QUARTER_START_DATE MONTH MONTH_START_DATE MONTH_END_DATE

Query

SQL_Statement

SELECT PR1.USER_PERIOD_SET_NAME CALENDAR_NAME, PR1.PERIOD_SET_NAME ||' '||PR1.PERIOD_TYPE SR_CALENDAR_CODE, PR1.DESCRIPTION DESCRIPTION, PR2.PERIOD_YEAR YEAR, PR2.YEAR_START_DATE YEAR_START_DATE, ADD_MONTHS(PR2.YEAR_START_DATE,12)-1 YEAR_END_DATE , 'FY-'||TO_CHAR(PR2.YEAR_START_DATE,'YY') YEAR_DESCRIPTION, PR2.PERIOD_YEAR||' Q'||PR2.QUARTER_NUM QUARTER, PR2.QUARTER_NUM QUARTER_SEQ_NUM, PR2.QUARTER_START_DATE QUARTER_START_DATE, PR2.PERIOD_NAME MONTH, PR2.START_DATE MONTH_START_DATE, PR2.END_DATE MONTH_END_DATE FROM GL_PERIODS PR2, GL_CALENDARS PR1 WHERE PR2.PERIOD_SET_NAME = PR1.PERIOD_SET_NAME AND PR2.PERIOD_TYPE = PR1.PERIOD_TYPE AND PR1.CALENDAR_TYPE_CODE = 'ACCOUNTING' AND PR1.NON_ADJ_PERIOD_FREQ_CODE = 'MONTH' AND PR2.ADJUSTMENT_PERIOD_FLAG = 'N'