drop table WFS.PMM_PROPERTIES;
drop table wfs.PMM_TITLELISTDETAILS;
drop table wfs.PMM_TITLELISTDETAILSTYPE;
drop table wfs.PMM_ProgressItem;
drop table wfs.PMM_Notification_Rulexref;
drop table wfs.PMM_Notification_userxref;
drop table wfs.PMM_TITLE_TITLELISTXREF;
drop table wfs.PMM_SERVICE_PARTNERXREF;
drop table wfs.PMM_TITLEMETADATA;
drop table wfs.PMM_WATCHFOLDERCONFIGURATION;
drop table wfs.PMM_Contact;
drop table wfs.PMM_PitchFrequency;
drop table wfs.PMM_SERVICE;
drop table wfs.PMM_TITLELIST;
drop table wfs.PMM_TITLELISTSTATUS;
drop table wfs.PMM_ListType;
drop table wfs.PMM_JobParameter;
drop table wfs.PMM_Job;
drop table wfs.PMM_Notification;
drop table wfs.PMM_TITLE;
drop table wfs.PMM_TITLESTATUS;
drop table wfs.PMM_Partner;
drop table wfs.PMM_partnerType;
drop table wfs.PMM_Context;
drop table wfs.PMM_ContainerType;
drop table wfs.PMM_RuleParameter;
drop table wfs.PMM_Rule;
drop table wfs.PMM_RULETYPE_ContentTYPEXREF;
drop table wfs.PMM_RuleTypeParameter;
drop table wfs.PMM_RULETYPE;
drop table wfs.PMM_RuleAssociationType;
drop table wfs.PMM_RuleTypeContent;
drop table wfs.PMM_RuleTypeContentDataType;
drop table wfs.PMM_RULETYPEPARAMETERDATATYPE;

DROP SEQUENCE WFS.PMM_Contact_SEQ;
DROP SEQUENCE WFS.PMM_Context_SEQ;
DROP SEQUENCE WFS.PMM_Job_SEQ;
DROP SEQUENCE WFS.PMM_JobParameter_SEQ;
DROP SEQUENCE WFS.PMM_Notification_SEQ;
DROP SEQUENCE WFS.PMM_Partner_SEQ;
DROP SEQUENCE WFS.PMM_PitchFrequency_SEQ;
DROP SEQUENCE WFS.PMM_ProgressItem_SEQ;
DROP SEQUENCE WFS.PMM_Rule_SEQ;
DROP SEQUENCE WFS.PMM_RuleParameter_SEQ;
DROP SEQUENCE WFS.PMM_SERVICE_SEQ;
DROP SEQUENCE WFS.PMM_TITLE_SEQ;
DROP SEQUENCE WFS.PMM_TITLELIST_SEQ;
DROP SEQUENCE WFS.PMM_TITLEMETADATA_SEQ;
DROP SEQUENCE WFS.PMM_WATCHFLDERCONFIG_SEQ;
DROP SEQUENCE WFS.PMM_PROPERTIES_SEQ;

DELETE FROM WFS.TTV_BIGROLEPERMISSION WHERE PERMISSIONID >= 26;
DELETE FROM WFS.TTV_MENUITEM WHERE  PERMISSIONID >= 26;
DELETE FROM WFS.TTV_ACTION WHERE  PERMISSIONID >= 26;
DELETE FROM WFS.TTV_PERMISSION WHERE PERMISSIONID >= 26;
DELETE FROM WFS.TTV_MODULE WHERE ModuleID >= 10;
DELETE FROM SYS.INSTALL_TABLE;
COMMIT;

select table_name from dba_tables where owner = 'WFS' and TABLE_NAME like 'PMM%';
select object_name from dba_objects where owner = 'WFS' AND OBJECT_NAME like 'PMM%';

select * from WFS.TTV_PERMISSION WHERE PERMISSIONID >= 26;
