VIEW: APPS.RG_REPORT_AXIS_SETS_V

Source

View Text - Preformatted

SELECT AXS.ROWID ROW_ID, AXS.APPLICATION_ID, AXS.AXIS_SET_ID, AXS.LAST_UPDATE_DATE, AXS.LAST_UPDATED_BY, AXS.LAST_UPDATE_LOGIN, AXS.CREATION_DATE, AXS.CREATED_BY, AXS.NAME, AXS.AXIS_SET_TYPE, AXS.SECURITY_FLAG, AXS.DISPLAY_IN_LIST_FLAG, AXS.PERIOD_SET_NAME, AXS.DESCRIPTION, AXS.COLUMN_SET_HEADER, AXS.SEGMENT_NAME, FLX.SEGMENT_NAME SEGMENT_DISPLAY_NAME, FLX.SEGMENT_NUM, AXS.ID_FLEX_CODE, AXS.STRUCTURE_ID, AXS.CONTEXT, AXS.ATTRIBUTE1, AXS.ATTRIBUTE2, AXS.ATTRIBUTE3, AXS.ATTRIBUTE4, AXS.ATTRIBUTE5, AXS.ATTRIBUTE6, AXS.ATTRIBUTE7, AXS.ATTRIBUTE8, AXS.ATTRIBUTE9, AXS.ATTRIBUTE10, AXS.ATTRIBUTE11, AXS.ATTRIBUTE12, AXS.ATTRIBUTE13, AXS.ATTRIBUTE14, AXS.ATTRIBUTE15, TAX.TAXONOMY_ID, TAX.TAXONOMY_NAME, TAX.TAXONOMY_DESCR, TAX.TAXONOMY_IMPORT_FLAG, DECODE(SECURITY_FLAG, 'Y', DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0, DECODE(AXS.AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET_V', 'GL_DAS_FSG_COLUMN_SET_V'), DECODE(AXS.AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET', 'GL_DAS_FSG_COLUMN_SET'), TO_CHAR(AXS.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(AXS.AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET_U', 'GL_DAS_FSG_COLUMN_SET_U'), DECODE(AXS.AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET', 'GL_DAS_FSG_COLUMN_SET'), TO_CHAR(AXS.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(AXS.AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET_M', 'GL_DAS_FSG_COLUMN_SET_M'), DECODE(AXS.AXIS_SET_TYPE, 'R', 'GL_DAS_FSG_ROW_SET', 'GL_DAS_FSG_COLUMN_SET'), TO_CHAR(AXS.AXIS_SET_ID), NULL, NULL, NULL, NULL, FND_GLOBAL.USER_NAME), 'T', 'Y', 'N'), 'Y') MODIFY_PRIVILEGE FROM RG_REPORT_AXIS_SETS AXS, RG_XBRL_TAXONOMIES TAX, FND_ID_FLEX_SEGMENTS FLX WHERE AXS.SEGMENT_NAME = FLX.APPLICATION_COLUMN_NAME(+) AND AXS.ID_FLEX_CODE = FLX.ID_FLEX_CODE(+) AND AXS.STRUCTURE_ID = FLX.ID_FLEX_NUM(+) AND FLX.APPLICATION_ID(+) = 101 AND AXS.TAXONOMY_ID = TAX.TAXONOMY_ID(+)

View Text - HTML Formatted

SELECT AXS.ROWID ROW_ID
, AXS.APPLICATION_ID
, AXS.AXIS_SET_ID
, AXS.LAST_UPDATE_DATE
, AXS.LAST_UPDATED_BY
, AXS.LAST_UPDATE_LOGIN
, AXS.CREATION_DATE
, AXS.CREATED_BY
, AXS.NAME
, AXS.AXIS_SET_TYPE
, AXS.SECURITY_FLAG
, AXS.DISPLAY_IN_LIST_FLAG
, AXS.PERIOD_SET_NAME
, AXS.DESCRIPTION
, AXS.COLUMN_SET_HEADER
, AXS.SEGMENT_NAME
, FLX.SEGMENT_NAME SEGMENT_DISPLAY_NAME
, FLX.SEGMENT_NUM
, AXS.ID_FLEX_CODE
, AXS.STRUCTURE_ID
, AXS.CONTEXT
, AXS.ATTRIBUTE1
, AXS.ATTRIBUTE2
, AXS.ATTRIBUTE3
, AXS.ATTRIBUTE4
, AXS.ATTRIBUTE5
, AXS.ATTRIBUTE6
, AXS.ATTRIBUTE7
, AXS.ATTRIBUTE8
, AXS.ATTRIBUTE9
, AXS.ATTRIBUTE10
, AXS.ATTRIBUTE11
, AXS.ATTRIBUTE12
, AXS.ATTRIBUTE13
, AXS.ATTRIBUTE14
, AXS.ATTRIBUTE15
, TAX.TAXONOMY_ID
, TAX.TAXONOMY_NAME
, TAX.TAXONOMY_DESCR
, TAX.TAXONOMY_IMPORT_FLAG
, DECODE(SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, DECODE(AXS.AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET_V'
, 'GL_DAS_FSG_COLUMN_SET_V')
, DECODE(AXS.AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET'
, 'GL_DAS_FSG_COLUMN_SET')
, TO_CHAR(AXS.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(AXS.AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET_U'
, 'GL_DAS_FSG_COLUMN_SET_U')
, DECODE(AXS.AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET'
, 'GL_DAS_FSG_COLUMN_SET')
, TO_CHAR(AXS.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(AXS.AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET_M'
, 'GL_DAS_FSG_COLUMN_SET_M')
, DECODE(AXS.AXIS_SET_TYPE
, 'R'
, 'GL_DAS_FSG_ROW_SET'
, 'GL_DAS_FSG_COLUMN_SET')
, TO_CHAR(AXS.AXIS_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM RG_REPORT_AXIS_SETS AXS
, RG_XBRL_TAXONOMIES TAX
, FND_ID_FLEX_SEGMENTS FLX
WHERE AXS.SEGMENT_NAME = FLX.APPLICATION_COLUMN_NAME(+)
AND AXS.ID_FLEX_CODE = FLX.ID_FLEX_CODE(+)
AND AXS.STRUCTURE_ID = FLX.ID_FLEX_NUM(+)
AND FLX.APPLICATION_ID(+) = 101
AND AXS.TAXONOMY_ID = TAX.TAXONOMY_ID(+)