R12 - customer profile > Drill Down
Any way around this?
SELECT count(ps.attribute1)+count(ps.attribute2)+count(ps.attribute3)
FROM hz_party_sites ps,
(SELECT distinct person_id FROM per_all_people_f) A,
(SELECT distinct person_id FROM per_all_people_f) b,
(SELECT distinct person_id FROM per_all_people_f) c
Where ps.party_id = :party_id
AND ps.party_site_id = :party_site_id
AND ps.attribute1 = A.person_id (+)