rem HEADER
rem   $Header: wfntfsh.sql 26.1 2001/11/05 20:10:25 ctilley ship $
rem NAME
rem   wfntfsh.sql - WorkFlow NoTiFication SHow status
rem USAGE
rem   @wfntfsh <notification_id>
rem DESCRIPTION
rem
rem dbdrv: none

col ACCESS_KEY for a12
col BEGIN_DATE for a18
col END_DATE for a18
col DUE_DATE for a18
col RESPONDER for a60
col FORMAT for a24
col TEXT_VALUE for a50
--
set verify off
set pagesize 999
set linesize 80

define nid='&1'

prompt Notification &nid
select  MESSAGE_TYPE, 
	MESSAGE_NAME, 
	RECIPIENT_ROLE, 
	STATUS, 
	ACCESS_KEY, 
	MAIL_STATUS, 
        to_char(BEGIN_DATE,'DD-MON-RR HH24:MI:SS') BEGIN_DATE,
        to_char(END_DATE,'DD-MON-RR HH24:MI:SS') END_DATE,
        to_char(DUE_DATE,'DD-MON-RR HH24:MI:SS') DUE_DATE,
	RESPONDER
from    WF_NOTIFICATIONS
where   notification_id = &nid
/

prompt Notification &nid Attributes
select  NA.NAME,
	MA.TYPE,
	MA.FORMAT,
	MA.SUBTYPE,
	NA.NUMBER_VALUE,
	NA.DATE_VALUE,
	NA.TEXT_VALUE
from    WF_NOTIFICATIONS N,
	WF_NOTIFICATION_ATTRIBUTES NA,
	WF_MESSAGE_ATTRIBUTES MA
where   N.NOTIFICATION_ID = &nid
and     NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and     MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and     MA.MESSAGE_NAME = N.MESSAGE_NAME
and     MA.NAME = NA.NAME
/

commit;
exit;