VIEW: APPLSYS.WF_NOTIFICATIONS#

Source

View Text - Preformatted

select NOTIFICATION_ID NOTIFICATION_ID, GROUP_ID GROUP_ID, MESSAGE_TYPE MESSAGE_TYPE, MESSAGE_NAME MESSAGE_NAME, RECIPIENT_ROLE RECIPIENT_ROLE, STATUS STATUS, ACCESS_KEY ACCESS_KEY, MAIL_STATUS MAIL_STATUS, PRIORITY PRIORITY, BEGIN_DATE BEGIN_DATE, END_DATE END_DATE, DUE_DATE DUE_DATE, RESPONDER RESPONDER, USER_COMMENT USER_COMMENT, CALLBACK CALLBACK, CONTEXT CONTEXT, ORIGINAL_RECIPIENT ORIGINAL_RECIPIENT, FROM_USER FROM_USER, TO_USER TO_USER, SUBJECT SUBJECT, LANGUAGE LANGUAGE, MORE_INFO_ROLE MORE_INFO_ROLE, FROM_ROLE FROM_ROLE, SECURITY_GROUP_ID SECURITY_GROUP_ID, USER_KEY USER_KEY, ITEM_KEY ITEM_KEY, PROTECTED_TEXT_ATTRIBUTE1 PROTECTED_TEXT_ATTRIBUTE1, PROTECTED_TEXT_ATTRIBUTE2 PROTECTED_TEXT_ATTRIBUTE2, PROTECTED_TEXT_ATTRIBUTE3 PROTECTED_TEXT_ATTRIBUTE3, PROTECTED_TEXT_ATTRIBUTE4 PROTECTED_TEXT_ATTRIBUTE4, PROTECTED_TEXT_ATTRIBUTE5 PROTECTED_TEXT_ATTRIBUTE5, PROTECTED_TEXT_ATTRIBUTE6 PROTECTED_TEXT_ATTRIBUTE6, PROTECTED_TEXT_ATTRIBUTE7 PROTECTED_TEXT_ATTRIBUTE7, PROTECTED_TEXT_ATTRIBUTE8 PROTECTED_TEXT_ATTRIBUTE8, PROTECTED_TEXT_ATTRIBUTE9 PROTECTED_TEXT_ATTRIBUTE9, PROTECTED_TEXT_ATTRIBUTE10 PROTECTED_TEXT_ATTRIBUTE10, PROTECTED_FORM_ATTRIBUTE1 PROTECTED_FORM_ATTRIBUTE1, PROTECTED_FORM_ATTRIBUTE2 PROTECTED_FORM_ATTRIBUTE2, PROTECTED_FORM_ATTRIBUTE3 PROTECTED_FORM_ATTRIBUTE3, PROTECTED_FORM_ATTRIBUTE4 PROTECTED_FORM_ATTRIBUTE4, PROTECTED_FORM_ATTRIBUTE5 PROTECTED_FORM_ATTRIBUTE5, PROTECTED_URL_ATTRIBUTE1 PROTECTED_URL_ATTRIBUTE1, PROTECTED_URL_ATTRIBUTE2 PROTECTED_URL_ATTRIBUTE2, PROTECTED_URL_ATTRIBUTE3 PROTECTED_URL_ATTRIBUTE3, PROTECTED_URL_ATTRIBUTE4 PROTECTED_URL_ATTRIBUTE4, PROTECTED_URL_ATTRIBUTE5 PROTECTED_URL_ATTRIBUTE5, PROTECTED_DATE_ATTRIBUTE1 PROTECTED_DATE_ATTRIBUTE1, PROTECTED_DATE_ATTRIBUTE2 PROTECTED_DATE_ATTRIBUTE2, PROTECTED_DATE_ATTRIBUTE3 PROTECTED_DATE_ATTRIBUTE3, PROTECTED_DATE_ATTRIBUTE4 PROTECTED_DATE_ATTRIBUTE4, PROTECTED_DATE_ATTRIBUTE5 PROTECTED_DATE_ATTRIBUTE5, PROTECTED_NUMBER_ATTRIBUTE1 PROTECTED_NUMBER_ATTRIBUTE1, PROTECTED_NUMBER_ATTRIBUTE2 PROTECTED_NUMBER_ATTRIBUTE2, PROTECTED_NUMBER_ATTRIBUTE3 PROTECTED_NUMBER_ATTRIBUTE3, PROTECTED_NUMBER_ATTRIBUTE4 PROTECTED_NUMBER_ATTRIBUTE4, PROTECTED_NUMBER_ATTRIBUTE5 PROTECTED_NUMBER_ATTRIBUTE5, TEXT_ATTRIBUTE1 TEXT_ATTRIBUTE1, TEXT_ATTRIBUTE2 TEXT_ATTRIBUTE2, TEXT_ATTRIBUTE3 TEXT_ATTRIBUTE3, TEXT_ATTRIBUTE4 TEXT_ATTRIBUTE4, TEXT_ATTRIBUTE5 TEXT_ATTRIBUTE5, TEXT_ATTRIBUTE6 TEXT_ATTRIBUTE6, TEXT_ATTRIBUTE7 TEXT_ATTRIBUTE7, TEXT_ATTRIBUTE8 TEXT_ATTRIBUTE8, TEXT_ATTRIBUTE9 TEXT_ATTRIBUTE9, TEXT_ATTRIBUTE10 TEXT_ATTRIBUTE10, FORM_ATTRIBUTE1 FORM_ATTRIBUTE1, FORM_ATTRIBUTE2 FORM_ATTRIBUTE2, FORM_ATTRIBUTE3 FORM_ATTRIBUTE3, FORM_ATTRIBUTE4 FORM_ATTRIBUTE4, FORM_ATTRIBUTE5 FORM_ATTRIBUTE5, URL_ATTRIBUTE1 URL_ATTRIBUTE1, URL_ATTRIBUTE2 URL_ATTRIBUTE2, URL_ATTRIBUTE3 URL_ATTRIBUTE3, URL_ATTRIBUTE4 URL_ATTRIBUTE4, URL_ATTRIBUTE5 URL_ATTRIBUTE5, DATE_ATTRIBUTE1 DATE_ATTRIBUTE1, DATE_ATTRIBUTE2 DATE_ATTRIBUTE2, DATE_ATTRIBUTE3 DATE_ATTRIBUTE3, DATE_ATTRIBUTE4 DATE_ATTRIBUTE4, DATE_ATTRIBUTE5 DATE_ATTRIBUTE5, NUMBER_ATTRIBUTE1 NUMBER_ATTRIBUTE1, NUMBER_ATTRIBUTE2 NUMBER_ATTRIBUTE2, NUMBER_ATTRIBUTE3 NUMBER_ATTRIBUTE3, NUMBER_ATTRIBUTE4 NUMBER_ATTRIBUTE4, NUMBER_ATTRIBUTE5 NUMBER_ATTRIBUTE5, SENT_DATE SENT_DATE from "APPLSYS"."WF_NOTIFICATIONS"

View Text - HTML Formatted

SELECT NOTIFICATION_ID NOTIFICATION_ID
, GROUP_ID GROUP_ID
, MESSAGE_TYPE MESSAGE_TYPE
, MESSAGE_NAME MESSAGE_NAME
, RECIPIENT_ROLE RECIPIENT_ROLE
, STATUS STATUS
, ACCESS_KEY ACCESS_KEY
, MAIL_STATUS MAIL_STATUS
, PRIORITY PRIORITY
, BEGIN_DATE BEGIN_DATE
, END_DATE END_DATE
, DUE_DATE DUE_DATE
, RESPONDER RESPONDER
, USER_COMMENT USER_COMMENT
, CALLBACK CALLBACK
, CONTEXT CONTEXT
, ORIGINAL_RECIPIENT ORIGINAL_RECIPIENT
, FROM_USER FROM_USER
, TO_USER TO_USER
, SUBJECT SUBJECT
, LANGUAGE LANGUAGE
, MORE_INFO_ROLE MORE_INFO_ROLE
, FROM_ROLE FROM_ROLE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, USER_KEY USER_KEY
, ITEM_KEY ITEM_KEY
, PROTECTED_TEXT_ATTRIBUTE1 PROTECTED_TEXT_ATTRIBUTE1
, PROTECTED_TEXT_ATTRIBUTE2 PROTECTED_TEXT_ATTRIBUTE2
, PROTECTED_TEXT_ATTRIBUTE3 PROTECTED_TEXT_ATTRIBUTE3
, PROTECTED_TEXT_ATTRIBUTE4 PROTECTED_TEXT_ATTRIBUTE4
, PROTECTED_TEXT_ATTRIBUTE5 PROTECTED_TEXT_ATTRIBUTE5
, PROTECTED_TEXT_ATTRIBUTE6 PROTECTED_TEXT_ATTRIBUTE6
, PROTECTED_TEXT_ATTRIBUTE7 PROTECTED_TEXT_ATTRIBUTE7
, PROTECTED_TEXT_ATTRIBUTE8 PROTECTED_TEXT_ATTRIBUTE8
, PROTECTED_TEXT_ATTRIBUTE9 PROTECTED_TEXT_ATTRIBUTE9
, PROTECTED_TEXT_ATTRIBUTE10 PROTECTED_TEXT_ATTRIBUTE10
, PROTECTED_FORM_ATTRIBUTE1 PROTECTED_FORM_ATTRIBUTE1
, PROTECTED_FORM_ATTRIBUTE2 PROTECTED_FORM_ATTRIBUTE2
, PROTECTED_FORM_ATTRIBUTE3 PROTECTED_FORM_ATTRIBUTE3
, PROTECTED_FORM_ATTRIBUTE4 PROTECTED_FORM_ATTRIBUTE4
, PROTECTED_FORM_ATTRIBUTE5 PROTECTED_FORM_ATTRIBUTE5
, PROTECTED_URL_ATTRIBUTE1 PROTECTED_URL_ATTRIBUTE1
, PROTECTED_URL_ATTRIBUTE2 PROTECTED_URL_ATTRIBUTE2
, PROTECTED_URL_ATTRIBUTE3 PROTECTED_URL_ATTRIBUTE3
, PROTECTED_URL_ATTRIBUTE4 PROTECTED_URL_ATTRIBUTE4
, PROTECTED_URL_ATTRIBUTE5 PROTECTED_URL_ATTRIBUTE5
, PROTECTED_DATE_ATTRIBUTE1 PROTECTED_DATE_ATTRIBUTE1
, PROTECTED_DATE_ATTRIBUTE2 PROTECTED_DATE_ATTRIBUTE2
, PROTECTED_DATE_ATTRIBUTE3 PROTECTED_DATE_ATTRIBUTE3
, PROTECTED_DATE_ATTRIBUTE4 PROTECTED_DATE_ATTRIBUTE4
, PROTECTED_DATE_ATTRIBUTE5 PROTECTED_DATE_ATTRIBUTE5
, PROTECTED_NUMBER_ATTRIBUTE1 PROTECTED_NUMBER_ATTRIBUTE1
, PROTECTED_NUMBER_ATTRIBUTE2 PROTECTED_NUMBER_ATTRIBUTE2
, PROTECTED_NUMBER_ATTRIBUTE3 PROTECTED_NUMBER_ATTRIBUTE3
, PROTECTED_NUMBER_ATTRIBUTE4 PROTECTED_NUMBER_ATTRIBUTE4
, PROTECTED_NUMBER_ATTRIBUTE5 PROTECTED_NUMBER_ATTRIBUTE5
, TEXT_ATTRIBUTE1 TEXT_ATTRIBUTE1
, TEXT_ATTRIBUTE2 TEXT_ATTRIBUTE2
, TEXT_ATTRIBUTE3 TEXT_ATTRIBUTE3
, TEXT_ATTRIBUTE4 TEXT_ATTRIBUTE4
, TEXT_ATTRIBUTE5 TEXT_ATTRIBUTE5
, TEXT_ATTRIBUTE6 TEXT_ATTRIBUTE6
, TEXT_ATTRIBUTE7 TEXT_ATTRIBUTE7
, TEXT_ATTRIBUTE8 TEXT_ATTRIBUTE8
, TEXT_ATTRIBUTE9 TEXT_ATTRIBUTE9
, TEXT_ATTRIBUTE10 TEXT_ATTRIBUTE10
, FORM_ATTRIBUTE1 FORM_ATTRIBUTE1
, FORM_ATTRIBUTE2 FORM_ATTRIBUTE2
, FORM_ATTRIBUTE3 FORM_ATTRIBUTE3
, FORM_ATTRIBUTE4 FORM_ATTRIBUTE4
, FORM_ATTRIBUTE5 FORM_ATTRIBUTE5
, URL_ATTRIBUTE1 URL_ATTRIBUTE1
, URL_ATTRIBUTE2 URL_ATTRIBUTE2
, URL_ATTRIBUTE3 URL_ATTRIBUTE3
, URL_ATTRIBUTE4 URL_ATTRIBUTE4
, URL_ATTRIBUTE5 URL_ATTRIBUTE5
, DATE_ATTRIBUTE1 DATE_ATTRIBUTE1
, DATE_ATTRIBUTE2 DATE_ATTRIBUTE2
, DATE_ATTRIBUTE3 DATE_ATTRIBUTE3
, DATE_ATTRIBUTE4 DATE_ATTRIBUTE4
, DATE_ATTRIBUTE5 DATE_ATTRIBUTE5
, NUMBER_ATTRIBUTE1 NUMBER_ATTRIBUTE1
, NUMBER_ATTRIBUTE2 NUMBER_ATTRIBUTE2
, NUMBER_ATTRIBUTE3 NUMBER_ATTRIBUTE3
, NUMBER_ATTRIBUTE4 NUMBER_ATTRIBUTE4
, NUMBER_ATTRIBUTE5 NUMBER_ATTRIBUTE5
, SENT_DATE SENT_DATE
FROM "APPLSYS"."WF_NOTIFICATIONS"