ZCA_AI_FEATURE_RULES

Details

Schema: FUSION
Object owner: ZCA
Object type: VIEW

Columns

Name
FEATURE_RULE_ID FEATURE_CODE FEATURE_RULE_CODE FEATURE_RULE_TYPE ACTIVATION_THRESHOLD EMERGING_THRESHOLD ADDITIONAL_METADATA IS_DELETED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER FEATURE_RULE_NAME

Name

FEATURE_RULE_ID

FEATURE_CODE

FEATURE_RULE_CODE

FEATURE_RULE_TYPE

ACTIVATION_THRESHOLD

EMERGING_THRESHOLD

ADDITIONAL_METADATA

IS_DELETED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

FEATURE_RULE_NAME

Query

SQL_Statement
SELECT ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_ID, ZCA_AI_FEATURE_RULES_B.FEATURE_CODE, ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_CODE, ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_TYPE, ZCA_AI_FEATURE_RULES_B.ACTIVATION_THRESHOLD, ZCA_AI_FEATURE_RULES_B.EMERGING_THRESHOLD, ZCA_AI_FEATURE_RULES_B.ADDITIONAL_METADATA, ZCA_AI_FEATURE_RULES_B.IS_DELETED_FLAG, ZCA_AI_FEATURE_RULES_B.CREATED_BY, ZCA_AI_FEATURE_RULES_B.CREATION_DATE, ZCA_AI_FEATURE_RULES_B.LAST_UPDATED_BY, ZCA_AI_FEATURE_RULES_B.LAST_UPDATE_DATE, ZCA_AI_FEATURE_RULES_B.LAST_UPDATE_LOGIN, ZCA_AI_FEATURE_RULES_B.OBJECT_VERSION_NUMBER, ZCA_AI_FEATURE_RULES_TL.FEATURE_RULE_NAME FROM ZCA_AI_FEATURE_RULES_B, ZCA_AI_FEATURE_RULES_TL WHERE ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_ID = ZCA_AI_FEATURE_RULES_TL.FEATURE_RULE_ID and ZCA_AI_FEATURE_RULES_B.FEATURE_CODE = ZCA_AI_FEATURE_RULES_TL.FEATURE_CODE and ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_CODE = ZCA_AI_FEATURE_RULES_TL.FEATURE_RULE_CODE and ZCA_AI_FEATURE_RULES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_ID,

ZCA_AI_FEATURE_RULES_B.FEATURE_CODE,

ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_CODE,

ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_TYPE,

ZCA_AI_FEATURE_RULES_B.ACTIVATION_THRESHOLD,

ZCA_AI_FEATURE_RULES_B.EMERGING_THRESHOLD,

ZCA_AI_FEATURE_RULES_B.ADDITIONAL_METADATA,

ZCA_AI_FEATURE_RULES_B.IS_DELETED_FLAG,

ZCA_AI_FEATURE_RULES_B.CREATED_BY,

ZCA_AI_FEATURE_RULES_B.CREATION_DATE,

ZCA_AI_FEATURE_RULES_B.LAST_UPDATED_BY,

ZCA_AI_FEATURE_RULES_B.LAST_UPDATE_DATE,

ZCA_AI_FEATURE_RULES_B.LAST_UPDATE_LOGIN,

ZCA_AI_FEATURE_RULES_B.OBJECT_VERSION_NUMBER,

ZCA_AI_FEATURE_RULES_TL.FEATURE_RULE_NAME

FROM

ZCA_AI_FEATURE_RULES_B,

ZCA_AI_FEATURE_RULES_TL

WHERE

ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_ID = ZCA_AI_FEATURE_RULES_TL.FEATURE_RULE_ID and ZCA_AI_FEATURE_RULES_B.FEATURE_CODE = ZCA_AI_FEATURE_RULES_TL.FEATURE_CODE and ZCA_AI_FEATURE_RULES_B.FEATURE_RULE_CODE = ZCA_AI_FEATURE_RULES_TL.FEATURE_RULE_CODE and ZCA_AI_FEATURE_RULES_TL.LANGUAGE = USERENV('LANG')