"PRODUCT_TYPE" "ORDER_ACTION" "PM_STATUS"
"TLS-UNI" "COMPLETED" "On Target"
Here order action is completed so PM_STATUS value also need to be complete.
NOTE: when ORDER_ACTION value is completed then PM_STATUS value going to be COMPLETED
SELECT QUERY:=
SELECT distinct --fcn.NF_ID,
fcn.PRODUCT_TYPE,
fcn.order_action,
fcn.PM_STATUS
FROM wfm_nf.NF_PM_IEN_FACNO fcn
WHERE fcn.PRODUCT_TYPE like '%UNI%'
and fcn.order_action in ('CANCEL',
'COMPLETED')
and fcn.PM_STATUS not in ('Canceled', 'Complete');