Hi all, While writing query to retrieving suppliers information I have used AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL. And to get contacts information for supplier I have used AP_SUPPLIER_CONTACTS table. But here Iam getting duplicates in my query. Does supplier contacts are assigned to site level or they assigned to supplier level. I didn't found any setup steps to set particular contact to site. So am unable to restrict them in my query. If I have 11 sites for a supplier and 7 contacts Iam getting 77 records totally. Anyone Provide me some assistance to do this. Code (Text): SELECT ASP.VENDOR_NAME "Vendor Name" ,ASSA.VENDOR_SITE_CODE "Vendor Site" ,RTRIM(TRIM(ASSA.ADDRESS_LINE1||' '||ASSA.CITY||','||ASSA.STATE||' '||ASSA.ZIP),',') "Address" FROM AP_SUPPLIERS ASP ,AP_SUPPLIER_SITES_ALL ASSA WHERE ASP.VENDOR_NAME = '3M Health Care' AND ASSA.VENDOR_ID = ASP.VENDOR_ID Output: - Vendor Name Vendor Site Address 3M Health Care BEI LIN CHINA 16th, Floor, Shuion Square Shangai,Shangai 3M Health Care CORP HQ 100 3M Way St. Paul,MN 55144 3M Health Care CORP HQ 100 3M Way St. Paul,MN 55144 3M Health Care DAS2GEN Bld des Généraux , 75011 3M Health Care DAS2GEN Bld des Généraux , 75011 3M Health Care KOREA 3M Health Care LEEDS 6 Neville Street Leeds, LS1 5JL 3M Health Care MAIN 123 Fox Road Atlanta,GA 30033 3M Health Care MAIN St. Paul, MN 55144-1000 ,MN 55144-1000 3M Health Care PARIS Rue Balzac , 75008 3M Health Care VHS 3M St. Paul, MN 55144-1000 St. Paul,MN 55144_1000 Now I want to add contacts table to retrieve contacts information to the above query. Code (Text): SELECT ASP.VENDOR_NAME "Vendor Name" ,ASSA.VENDOR_SITE_CODE "Vendor Site Code" ,RTRIM(TRIM(ASSA.ADDRESS_LINE1||' '||ASSA.CITY||','||ASSA.STATE||' '||ASSA.ZIP),',') ,nvl(fu.email_address,hp_email.email_address)"EMAIL" ,hp.person_first_name ,hp.person_last_name ,FU.USER_NAME ,hp_email.primary_phone_area_code||' '||hp_email.primary_phone_number"Mobile#" FROM AP_SUPPLIERS ASP ,AP_SUPPLIER_SITES_ALL ASSA ,HZ_PARTIES HP_EMAIL ,HZ_RELATIONSHIPS HR ,HZ_PARTIES HP ,FND_USER FU WHERE ASP.VENDOR_NAME = '&VENDOR_NAME' AND ASSA.VENDOR_ID = ASP.VENDOR_ID AND HR.OBJECT_ID=ASP.PARTY_ID AND HR.PARTY_ID=HP_EMAIL.PARTY_ID AND HR.SUBJECT_ID=HP.PARTY_ID AND FU.PERSON_PARTY_ID(+)=HR.SUBJECT_ID; For this query Iam getting 77 records which is like 7 contacts * 11 sites. Totally 77 records. Am I missing any join here?