BEN_ACTN_TYP_VL

Details

• Schema: FUSION

• Object owner: BEN

• Object type: VIEW

Columns

Name

ACTN_TYP_ID BUSINESS_GROUP_ID TYPE_CD NAME DESCRIPTION EAT_ATTRIBUTE_CATEGORY EAT_ATTRIBUTE1 EAT_ATTRIBUTE2 EAT_ATTRIBUTE3 EAT_ATTRIBUTE4 EAT_ATTRIBUTE5 EAT_ATTRIBUTE6 EAT_ATTRIBUTE7 EAT_ATTRIBUTE8 EAT_ATTRIBUTE9 EAT_ATTRIBUTE10 EAT_ATTRIBUTE11 EAT_ATTRIBUTE12 EAT_ATTRIBUTE13 EAT_ATTRIBUTE14 EAT_ATTRIBUTE15 EAT_ATTRIBUTE16 EAT_ATTRIBUTE17 EAT_ATTRIBUTE18 EAT_ATTRIBUTE19 EAT_ATTRIBUTE20 EAT_ATTRIBUTE21 EAT_ATTRIBUTE22 EAT_ATTRIBUTE23 EAT_ATTRIBUTE24 EAT_ATTRIBUTE25 EAT_ATTRIBUTE26 EAT_ATTRIBUTE27 EAT_ATTRIBUTE28 EAT_ATTRIBUTE29 EAT_ATTRIBUTE30 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER ACTN_TYP_LVL_CD EAT_ATTRIBUTE_NUMBER1 EAT_ATTRIBUTE_NUMBER2 EAT_ATTRIBUTE_NUMBER3 EAT_ATTRIBUTE_NUMBER4 EAT_ATTRIBUTE_NUMBER5 EAT_ATTRIBUTE_NUMBER6 EAT_ATTRIBUTE_NUMBER7 EAT_ATTRIBUTE_NUMBER8 EAT_ATTRIBUTE_NUMBER9 EAT_ATTRIBUTE_NUMBER10 EAT_ATTRIBUTE_NUMBER11 EAT_ATTRIBUTE_NUMBER12 EAT_ATTRIBUTE_NUMBER13 EAT_ATTRIBUTE_NUMBER14 EAT_ATTRIBUTE_NUMBER15 EAT_ATTRIBUTE_NUMBER16 EAT_ATTRIBUTE_NUMBER17 EAT_ATTRIBUTE_NUMBER18 EAT_ATTRIBUTE_NUMBER19 EAT_ATTRIBUTE_NUMBER20 EAT_ATTRIBUTE_DATE1 EAT_ATTRIBUTE_DATE2 EAT_ATTRIBUTE_DATE3 EAT_ATTRIBUTE_DATE4 EAT_ATTRIBUTE_DATE5 EAT_ATTRIBUTE_DATE6 EAT_ATTRIBUTE_DATE7 EAT_ATTRIBUTE_DATE8 EAT_ATTRIBUTE_DATE9 EAT_ATTRIBUTE_DATE10 EAT_ATTRIBUTE_DATE11 EAT_ATTRIBUTE_DATE12 EAT_ATTRIBUTE_DATE13 EAT_ATTRIBUTE_DATE14 EAT_ATTRIBUTE_DATE15

Query

SQL_Statement

SELECT EAT.ACTN_TYP_ID, EAT.BUSINESS_GROUP_ID, EAT.TYPE_CD, TL.NAME, TL.DESCRIPTION, EAT.EAT_ATTRIBUTE_CATEGORY, EAT.EAT_ATTRIBUTE1, EAT.EAT_ATTRIBUTE2, EAT.EAT_ATTRIBUTE3, EAT.EAT_ATTRIBUTE4, EAT.EAT_ATTRIBUTE5, EAT.EAT_ATTRIBUTE6, EAT.EAT_ATTRIBUTE7, EAT.EAT_ATTRIBUTE8, EAT.EAT_ATTRIBUTE9, EAT.EAT_ATTRIBUTE10, EAT.EAT_ATTRIBUTE11, EAT.EAT_ATTRIBUTE12, EAT.EAT_ATTRIBUTE13, EAT.EAT_ATTRIBUTE14, EAT.EAT_ATTRIBUTE15, EAT.EAT_ATTRIBUTE16, EAT.EAT_ATTRIBUTE17, EAT.EAT_ATTRIBUTE18, EAT.EAT_ATTRIBUTE19, EAT.EAT_ATTRIBUTE20, EAT.EAT_ATTRIBUTE21, EAT.EAT_ATTRIBUTE22, EAT.EAT_ATTRIBUTE23, EAT.EAT_ATTRIBUTE24, EAT.EAT_ATTRIBUTE25, EAT.EAT_ATTRIBUTE26, EAT.EAT_ATTRIBUTE27, EAT.EAT_ATTRIBUTE28, EAT.EAT_ATTRIBUTE29, EAT.EAT_ATTRIBUTE30, EAT.LAST_UPDATE_DATE, EAT.LAST_UPDATED_BY, EAT.LAST_UPDATE_LOGIN, EAT.CREATED_BY, EAT.CREATION_DATE, EAT.OBJECT_VERSION_NUMBER, EAT.ACTN_TYP_LVL_CD, EAT.EAT_ATTRIBUTE_NUMBER1, EAT.EAT_ATTRIBUTE_NUMBER2, EAT.EAT_ATTRIBUTE_NUMBER3, EAT.EAT_ATTRIBUTE_NUMBER4, EAT.EAT_ATTRIBUTE_NUMBER5, EAT.EAT_ATTRIBUTE_NUMBER6, EAT.EAT_ATTRIBUTE_NUMBER7, EAT.EAT_ATTRIBUTE_NUMBER8, EAT.EAT_ATTRIBUTE_NUMBER9, EAT.EAT_ATTRIBUTE_NUMBER10, EAT.EAT_ATTRIBUTE_NUMBER11, EAT.EAT_ATTRIBUTE_NUMBER12, EAT.EAT_ATTRIBUTE_NUMBER13, EAT.EAT_ATTRIBUTE_NUMBER14, EAT.EAT_ATTRIBUTE_NUMBER15, EAT.EAT_ATTRIBUTE_NUMBER16, EAT.EAT_ATTRIBUTE_NUMBER17, EAT.EAT_ATTRIBUTE_NUMBER18, EAT.EAT_ATTRIBUTE_NUMBER19, EAT.EAT_ATTRIBUTE_NUMBER20, EAT.EAT_ATTRIBUTE_DATE1, EAT.EAT_ATTRIBUTE_DATE2, EAT.EAT_ATTRIBUTE_DATE3, EAT.EAT_ATTRIBUTE_DATE4, EAT.EAT_ATTRIBUTE_DATE5, EAT.EAT_ATTRIBUTE_DATE6, EAT.EAT_ATTRIBUTE_DATE7, EAT.EAT_ATTRIBUTE_DATE8, EAT.EAT_ATTRIBUTE_DATE9, EAT.EAT_ATTRIBUTE_DATE10, EAT.EAT_ATTRIBUTE_DATE11, EAT.EAT_ATTRIBUTE_DATE12, EAT.EAT_ATTRIBUTE_DATE13, EAT.EAT_ATTRIBUTE_DATE14, EAT.EAT_ATTRIBUTE_DATE15 FROM BEN_ACTN_TYP EAT, BEN_ACTN_TYP_TL TL WHERE EAT.ACTN_TYP_ID = TL.ACTN_TYP_ID AND TL.LANGUAGE = USERENV('LANG')