ACA_PC_COMMON_CONFIG_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
CONFIG_TYPE CONFIG_CODE CONFIG_VALUE DELETE_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CONFIG_LABEL DESCRIPTION

Query

SQL_Statement
SELECT A.CONFIG_TYPE, A.CONFIG_CODE, A.CONFIG_VALUE, A.DELETE_FLAG, A.OBJECT_VERSION_NUMBER, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, TL.CONFIG_LABEL, TL.DESCRIPTION FROM ACA_PC_COMMON_CONFIG_B A, ACA_PC_COMMON_CONFIG_TL TL WHERE A.CONFIG_TYPE = TL.CONFIG_TYPE AND A.CONFIG_CODE = TL.CONFIG_CODE AND TL.LANGUAGE = USERENV('LANG')