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_UTILITY_V2PUB

Line 690: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login

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
692: from (
693: ------------------ PARTY LEVEL DUPLICATE IDENTIFICATION BEGINS --------------------
694: select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,

Line 691: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

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
692: from (
693: ------------------ PARTY LEVEL DUPLICATE IDENTIFICATION BEGINS --------------------
694: select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,
695: -------PARTY ENTITY: SCORING SECTION ---------

Line 876: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login

872: )
873: )
874: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
875: s2.CONTACT_POINT_ID
876: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
877: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
878: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
879: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
880: and s1.party_id = s2.party_id

Line 877: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

873: )
874: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
875: s2.CONTACT_POINT_ID
876: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
877: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
878: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
879: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
880: and s1.party_id = s2.party_id
881: and (

Line 934: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login

930: 0
931: )
932: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
933: s2.PARTY_SITE_ID
934: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
935: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
936: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
937: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
938: and s1.party_id = s2.party_id

Line 935: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

931: )
932: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
933: s2.PARTY_SITE_ID
934: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
935: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
936: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
937: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
938: and s1.party_id = s2.party_id
939: and (

Line 1142: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date

1138: decode(nvl(s1.TX10,'N1'),nvl(substrb(s2.TX10,1,length(s1.TX10)),'N2'),70,
1139: 0
1140: )
1141: )
1142: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1143: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1144: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1145: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1146: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

Line 1143: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login

1139: 0
1140: )
1141: )
1142: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1143: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1144: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1145: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1146: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1147: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )

Line 1144: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1140: )
1141: )
1142: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1143: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1144: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1145: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1146: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1147: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )
1148: and s2.batch_id = p_batch_id and s1.CONTACT_PT_OSR < s2.CONTACT_PT_OSR

Line 1193: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date

1189: +
1190: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),5,
1191: 0
1192: )
1193: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1194: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1195: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1196: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1197: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

Line 1194: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login

1190: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),5,
1191: 0
1192: )
1193: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1194: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1195: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1196: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1197: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1198: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )

Line 1195: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1191: 0
1192: )
1193: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1194: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1195: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1196: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1197: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1198: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )
1199: and s2.batch_id = p_batch_id and s1.PARTY_SITE_OSR < s2.PARTY_SITE_OSR