This discussion is archived
2 Replies Latest reply: Nov 13, 2012 3:08 PM by 974076 RSS

query to derive customer_id, customer bill to site id from customer number

967346 Newbie
Currently Being Moderated
Hi,
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points