Product: | RG - Application Report Generator |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.RG_DSS_VAR_DIMENSIONS_V |
SELECT VD.ROWID ROW_ID
, VD.VARIABLE_ID
, VD.SEQUENCE
, VD.DIMENSION_ID
, DIM.NAME DIMENSION_NAME
, DIM.LEVEL_CODE
, LK.MEANING LEVEL_DISP
, DIM.DIMENSION_TYPE
, DIM.DIMENSION_BY_CURRENCY
, VD.LAST_UPDATE_DATE
, VD.LAST_UPDATED_BY
, VD.LAST_UPDATE_LOGIN
, VD.CREATION_DATE
, VD.CREATED_BY
, VD.CONTEXT
, VD.ATTRIBUTE1
, VD.ATTRIBUTE2
, VD.ATTRIBUTE3
, VD.ATTRIBUTE4
, VD.ATTRIBUTE5
, VD.ATTRIBUTE6
, VD.ATTRIBUTE7
, VD.ATTRIBUTE8
, VD.ATTRIBUTE9
, VD.ATTRIBUTE10
, VD.ATTRIBUTE11
, VD.ATTRIBUTE12
, VD.ATTRIBUTE13
, VD.ATTRIBUTE14
, VD.ATTRIBUTE15
FROM GL_LOOKUPS LK
, RG_DSS_VAR_DIMENSIONS VD
, RG_DSS_DIMENSIONS DIM
WHERE VD.DIMENSION_ID = DIM.DIMENSION_ID
AND LK.LOOKUP_TYPE = 'GL_DSS_LEVEL_CODE'
AND LK.LOOKUP_CODE ||'' = DIM.LEVEL_CODE