VIEW: APPS.GL_AVGBAL_CALENDAR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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