Query NULL criteria in e-Business Suite form window

Today I was asked by one of my colleagues to determine the Invoices which has Purchase Orders related to it in the Invoice Entry window.

I remembered how to do it and did the same. In case your requirement is similar to this, follow these simple steps:

• Navigate to the window
• Enter Query mode through View> Query By Example > Enter or F11
• Navigate to the field for which you want to determine the null or not null criteria
• Enter the following: "# IS NULL" or "#IS NOT NULL" depending on whether you were asked to find the Null or not null data- excluding the double quotes
  
• Ctrl+F11 or View> Query By Example > Run