APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_DUP_WORKER_CHUNK_GT

Line 709: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2

705: decode(instrb(s2.TX45,s1.TX45),1,200,
706: 0
707: )
708: score
709: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2
710: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
711: and nvl(s1.status,'A') = 'A' and nvl(s2.status,'A') = 'A'
712: and 1=decode(trap_explosion,'N',1,decode(rownum,l_party_limit,to_number('A'),1))
713: and (

Line 748: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2

744: 0
745: )
746: )
747: score
748: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
749: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
750: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
751: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
752: and (

Line 817: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2

813: decode(instrb(s2.TX22,s1.TX22),1,5,
814: 0
815: )
816: score
817: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
818: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
819: and (
820: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
821: -- do an or between all the transformations of an attribute --

Line 857: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACTS s1, HZ_STAGED_CONTACTS s2

853: decode(instrb(s2.TX22,s1.TX22),1,10,
854: 0
855: )
856: score
857: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACTS s1, HZ_STAGED_CONTACTS s2
858: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
859: and (
860: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
861: -- do an or between all the transformations of an attribute --