APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_PARTY_SITES

Line 716: FROM hz_parties hp, hz_locations hl, hz_party_sites hs

712: FROM (SELECT hp.customer_key || hl.address_key key_comb,
713: decode(hp.party_type,'ORGANIZATION',count(*),0) org_count,
714: decode(hp.party_type,'PERSON',count(*),0) per_count,
715: hp.party_type ptype
716: FROM hz_parties hp, hz_locations hl, hz_party_sites hs
717: WHERE hp.party_id = hs.party_id (+)
718: AND hp.party_type in ('ORGANIZATION','PERSON')
719: AND hp.status = 'A'
720: AND hs.identifying_address_flag (+) = 'Y'

Line 758: from hz_parties hp, hz_party_sites hs, hz_locations hl

754: , pt, count(*) occurence, col1*count(*) totalptycount
755: from
756: ( select /*+ parallel(hp) parallel(hs) parallel(hl) use_hash(hs,hl) */
757: count(*) col1, hp.party_type pt
758: from hz_parties hp, hz_party_sites hs, hz_locations hl
759: where hp.party_type in ('ORGANIZATION','PERSON')
760: and hp.status = 'A'
761: and hp.party_id = hs.party_id(+)
762: and hs.identifying_address_flag(+) = 'Y'