I am trying to run a query in Maximo work order tracking to find PM work orders that are not COMP, CLOSE, COMPFLD, or CAN where the PM.EXTDATE is not NULL. Here is what I have but it does not work.
((wosequence is null and status not in ('COMP', 'COMPFLD') and (woclass = 'WORKORDER' or woclass = 'ACTIVITY') and upper(crewid) = 'SD' and historyflag = 0 and istask = 0 and siteid = 'SD' and pmnum like '%') and (exists (select from MAXIMO_PM where ((MAXIMO_WORKORDER.PMNUM = MAXIMO_PM.PMNUM) and (MAXIMO_PM.EXTDATE Like '%')))))