Filter Receipt
Hi,
I am receiving output of the query as below
I would like to modify the below query to have separate queries
one query to display row number 1,2,3 which are highlighted in yellow
next query to display row number 4,5 highlighted in blue colour
QUERY
select distinct account_number, party_name, arm.name, receipt_number, amount from hz_parties hp, hz_cust_accounts hca, ar_cash_receipts_all acra, ar_receipt_methods arm
where hp.party_id = hca.party_id
and hca.cust_account_id = acra.pay_from_customer
and acra.receipt_method_id = arm.receipt_method_id
and arm.name in ('Cash','Direct Debit')
0