ZCA_AI_HINTS_VL

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

HINT_CODE

HINT_TYPE

HINT_NAME

HINT_DESCRIPTION

FEATURE_CODE

OBJECT_TYPE

ENABLED_FLAG

LOCALIZED_SUMMARY

LOCALIZED_DETAIL

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

USER_LAST_UPDATE_DATE

Query

SQL_Statement

SELECT

ZCA_AI_HINTS_B.HINT_CODE HINT_CODE,

ZCA_AI_HINTS_B.HINT_TYPE HINT_TYPE,

ZCA_AI_HINTS_TL.HINT_NAME HINT_NAME,

ZCA_AI_HINTS_TL.HINT_DESCRIPTION HINT_DESCRIPTION,

ZCA_AI_HINTS_B.FEATURE_CODE FEATURE_CODE,

ZCA_AI_HINTS_B.OBJECT_TYPE OBJECT_TYPE,

ZCA_AI_HINTS_B.ENABLED_FLAG ENABLED_FLAG,

ZCA_AI_HINTS_TL.LOCALIZED_SUMMARY LOCALIZED_SUMMARY,

ZCA_AI_HINTS_TL.LOCALIZED_DETAIL LOCALIZED_DETAIL,

ZCA_AI_HINTS_B.CREATION_DATE CREATION_DATE,

ZCA_AI_HINTS_B.CREATED_BY CREATED_BY,

ZCA_AI_HINTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ZCA_AI_HINTS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ZCA_AI_HINTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ZCA_AI_HINTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ZCA_AI_HINTS_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE

FROM

ZCA_AI_HINTS_B,

ZCA_AI_HINTS_TL

WHERE

ZCA_AI_HINTS_B.HINT_CODE = ZCA_AI_HINTS_TL.HINT_CODE

AND ZCA_AI_HINTS_TL.LANGUAGE = USERENV('LANG')