Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

967346Oct 10 2012 — edited Nov 13 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2012
Added on Oct 10 2012
2 comments
6,836 views