create a query to List all the Customers and Customer sites specific to each Operating Unit...

Hi frndz if u want to find customer details of each operating unit in oracle apps then u can use following query..
----------------------------------------------------------------------------------------------------------------------   
select  distinct
         -- ,b.org_id
         --a.organization_id
         -- ,c.party_id
         a.name                     as OPERATING_UNIT
        ,d.party_name               AS CUSTOMER_NAME
        ,d.party_number             AS CUSTOMER_NUMBER
        ,c.PARTY_SITE_NAME          AS SITE_NAME
        ,d.ADDRESS1                 AS ADDRESS
        ,d.CITY
        ,d.STATE
        ,d.POSTAL_CODE
        ,d.STATUS
from
          HR_OPERATING_UNITS a
         ,HZ_CUST_ACCT_SITES_ALL b
         ,HZ_PARTY_SITES c
         ,hz_parties d
where
         a.organization_id=b.org_id
    and  b.PARTY_SITE_ID= c.PARTY_SITE_ID
    and  c.party_id=d.party_id
    and  c.party_site_name is not null
order by
         d.party_name              
         ,d.party_number
        ,d.status;