View: GL_PERIODS_AND_TYPES_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.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