Query to get customer Business Unit in oracle fusion

Query to get customer Business Unit in oracle fusion

Hi friends, we are going to discuss about the Query to get customer Business Unit in oracle fusion. We will share the sql query to get the customer details with business unit in oracle fusion. This is the complete sql query to extract the customer details with business unit assignments in oracle fusion. We will also share the important Tables related to customer in Oracle Fusion. Please find below the complete detail about Query to get customer Business Unit in oracle fusion.

Query to get customer Business Unit in oracle fusion

6 Important table in Customer Master in Oracle Fusion

1.hz_cust_accounts
2.hz_cust_acct_sites_all
3.hz_cust_site_uses_all
4.hz_party_sites
5.hz_parties
6.hz_locations

Query to get Customer Master in Oracle Fusion

Here below is the sql to extract the customer detail in Oracle Fusion.

select a4.party_name "Customer Name" ,
a1.account_number "Customer Number" ,
a1.cust_account_id,
a2.cust_acct_site_id,
a3.party_site_number "Site Number",
a5.SITE_USE_CODE,
a5.STATUS site_status,
a6.ADDRESS1,
a6.ADDRESS2,
a6.ADDRESS3,
a6.ADDRESS4,
a6.city,
a6.state,
a6.POSTAL_CODE
from hz_cust_accounts a1,
hz_cust_acct_sites_all a2,
hz_cust_site_uses_all a5,
hz_party_sites a3,
hz_parties a4,
hz_locations a6
where a1.cust_account_id=a2.cust_account_id
and a2.party_site_id=a3.party_site_id
and a2.CUST_ACCT_SITE_ID=a5.CUST_ACCT_SITE_ID
and a1.party_id=a4.party_id
and a3.location_id=a6.location_id

Query to get customer Business Unit in oracle fusion

Query to get customer Business Unit in oracle fusion