VIEW: APPS.BSC_P_BSC_PER_CAL1_PER1_V

Source

View Text - Preformatted

SELECT  C.YEAR,C.YEAR,  MIN(TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY, 'YYYY-MM-DD')) START_DATE,  MAX(TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY, 'YYYY-MM-DD')) END_DATE  FROM  BSC_DB_CALENDAR C  WHERE C.CALENDAR_ID = 1 GROUP BY C.YEAR  ORDER BY C.YEAR 

View Text - HTML Formatted

SELECT C.YEAR
, C.YEAR
, MIN(TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY
, 'YYYY-MM-DD')) START_DATE
, MAX(TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY
, 'YYYY-MM-DD')) END_DATE
FROM BSC_DB_CALENDAR C
WHERE C.CALENDAR_ID = 1 GROUP BY C.YEAR ORDER BY C.YEAR