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

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

904: FND_FILE.put_line(FND_FILE.log,'Start time of insert of Parties '||to_char(sysdate,'hh24:mi:ss'));
905: insert into hz_imp_dup_parties(party_id,dup_party_id, score, party_osr, party_os, batch_id, auto_merge_flag
906: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
907: select f, t, sum(score) sc, party_osr, party_os, p_batch_id, 'N'
908: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
909: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
910: from (
911: ------------------ PARTY LEVEL DUPLICATE IDENTIFICATION BEGINS --------------------
912: select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,

Line 909: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

905: insert into hz_imp_dup_parties(party_id,dup_party_id, score, party_osr, party_os, batch_id, auto_merge_flag
906: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
907: select f, t, sum(score) sc, party_osr, party_os, p_batch_id, 'N'
908: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
909: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
910: from (
911: ------------------ PARTY LEVEL DUPLICATE IDENTIFICATION BEGINS --------------------
912: select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,
913: -------PARTY ENTITY: SCORING SECTION ---------

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

1146: )
1147: )
1148: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1149: s2.CONTACT_POINT_ID
1150: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1151: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1152: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1153: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1154: and s1.party_id = s2.party_id

Line 1151: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1147: )
1148: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1149: s2.CONTACT_POINT_ID
1150: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1151: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1152: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1153: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1154: and s1.party_id = s2.party_id
1155: and (

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

1209: 0
1210: )
1211: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1212: s2.PARTY_SITE_ID
1213: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1214: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1215: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1216: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1217: and s1.party_id = s2.party_id

Line 1214: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1210: )
1211: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1212: s2.PARTY_SITE_ID
1213: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1214: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1215: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1216: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1217: and s1.party_id = s2.party_id
1218: and (

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

1262: 0
1263: )
1264: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1265: s2.ORG_CONTACT_ID
1266: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1267: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1268: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1269: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1270: and s1.party_id = s2.party_id

Line 1267: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1263: )
1264: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1265: s2.ORG_CONTACT_ID
1266: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1267: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1268: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1269: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1270: and s1.party_id = s2.party_id
1271: and (

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

1522: decode(nvl(s1.TX158,'N1'),nvl(substrb(s2.TX158,1,length(s1.TX158)),'N2'),70,
1523: 0
1524: )
1525: )
1526: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1527: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1528: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1529: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1530: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

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

1523: 0
1524: )
1525: )
1526: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1527: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1528: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1529: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1530: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1531: 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 1528: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1524: )
1525: )
1526: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1527: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1528: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1529: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1530: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1531: 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) )
1532: and s2.batch_id = p_batch_id and s1.CONTACT_PT_OSR < s2.CONTACT_PT_OSR

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

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

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

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

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

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

1623: +
1624: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),10,
1625: 0
1626: )
1627: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1628: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1629: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1630: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1631: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr

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

1624: decode(nvl(s1.TX22,'N1'),nvl(substrb(s2.TX22,1,length(s1.TX22)),'N2'),10,
1625: 0
1626: )
1627: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1628: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1629: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1630: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1631: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1632: 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 1629: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by

1625: 0
1626: )
1627: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1628: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1629: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1630: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1631: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1632: 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) )
1633: and s2.batch_id = p_batch_id and s1.CONTACT_OSR < s2.CONTACT_OSR