ZCA_AI_FEATURES

Details

Schema: FUSION
Object owner: ZCA
Object type: VIEW

Columns

Name
FEATURE_ID FEATURE_CODE FEATURE_PLATFORM_CODE FEATURE_RESOURCE IS_ACTIVE_BY_DEFAULT_FLAG ACTIVATION_THRESHOLD EMERGING_THRESHOLD ADDITIONAL_METADATA CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER FEATURE_STATUS DATASUFFICIENCY_LEVEL SELECTED_TO_ENABLE_FLAG MRG_REPORT_ID MRG_REPORT REVIEW_IN_PROGRESS_FLAG FEATURE_NAME FEATURE_DESCRIPTION FEATURE_PLATFORM_NAME

Name

FEATURE_ID

FEATURE_CODE

FEATURE_PLATFORM_CODE

FEATURE_RESOURCE

IS_ACTIVE_BY_DEFAULT_FLAG

ACTIVATION_THRESHOLD

EMERGING_THRESHOLD

ADDITIONAL_METADATA

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

FEATURE_STATUS

DATASUFFICIENCY_LEVEL

SELECTED_TO_ENABLE_FLAG

MRG_REPORT_ID

MRG_REPORT

REVIEW_IN_PROGRESS_FLAG

FEATURE_NAME

FEATURE_DESCRIPTION

FEATURE_PLATFORM_NAME

Query

SQL_Statement
SELECT ZCA_AI_FEATURES_B.FEATURE_ID, ZCA_AI_FEATURES_B.FEATURE_CODE, ZCA_AI_FEATURES_B.FEATURE_PLATFORM_CODE, ZCA_AI_FEATURES_B.FEATURE_RESOURCE, ZCA_AI_FEATURES_B.IS_ACTIVE_BY_DEFAULT_FLAG, ZCA_AI_FEATURES_B.ACTIVATION_THRESHOLD, ZCA_AI_FEATURES_B.EMERGING_THRESHOLD, ZCA_AI_FEATURES_B.ADDITIONAL_METADATA, ZCA_AI_FEATURES_B.CREATION_DATE, ZCA_AI_FEATURES_B.CREATED_BY, ZCA_AI_FEATURES_B.LAST_UPDATED_BY, ZCA_AI_FEATURES_B.LAST_UPDATE_DATE, ZCA_AI_FEATURES_B.LAST_UPDATE_LOGIN, ZCA_AI_FEATURES_B.OBJECT_VERSION_NUMBER, ZCA_AI_FEATURE_ACTIVATION_INFO.FEATURE_STATUS, ZCA_AI_FEATURE_ACTIVATION_INFO.DATASUFFICIENCY_LEVEL, ZCA_AI_FEATURE_ACTIVATION_INFO.SELECTED_TO_ENABLE_FLAG, ZCA_AI_FEATURE_ACTIVATION_INFO.MRG_REPORT_ID, ZCA_AI_FEATURE_ACTIVATION_INFO.MRG_REPORT, ZCA_AI_FEATURE_ACTIVATION_INFO.REVIEW_IN_PROGRESS_FLAG, ZCA_AI_FEATURES_TL.FEATURE_NAME, ZCA_AI_FEATURES_TL.FEATURE_DESCRIPTION, ZCA_AI_FEATURES_TL.FEATURE_PLATFORM_NAME FROM ZCA_AI_FEATURES_B, ZCA_AI_FEATURE_ACTIVATION_INFO, ZCA_AI_FEATURES_TL WHERE ZCA_AI_FEATURES_B.FEATURE_ID = ZCA_AI_FEATURES_TL.FEATURE_ID and ZCA_AI_FEATURES_B.FEATURE_ID = ZCA_AI_FEATURE_ACTIVATION_INFO.FEATURE_ID and ZCA_AI_FEATURES_B.FEATURE_CODE = ZCA_AI_FEATURES_TL.FEATURE_CODE and ZCA_AI_FEATURES_B.FEATURE_CODE = ZCA_AI_FEATURE_ACTIVATION_INFO.FEATURE_CODE and ZCA_AI_FEATURES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ZCA_AI_FEATURES_B.FEATURE_ID,

ZCA_AI_FEATURES_B.FEATURE_CODE,

ZCA_AI_FEATURES_B.FEATURE_PLATFORM_CODE,

ZCA_AI_FEATURES_B.FEATURE_RESOURCE,

ZCA_AI_FEATURES_B.IS_ACTIVE_BY_DEFAULT_FLAG,

ZCA_AI_FEATURES_B.ACTIVATION_THRESHOLD,

ZCA_AI_FEATURES_B.EMERGING_THRESHOLD,

ZCA_AI_FEATURES_B.ADDITIONAL_METADATA,

ZCA_AI_FEATURES_B.CREATION_DATE,

ZCA_AI_FEATURES_B.CREATED_BY,

ZCA_AI_FEATURES_B.LAST_UPDATED_BY,

ZCA_AI_FEATURES_B.LAST_UPDATE_DATE,

ZCA_AI_FEATURES_B.LAST_UPDATE_LOGIN,

ZCA_AI_FEATURES_B.OBJECT_VERSION_NUMBER,

ZCA_AI_FEATURE_ACTIVATION_INFO.FEATURE_STATUS,

ZCA_AI_FEATURE_ACTIVATION_INFO.DATASUFFICIENCY_LEVEL,

ZCA_AI_FEATURE_ACTIVATION_INFO.SELECTED_TO_ENABLE_FLAG,

ZCA_AI_FEATURE_ACTIVATION_INFO.MRG_REPORT_ID,

ZCA_AI_FEATURE_ACTIVATION_INFO.MRG_REPORT,

ZCA_AI_FEATURE_ACTIVATION_INFO.REVIEW_IN_PROGRESS_FLAG,

ZCA_AI_FEATURES_TL.FEATURE_NAME,

ZCA_AI_FEATURES_TL.FEATURE_DESCRIPTION,

ZCA_AI_FEATURES_TL.FEATURE_PLATFORM_NAME

FROM

ZCA_AI_FEATURES_B,

ZCA_AI_FEATURE_ACTIVATION_INFO,

ZCA_AI_FEATURES_TL

WHERE

ZCA_AI_FEATURES_B.FEATURE_ID = ZCA_AI_FEATURES_TL.FEATURE_ID and ZCA_AI_FEATURES_B.FEATURE_ID = ZCA_AI_FEATURE_ACTIVATION_INFO.FEATURE_ID and ZCA_AI_FEATURES_B.FEATURE_CODE = ZCA_AI_FEATURES_TL.FEATURE_CODE and ZCA_AI_FEATURES_B.FEATURE_CODE = ZCA_AI_FEATURE_ACTIVATION_INFO.FEATURE_CODE and ZCA_AI_FEATURES_TL.LANGUAGE = USERENV('LANG')