Asset Deletion Query Sql | IBM Maximo

To delete asset totally from system including all related tables in Maximo System.

Single Asset Delete Query Example:

delete from AMCREWTOOL where ASSETNUM='WAP-0071';

delete from AMCREWWOTL  where ASSETNUM='WAP-0071';

delete from AREASAFFECTED where AFFECTEDASSETNUM='WAP-0071';

delete from ASSET  where ANCESTOR='WAP-0071';

delete from ASSET  where ASSETNUM='WAP-0071';

delete from ASSET  where PARENT='WAP-0071';

delete from ASSET where PLUSTALIAS='WAP-0071';

delete from ASSETANCESTOR  where ANCESTOR='WAP-0071';

delete from ASSETANCESTOR  where ASSETNUM='WAP-0071';

delete from ASSETAUDIT  where ASSETNUM='WAP-0071';

delete from ASSETCALIBRATION  where ASSETNUM='WAP-0071';

delete from ASSETFEASPECHIST  where ASSETNUM='WAP-0071';

delete from ASSETFEATURE  where ASSETNUM='WAP-0071';

delete from ASSETFEATUREHIST  where ASSETNUM='WAP-0071';

delete from ASSETFEATURESPEC  where ASSETNUM='WAP-0071';

delete from ASSETHIERARCHY  where ASSETNUM='WAP-0071';

delete from ASSETHIERARCHY  where PARENT='WAP-0071';

delete from ASSETHISTORY  where ASSETNUM='WAP-0071';

delete from ASSETLOCCOMM  where ASSETNUM='WAP-0071';

delete from ASSETLOCRELATION  where SOURCEASSETNUM='WAP-0071';

delete from ASSETLOCRELATION  where TARGETASSETNUM='WAP-0071';

delete from ASSETLOCRELHIST  where SOURCEASSETNUM='WAP-0071';

delete from ASSETLOCRELHIST  where TARGETASSETNUM='WAP-0071';

delete from ASSETLOCUSERCUST  where ASSETNUM='WAP-0071';

delete from ASSETMETER  where ASSETNUM='WAP-0071';

delete from ASSETMNTSKD  where ASSETNUM='WAP-0071';

delete from ASSETOPSKD  where ASSETNUM='WAP-0071';

delete from ASSETSPEC  where ASSETNUM='WAP-0071';

delete from ASSETSPECHIST  where ASSETNUM='WAP-0071';

delete from ASSETSTATUS  where ASSETNUM='WAP-0071';

delete from ASSETTOPOCACHE  where SOURCEASSETNUM='WAP-0071';

delete from ASSETTOPOCACHE  where TARGETASSETNUM='WAP-0071';

delete from ASSETTRANS  where ASSETNUM='WAP-0071';

delete from ASSETTRANS  where FROMPARENT='WAP-0071';

delete from ASSETTRANS  where TOPARENT='WAP-0071';

delete from ASSETWORKZONE  where ASSETNUM='WAP-0071';

delete from AUTOATTRUPDATE where ASSET='WAP-0071';

delete from CI  where ASSETNUM='WAP-0071';

delete from COLLECTDETAILS  where ASSETNUM='WAP-0071';

delete from DEPHISTORY  where ASSETNUM='WAP-0071';

delete from DEPHISTORY where NEXTASSET='WAP-0071';

delete from DEPHISTORY where PREVIOUSASSET='WAP-0071';

delete from DEPHISTORY where SWAPPEDTOASSET='WAP-0071';

delete from DEPTRANS  where ASSETNUM='WAP-0071';

delete from FAILUREREPORT  where ASSETNUM='WAP-0071';

delete from FRACAS  where ASSETNUM='WAP-0071';

delete from INSPECTIONRESULT where ASSET='WAP-0071';

delete from INVOICECOST  where ASSETNUM='WAP-0071';

delete from INVOICELINE where LEASEASSET='WAP-0071';

delete from INVRESERVE  where ASSETNUM='WAP-0071';

delete from INVUSELINE  where ASSETNUM='WAP-0071';

delete from INVUSELINE where NEWASSETNUM='WAP-0071';

delete from INVUSELINE  where ROTASSETNUM='WAP-0071';

delete from INVUSELINESPLIT  where NEWASSETNUM='WAP-0071';

delete from INVUSELINESPLIT  where ROTASSETNUM='WAP-0071';

delete from JPASSETSPLINK  where ASSETNUM='WAP-0071';

delete from KPIOEE  where ASSETNUM='WAP-0071';

delete from LABTRANS  where ASSETNUM='WAP-0071';

delete from LNRRECALIB  where ASSETNUM='WAP-0071';

delete from LNRRECALIB  where SOURCEASSETNUM='WAP-0071';

delete from LNRRECALIB  where TARGETASSETNUM='WAP-0071';

delete from LNRRECALIBNONAF  where ASSETNUM='WAP-0071';

delete from LOCKOUT  where ASSETNUM='WAP-0071';

delete from MATRECTRANS  where ASSETNUM='WAP-0071';

delete from MATRECTRANS  where ROTASSETNUM='WAP-0071';

delete from MATUSETRANS  where ASSETNUM='WAP-0071';

delete from MATUSETRANS  where ROTASSETNUM='WAP-0071';

delete from MEASUREMENT  where ASSETNUM='WAP-0071';

delete from MEASUREPOINT  where ASSETNUM='WAP-0071';

delete from METERREADING  where ASSETNUM='WAP-0071';

delete from METERREADING  where INHERITEDFROMASSET='WAP-0071';

delete from MITIGATION  where ASSETNUM='WAP-0071';

delete from MR  where ASSETNUM='WAP-0071';

delete from MRLINE  where ASSETNUM='WAP-0071';

delete from MULTIASSETLOCCI  where ASSETNUM='WAP-0071';

delete from MULTIASSETLOCCI  where MOVETOPARENT='WAP-0071';

delete from MULTIASSETLOCCI  where NEWASSETNUM='WAP-0071';

delete from MULTIASSETLOCCI  where NEWREPLACEASSETNUM='WAP-0071';

delete from MULTIASSETLOCCI  where PLUSTCONSIST='WAP-0071';

delete from MULTIASSETLOCCI  where REPLACEASSETNUM='WAP-0071';

delete from MULTIASSETLOCCIPR  where ASSETNUM='WAP-0071';

delete from NAMEDUSERS  where ASSETNUM='WAP-0071';

delete from PLUSCASSETSTATUS  where ASSETNUM='WAP-0071';

delete from PLUSCDSASSETLINK  where ASSETNUM='WAP-0071';

delete from PLUSCJPDATASHEET  where ASSETNUM='WAP-0071';

delete from PLUSCSPOTCHECK  where ASSETNUM='WAP-0071';

delete from PLUSCSPOTCHECK  where STDASSETNUM='WAP-0071';

delete from PLUSCTPASSET  where ASSETNUM='WAP-0071';

delete from PLUSCTPHISTORY  where ASSETNUM='WAP-0071';

delete from PLUSCWODS  where ASSETNUM='WAP-0071';

delete from PLUSCWODSINSTR  where ASSETNUM='WAP-0071';

delete from PLUSPACTUALUSAGE  where ASSETNUM='WAP-0071';

delete from PLUSPAGRMDATES  where ASSETNUM='WAP-0071';

delete from PLUSPAGRMITEMS  where ASSETNUM='WAP-0071';

delete from PLUSPAPPLASSET  where ASSETNUM='WAP-0071';

delete from PLUSPBILLMETER  where ASSETNUM='WAP-0071';

delete from PLUSPBSITEMLIST  where ASSETNUM='WAP-0071';

delete from PLUSPBSSERVLIST  where ASSETNUM='WAP-0071';

delete from PLUSPGBTRANS  where ASSETNUM='WAP-0071';

delete from PLUSPPSMATPRIC  where ASSETNUM='WAP-0071';

delete from PLUSPSALESORDER  where ASSETNUM='WAP-0071';

delete from PLUSTACHISTORY  where ASSETNUM='WAP-0071';

delete from PLUSTACHISTORY  where ROTASSETNUM='WAP-0071';

delete from PLUSTACTIVITY  where ASSETNUM='WAP-0071';

delete from PLUSTACTIVITY  where CONSIST='WAP-0071';

delete from PLUSTASSETACPOSITION  where ASSETNUM='WAP-0071';

delete from PLUSTASSETACPOSITION  where ROTASSETNUM='WAP-0071';

delete from PLUSTASSETALIAS  where ALIAS='WAP-0071';

delete from PLUSTASSETALIAS  where ASSETNUM='WAP-0071';

delete from PLUSTASSETQUAL  where ASSETNUM='WAP-0071';

delete from PLUSTASSETSTHIST  where INHERITEDFROM='WAP-0071';

delete from PLUSTCBLINES  where ASSETNUM='WAP-0071';

delete from PLUSTCLAIM  where ASSETNUM='WAP-0071';

delete from PLUSTCONSIST  where ASSETNUM='WAP-0071';

delete from PLUSTCONSIST  where CONSISTID='WAP-0071';

delete from PLUSTDEPSCHEDHISTORY  where ASSETNUM='WAP-0071';

delete from PLUSTDEPSCHEDHISTORY  where PREVIOUSASSET='WAP-0071';

delete from PLUSTDEPSCHEDULE  where ASSETNUM='WAP-0071';

delete from PLUSTLICENSE  where ASSETNUM='WAP-0071';

delete from PLUSTLOGENTRY  where ASSETNUM='WAP-0071';

delete from PLUSTLOGMTR  where ASSETNUM='WAP-0071';

delete from PLUSTLOGPROB  where ASSETNUM='WAP-0071';

delete from PLUSTLOGS  where ASSETNUM='WAP-0071';

delete from PLUSTMARRPAIR  where ASSETNUM='WAP-0071';

delete from PLUSTMPSCHEDULE  where ASSETNUM='WAP-0071';

delete from PLUSTMPTRANS  where ASSETNUM='WAP-0071';

delete from PLUSTMTRCHNG  where ASSETNUM='WAP-0071';

delete from PLUSTMTRIMP  where ALIAS='WAP-0071';

delete from PLUSTPMHIST  where ASSETNUM='WAP-0071';

delete from PLUSTPMHIST  where PLUSTCONSISTID='WAP-0071';

delete from PLUSTTELEHIST  where ASSETNUM='WAP-0071';

delete from PLUSTTELETRANS  where ASSETNUM='WAP-0071';

delete from PLUSTVEND  where ALIAS='WAP-0071';

delete from PLUSTWARRTRANS  where ASSETNUM='WAP-0071';

delete from PLUSTWARRTRANS  where COVEREDASSETNUM='WAP-0071';

delete from PLUSTWOASSET  where ASSETNUM='WAP-0071';

delete from PLUSTWOMEASUREMENT  where ASSETNUM='WAP-0071';

delete from PLUSTWOMEASUREMENT  where CONSISTID='WAP-0071';

delete from PLUSTWPSERV  where ASSETNUM='WAP-0071';

delete from PM  where ASSETNUM='WAP-0071';

delete from PM  where PLUSTCONSISTID='WAP-0071';

delete from PMMETER  where ASSETNUM='WAP-0071';

delete from POLINE  where ASSETNUM='WAP-0071';

delete from PRLINE  where ASSETNUM='WAP-0071';

delete from REORDERPAD  where ASSETNUM='WAP-0071';

delete from RFQLINE  where ASSETNUM='WAP-0071';

delete from ROUTE_STOP  where ASSETNUM='WAP-0071';

delete from SAFETYLEXICON  where ASSETNUM='WAP-0071';

delete from SCHEDULELINE  where ASSETNUM='WAP-0071';

delete from SERVRECTRANS  where ASSETNUM='WAP-0071';

delete from SKDACTIVITYQBE  where ASSETNUM='WAP-0071';

delete from SKDPROJECTASSTS  where ASSETNUM='WAP-0071';

delete from SLAASSETLOC  where ASSETNUM='WAP-0071';

delete from SPAREPART  where ASSETNUM='WAP-0071';

delete from SPRELATEDASSET  where ASSETNUM='WAP-0071';

delete from SPRELATEDASSET  where RELATEDASSET='WAP-0071';

delete from SPWORKASSET  where WORKASSET='WAP-0071';

delete from TAGOUT  where ASSETNUM='WAP-0071';

delete from TICKET  where ASSETNUM='WAP-0071';

delete from TI_ZZAS  where ANCESTOR='WAP-0071';

delete from TI_ZZAS  where ASSETNUM='WAP-0071';

delete from TI_ZZAS  where PARENT='WAP-0071';

delete from TI_ZZAS  where PLUSTALIAS='WAP-0071';

delete from TI_ZZASSET  where ANCESTOR='WAP-0071';

delete from TI_ZZASSET  where ASSETNUM='WAP-0071';

delete from TI_ZZASSET  where PARENT='WAP-0071';

delete from TI_ZZASSET  where PLUSTALIAS='WAP-0071';

delete from TI_ZZASSETMETER  where MAXIMOID='WAP-0071';

delete from TI_ZZPM  where ASSETNUM='WAP-0071';

delete from TI_ZZPM  where PLUSTCONSISTID='WAP-0071';

delete from TLOAMASSETGRP  where ASSETNUM='WAP-0071';

delete from TOOLTRANS  where ASSETNUM='WAP-0071';

delete from TOOLTRANS  where ROTASSETNUM='WAP-0071';

delete from WOCONTRACT  where ASSET='WAP-0071';

delete from WOCONTRACT  where ASSETNUM='WAP-0071';

delete from WOGEN  where ASSETNUM='WAP-0071';

delete from WOGEN  where PLUSTCONSISTID='WAP-0071';

delete from WOLOCKOUT  where ASSETNUM='WAP-0071';

delete from WORKORDER  where ASSETNUM='WAP-0071';

delete from WORKORDER  where PLUSTCONSISTID='WAP-0071';

delete from WOSAFETYLINK  where ASSETNUM='WAP-0071';

delete from WOTAGOUT  where ASSETNUM='WAP-0071';

Multi Asset Delete Query Example:

delete from AMCREWTOOL where ASSETNUM like 'WAP%';

delete from AMCREWWOTL  where ASSETNUM like 'WAP%';

delete from AREASAFFECTED where AFFECTEDASSETNUM like 'WAP%';

delete from ASSET  where ANCESTOR like 'WAP%';

delete from ASSET  where ASSETNUM like 'WAP%';

delete from ASSET  where PARENT like 'WAP%';

delete from ASSET where PLUSTALIAS like 'WAP%';

delete from ASSETANCESTOR  where ANCESTOR like 'WAP%';

delete from ASSETANCESTOR  where ASSETNUM like 'WAP%';

delete from ASSETAUDIT  where ASSETNUM like 'WAP%';

delete from ASSETCALIBRATION  where ASSETNUM like 'WAP%';

delete from ASSETFEASPECHIST  where ASSETNUM like 'WAP%';

delete from ASSETFEATURE  where ASSETNUM like 'WAP%';

delete from ASSETFEATUREHIST  where ASSETNUM like 'WAP%';

delete from ASSETFEATURESPEC  where ASSETNUM like 'WAP%';

delete from ASSETHIERARCHY  where ASSETNUM like 'WAP%';

delete from ASSETHIERARCHY  where PARENT like 'WAP%';

delete from ASSETHISTORY  where ASSETNUM like 'WAP%';

delete from ASSETLOCCOMM  where ASSETNUM like 'WAP%';

delete from ASSETLOCRELATION  where SOURCEASSETNUM like 'WAP%';

delete from ASSETLOCRELATION  where TARGETASSETNUM like 'WAP%';

delete from ASSETLOCRELHIST  where SOURCEASSETNUM like 'WAP%';

delete from ASSETLOCRELHIST  where TARGETASSETNUM like 'WAP%';

delete from ASSETLOCUSERCUST  where ASSETNUM like 'WAP%';

delete from ASSETMETER  where ASSETNUM like 'WAP%';

delete from ASSETMNTSKD  where ASSETNUM like 'WAP%';

delete from ASSETOPSKD  where ASSETNUM like 'WAP%';

delete from ASSETSPEC  where ASSETNUM like 'WAP%';

delete from ASSETSPECHIST  where ASSETNUM like 'WAP%';

delete from ASSETSTATUS  where ASSETNUM like 'WAP%';

delete from ASSETTOPOCACHE  where SOURCEASSETNUM like 'WAP%';

delete from ASSETTOPOCACHE  where TARGETASSETNUM like 'WAP%';

delete from ASSETTRANS  where ASSETNUM like 'WAP%';

delete from ASSETTRANS  where FROMPARENT like 'WAP%';

delete from ASSETTRANS  where TOPARENT like 'WAP%';

delete from ASSETWORKZONE  where ASSETNUM like 'WAP%';

delete from AUTOATTRUPDATE where ASSET like 'WAP%';

delete from CI  where ASSETNUM like 'WAP%';

delete from COLLECTDETAILS  where ASSETNUM like 'WAP%';

delete from DEPHISTORY  where ASSETNUM like 'WAP%';

delete from DEPHISTORY where NEXTASSET like 'WAP%';

delete from DEPHISTORY where PREVIOUSASSET like 'WAP%';

delete from DEPHISTORY where SWAPPEDTOASSET like 'WAP%';

delete from DEPTRANS  where ASSETNUM like 'WAP%';

delete from FAILUREREPORT  where ASSETNUM like 'WAP%';

delete from FRACAS  where ASSETNUM like 'WAP%';

delete from INSPECTIONRESULT where ASSET like 'WAP%';

delete from INVOICECOST  where ASSETNUM like 'WAP%';

delete from INVOICELINE where LEASEASSET like 'WAP%';

delete from INVRESERVE  where ASSETNUM like 'WAP%';

delete from INVUSELINE  where ASSETNUM like 'WAP%';

delete from INVUSELINE where NEWASSETNUM like 'WAP%';

delete from INVUSELINE  where ROTASSETNUM like 'WAP%';

delete from INVUSELINESPLIT  where NEWASSETNUM like 'WAP%';

delete from INVUSELINESPLIT  where ROTASSETNUM like 'WAP%';

delete from JPASSETSPLINK  where ASSETNUM like 'WAP%';

delete from KPIOEE  where ASSETNUM like 'WAP%';

delete from LABTRANS  where ASSETNUM like 'WAP%';

delete from LNRRECALIB  where ASSETNUM like 'WAP%';

delete from LNRRECALIB  where SOURCEASSETNUM like 'WAP%';

delete from LNRRECALIB  where TARGETASSETNUM like 'WAP%';

delete from LNRRECALIBNONAF  where ASSETNUM like 'WAP%';

delete from LOCKOUT  where ASSETNUM like 'WAP%';

delete from MATRECTRANS  where ASSETNUM like 'WAP%';

delete from MATRECTRANS  where ROTASSETNUM like 'WAP%';

delete from MATUSETRANS  where ASSETNUM like 'WAP%';

delete from MATUSETRANS  where ROTASSETNUM like 'WAP%';

delete from MEASUREMENT  where ASSETNUM like 'WAP%';

delete from MEASUREPOINT  where ASSETNUM like 'WAP%';

delete from METERREADING  where ASSETNUM like 'WAP%';

delete from METERREADING  where INHERITEDFROMASSET like 'WAP%';

delete from MITIGATION  where ASSETNUM like 'WAP%';

delete from MR  where ASSETNUM like 'WAP%';

delete from MRLINE  where ASSETNUM like 'WAP%';

delete from MULTIASSETLOCCI  where ASSETNUM like 'WAP%';

delete from MULTIASSETLOCCI  where MOVETOPARENT like 'WAP%';

delete from MULTIASSETLOCCI  where NEWASSETNUM like 'WAP%';

delete from MULTIASSETLOCCI  where NEWREPLACEASSETNUM like 'WAP%';

delete from MULTIASSETLOCCI  where PLUSTCONSIST like 'WAP%';

delete from MULTIASSETLOCCI  where REPLACEASSETNUM like 'WAP%';

delete from MULTIASSETLOCCIPR  where ASSETNUM like 'WAP%';

delete from NAMEDUSERS  where ASSETNUM like 'WAP%';

delete from PLUSCASSETSTATUS  where ASSETNUM like 'WAP%';

delete from PLUSCDSASSETLINK  where ASSETNUM like 'WAP%';

delete from PLUSCJPDATASHEET  where ASSETNUM like 'WAP%';

delete from PLUSCSPOTCHECK  where ASSETNUM like 'WAP%';

delete from PLUSCSPOTCHECK  where STDASSETNUM like 'WAP%';

delete from PLUSCTPASSET  where ASSETNUM like 'WAP%';

delete from PLUSCTPHISTORY  where ASSETNUM like 'WAP%';

delete from PLUSCWODS  where ASSETNUM like 'WAP%';

delete from PLUSCWODSINSTR  where ASSETNUM like 'WAP%';

delete from PLUSPACTUALUSAGE  where ASSETNUM like 'WAP%';

delete from PLUSPAGRMDATES  where ASSETNUM like 'WAP%';

delete from PLUSPAGRMITEMS  where ASSETNUM like 'WAP%';

delete from PLUSPAPPLASSET  where ASSETNUM like 'WAP%';

delete from PLUSPBILLMETER  where ASSETNUM like 'WAP%';

delete from PLUSPBSITEMLIST  where ASSETNUM like 'WAP%';

delete from PLUSPBSSERVLIST  where ASSETNUM like 'WAP%';

delete from PLUSPGBTRANS  where ASSETNUM like 'WAP%';

delete from PLUSPPSMATPRIC  where ASSETNUM like 'WAP%';

delete from PLUSPSALESORDER  where ASSETNUM like 'WAP%';

delete from PLUSTACHISTORY  where ASSETNUM like 'WAP%';

delete from PLUSTACHISTORY  where ROTASSETNUM like 'WAP%';

delete from PLUSTACTIVITY  where ASSETNUM like 'WAP%';

delete from PLUSTACTIVITY  where CONSIST like 'WAP%';

delete from PLUSTASSETACPOSITION  where ASSETNUM like 'WAP%';

delete from PLUSTASSETACPOSITION  where ROTASSETNUM like 'WAP%';

delete from PLUSTASSETALIAS  where ALIAS like 'WAP%';

delete from PLUSTASSETALIAS  where ASSETNUM like 'WAP%';

delete from PLUSTASSETQUAL  where ASSETNUM like 'WAP%';

delete from PLUSTASSETSTHIST  where INHERITEDFROM like 'WAP%';

delete from PLUSTCBLINES  where ASSETNUM like 'WAP%';

delete from PLUSTCLAIM  where ASSETNUM like 'WAP%';

delete from PLUSTCONSIST  where ASSETNUM like 'WAP%';

delete from PLUSTCONSIST  where CONSISTID like 'WAP%';

delete from PLUSTDEPSCHEDHISTORY  where ASSETNUM like 'WAP%';

delete from PLUSTDEPSCHEDHISTORY  where PREVIOUSASSET like 'WAP%';

delete from PLUSTDEPSCHEDULE  where ASSETNUM like 'WAP%';

delete from PLUSTLICENSE  where ASSETNUM like 'WAP%';

delete from PLUSTLOGENTRY  where ASSETNUM like 'WAP%';

delete from PLUSTLOGMTR  where ASSETNUM like 'WAP%';

delete from PLUSTLOGPROB  where ASSETNUM like 'WAP%';

delete from PLUSTLOGS  where ASSETNUM like 'WAP%';

delete from PLUSTMARRPAIR  where ASSETNUM like 'WAP%';

delete from PLUSTMPSCHEDULE  where ASSETNUM like 'WAP%';

delete from PLUSTMPTRANS  where ASSETNUM like 'WAP%';

delete from PLUSTMTRCHNG  where ASSETNUM like 'WAP%';

delete from PLUSTMTRIMP  where ALIAS like 'WAP%';

delete from PLUSTPMHIST  where ASSETNUM like 'WAP%';

delete from PLUSTPMHIST  where PLUSTCONSISTID like 'WAP%';

delete from PLUSTTELEHIST  where ASSETNUM like 'WAP%';

delete from PLUSTTELETRANS  where ASSETNUM like 'WAP%';

delete from PLUSTVEND  where ALIAS like 'WAP%';

delete from PLUSTWARRTRANS  where ASSETNUM like 'WAP%';

delete from PLUSTWARRTRANS  where COVEREDASSETNUM like 'WAP%';

delete from PLUSTWOASSET  where ASSETNUM like 'WAP%';

delete from PLUSTWOMEASUREMENT  where ASSETNUM like 'WAP%';

delete from PLUSTWOMEASUREMENT  where CONSISTID like 'WAP%';

delete from PLUSTWPSERV  where ASSETNUM like 'WAP%';

delete from PM  where ASSETNUM like 'WAP%';

delete from PM  where PLUSTCONSISTID like 'WAP%';

delete from PMMETER  where ASSETNUM like 'WAP%';

delete from POLINE  where ASSETNUM like 'WAP%';

delete from PRLINE  where ASSETNUM like 'WAP%';

delete from REORDERPAD  where ASSETNUM like 'WAP%';

delete from RFQLINE  where ASSETNUM like 'WAP%';

delete from ROUTE_STOP  where ASSETNUM like 'WAP%';

delete from SAFETYLEXICON  where ASSETNUM like 'WAP%';

delete from SCHEDULELINE  where ASSETNUM like 'WAP%';

delete from SERVRECTRANS  where ASSETNUM like 'WAP%';

delete from SKDACTIVITYQBE  where ASSETNUM like 'WAP%';

delete from SKDPROJECTASSTS  where ASSETNUM like 'WAP%';

delete from SLAASSETLOC  where ASSETNUM like 'WAP%';

delete from SPAREPART  where ASSETNUM like 'WAP%';

delete from SPRELATEDASSET  where ASSETNUM like 'WAP%';

delete from SPRELATEDASSET  where RELATEDASSET like 'WAP%';

delete from SPWORKASSET  where WORKASSET like 'WAP%';

delete from TAGOUT  where ASSETNUM like 'WAP%';

delete from TICKET  where ASSETNUM like 'WAP%';

delete from TI_ZZAS  where ANCESTOR like 'WAP%';

delete from TI_ZZAS  where ASSETNUM like 'WAP%';

delete from TI_ZZAS  where PARENT like 'WAP%';

delete from TI_ZZAS  where PLUSTALIAS like 'WAP%';

delete from TI_ZZASSET  where ANCESTOR like 'WAP%';

delete from TI_ZZASSET  where ASSETNUM like 'WAP%';

delete from TI_ZZASSET  where PARENT like 'WAP%';

delete from TI_ZZASSET  where PLUSTALIAS like 'WAP%';

delete from TI_ZZASSETMETER  where MAXIMOID like 'WAP%';

delete from TI_ZZPM  where ASSETNUM like 'WAP%';

delete from TI_ZZPM  where PLUSTCONSISTID like 'WAP%';

delete from TLOAMASSETGRP  where ASSETNUM like 'WAP%';

delete from TOOLTRANS  where ASSETNUM like 'WAP%';

delete from TOOLTRANS  where ROTASSETNUM like 'WAP%';

delete from WOCONTRACT  where ASSET like 'WAP%';

delete from WOCONTRACT  where ASSETNUM like 'WAP%';

delete from WOGEN  where ASSETNUM like 'WAP%';

delete from WOGEN  where PLUSTCONSISTID like 'WAP%';

delete from WOLOCKOUT  where ASSETNUM like 'WAP%';

delete from WORKORDER  where ASSETNUM like 'WAP%';

delete from WORKORDER  where PLUSTCONSISTID like 'WAP%';

delete from WOSAFETYLINK  where ASSETNUM like 'WAP%';

delete from WOTAGOUT  where ASSETNUM like 'WAP%';