query to derive customer_id, customer bill to site id from customer number
967346Oct 10 2012 — edited Nov 13 2012Hi,
I have a question. I need to write a query to derive customer_id, customer bill to site id from customer number and address information from the following tables
select * from hz_parties;
select * from hz_party_sites;
select * from HZ_LOCATIONS;
select * from hz_party_site_uses;
kindly help
Thanks in advance