VIEW: APPS.GL_AUTO_ALLOC_SETS_V

Source

View Text - Preformatted

SELECT Rowid ROW_ID , ALLOCATION_SET_ID , ALLOCATION_SET_NAME , ALLOCATION_SET_TYPE_CODE , ALLOCATION_CODE , CHART_OF_ACCOUNTS_ID , PERIOD_SET_NAME , ACCOUNTED_PERIOD_TYPE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , ORG_ID , DESCRIPTION , OWNER , SECURITY_FLAG , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , CONTEXT , substr(gl_auto_alloc_vw_pkg.get_owner_dsp(Owner),1,240) owner_dsp , decode(security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_AUTO_ALLOC_SETS_V', 'GL_DAS_AUTO_ALLOC_SETS', to_char(allocation_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') VIEW_PRIVILEGE , decode(security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_AUTO_ALLOC_SETS_U', 'GL_DAS_AUTO_ALLOC_SETS', to_char(allocation_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') USE_PRIVILEGE , decode(security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_AUTO_ALLOC_SETS_M', 'GL_DAS_AUTO_ALLOC_SETS', to_char(allocation_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') MODIFY_PRIVILEGE From GL_AUTO_ALLOC_SETS

View Text - HTML Formatted

SELECT ROWID ROW_ID
, ALLOCATION_SET_ID
, ALLOCATION_SET_NAME
, ALLOCATION_SET_TYPE_CODE
, ALLOCATION_CODE
, CHART_OF_ACCOUNTS_ID
, PERIOD_SET_NAME
, ACCOUNTED_PERIOD_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
, DESCRIPTION
, OWNER
, SECURITY_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, SUBSTR(GL_AUTO_ALLOC_VW_PKG.GET_OWNER_DSP(OWNER)
, 1
, 240) OWNER_DSP
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTO_ALLOC_SETS_V'
, 'GL_DAS_AUTO_ALLOC_SETS'
, TO_CHAR(ALLOCATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTO_ALLOC_SETS_U'
, 'GL_DAS_AUTO_ALLOC_SETS'
, TO_CHAR(ALLOCATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTO_ALLOC_SETS_M'
, 'GL_DAS_AUTO_ALLOC_SETS'
, TO_CHAR(ALLOCATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_AUTO_ALLOC_SETS