VIEW: APPS.MTH_445_CAL_START_DAY_V

Source

View Text - Preformatted

SELECT c.ID, c.START_DAY_OF_WEEK FROM ( SELECT LEVEL AS ID, To_Char(SYSDATE - To_Char(SYSDATE,'D') + level,'Day') AS START_DAY_OF_WEEK from fnd_dual CONNECT BY LEVEL <=7 ) c WHERE c.id = Nvl((SELECT To_Char(Max(DAY)+1,'D') FROM mth_445_period_calendar WHERE DAY IS NOT NULL), c.id) ORDER BY c.ID

View Text - HTML Formatted

SELECT C.ID
, C.START_DAY_OF_WEEK
FROM ( SELECT LEVEL AS ID
, TO_CHAR(SYSDATE - TO_CHAR(SYSDATE
, 'D') + LEVEL
, 'DAY') AS START_DAY_OF_WEEK
FROM FND_DUAL CONNECT BY LEVEL <=7 ) C
WHERE C.ID = NVL((SELECT TO_CHAR(MAX(DAY)+1
, 'D')
FROM MTH_445_PERIOD_CALENDAR
WHERE DAY IS NOT NULL)
, C.ID) ORDER BY C.ID