2 Replies Latest reply: Nov 13, 2012 5:08 PM by 974076 RSS

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

    967346
      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