VIEW: APPS.IMC_DUPL_PER_KEY_V

Source

View Text - Preformatted

SELECT hp.customer_key||hl.address_key key_comb, count(hp.party_id) party_count from hz_parties hp, hz_locations hl, hz_party_sites hs WHERE hp.party_id = hs.party_id (+) and hs.identifying_address_flag (+) = 'Y' and hs.location_id = hl.location_id (+) and hp.party_type = 'PERSON' group by hp.customer_key||hl.address_key

View Text - HTML Formatted

SELECT HP.CUSTOMER_KEY||HL.ADDRESS_KEY KEY_COMB
, COUNT(HP.PARTY_ID) PARTY_COUNT
FROM HZ_PARTIES HP
, HZ_LOCATIONS HL
, HZ_PARTY_SITES HS
WHERE HP.PARTY_ID = HS.PARTY_ID (+)
AND HS.IDENTIFYING_ADDRESS_FLAG (+) = 'Y'
AND HS.LOCATION_ID = HL.LOCATION_ID (+)
AND HP.PARTY_TYPE = 'PERSON' GROUP BY HP.CUSTOMER_KEY||HL.ADDRESS_KEY