eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_IMP_DUP_PARTIES

Line 687: insert into hz_imp_dup_parties(party_id,dup_party_id, score, party_osr, party_os, batch_id, auto_merge_flag

683: BEGIN
684: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
685: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);
686: FND_FILE.put_line(FND_FILE.log,'Start time of insert of Parties '||to_char(sysdate,'hh24:mi:ss'));
687: insert into hz_imp_dup_parties(party_id,dup_party_id, score, party_osr, party_os, batch_id, auto_merge_flag
688: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
689: select f, t, sum(score) sc, party_osr, party_os, p_batch_id, 'N'
690: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
691: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

Line 793: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

789: decode(instrb(s2.TX22,s1.TX22),1,5,
790: 0
791: )
792: score
793: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
794: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
795: and s1.batch_id = h1.batch_id and s1.party_osr = h1.party_osr and s1.party_os = h1.party_os and s2.party_id = h1.dup_party_id
796: and (
797: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 810: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);

806: (
807: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11 || ' ' )
808: )
809: ) group by f,t ;
810: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);
811: close x_ent_cur;
812: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
813: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
814: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

Line 822: delete from hz_imp_dup_parties a

818: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
819: FND_FILE.put_line(FND_FILE.log,'DELETE ON THRESHOLD AND INDIRECT TRANSITIVITY ');
820: FND_FILE.put_line(FND_FILE.log,'Begin time to delete '||to_char(sysdate,'hh24:mi:ss'));
821:
822: delete from hz_imp_dup_parties a
823: where (a.party_osr >= from_osr and a.party_osr <= to_osr
824: and a.batch_id = p_batch_id)
825: and (
826: a.score < p_threshold

Line 830: (Select 1 from hz_imp_dup_parties b

826: a.score < p_threshold
827: or
828: -- delete the party id whose duplicate is a bigger number, when scores are same
829: exists
830: (Select 1 from hz_imp_dup_parties b
831: where b.batch_id=p_batch_id and a.party_id=b.party_id and a.dup_party_id > b.dup_party_id and a.score = b.score)
832: or
833: -- delete the party id with least score, if scores are different
834: exists

Line 835: (Select 1 from hz_imp_dup_parties b

831: where b.batch_id=p_batch_id and a.party_id=b.party_id and a.dup_party_id > b.dup_party_id and a.score = b.score)
832: or
833: -- delete the party id with least score, if scores are different
834: exists
835: (Select 1 from hz_imp_dup_parties b
836: where b.batch_id=p_batch_id and a.party_id=b.party_id and a.score < b.score)
837: );
838:
839: FND_FILE.put_line(FND_FILE.log,'Number of records deleted from hz_imp_dup_parties '||SQL%ROWCOUNT);

Line 839: FND_FILE.put_line(FND_FILE.log,'Number of records deleted from hz_imp_dup_parties '||SQL%ROWCOUNT);

835: (Select 1 from hz_imp_dup_parties b
836: where b.batch_id=p_batch_id and a.party_id=b.party_id and a.score < b.score)
837: );
838:
839: FND_FILE.put_line(FND_FILE.log,'Number of records deleted from hz_imp_dup_parties '||SQL%ROWCOUNT);
840: FND_FILE.put_line(FND_FILE.log,'End time to delete '||to_char(sysdate,'hh24:mi:ss'));
841: --------UPDATE AUTO MERGE FLAG --------------
842: update hz_imp_dup_parties a
843: set a.auto_merge_flag = 'Y'

Line 842: update hz_imp_dup_parties a

838:
839: FND_FILE.put_line(FND_FILE.log,'Number of records deleted from hz_imp_dup_parties '||SQL%ROWCOUNT);
840: FND_FILE.put_line(FND_FILE.log,'End time to delete '||to_char(sysdate,'hh24:mi:ss'));
841: --------UPDATE AUTO MERGE FLAG --------------
842: update hz_imp_dup_parties a
843: set a.auto_merge_flag = 'Y'
844: where a.score >= p_auto_merge_threshold
845: and a.party_osr >= from_osr and a.party_osr <= to_osr
846: and a.batch_id = p_batch_id ;

Line 851: from hz_imp_dup_parties a

847: --------UPDATE DQM ACTION FLAG IN INTERFACE/STAGING TABLES --------------
848:
849: open x_ent_cur for
850: select a.party_osr, a.party_os, a.auto_merge_flag
851: from hz_imp_dup_parties a
852: where a.batch_id = p_batch_id
853: and a.party_osr between from_osr and to_osr ;
854: HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);
855: ----------------------PARTY LEVEL DUPLICATE IDENTIFICATION ENDS --------------------