DBA Data[Home] [Help]

VIEW: APPS.RG_REPORT_SET_NAME_V

Source

View Text - Preformatted

SELECT REPORT_SET_ID, NAME, DESCRIPTION, APPLICATION_ID, ID_FLEX_CODE, STRUCTURE_ID, DECODE(SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, 'GL_DAS_FSG_REPORT_SET_U', 'GL_DAS_FSG_REPORT_SET', TO_CHAR(REPORT_SET_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T' ,'Y', 'N'), 'Y') USE_PRIVILEGE FROM RG_REPORT_SETS
View Text - HTML Formatted

SELECT REPORT_SET_ID
, NAME
, DESCRIPTION
, APPLICATION_ID
, ID_FLEX_CODE
, STRUCTURE_ID
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_REPORT_SET_U'
, 'GL_DAS_FSG_REPORT_SET'
, TO_CHAR(REPORT_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM RG_REPORT_SETS