APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_DUP_RESULTS

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

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

Line 808: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2

804: 0
805: )
806: )
807: score
808: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
809: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
810: and (
811: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
812: -- do an or between all the transformations of an attribute --

Line 823: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

819: (s1.TX158 is not null and s2.TX158 like s1.TX158 || decode(sign(lengthb(s1.TX158)-3),1,'%',''))
820: )
821: )
822: ) group by f,t ;
823: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
824: close x_ent_cur;
825: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
826: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
827: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACT_POINTS');

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

843: decode(instrb(s2.TX22,s1.TX22),1,10,
844: 0
845: )
846: score
847: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACTS s1, HZ_STAGED_CONTACTS s2
848: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
849: and (
850: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
851: -- do an or between all the transformations of an attribute --

Line 857: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

853: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
854: )
855: )
856: ) group by f,t ;
857: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
858: close x_ent_cur;
859: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
860: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
861: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');