VIEW: APPS.RG_DSS_DIM_SEGMENTS_V

Source

View Text - Preformatted

SELECT SMP.ROWID ROW_ID , SMP.DIMENSION_ID , SMP.SEQUENCE , FLX.SEGMENT_NAME , SMP.APPLICATION_COLUMN_NAME , SMP.ID_FLEX_CODE , SMP.ID_FLEX_NUM , SMP.MAX_DESC_SIZE , SMP.LAST_UPDATE_DATE , SMP.LAST_UPDATED_BY , SMP.LAST_UPDATE_LOGIN , SMP.CREATION_DATE , SMP.CREATED_BY , RGS.NAME RANGE_SET_NAME , SMP.RANGE_SET_ID , SMP.ACCOUNT_TYPE , SMP.CONTEXT , SMP.ATTRIBUTE1 , SMP.ATTRIBUTE2 , SMP.ATTRIBUTE3 , SMP.ATTRIBUTE4 , SMP.ATTRIBUTE5 , SMP.ATTRIBUTE6 , SMP.ATTRIBUTE7 , SMP.ATTRIBUTE8 , SMP.ATTRIBUTE9 , SMP.ATTRIBUTE10 , SMP.ATTRIBUTE11 , SMP.ATTRIBUTE12 , SMP.ATTRIBUTE13 , SMP.ATTRIBUTE14 , SMP.ATTRIBUTE15 FROM RG_DSS_DIM_SEGMENTS SMP,FND_ID_FLEX_SEGMENTS FLX,RG_DSS_SEG_RANGE_SETS RGS WHERE SMP.APPLICATION_COLUMN_NAME = FLX.APPLICATION_COLUMN_NAME AND SMP.ID_FLEX_CODE = FLX.ID_FLEX_CODE AND SMP.ID_FLEX_NUM = FLX.ID_FLEX_NUM AND SMP.RANGE_SET_ID = RGS.RANGE_SET_ID (+)

View Text - HTML Formatted

SELECT SMP.ROWID ROW_ID
, SMP.DIMENSION_ID
, SMP.SEQUENCE
, FLX.SEGMENT_NAME
, SMP.APPLICATION_COLUMN_NAME
, SMP.ID_FLEX_CODE
, SMP.ID_FLEX_NUM
, SMP.MAX_DESC_SIZE
, SMP.LAST_UPDATE_DATE
, SMP.LAST_UPDATED_BY
, SMP.LAST_UPDATE_LOGIN
, SMP.CREATION_DATE
, SMP.CREATED_BY
, RGS.NAME RANGE_SET_NAME
, SMP.RANGE_SET_ID
, SMP.ACCOUNT_TYPE
, SMP.CONTEXT
, SMP.ATTRIBUTE1
, SMP.ATTRIBUTE2
, SMP.ATTRIBUTE3
, SMP.ATTRIBUTE4
, SMP.ATTRIBUTE5
, SMP.ATTRIBUTE6
, SMP.ATTRIBUTE7
, SMP.ATTRIBUTE8
, SMP.ATTRIBUTE9
, SMP.ATTRIBUTE10
, SMP.ATTRIBUTE11
, SMP.ATTRIBUTE12
, SMP.ATTRIBUTE13
, SMP.ATTRIBUTE14
, SMP.ATTRIBUTE15
FROM RG_DSS_DIM_SEGMENTS SMP
, FND_ID_FLEX_SEGMENTS FLX
, RG_DSS_SEG_RANGE_SETS RGS
WHERE SMP.APPLICATION_COLUMN_NAME = FLX.APPLICATION_COLUMN_NAME
AND SMP.ID_FLEX_CODE = FLX.ID_FLEX_CODE
AND SMP.ID_FLEX_NUM = FLX.ID_FLEX_NUM
AND SMP.RANGE_SET_ID = RGS.RANGE_SET_ID (+)