SELECT BP.PERIOD_ID, BP.NAME, 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_SYS_PERIODS_VL BP, BSC_DB_CALENDAR C WHERE BP.PERIODICITY_ID = 7 AND C.CALENDAR_ID = 1 AND BP.YEAR = C.YEAR AND BP.PERIOD_ID = C.WEEK52 GROUP BY BP.PERIOD_ID, BP.NAME, BP.YEAR ORDER BY BP.YEAR, BP.PERIOD_ID
SELECT BP.PERIOD_ID
, BP.NAME
, 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_SYS_PERIODS_VL BP
, BSC_DB_CALENDAR C
WHERE BP.PERIODICITY_ID = 7
AND C.CALENDAR_ID = 1
AND BP.YEAR = C.YEAR
AND BP.PERIOD_ID = C.WEEK52 GROUP BY BP.PERIOD_ID
, BP.NAME
, BP.YEAR ORDER BY BP.YEAR
, BP.PERIOD_ID
|
|
|