Hi,
I am trying to write a query which returns all the master agreement names, id, date etc which are neither closed nor cancelled. I wrote the query given below. However it returned no results.
Select
<%RESULTS%>
From
<%SCHEMA%>.FCI_CONTRACT T1
Where
T1.CANCELED_AT = NULL
Please let me know where i am going wrong.
Regards,
Anshuman