View: CSY_PERIODS_V

Product:	CS - Service
Description:	This view returns all the periods used by Embedded Analytics
Implementation/DBA Data:	APPS.CSY_PERIODS_V

View Text

SELECT LOOKUP_CODE PERIOD_TYPE
, MEANING PERIOD_NAME
, TRUNC(DECODE(LOOKUP_CODE
, 'TODAY'
, SYSDATE
, 'LAST_7_DAYS'
, SYSDATE - 06
, 'LAST_30_DAYS'
, SYSDATE - 29
, 'LAST_90_DAYS'
, SYSDATE - 89
, 'LAST_365_DAYS'
, SYSDATE - 364 ))START_DATE
, TRUNC(SYSDATE) END_DATE
FROM CS_LOOKUPS
WHERE LOOKUP_TYPE = 'CSY_PERIODS'

Columns