View: GL_AVGBAL_CALENDAR_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_AVGBAL_CALENDAR_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
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CALENDAR_U'
, 'GL_DAS_CALENDAR'
, PR.PERIOD_SET_NAME
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N') USE_PRIVILEGE
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 HAVING MAX(PR.END_DATE - PR.START_DATE) < 35

Columns