ZCA_SA_UTTERANCE_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
SA_CONTEXT_CODE SA_CONTEXT_VALUE UTTERANCE_TYPE UTTERANCE_CODE UTTERANCE OBJECT_LABEL UTTERANCE_METADATA CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT zca_sa_utterance_b.SA_CONTEXT_CODE SA_CONTEXT_CODE, zca_sa_utterance_b.SA_CONTEXT_VALUE SA_CONTEXT_VALUE, zca_sa_utterance_b.UTTERANCE_TYPE UTTERANCE_TYPE, zca_sa_utterance_b.UTTERANCE_CODE UTTERANCE_CODE, zca_sa_utterance_tl.UTTERANCE UTTERANCE, zca_sa_utterance_tl.OBJECT_LABEL OBJECT_LABEL, zca_sa_utterance_b.UTTERANCE_METADATA UTTERANCE_METADATA, zca_sa_utterance_b.CREATION_DATE CREATION_DATE, zca_sa_utterance_b.CREATED_BY CREATED_BY, zca_sa_utterance_b.LAST_UPDATE_DATE LAST_UPDATE_DATE, zca_sa_utterance_b.LAST_UPDATED_BY LAST_UPDATED_BY, zca_sa_utterance_b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, zca_sa_utterance_b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM zca_sa_utterance_b, zca_sa_utterance_tl WHERE zca_sa_utterance_b.SA_CONTEXT_CODE = zca_sa_utterance_tl.SA_CONTEXT_CODE AND zca_sa_utterance_b.SA_CONTEXT_VALUE = zca_sa_utterance_tl.SA_CONTEXT_VALUE AND zca_sa_utterance_b.UTTERANCE_TYPE = zca_sa_utterance_tl.UTTERANCE_TYPE AND zca_sa_utterance_b.UTTERANCE_CODE = zca_sa_utterance_tl.UTTERANCE_CODE AND zca_sa_utterance_tl.LANGUAGE = USERENV('LANG')