CN_GOALS_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

GOAL_ID OBJECT_VERSION_NUMBER ORG_ID GOAL_NAME DESCRIPTION TARGET ALT_TARGET_1 ALT_TARGET_2 ALT_TARGET_3 ALT_TARGET_4 ALT_TARGET_5 START_DATE END_DATE ACCUMULATION_INTERVAL_ID UNIT_OF_MEASURE 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.GOAL_ID, b.OBJECT_VERSION_NUMBER, b.ORG_ID, GOAL_NAME,DESCRIPTION, TARGET, ALT_TARGET_1, ALT_TARGET_2, ALT_TARGET_3, ALT_TARGET_4, ALT_TARGET_5, START_DATE , END_DATE , ACCUMULATION_INTERVAL_ID, UNIT_OF_MEASURE, 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_GOALS_ALL_B b, CN_GOALS_ALL_TL t where b.GOAL_ID = t.GOAL_ID and t.LANGUAGE = userenv('LANG') )