VIEW: APPS.RG_REPORT_AXIS_SETS_LOV_V

Source

View Text - Preformatted

SELECT ROWID ROW_ID, NAME, DESCRIPTION, APPLICATION_ID, AXIS_SET_TYPE, AXIS_SET_ID, SECURITY_FLAG, STRUCTURE_ID, ID_FLEX_CODE, DECODE ( SECURITY_FLAG, 'Y', DECODE ( FND_DATA_SECURITY.CHECK_FUNCTION ( 1.0, DECODE ( AXIS_SET_TYPE,'R', 'GL_DAS_FSG_ROW_SET_V', 'GL_DAS_FSG_COLUMN_SET_V') ,DECODE ( AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET','GL_DAS_FSG_COLUMN_SET') , TO_CHAR ( AXIS_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, DECODE ( AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET_U', 'GL_DAS_FSG_COLUMN_SET_U') , DECODE ( AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET', 'GL_DAS_FSG_COLUMN_SET') , TO_CHAR ( AXIS_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, DECODE ( AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET_M', 'GL_DAS_FSG_COLUMN_SET_M') , DECODE ( AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET', 'GL_DAS_FSG_COLUMN_SET') , TO_CHAR ( AXIS_SET_ID ) , NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME ) , 'T', 'Y', 'N') , 'Y') MODIFY_PRIVILEGE FROM RG_REPORT_AXIS_SETS

View Text - HTML Formatted

SELECT ROWID ROW_ID
, NAME
, DESCRIPTION
, APPLICATION_ID
, AXIS_SET_TYPE
, AXIS_SET_ID
, SECURITY_FLAG
, STRUCTURE_ID
, ID_FLEX_CODE
, DECODE ( SECURITY_FLAG
, 'Y'
, DECODE ( FND_DATA_SECURITY.CHECK_FUNCTION ( 1.0
, DECODE ( AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET_V'
, 'GL_DAS_FSG_COLUMN_SET_V')
, DECODE ( AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET'
, 'GL_DAS_FSG_COLUMN_SET')
, TO_CHAR ( AXIS_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
, DECODE ( AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET_U'
, 'GL_DAS_FSG_COLUMN_SET_U')
, DECODE ( AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET'
, 'GL_DAS_FSG_COLUMN_SET')
, TO_CHAR ( AXIS_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
, DECODE ( AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET_M'
, 'GL_DAS_FSG_COLUMN_SET_M')
, DECODE ( AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET'
, 'GL_DAS_FSG_COLUMN_SET')
, TO_CHAR ( AXIS_SET_ID )
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME )
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM RG_REPORT_AXIS_SETS