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_50 dependencies on HZ_UTILITY_V2PUB

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

894: FND_FILE.put_line(FND_FILE.log,'Start time of insert of Parties '||to_char(sysdate,'hh24:mi:ss'));
895: insert into hz_imp_dup_parties(party_id,dup_party_id, score, party_osr, party_os, batch_id, auto_merge_flag
896: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
897: select f, t, sum(score) sc, party_osr, party_os, p_batch_id, 'N'
898: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
899: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
900: from (
901: ------------------ PARTY LEVEL DUPLICATE IDENTIFICATION BEGINS --------------------
902: select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,

Line 899: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

895: insert into hz_imp_dup_parties(party_id,dup_party_id, score, party_osr, party_os, batch_id, auto_merge_flag
896: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
897: select f, t, sum(score) sc, party_osr, party_os, p_batch_id, 'N'
898: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
899: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
900: from (
901: ------------------ PARTY LEVEL DUPLICATE IDENTIFICATION BEGINS --------------------
902: select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,
903: -------PARTY ENTITY: SCORING SECTION ---------

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

1129: 0
1130: )
1131: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1132: s2.PARTY_SITE_ID
1133: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1134: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1135: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1136: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1137: and s1.party_id = s2.party_id

Line 1134: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1130: )
1131: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1132: s2.PARTY_SITE_ID
1133: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1134: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1135: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1136: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1137: and s1.party_id = s2.party_id
1138: and (

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

1182: )
1183: )
1184: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1185: s2.CONTACT_POINT_ID
1186: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1187: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1188: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1189: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1190: and s1.party_id = s2.party_id

Line 1187: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1183: )
1184: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1185: s2.CONTACT_POINT_ID
1186: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1187: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1188: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1189: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1190: and s1.party_id = s2.party_id
1191: and (

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

1234: 0
1235: )
1236: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1237: s2.ORG_CONTACT_ID
1238: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1239: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1240: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1241: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1242: and s1.party_id = s2.party_id

Line 1239: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1235: )
1236: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1237: s2.ORG_CONTACT_ID
1238: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1239: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1240: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1241: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1242: and s1.party_id = s2.party_id
1243: and (

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

1487: +
1488: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),5,
1489: 0
1490: )
1491: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1492: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1493: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1494: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1495: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

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

1488: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),5,
1489: 0
1490: )
1491: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1492: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1493: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1494: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1495: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1496: 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 1493: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1489: 0
1490: )
1491: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1492: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1493: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1494: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1495: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1496: 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) )
1497: and s2.batch_id = p_batch_id and s1.PARTY_SITE_OSR < s2.PARTY_SITE_OSR

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

1532: decode(nvl(s1.TX10,'N1'),nvl(substrb(s2.TX10,1,length(s1.TX10)),'N2'),70,
1533: 0
1534: )
1535: )
1536: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1537: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1538: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1539: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1540: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

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

1533: 0
1534: )
1535: )
1536: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1537: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1538: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1539: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1540: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1541: 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 1538: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1534: )
1535: )
1536: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1537: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1538: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1539: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1540: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1541: 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) )
1542: and s2.batch_id = p_batch_id and s1.CONTACT_PT_OSR < s2.CONTACT_PT_OSR

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

1577: +
1578: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),10,
1579: 0
1580: )
1581: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1582: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1583: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1584: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1585: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

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

1578: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),10,
1579: 0
1580: )
1581: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1582: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1583: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1584: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1585: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1586: 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 1583: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1579: 0
1580: )
1581: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1582: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1583: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1584: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1585: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1586: 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) )
1587: and s2.batch_id = p_batch_id and s1.CONTACT_OSR < s2.CONTACT_OSR