View: MSD_SR_FISCAL_TIME_V

Product:	MSD - Demand Planning
Description:	This is the Source View for Fiscal Calendar. This view would be applied to an Oracle Applications 11i instance from which the Fiscal Calendar information is to be retrieved.
Implementation/DBA Data:	APPS.MSD_SR_FISCAL_TIME_V

View Text

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

Columns