SELECT DISTINCT PARTY.PARTY_NAME , PARTY.CREATION_DATE , PARTY.COUNTRY , PARTY.PARTY_ID , LOC.LOCATION_ID , 1.0 OBJECT_VERSION_NUMBER FROM HZ_PARTIES PARTY , HZ_LOCATIONS LOC , HZ_PARTY_SITES SITE WHERE PARTY.PARTY_TYPE = 'ORGANIZATION' AND SITE.PARTY_ID = PARTY.PARTY_ID AND SITE.LOCATION_ID = LOC.LOCATION_ID