HWM_TL_TASK_FEATURES_VL

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

TL_TASK_FEATURES_ID

ENTERPRISE_ID

TASK_NAME

DESCRIPTION

TASK_SHORT_NAME

LOGIC_EXPRESION

TYPE

URL_RESOURCE

SEQUENCE_NUM

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

Query

SQL_Statement

SELECT

HWM_TL_TASK_FEATURES_B.TL_TASK_FEATURES_ID,

HWM_TL_TASK_FEATURES_B.ENTERPRISE_ID,

HWM_TL_TASK_FEATURES_TL.TASK_NAME,

HWM_TL_TASK_FEATURES_TL.DESCRIPTION,

HWM_TL_TASK_FEATURES_B.TASK_SHORT_NAME,

HWM_TL_TASK_FEATURES_B.LOGIC_EXPRESION,

HWM_TL_TASK_FEATURES_B.TYPE,

HWM_TL_TASK_FEATURES_B.URL_RESOURCE,

HWM_TL_TASK_FEATURES_B.SEQUENCE_NUM,

HWM_TL_TASK_FEATURES_B.CREATED_BY,

HWM_TL_TASK_FEATURES_B.CREATION_DATE,

HWM_TL_TASK_FEATURES_B.LAST_UPDATE_DATE,

HWM_TL_TASK_FEATURES_B.LAST_UPDATE_LOGIN,

HWM_TL_TASK_FEATURES_B.LAST_UPDATED_BY

FROM

HWM_TL_TASK_FEATURES_B HWM_TL_TASK_FEATURES_B,

HWM_TL_TASK_FEATURES_TL HWM_TL_TASK_FEATURES_TL

WHERE

HWM_TL_TASK_FEATURES_B.TL_TASK_FEATURES_ID = HWM_TL_TASK_FEATURES_TL.TL_TASK_FEATURES_ID AND

HWM_TL_TASK_FEATURES_TL.LANGUAGE = USERENV('LANG')