CN_RATE_TABLES_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
RATE_TABLE_ID OBJECT_VERSION_NUMBER ORG_ID RATE_TABLE_NAME DISPLAY_NAME DESCRIPTION COMMISSION_UNIT_CODE NUMBER_DIM 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_TABLE_ID,b.OBJECT_VERSION_NUMBER,b.ORG_ID,RATE_TABLE_NAME,DISPLAY_NAME, DESCRIPTION, COMMISSION_UNIT_CODE,NUMBER_DIM,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_TABLES_ALL_B b, CN_RATE_TABLES_ALL_TL t where b.RATE_TABLE_ID = t.RATE_TABLE_ID and t.LANGUAGE = userenv('LANG')