Product: | RG - Application Report Generator |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.RG_DSS_VAR_SELECTIONS_V |
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