VIEW: APPS.RG_REPORT_DISPLAY_GROUPS_V

Source

View Text - Preformatted

SELECT DG.ROWID ROW_ID, DG.REPORT_DISPLAY_GROUP_ID, DG.NAME, DG.DESCRIPTION, DG.ROW_SET_ID, RS.NAME ROW_SET, DG.COLUMN_SET_ID, CSET.NAME COLUMN_SET, DG.FROM_SEQUENCE, DG.TO_SEQUENCE, DG.CREATION_DATE, DG.CREATED_BY, DG.LAST_UPDATE_DATE, DG.LAST_UPDATED_BY, DG.LAST_UPDATE_LOGIN, DG.CONTEXT, DG.ATTRIBUTE1, DG.ATTRIBUTE2, DG.ATTRIBUTE3, DG.ATTRIBUTE4, DG.ATTRIBUTE5, DG.ATTRIBUTE6, DG.ATTRIBUTE7, DG.ATTRIBUTE8, DG.ATTRIBUTE9, DG.ATTRIBUTE10, DG.ATTRIBUTE11, DG.ATTRIBUTE12, DG.ATTRIBUTE13, DG.ATTRIBUTE14, DG.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_GROUPS DG, RG_REPORT_AXIS_SETS RS, RG_REPORT_AXIS_SETS CSET WHERE DG.ROW_SET_ID = RS.AXIS_SET_ID(+) AND DG.COLUMN_SET_ID = CSET.AXIS_SET_ID(+)

View Text - HTML Formatted

SELECT DG.ROWID ROW_ID
, DG.REPORT_DISPLAY_GROUP_ID
, DG.NAME
, DG.DESCRIPTION
, DG.ROW_SET_ID
, RS.NAME ROW_SET
, DG.COLUMN_SET_ID
, CSET.NAME COLUMN_SET
, DG.FROM_SEQUENCE
, DG.TO_SEQUENCE
, DG.CREATION_DATE
, DG.CREATED_BY
, DG.LAST_UPDATE_DATE
, DG.LAST_UPDATED_BY
, DG.LAST_UPDATE_LOGIN
, DG.CONTEXT
, DG.ATTRIBUTE1
, DG.ATTRIBUTE2
, DG.ATTRIBUTE3
, DG.ATTRIBUTE4
, DG.ATTRIBUTE5
, DG.ATTRIBUTE6
, DG.ATTRIBUTE7
, DG.ATTRIBUTE8
, DG.ATTRIBUTE9
, DG.ATTRIBUTE10
, DG.ATTRIBUTE11
, DG.ATTRIBUTE12
, DG.ATTRIBUTE13
, DG.ATTRIBUTE14
, DG.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_GROUPS DG
, RG_REPORT_AXIS_SETS RS
, RG_REPORT_AXIS_SETS CSET
WHERE DG.ROW_SET_ID = RS.AXIS_SET_ID(+)
AND DG.COLUMN_SET_ID = CSET.AXIS_SET_ID(+)