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