ZCA_OBJECTIVE_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
Name |
---|
OBJECTIVE_TYPE_ID OBJECTIVE_TYPE_CODE UOM_CODE ENABLED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CONFLICT_ID OBJECT_VERSION_NUMBER NAME DESCRIPTION |
Query
SQL_Statement |
---|
SELECT ZCA_OBJECTIVE_TYPES_B.OBJECTIVE_TYPE_ID OBJECTIVE_TYPE_ID, ZCA_OBJECTIVE_TYPES_B.OBJECTIVE_TYPE_CODE OBJECTIVE_TYPE_CODE, ZCA_OBJECTIVE_TYPES_B.UOM_CODE UOM_CODE, ZCA_OBJECTIVE_TYPES_B.ENABLED_FLAG ENABLED_FLAG, ZCA_OBJECTIVE_TYPES_B.CREATION_DATE CREATION_DATE, ZCA_OBJECTIVE_TYPES_B.CREATED_BY CREATED_BY, ZCA_OBJECTIVE_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ZCA_OBJECTIVE_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, ZCA_OBJECTIVE_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ZCA_OBJECTIVE_TYPES_B.CONFLICT_ID CONFLICT_ID, ZCA_OBJECTIVE_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZCA_OBJECTIVE_TYPES_TL.NAME NAME, ZCA_OBJECTIVE_TYPES_TL.DESCRIPTION DESCRIPTION FROM ZCA_OBJECTIVE_TYPES_B, ZCA_OBJECTIVE_TYPES_TL WHERE ZCA_OBJECTIVE_TYPES_B.OBJECTIVE_TYPE_ID = ZCA_OBJECTIVE_TYPES_TL.OBJECTIVE_TYPE_ID AND ZCA_OBJECTIVE_TYPES_TL.LANGUAGE = USERENV('LANG') |