CN_ELIGIBLE_CATS_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
ELIGIBLE_CAT_ID ORG_ID NAME DESCRIPTION LIABILITY_ACCOUNT_ID EXPENSE_ACCOUNT_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

Select B.ELIGIBLE_CAT_ID ,B.ORG_ID ,TL.NAME ,TL.DESCRIPTION ,B.LIABILITY_ACCOUNT_ID ,B.EXPENSE_ACCOUNT_ID ,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 ,B.CREATED_BY ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER FROM CN_ELIGIBLE_CATS_ALL_B B, CN_ELIGIBLE_CATS_ALL_TL TL WHERE B.ELIGIBLE_CAT_ID = TL.ELIGIBLE_CAT_ID AND TL.LANGUAGE = USERENV('LANG')