CN_RATE_DIMENSIONS_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
RATE_DIMENSION_ID OBJECT_VERSION_NUMBER ORG_ID RATE_DIMENSION_NAME DESCRIPTION DIM_UNIT_CODE NUMBER_TIER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15

Query

SQL_Statement

select b.RATE_DIMENSION_ID, b.OBJECT_VERSION_NUMBER, b.ORG_ID, RATE_DIMENSION_NAME, DESCRIPTION,DIM_UNIT_CODE,NUMBER_TIER,b.CREATED_BY,b.CREATION_DATE,b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE,b.LAST_UPDATE_LOGIN,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2, ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9, ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15 from CN_RATE_DIMENSIONS_ALL_B b, CN_RATE_DIMENSIONS_ALL_TL t where b.RATE_DIMENSION_ID = t.RATE_DIMENSION_ID and t.LANGUAGE = userenv('LANG')