APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_DUP_RESULTS

Line 691: insert into hz_dup_results(fid, tid, ord_fid, ord_tid, score)

687: l_party_limit NUMBER := 50000;
688: l_detail_limit NUMBER := 100000;
689: BEGIN
690: FND_FILE.put_line(FND_FILE.log,'Start time of insert of Parties '||to_char(sysdate,'hh24:mi:ss'));
691: insert into hz_dup_results(fid, tid, ord_fid, ord_tid, score)
692: select f, t, least(f,t), greatest(f,t), sum(score) score from (
693: select /*+ ORDERED */ s1.party_id f, s2.party_id t,
694: -------PARTY ENTITY: SCORING SECTION ---------
695: decode(instrb(s2.TX2,s1.TX2),1,80,

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 833: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

829: (
830: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11)
831: )
832: ) group by f,t ;
833: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
834: close x_ent_cur;
835: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
836: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
837: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

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 --

Line 867: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

863: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
864: )
865: )
866: ) group by f,t ;
867: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
868: close x_ent_cur;
869: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
870: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
871: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');