1. Tables and Views for Sales, Fusion Service, and Field Service
  2. ZCA_ENGMT_OBJECTIVE_HVA_DT_VL

ZCA_ENGMT_OBJECTIVE_HVA_DT_VL

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

OBJECTIVE_HVA_DT_ID

NAME

DESC_TEXT

EVALUATION_TEXT

DISPLAY_SEQUENCE

CREATION_DATE

SALES_OBJECTIVE_ID

DELETED_FLAG

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

B.OBJECTIVE_HVA_DT_ID,

T.NAME NAME,

T.DESC_TEXT DESC_TEXT,

T.EVALUATION_TEXT EVALUATION_TEXT,

B.DISPLAY_SEQUENCE,

B.CREATION_DATE,

B.SALES_OBJECTIVE_ID,

B.DELETED_FLAG,

B.CREATED_BY,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER

FROM

ZCA_ENGMT_OBJECTIVE_HVA_DT_B B,

ZCA_ENGMT_OBJECTIVE_HVA_DT_TL T

WHERE

B.OBJECTIVE_HVA_DT_ID = T.OBJECTIVE_HVA_DT_ID

AND T.LANGUAGE = USERENV('LANG')