[Home] [Help]
View: GL_PERIODS_AND_TYPES_V
View Text
SELECT PR.PERIOD_SET_NAME PERIOD_SET_NAME
, PTY.USER_PERIOD_TYPE USER_PERIOD_TYPE
, PTY.PERIOD_TYPE PERIOD_TYPE
, MAX(PR.END_DATE - PR.START_DATE)+1 MAX_DAYS FROM GL_PERIODS PR
, GL_PERIOD_TYPES PTY
WHERE PR.PERIOD_TYPE = PTY.PERIOD_TYPE GROUP BY PR.PERIOD_SET_NAME
, PTY.USER_PERIOD_TYPE
, PTY.PERIOD_TYPE
Columns
Name |
PERIOD_SET_NAME |
USER_PERIOD_TYPE |
PERIOD_TYPE |
MAX_DAYS |