ZCA_CH_CLICK_MAPPING_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name

CLICK_MAPPING_ID CH_EVENT_COMP_CLIENT_CODE CLICK_EVENT_FLOW_NAME CLICK_EVENT_FLOW_NAME_CODE CLICK_EVENT_TYPE CLICK_MAPPING_DESCRIPTION CLICK_MAPPING_DESC_CODE CLICK_PATTERN CLICK_EVENT_FLOW_NAME_STR CLICK_MAPPING_DESCRIPTION_STR CLICK_REGION_VIEW_ID CLICK_RVD_PATTERN SEED_DATA_SOURCE OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.CLICK_MAPPING_ID, B.CH_EVENT_COMP_CLIENT_CODE, TL.CLICK_EVENT_FLOW_NAME, B.CLICK_EVENT_FLOW_NAME_CODE, B.CLICK_EVENT_TYPE, TL.CLICK_MAPPING_DESCRIPTION, B.CLICK_MAPPING_DESC_CODE, B.CLICK_PATTERN, B.CLICK_EVENT_FLOW_NAME_STR, B.CLICK_MAPPING_DESCRIPTION_STR, B.CLICK_REGION_VIEW_ID, B.CLICK_RVD_PATTERN, TL.SEED_DATA_SOURCE, B.OBJECT_VERSION_NUMBER, TL.REQUEST_ID, TL.JOB_DEFINITION_NAME, TL.JOB_DEFINITION_PACKAGE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM ZCA_CH_CLICK_MAPPING_B B, ZCA_CH_CLICK_MAPPING_TL TL WHERE B.CLICK_MAPPING_ID = TL.CLICK_MAPPING_ID AND TL.LANGUAGE = USERENV('LANG')