 delete from krew_rte_brch_proto_t where RTE_BRCH_PROTO_ID not in (select rte_brch_proto_id from krew_rte_node_t)
 /
 
+
 -- Rule Attributes
 
 delete from krew_rule_attr_t where nm='DestinationAttribute'

/
delete from krew_rule_tmpl_t where nm='WorkflowDocument3Template'
/

-- Rules


/
delete from krew_rule_t where doc_typ_nm is not null and doc_typ_nm not in (select doc_typ_nm from krew_doc_typ_t)
/
delete from KREW_RULE_TMPL_ATTR_T where rule_tmpl_id is not null and rule_tmpl_id not in (select rule_tmpl_id from krew_rule_tmpl_t)


-- EDL

