ZCA_OML_RULES_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
RULE_CODE RULE_TYPE TABLE_OR_FIELD_LEVEL CONDITION_PREDICATE ERROR_TYPE ADDITIONAL_METADATA CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SOURCE_LANG LANGUAGE RULE_TEXT

Query

SQL_Statement

SELECT zca_oml_rules_b.RULE_CODE, zca_oml_rules_b.RULE_TYPE, zca_oml_rules_b.TABLE_OR_FIELD_LEVEL, zca_oml_rules_b.CONDITION_PREDICATE, zca_oml_rules_b.ERROR_TYPE, zca_oml_rules_b.ADDITIONAL_METADATA, zca_oml_rules_b.CREATED_BY, zca_oml_rules_b.CREATION_DATE, zca_oml_rules_b.LAST_UPDATE_DATE, zca_oml_rules_b.LAST_UPDATED_BY, zca_oml_rules_b.LAST_UPDATE_LOGIN, zca_oml_rules_b.OBJECT_VERSION_NUMBER, zca_oml_rules_tl.SOURCE_LANG, zca_oml_rules_tl.LANGUAGE, zca_oml_rules_tl.RULE_TEXT FROM zca_oml_rules_b, zca_oml_rules_tl WHERE zca_oml_rules_b.RULE_CODE = zca_oml_rules_tl.RULE_CODE and zca_oml_rules_tl.LANGUAGE = USERENV('LANG')