Friday, 27 September 2013

FIND DUPLICATE CUSTOMERS IN ORACLE APPS R12

select count(PARTY_NAME),party_name from(
SELECT distinct hp.PARTY_ID,hp.PARTY_NUMBER,hp.PARTY_NAME
  FROM
       hz_cust_accounts hca,
       hz_parties hp,
       hz_cust_acct_sites_all hcas
 WHERE  hp.party_id = hca.party_id
   AND hcas.cust_account_id =hca.CUST_ACCOUNT_ID
   and hcas.ORG_ID=85
   )
   group by party_name
   having count(PARTY_NAME)>1