VIEW: APPS.BSC_P_BSC_PER_CAL1_PER4_V

Source

View Text - Preformatted

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 = 4 AND C.CALENDAR_ID = 1 AND BP.YEAR = C.YEAR  AND BP.PERIOD_ID = C.BIMESTER GROUP BY BP.PERIOD_ID, BP.NAME, BP.YEAR  ORDER BY BP.YEAR, BP.PERIOD_ID 

View Text - HTML Formatted

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 = 4
AND C.CALENDAR_ID = 1
AND BP.YEAR = C.YEAR
AND BP.PERIOD_ID = C.BIMESTER GROUP BY BP.PERIOD_ID
, BP.NAME
, BP.YEAR ORDER BY BP.YEAR
, BP.PERIOD_ID