VIEW: APPS.GL_DAILY_CONVERSION_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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