-- create_approval_wk_table.sql     CREATE TABLE APPROVAL_WK  for Approval Notices email
--**Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences. The scripts and information are provided "as is" without warranty, implied or otherwise. Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:) 
-- created by bknox 05/28/2003

DROP TABLE APPROVAL_WK

CREATE TABLE APPROVAL_WK
(APPROVAL_WK_REPORT_PIDM    NUMBER(8),
 APPROVAL_WK_SORT_ORDER     VARCHAR2(45),
 APPROVAL_WK_DETAIL_STRING  VARCHAR2(512)
);

--grant select,insert,update,delete on APPROVAL_WK to user_that_sends_notices; 
--create public synonym APPROVAL_WK for owner.APPROVAL_WK;

-- create_approval_wk_table.sql end