/* used to generate the acp list to insert into acc_queries.html 
 1 - run this in sql
 2 - pico acplist.ins and justify it
 3 - paste into acc_queries.html
*/
set heading off pause off pagesize 1000 feedback off trimspool on
set embedded on 
spool acplist.ins
select '<option>'||acp||'</option>' from prod.acc where acp <> 'PI' group
 by '<option>'||acp||'</option>' order by 1;
spool off