VIEW: APPS.RG_DSS_VAR_SELECTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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