I need to build a SQL Query to show all cash receipts in HKD for all Hong Kong customers from Jan 2017 thru Dec 2017.
how to derive it?please help
You can use 2 tables for the query
AR_CASH_RECEIPTS_ALL => receipt detals
HZ_CUST_ACCOUNTS => for customer
You can review seeded view AR_CASH_RECEIPTS_V , it will tell all the joins and you will get most of the details using this view.