VIEW: PV.PV_GE_NOTIF_RULES_B#

Source

View Text - Preformatted

select NOTIF_RULE_ID NOTIF_RULE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ARC_NOTIF_FOR_ENTITY_CODE ARC_NOTIF_FOR_ENTITY_CODE, NOTIF_FOR_ENTITY_ID NOTIF_FOR_ENTITY_ID, WF_ITEM_TYPE_CODE WF_ITEM_TYPE_CODE, NOTIF_TYPE_CODE NOTIF_TYPE_CODE, ACTIVE_FLAG ACTIVE_FLAG, REPEAT_FREQ_UNIT REPEAT_FREQ_UNIT, REPEAT_FREQ_VALUE REPEAT_FREQ_VALUE, SEND_NOTIF_BEFORE_UNIT SEND_NOTIF_BEFORE_UNIT, REPEAT_UNTIL_VALUE REPEAT_UNTIL_VALUE, SEND_NOTIF_AFTER_UNIT SEND_NOTIF_AFTER_UNIT, SEND_NOTIF_AFTER_VALUE SEND_NOTIF_AFTER_VALUE, REPEAT_UNTIL_UNIT REPEAT_UNTIL_UNIT, SEND_NOTIF_BEFORE_VALUE SEND_NOTIF_BEFORE_VALUE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PV"."PV_GE_NOTIF_RULES_B"

View Text - HTML Formatted

SELECT NOTIF_RULE_ID NOTIF_RULE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ARC_NOTIF_FOR_ENTITY_CODE ARC_NOTIF_FOR_ENTITY_CODE
, NOTIF_FOR_ENTITY_ID NOTIF_FOR_ENTITY_ID
, WF_ITEM_TYPE_CODE WF_ITEM_TYPE_CODE
, NOTIF_TYPE_CODE NOTIF_TYPE_CODE
, ACTIVE_FLAG ACTIVE_FLAG
, REPEAT_FREQ_UNIT REPEAT_FREQ_UNIT
, REPEAT_FREQ_VALUE REPEAT_FREQ_VALUE
, SEND_NOTIF_BEFORE_UNIT SEND_NOTIF_BEFORE_UNIT
, REPEAT_UNTIL_VALUE REPEAT_UNTIL_VALUE
, SEND_NOTIF_AFTER_UNIT SEND_NOTIF_AFTER_UNIT
, SEND_NOTIF_AFTER_VALUE SEND_NOTIF_AFTER_VALUE
, REPEAT_UNTIL_UNIT REPEAT_UNTIL_UNIT
, SEND_NOTIF_BEFORE_VALUE SEND_NOTIF_BEFORE_VALUE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PV"."PV_GE_NOTIF_RULES_B"