[Home] [Help]
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
Name |
PERIOD_TYPE |
PERIOD_NAME |
START_DATE |
END_DATE |