Customer tables in oracle apps r12

Customer tables in oracle apps r12

Oracle Customer Information's of the Oracle applications Stores in the Customer Tables. In this post , I will share you all these customer tables in oracle apps r12 , which stores all the customer information. We uses these tables in the sql query to fetch or extract the customer information from Oracle database. Here below i am sharing the Customer tables in oracle apps r12.

 

 

Here above is the list of the Customer Tables in Oracle apps r12.

 

AR_CUSTOMERS:-

 

This Table stores Customer Header Information's in Oracle application. We get the Customer Name and Customer Number in this Table.

 

HZ_CUST_ACCOUNTS_ALL :-

 

This table store Customer Header Information. We get the Cust_account_id column from this table which joins with the ar_customer customer_id column.

 

 HZ_PARTIES:-

 

This Table Stores Customer Information as Party in the Oracle application. Party Name and Party Id is the Key Column of this Table which joins with the HZ_CUST_ACCOUNTS_ALL  table.

 

HZ_CUST_ACCT_SITES_ALL:-

 

This table stores the Customer Sites Information. This table helps to get the Customer sites Address and other important Information's.

 

HZ_CUST_SITE_USES_ALL:-

 

This Table stores Customer Site use Code. We get the Party Site Id columns also which helps to Join with the HZ_PARTY_SITES_ALL.

 

HZ_PARTY_SITES_ALL :-

 

This table stores the Customer Party Site Information. We gets the Location id from this Table to join with the HZ_LOCATIONS table.

 

HZ_LOCATIONS:- This Table stores the Customer Site Location Information's in Oracle apps R12.

 

 

Customer tables in oracle apps r12