eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CSL.CSL_WF_NOTIFICATIONS_INQ#

Source

View Text - Preformatted


select CLID$$CS CLID$$CS, 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, ORIGINAL_RECIPIENT ORIGINAL_RECIPIENT, FROM_USER FROM_USER, TO_USER TO_USER, SUBJECT SUBJECT, LANGUAGE LANGUAGE, MORE_INFO_ROLE MORE_INFO_ROLE, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$ from "CSL"."CSL_WF_NOTIFICATIONS_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, 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
, ORIGINAL_RECIPIENT ORIGINAL_RECIPIENT
, FROM_USER FROM_USER
, TO_USER TO_USER
, SUBJECT SUBJECT
, LANGUAGE LANGUAGE
, MORE_INFO_ROLE MORE_INFO_ROLE
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
FROM "CSL"."CSL_WF_NOTIFICATIONS_INQ"