ZCA_CH_CLICK_COMPONENT_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
CH_COMPONENT_TYPE_CODE CH_COMPONENT_NAME_CODE CH_COMPONENT_NAME LANGUAGE SOURCE_LANG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.CH_COMPONENT_TYPE_CODE, B.CH_COMPONENT_NAME_CODE, TL.CH_COMPONENT_NAME, TL.LANGUAGE, TL.SOURCE_LANG, TL.CREATED_BY, TL.CREATION_DATE, TL.LAST_UPDATED_BY, TL.LAST_UPDATE_DATE, TL.LAST_UPDATE_LOGIN FROM ZCA_CH_CLICK_COMPONENT_B B, ZCA_CH_CLICK_COMPONENT_TL TL WHERE B.CH_COMPONENT_TYPE_CODE = TL.CH_COMPONENT_TYPE_CODE AND TL.LANGUAGE = USERENV('LANG')