ZSP_BR_RULES_VL
Details
-
Schema: FUSION
-
Object owner: ZSP
-
Object type: VIEW
Columns
Name |
---|
RULE_ID RULE_TYPE_NAME RULE_FOLDER_ID RULE_NAME ACTIVE_FLAG EFFECTIVE_START_DATE EFFECTIVE_END_DATE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE DESCRIPTION CONDITIONS_TEXT |
Query
SQL_Statement |
---|
SELECT ZSP_BR_RULES_B.RULE_ID, ZSP_BR_RULES_B.RULE_TYPE_NAME, ZSP_BR_RULES_B.RULE_FOLDER_ID, ZSP_BR_RULES_B.RULE_NAME, ZSP_BR_RULES_B.ACTIVE_FLAG, ZSP_BR_RULES_B.EFFECTIVE_START_DATE, ZSP_BR_RULES_B.EFFECTIVE_END_DATE, ZSP_BR_RULES_B.CREATED_BY, ZSP_BR_RULES_B.CREATION_DATE, ZSP_BR_RULES_B.LAST_UPDATE_DATE, ZSP_BR_RULES_B.LAST_UPDATE_LOGIN, ZSP_BR_RULES_B.LAST_UPDATED_BY, ZSP_BR_RULES_B.OBJECT_VERSION_NUMBER, ZSP_BR_RULES_B.USER_LAST_UPDATE_DATE, ZSP_BR_RULES_TL.DESCRIPTION, ZSP_BR_RULES_TL.CONDITIONS_TEXT FROM ZSP_BR_RULES_B, ZSP_BR_RULES_TL WHERE ZSP_BR_RULES_B.RULE_ID = ZSP_BR_RULES_TL.RULE_ID AND ZSP_BR_RULES_TL.LANGUAGE = USERENV('LANG') |