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;
Thanks in advance
Those are E-Business Suite tables, which is a specialist area. Most of the people who answer questions on this forum won't know EBS. If you want people who underdstand the HZ schema I suggest you ask your question on [url https://forums.oracle.com/forums/category.jspa?categoryID=3]the appropriate site.
I also suggest you put a little effiort into attempting an answer before your ask, as people are usually unwilling to reward abject laziness.
Try something like this
select * from hz_party_sites site, hz_party_site_uses uses,hz_locations loc where site.party_site_id = uses.party_site_id
and uses.site_use_type = 'SHIP_TO'
and site.status = 'A'
and site.location_id = loc.location_id