POI_RULES_VL

Details

• Schema: FUSION

• Object owner: POI

• Object type: VIEW

Columns

Name
RULE_ID RULE_NAME DESCRIPTION TYPE SEQUENCE CONDITION_TYPE ACTION_TYPE ON_ATTRIBUTE ACTION_CONDITION TO_ATTRIBUTE TO_CONST_VALUE RUN_COUNT LAST_RUN_DATE RUN_MESSAGE CREATION_DATE SQL_CLAUSE KB_TYPE DS_TYPE START_DATE END_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER STOP_FURTHER_RULES_FLAG ENTITY_ID

Query

SQL_Statement

SELECT B.RULE_ID, B.RULE_NAME, TL.DESCRIPTION, B.TYPE, B.SEQUENCE, B.CONDITION_TYPE, B.ACTION_TYPE, B.ON_ATTRIBUTE, B.ACTION_CONDITION, B.TO_ATTRIBUTE, B.TO_CONST_VALUE, B.RUN_COUNT, B.LAST_RUN_DATE, B.RUN_MESSAGE, B.CREATION_DATE, B.SQL_CLAUSE, B.KB_TYPE, B.DS_TYPE, B.START_DATE, B.END_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.STOP_FURTHER_RULES_FLAG, B.ENTITY_ID FROM POI_RULES_B B, POI_RULES_TL TL WHERE TL.RULE_ID = B.RULE_ID AND TL.LANGUAGE = USERENV('LANG')