tables that is have used is
ra_customers for customer name,number
ra_customer_trx_all trx_id,trx_number,trx_date
from ra_customer -->hz_cust_acct for account number
hz_cust_acct_sites,
hz_cust_act_sites_usage for ship_to location(for location where the items have been shiipped)

ra_custtomer_trx_lines_all(qty_ordered,qty_credited,qty_invoiced
mtl_system_item_b (itemcode,product,unitprice)
hz_cust_acct_sites_all for location
but i need to join these tables to get location
ra_customers,hz_cust_acct,hz_acct_sites,hz_cust_acct_site_usage