Join between ap_suppliers and hz_parties

Join between ap_suppliers and hz_parties

Here we are going to discuss between the sql Join between ap_suppliers and hz_parties. The Tables Join between the Supplier and the TCS hz parties table.ap_suppliers is the master table of Suppliers in Oracle Apps and hz_parties stores the Parties related information’s. hz_parties is the table of TCA architecture in oracle apps. We need to understand why we are using this hz_parties table.A party is anybody that exists. He/She/It does not have to have bought something from the company earlier. In fact, they do not have any relationship whatsoever with the company. But they are ones who has the potential to have a relationship with the organization in future.

 

 

2 Important Joins between ap_suppliers and hz_parties

ap_suppliers   ==> Party_id

hz_parties   ==> Party_id

 

 

SQL Query using Join between ap_suppliers and hz_parties

 

select ass.VENDOR_NAME,ass.SEGMENT1 vendor_number,Party_name,PARTY_TYPE  from ap_suppliers ass,hz_parties  hps
where ass.party_id=hps.party_id
and ass.SEGMENT1=:P_VENDOR_NUMBER