CN_CONVERSION_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

CONVERSION_TYPE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

CONVERSION_NAME

CONVERSION_DESCRIPTION

Query

SQL_Statement

select

b.CONVERSION_TYPE_ID,

b.OBJECT_VERSION_NUMBER,

b.CREATED_BY,

b.CREATION_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.attribute1 ,

b.attribute2 ,

b.attribute3 ,

b.attribute4 ,

b.attribute5 ,

b.attribute6 ,

b.attribute7 ,

b.attribute8 ,

b.attribute9 ,

b.attribute10 ,

b.attribute11 ,

b.attribute12 ,

b.attribute13 ,

b.attribute14 ,

b.attribute15 ,

t.CONVERSION_NAME,

t.CONVERSION_DESCRIPTION

from cn_conversion_types_b b,

cn_conversion_types_tl t

where b.CONVERSION_TYPE_ID = t.conversion_type_id

and t.language = userenv('LANG')