AR Customer Tables in Oracle Fusion

AR Customer Tables in Oracle Fusion

Hi friends, we are going to discuss about the AR Customer Tables in Oracle Fusion. We will share the list of most important oracle fusion customer tables which helps to store the customer details in oracle fusion. If we will compare with the Oracle EBS customer tables then i need to say there is not much difference in the customer tables. Customer tables are quite same in Oracle fusion as compared to Oracle Apps EBS. If we need to extract the customer details from backend then we need to know the name of customer tables as well the customer tables joins also. In this post , we will try our best to share important customer tables as well these customer tables joins too. We will also try to share some of the sql queries relates to customers in oracle fusion which helps to extract different different customer information's from system. You can also use these queries to develop the custom oracle fusion BIP reports to extract the custom details from system. Please find below the complete detail about AR Customer Tables in Oracle Fusion.

AR Customer Tables in Oracle Fusion

6 Important AR Customer Tables in Oracle Fusion

Here below is the list of customer tables in oracle fusion. These are some of the most important AR customer tables in oracle fusion.

1.HZ_CUST_ACCOUNTS

2.HZ_PARTIES

3.HZ_CUST_ACCT_SITES_ALL

4.HZ_CUST_SITE_USES_ALL

5.HZ_PARTY_SITES

6.HZ_LOCATIONS

Complete Customer Master Query using AR Customer Tables in Oracle Fusion

Here below is the detail sql query for customers in oracle fusion. In this query we have used the AR customer tables for data extraction.

select hp.party_name "Customer Name",

a1.account_number "Customer Number",

a3.STATUS "Site Status",

SITE_USE_CODE "Site Uses Code",

,PARTY_SITE_NUMBER "Customer Site Number",

A5.ADDRESS1,

A5.ADDRESS2,

A5.CITY,

A5.COUNTRY,

LOCATION

from hz_cust_accounts a1,

hz_cust_acct_sites_all a2,

hz_cust_site_uses_all a3,

HZ_PARTY_SITES A4,

HZ_LOCATIONS A5,

hz_parties hp

 where 

a1.party_id=hp.party_id

and a2.CUST_ACCT_SITE_ID=a3.CUST_ACCT_SITE_ID

and a1.CUST_ACCOUNT_ID=a2.CUST_ACCOUNT_ID

AND A2.PARTY_SITE_ID=A4.PARTY_SITE_ID

AND A4.LOCATION_ID=A5.LOCATION_ID

and nvl(A1.STATUS,'A')='A'

and nvl(A3.STATUS,'A')='A'

AND 1=1

order by a1.account_number,PARTY_SITE_NUMBER

AR Customer Tables in Oracle Fusion