ZCA_SA_CONFIGURATIONS

Details

Schema: FUSION
Object owner: ZCA
Object type: VIEW

Columns

Name
CONFIGURATION_CODE CONFIGURATION_VALUE SA_CONTEXT_CODE SA_CONTEXT_VALUE CONFIGURATION_MEANING ADDITIONAL_CONTEXT EFFECTIVE_START_DATE EFFECTIVE_END_DATE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Name

CONFIGURATION_CODE

CONFIGURATION_VALUE

SA_CONTEXT_CODE

SA_CONTEXT_VALUE

CONFIGURATION_MEANING

ADDITIONAL_CONTEXT

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT ZCA_SA_CONFIGURATIONS_B.CONFIGURATION_CODE, ZCA_SA_CONFIGURATIONS_B.CONFIGURATION_VALUE, ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_CODE, ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_VALUE, ZCA_SA_CONFIGURATIONS_TL.CONFIGURATION_MEANING, ZCA_SA_CONFIGURATIONS_B.ADDITIONAL_CONTEXT, ZCA_SA_CONFIGURATIONS_B.EFFECTIVE_START_DATE, ZCA_SA_CONFIGURATIONS_B.EFFECTIVE_END_DATE, ZCA_SA_CONFIGURATIONS_B.CREATION_DATE, ZCA_SA_CONFIGURATIONS_B.CREATED_BY, ZCA_SA_CONFIGURATIONS_B.LAST_UPDATED_BY, ZCA_SA_CONFIGURATIONS_B.LAST_UPDATE_DATE, ZCA_SA_CONFIGURATIONS_B.LAST_UPDATE_LOGIN, ZCA_SA_CONFIGURATIONS_B.OBJECT_VERSION_NUMBER FROM ZCA_SA_CONFIGURATIONS_B, ZCA_SA_CONFIGURATIONS_TL WHERE ZCA_SA_CONFIGURATIONS_B.CONFIGURATION_CODE = ZCA_SA_CONFIGURATIONS_TL.CONFIGURATION_CODE AND ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_CODE = ZCA_SA_CONFIGURATIONS_TL.SA_CONTEXT_CODE AND ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_VALUE = ZCA_SA_CONFIGURATIONS_TL.SA_CONTEXT_VALUE AND ZCA_SA_CONFIGURATIONS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ZCA_SA_CONFIGURATIONS_B.CONFIGURATION_CODE,

ZCA_SA_CONFIGURATIONS_B.CONFIGURATION_VALUE,

ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_CODE,

ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_VALUE,

ZCA_SA_CONFIGURATIONS_TL.CONFIGURATION_MEANING,

ZCA_SA_CONFIGURATIONS_B.ADDITIONAL_CONTEXT,

ZCA_SA_CONFIGURATIONS_B.EFFECTIVE_START_DATE,

ZCA_SA_CONFIGURATIONS_B.EFFECTIVE_END_DATE,

ZCA_SA_CONFIGURATIONS_B.CREATION_DATE,

ZCA_SA_CONFIGURATIONS_B.CREATED_BY,

ZCA_SA_CONFIGURATIONS_B.LAST_UPDATED_BY,

ZCA_SA_CONFIGURATIONS_B.LAST_UPDATE_DATE,

ZCA_SA_CONFIGURATIONS_B.LAST_UPDATE_LOGIN,

ZCA_SA_CONFIGURATIONS_B.OBJECT_VERSION_NUMBER

FROM

ZCA_SA_CONFIGURATIONS_B,

ZCA_SA_CONFIGURATIONS_TL

WHERE

ZCA_SA_CONFIGURATIONS_B.CONFIGURATION_CODE = ZCA_SA_CONFIGURATIONS_TL.CONFIGURATION_CODE AND ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_CODE = ZCA_SA_CONFIGURATIONS_TL.SA_CONTEXT_CODE AND ZCA_SA_CONFIGURATIONS_B.SA_CONTEXT_VALUE = ZCA_SA_CONFIGURATIONS_TL.SA_CONTEXT_VALUE AND ZCA_SA_CONFIGURATIONS_TL.LANGUAGE = USERENV('LANG')