APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_DUP_WORKER_CHUNK_GT

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

540: decode(instrb(s2.TX45,s1.TX45),1,200,
541: 0
542: )
543: score
544: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2
545: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
546: and nvl(s1.status,'A') = 'A' and nvl(s2.status,'A') = 'A'
547: and 1=decode(trap_explosion,'N',1,decode(rownum,l_party_limit,to_number('A'),1))
548: and (

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

570: 0
571: )
572: )
573: score
574: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
575: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
576: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
577: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
578: and (

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

629: decode(instrb(s2.TX22,s1.TX22),1,5,
630: 0
631: )
632: score
633: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
634: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
635: and (
636: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
637: -- do an or between all the transformations of an attribute --