Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!