VIEW: APPS.MSD_SR_FISCAL_TIME_V

Source

View Text - Preformatted

SELECT gp1.period_set_name, gp3.period_name year, gp3.period_name year_description, gp3.start_date year_start_date, gp3.end_date year_end_date, gp2.period_name quarter, gp2.period_name quarter_description, gp2.start_date quarter_start_date, gp2.end_date quarter_end_date, gp1.period_name month, gp1.period_name month_description, gp1.start_date month_start_date, gp1.end_date month_end_date FROM gl_periods gp3, gl_periods gp2, gl_periods gp1 WHERE gp1.period_type = 'Month' AND gp2.period_set_name = gp1.period_set_name AND gp2.period_type = 'Quarter' AND gp1.start_date BETWEEN gp2.start_date AND gp2.end_date AND gp3.period_set_name = gp1.period_set_name AND gp3.period_type = 'Year' AND gp1.start_date BETWEEN gp3.start_date AND gp3.end_date AND gp1.start_date != gp1.end_date

View Text - HTML Formatted

SELECT GP1.PERIOD_SET_NAME
, GP3.PERIOD_NAME YEAR
, GP3.PERIOD_NAME YEAR_DESCRIPTION
, GP3.START_DATE YEAR_START_DATE
, GP3.END_DATE YEAR_END_DATE
, GP2.PERIOD_NAME QUARTER
, GP2.PERIOD_NAME QUARTER_DESCRIPTION
, GP2.START_DATE QUARTER_START_DATE
, GP2.END_DATE QUARTER_END_DATE
, GP1.PERIOD_NAME MONTH
, GP1.PERIOD_NAME MONTH_DESCRIPTION
, GP1.START_DATE MONTH_START_DATE
, GP1.END_DATE MONTH_END_DATE
FROM GL_PERIODS GP3
, GL_PERIODS GP2
, GL_PERIODS GP1
WHERE GP1.PERIOD_TYPE = 'MONTH'
AND GP2.PERIOD_SET_NAME = GP1.PERIOD_SET_NAME
AND GP2.PERIOD_TYPE = 'QUARTER'
AND GP1.START_DATE BETWEEN GP2.START_DATE
AND GP2.END_DATE
AND GP3.PERIOD_SET_NAME = GP1.PERIOD_SET_NAME
AND GP3.PERIOD_TYPE = 'YEAR'
AND GP1.START_DATE BETWEEN GP3.START_DATE
AND GP3.END_DATE
AND GP1.START_DATE != GP1.END_DATE