Product: | RG - Application Report Generator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RG_REPORT_AXIS_SETS_V |
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(+)