VIEW: APPS.RG_REPORT_DISPLAY_SETS_V

Source

View Text - Preformatted

SELECT DS.ROWID ROW_ID, DS.REPORT_DISPLAY_SET_ID, DS.NAME, DS.DESCRIPTION, DS.ROW_SET_ID, RS.NAME ROW_SET, DS.COLUMN_SET_ID, CSET.NAME COLUMN_SET, DS.CREATION_DATE, DS.CREATED_BY, DS.LAST_UPDATE_DATE, DS.LAST_UPDATED_BY, DS.LAST_UPDATE_LOGIN, DS.CONTEXT, DS.ATTRIBUTE1, DS.ATTRIBUTE2, DS.ATTRIBUTE3, DS.ATTRIBUTE4, DS.ATTRIBUTE5, DS.ATTRIBUTE6, DS.ATTRIBUTE7, DS.ATTRIBUTE8, DS.ATTRIBUTE9, DS.ATTRIBUTE10, DS.ATTRIBUTE11, DS.ATTRIBUTE12, DS.ATTRIBUTE13, DS.ATTRIBUTE14, DS.ATTRIBUTE15, DECODE(RS.SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, 'GL_DAS_FSG_ROW_SET_U', 'GL_DAS_FSG_ROW_SET', TO_CHAR(RS.AXIS_SET_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T', 'Y', 'N'), 'Y') ROW_SET_USE_PRIVILEGE, DECODE(CSET.SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, 'GL_DAS_FSG_COLUMN_SET_U', 'GL_DAS_FSG_COLUMN_SET', TO_CHAR(CSET.AXIS_SET_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T', 'Y', 'N'), 'Y') COL_SET_USE_PRIVILEGE FROM RG_REPORT_DISPLAY_SETS DS, RG_REPORT_AXIS_SETS RS, RG_REPORT_AXIS_SETS CSET WHERE DS.ROW_SET_ID = RS.AXIS_SET_ID(+) AND DS.COLUMN_SET_ID = CSET.AXIS_SET_ID(+)

View Text - HTML Formatted

SELECT DS.ROWID ROW_ID
, DS.REPORT_DISPLAY_SET_ID
, DS.NAME
, DS.DESCRIPTION
, DS.ROW_SET_ID
, RS.NAME ROW_SET
, DS.COLUMN_SET_ID
, CSET.NAME COLUMN_SET
, DS.CREATION_DATE
, DS.CREATED_BY
, DS.LAST_UPDATE_DATE
, DS.LAST_UPDATED_BY
, DS.LAST_UPDATE_LOGIN
, DS.CONTEXT
, DS.ATTRIBUTE1
, DS.ATTRIBUTE2
, DS.ATTRIBUTE3
, DS.ATTRIBUTE4
, DS.ATTRIBUTE5
, DS.ATTRIBUTE6
, DS.ATTRIBUTE7
, DS.ATTRIBUTE8
, DS.ATTRIBUTE9
, DS.ATTRIBUTE10
, DS.ATTRIBUTE11
, DS.ATTRIBUTE12
, DS.ATTRIBUTE13
, DS.ATTRIBUTE14
, DS.ATTRIBUTE15
, DECODE(RS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_ROW_SET_U'
, 'GL_DAS_FSG_ROW_SET'
, TO_CHAR(RS.AXIS_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') ROW_SET_USE_PRIVILEGE
, DECODE(CSET.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_FSG_COLUMN_SET_U'
, 'GL_DAS_FSG_COLUMN_SET'
, TO_CHAR(CSET.AXIS_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') COL_SET_USE_PRIVILEGE
FROM RG_REPORT_DISPLAY_SETS DS
, RG_REPORT_AXIS_SETS RS
, RG_REPORT_AXIS_SETS CSET
WHERE DS.ROW_SET_ID = RS.AXIS_SET_ID(+)
AND DS.COLUMN_SET_ID = CSET.AXIS_SET_ID(+)