Query between ra_customer_trx_all and HZ Tables

Hello,

I am trying to build a query to get a list of all active customer sites for the past two years depending on the customer Invoices over that period of time. This is what I have till now. Would someone let me know if this holds good or guide me if they have a better solution?

SELECT hou.name operating_unit,

         hp.party_name customer_name,

         hca.account_number customer_number,

         hca.cust_account_id customer_id,

         hps.party_site_number site_number,

         hcsua.site_use_code,

         hcsua.location,

         hl.address1,

         hl.address2,

         hl.city,

         hl.state

    FROM hz_locations hl,