Join Between hz_parties and hz_locations

Join Between hz_parties and HZ_Locations

In this post , We will discuss about Join Between hz_parties and HZ_Locations. These tables are related to the TCA Tables. These tables stores Parties Information's and the Address information's of the Parties in oracle apps r12. To join between these two table we need to use one another table 'HZ_PARTY_SITES_ALL' . Here below I will share the complete SQ query  using Join Between hz_parties and HZ_Locations.

 

 

 

SQL Join Between hz_parties and HZ_Locations

HZ_PARTIES ==> PARTY_ID

HZ_PARTY_SITES ==> PARTY_ID

HZ_LOCATIONS ==> LOCATION_ID

 

 

 

select PARTY_NAME,A3.ADDRESS1,A3.ADDRESS2,A3.ADDRESS3,A3.ADDRESS4,A3.CITY,A3.POSTAL_CODE,A3.STATE,ADDRESS_STYLE from hz_parties A1,hz_party_sites A2,
hz_locations A3
where A1.party_id=:PARTY_ID
AND A1.PARTY_ID=A2.PARTY_ID
AND A2.LOCATION_ID=A3.LOCATION_ID