[Home] [Help]
View: GL_DAILY_CONVERSION_TYPES_V
View Text
SELECT CT.USER_CONVERSION_TYPE USER_CONVERSION_TYPE
, CT.CONVERSION_TYPE CONVERSION_TYPE
, CT.DESCRIPTION DESCRIPTION
, DECODE(CT.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RATE_TYPES_V'
, 'GL_DAS_RATE_TYPES'
, CT.CONVERSION_TYPE
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(CT.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RATE_TYPES_U'
, 'GL_DAS_RATE_TYPES'
, CT.CONVERSION_TYPE
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(CT.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_RATE_TYPES_M'
, 'GL_DAS_RATE_TYPES'
, CT.CONVERSION_TYPE
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_DAILY_CONVERSION_TYPES CT
Columns
Name |
USER_CONVERSION_TYPE |
CONVERSION_TYPE |
DESCRIPTION |
VIEW_PRIVILEGE |
USE_PRIVILEGE |
MODIFY_PRIVILEGE |