VIEW: APPS.RG_DSS_VAR_DIMENSIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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