View: RG_REPORT_AXIS_SETS_LOV_V

Product:	RG - Application Report Generator
Description:
Implementation/DBA Data:	APPS.RG_REPORT_AXIS_SETS_LOV_V

View Text

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

Columns