FND Design Data [Home] [Help]

View: RG_DSS_VAR_SELECTIONS_V

Product: RG - Application Report Generator
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.RG_DSS_VAR_SELECTIONS_V
View Text

SELECT VS.ROWID ROW_ID
, VS.VARIABLE_ID
, VS.ID_FLEX_CODE
, VS.ID_FLEX_NUM
, VS.APPLICATION_COLUMN_NAME
, FLX.SEGMENT_NAME
, VS.SELECTION_ID
, VS.RANGE_SET_ID
, SRS.NAME RANGE_SET_NAME
, VS.LAST_UPDATE_DATE
, VS.LAST_UPDATED_BY
, VS.LAST_UPDATE_LOGIN
, VS.CREATION_DATE
, VS.CREATED_BY
, VS.CONTEXT
, VS.ATTRIBUTE1
, VS.ATTRIBUTE2
, VS.ATTRIBUTE3
, VS.ATTRIBUTE4
, VS.ATTRIBUTE5
, VS.ATTRIBUTE6
, VS.ATTRIBUTE7
, VS.ATTRIBUTE8
, VS.ATTRIBUTE9
, VS.ATTRIBUTE10
, VS.ATTRIBUTE11
, VS.ATTRIBUTE12
, VS.ATTRIBUTE13
, VS.ATTRIBUTE14
, VS.ATTRIBUTE15
FROM RG_DSS_VAR_SELECTIONS VS
, FND_ID_FLEX_SEGMENTS FLX
, RG_DSS_SEG_RANGE_SETS SRS
WHERE VS.APPLICATION_COLUMN_NAME = FLX.APPLICATION_COLUMN_NAME
AND VS.ID_FLEX_CODE = FLX.ID_FLEX_CODE
AND VS.ID_FLEX_NUM = FLX.ID_FLEX_NUM
AND VS.RANGE_SET_ID = SRS.RANGE_SET_ID

Columns

Name
ROW_ID
VARIABLE_ID
ID_FLEX_CODE
ID_FLEX_NUM
APPLICATION_COLUMN_NAME
SEGMENT_NAME
SELECTION_ID
RANGE_SET_ID
RANGE_SET_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15