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_DUP_PVT dependencies on HZ_DUP_SET_PARTIES

Line 29: from hz_parties p, hz_dup_set_parties mp

25: select party_id, party_name
26: from(
27: select p.party_id party_id, p.party_name party_name,
28: RANK() OVER (ORDER BY p.last_update_date desc ) rank
29: from hz_parties p, hz_dup_set_parties mp
30: where p.party_id = mp.dup_party_id
31: and mp.dup_set_id = p_dup_set_id
32: and p.status = cp_status
33: and nvl(mp.merge_flag,'Y') = 'Y'

Line 44: from hz_parties p, hz_dup_set_parties mp

40: select party_id, party_name
41: from(
42: select p.party_id party_id,p.party_name party_name,
43: RANK() OVER (ORDER BY p.creation_date desc, p.party_id desc ) rank
44: from hz_parties p, hz_dup_set_parties mp
45: where p.party_id = mp.dup_party_id
46: and mp.dup_set_id = p_dup_set_id
47: and p.status = cp_status
48: and nvl(mp.merge_flag,'Y') = 'Y'

Line 58: from hz_parties p, hz_dup_set_parties mp

54: select party_id, party_name
55: from(
56: select p.party_id party_id,p.party_name party_name,
57: RANK() OVER (ORDER BY p.creation_date, p.party_id) rank
58: from hz_parties p, hz_dup_set_parties mp
59: where p.party_id = mp.dup_party_id
60: and mp.dup_set_id = p_dup_set_id
61: and p.status = cp_status
62: and nvl(mp.merge_flag,'Y') = 'Y'

Line 79: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

75: count(*) over (partition by ca.party_id) as cnt,
76: ca.last_update_date
77: from
78: HZ_CUST_ACCOUNTS CA,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
79: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
80: WHERE CA.PARTY_ID =DSP.DUP_PARTY_ID
81: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
82: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
83: AND CA.PARTY_ID = PARTY.PARTY_ID

Line 102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

98: ps.party_id party_id, party.party_name party_name,
99: count(*) over (partition by ps.party_id) as cnt,
100: ps.last_update_date
101: from HZ_PARTY_SITES PS,HZ_PARTIES PARTY,
102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
103: WHERE PS.PARTY_ID =DSP.DUP_PARTY_ID
104: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
105: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
106: AND PS.PARTY_ID = PARTY.PARTY_ID

Line 126: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

122: party.party_name party_name,
123: count(*) over (partition by party.party_id) as cnt,
124: party.last_update_date
125: from HZ_RELATIONSHIPS R,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
126: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
127: WHERE PARTY.PARTY_ID =DSP.DUP_PARTY_ID
128: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
129: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
130: AND R.OBJECT_ID = PARTY.PARTY_ID

Line 144: from hz_parties p, hz_dup_set_parties mp

140: select party_id, party_name
141: from(
142: select p.party_id party_id, p.party_name party_name,
143: RANK() OVER (ORDER BY p.certification_level, p.last_update_date desc ) rank
144: from hz_parties p, hz_dup_set_parties mp
145: where p.party_id = mp.dup_party_id
146: and mp.dup_set_id = p_dup_set_id
147: and p.status = cp_status
148: and nvl(mp.merge_flag,'Y') = 'Y'

Line 154: from hz_parties p, hz_dup_set_parties mp

150: where rank = 1 and rownum=1;
151:
152: cursor get_active_party_count_csr is
153: select count(*)
154: from hz_parties p, hz_dup_set_parties mp
155: where p.party_id = mp.dup_party_id
156: and mp.dup_set_id = p_dup_set_id
157: and p.status = 'A';
158:

Line 167: from HZ_DUP_SET_PARTIES dsp, hz_parties p

163:
164: -- validate party_id and party_name combination.
165: cursor check_set_party_exist_csr(cp_party_id number, cp_party_name varchar2) is
166: select count(*)
167: from HZ_DUP_SET_PARTIES dsp, hz_parties p
168: where dsp.dup_set_id = p_dup_set_id
169: and dsp.dup_party_id = p.party_id
170: and dsp.dup_party_id = cp_party_id
171: and p.party_name = cp_party_name;

Line 176: from hz_parties p, hz_dup_set_parties mp

172:
173: -- Bug 4592273: only one active party in the set
174: cursor get_active_party_csr is
175: select p.party_id, p.party_name
176: from hz_parties p, hz_dup_set_parties mp
177: where p.party_id = mp.dup_party_id
178: and mp.dup_set_id = p_dup_set_id
179: and p.status = 'A'
180: and rownum = 1;

Line 294: update hz_dup_set_parties

290: then
291:
292: -- update the winner party id to have merge_flag = 'Y'
293:
294: update hz_dup_set_parties
295: set merge_flag = 'Y'
296: where dup_set_id = p_dup_set_id
297: and dup_party_id = l_master_party_id;
298:

Line 512: HZ_DUP_SET_PARTIES_PKG.Insert_Row(

508: l_merge_seq_id := p_merge_seq_id;
509: l_merge_batch_id := p_merge_batch_id;
510: l_merge_batch_name := p_merge_batch_name;
511:
512: HZ_DUP_SET_PARTIES_PKG.Insert_Row(
513: p_dup_party_id => l_dup_set_party_id
514: ,p_dup_set_id => l_dup_set_id
515: ,p_merge_flag => 'Y'
516: ,p_not_dup => l_not_dup

Line 673: HZ_DUP_SET_PARTIES_PKG.Insert_Row(

669: x_dup_set_id := l_dup_set_id;
670:
671: FOR i IN 1..p_dup_party_tbl.count LOOP
672: l_party_id := p_dup_party_tbl(i).party_id;
673: HZ_DUP_SET_PARTIES_PKG.Insert_Row(
674: p_dup_party_id => l_party_id
675: ,p_dup_set_id => l_dup_set_id
676: ,p_merge_flag => 'Y'
677: ,p_not_dup => p_dup_party_tbl(i).not_dup

Line 792: HZ_DUP_SET_PARTIES_PKG.Insert_Row(

788: x_dup_set_id := l_dup_set_id;
789:
790: FOR i IN 1..p_dup_party_tbl.count LOOP
791: l_party_id := p_dup_party_tbl(i).party_id;
792: HZ_DUP_SET_PARTIES_PKG.Insert_Row(
793: p_dup_party_id => l_party_id
794: ,p_dup_set_id => l_dup_set_id
795: ,p_merge_flag => 'Y'
796: ,p_not_dup => p_dup_party_tbl(i).not_dup

Line 857: from HZ_DUP_SET_PARTIES

853: l_old_winner_party_id NUMBER;
854:
855: cursor check_winner_party_exist is
856: select 'X'
857: from HZ_DUP_SET_PARTIES
858: where dup_set_id = p_dup_set_id
859: and dup_party_id = p_winner_party_id
860: and nvl(merge_flag,'Y') = 'Y';
861:

Line 893: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

889: l_old_winner_party_id
890: ,l_set_obj_version_number;
891: CLOSE get_dup_sets_info;
892:
893: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
894: IF (l_set_obj_version_number IS NOT NULL) THEN
895: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: -- row has been changed by another user.

Line 909: -- in hz_dup_set_parties, winner party has merge_flag = null and other

905:
906: px_set_obj_version_number := nvl(l_set_obj_version_number,1)+1;
907:
908: -- Swap master and candidate
909: -- in hz_dup_set_parties, winner party has merge_flag = null and other
910: -- candidate has merge_flag = 'Y'. So, swapping master and candidate
911: -- is actually updating the merge_flag
912:
913: -- Update old winner party. Set merge_flag = 'Y'

Line 914: UPDATE HZ_DUP_SET_PARTIES

910: -- candidate has merge_flag = 'Y'. So, swapping master and candidate
911: -- is actually updating the merge_flag
912:
913: -- Update old winner party. Set merge_flag = 'Y'
914: UPDATE HZ_DUP_SET_PARTIES
915: SET merge_flag = 'Y'
916: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
917: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
918: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 923: UPDATE HZ_DUP_SET_PARTIES

919: WHERE dup_party_id = l_old_winner_party_id
920: AND dup_set_id = p_dup_set_id;
921:
922: -- no need to set the merge flag back to NULL for master party
923: UPDATE HZ_DUP_SET_PARTIES
924: SET last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
925: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
926: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
927: WHERE dup_party_id = p_winner_party_id

Line 1013: from HZ_DUP_SET_PARTIES

1009: and dup_set_id = p_dup_set_id;
1010:
1011: CURSOR check_dup_party(x_party_id NUMBER) IS
1012: select 'X'
1013: from HZ_DUP_SET_PARTIES
1014: where dup_set_id = p_dup_set_id
1015: and dup_party_id = x_party_id;
1016:
1017: l_check VARCHAR2(1);

Line 1035: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

1031: l_winner_party_id
1032: ,l_set_obj_version_number;
1033: CLOSE get_dup_sets_info;
1034:
1035: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1036: IF (l_set_obj_version_number IS NOT NULL) THEN
1037: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: -- row has been changed by another user.

Line 1073: UPDATE HZ_DUP_SET_PARTIES

1069: , last_update_login = hz_utility_v2pub.last_update_login
1070: where dup_set_id = p_dup_set_id;
1071:
1072: -- remove dup party
1073: UPDATE HZ_DUP_SET_PARTIES
1074: SET merge_flag = 'N'
1075: , last_update_date = hz_utility_v2pub.last_update_date
1076: , last_updated_by = hz_utility_v2pub.last_updated_by
1077: , last_update_login = hz_utility_v2pub.last_update_login

Line 1115: UPDATE HZ_DUP_SET_PARTIES

1111: , last_updated_by = hz_utility_v2pub.last_updated_by
1112: , last_update_login = hz_utility_v2pub.last_update_login
1113: where dup_set_id = p_dup_set_id;
1114:
1115: UPDATE HZ_DUP_SET_PARTIES
1116: SET merge_flag = 'N'
1117: , last_update_date = hz_utility_v2pub.last_update_date
1118: , last_updated_by = hz_utility_v2pub.last_updated_by
1119: , last_update_login = hz_utility_v2pub.last_update_login

Line 1180: -- should be removed except the master in HZ_DUP_SET_PARTIES.

1176: -- one party involved, the merge_type of this dup set is set to PARTY_MERGE. Howvever,
1177: -- on UI, user is allowed to remove candidates from a dup set. If user removed all
1178: -- candidates except master and click submit to create merge request. The merge_type of
1179: -- dup set should be restamped as 'SAME_PARTY_MERGE' for single party. All candidates
1180: -- should be removed except the master in HZ_DUP_SET_PARTIES.
1181: --
1182: PROCEDURE reset_merge_type (
1183: p_dup_set_id IN NUMBER
1184: ,px_set_obj_version_number IN OUT NOCOPY NUMBER

Line 1197: from HZ_DUP_SET_PARTIES

1193: where dup_set_id = p_dup_set_id;
1194:
1195: CURSOR check_only_master IS
1196: select count(1)
1197: from HZ_DUP_SET_PARTIES
1198: where dup_set_id = p_dup_set_id;
1199:
1200: CURSOR check_winner_party IS
1201: select 'X'

Line 1205: from HZ_DUP_SET_PARTIES

1201: select 'X'
1202: from HZ_DUP_SETS
1203: where winner_party_id =
1204: ( select dup_party_id
1205: from HZ_DUP_SET_PARTIES
1206: where dup_set_id = p_dup_set_id
1207: and nvl(merge_flag,'Y') <> 'N' )
1208: and dup_set_id = p_dup_set_id;
1209:

Line 1229: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

1225: l_winner_party_id
1226: ,l_set_obj_version_number;
1227: CLOSE get_dup_sets_info;
1228:
1229: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1230: IF (l_set_obj_version_number IS NOT NULL) THEN
1231: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1233: -- row has been changed by another user.

Line 1248: -- the remain party in HZ_DUP_SET_PARTIES which has merge_flag <> 'N'

1244: OPEN check_winner_party;
1245: FETCH check_winner_party INTO l_check;
1246: IF check_winner_party%NOTFOUND THEN
1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1248: -- the remain party in HZ_DUP_SET_PARTIES which has merge_flag <> 'N'
1249: -- is not the same as the winner_party_id in HZ_DUP_SETS
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_SEL_MASTER');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;

Line 1266: DELETE HZ_DUP_SET_PARTIES

1262: , last_updated_by = hz_utility_v2pub.last_updated_by
1263: , last_update_login = hz_utility_v2pub.last_update_login
1264: where dup_set_id = p_dup_set_id;
1265:
1266: DELETE HZ_DUP_SET_PARTIES
1267: where dup_party_id not in
1268: ( select winner_party_id
1269: from HZ_DUP_SETS
1270: where dup_set_id = p_dup_set_id )

Line 1342: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

1338: l_winner_party_id
1339: ,l_set_obj_version_number;
1340: CLOSE get_dup_sets_info;
1341:
1342: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1343: IF (l_set_obj_version_number IS NOT NULL) THEN
1344: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1346: -- row has been changed by another user.

Line 1971: select count(*) from hz_dup_set_parties where dup_set_id=p_dup_set_id and remove_flag is not null;

1967: FUNCTION get_update_flag(x_dup_set_id NUMBER)
1968: RETURN VARCHAR2 IS
1969: update_count NUMBER;
1970: CURSOR update_dupset(p_dup_set_id NUMBER) IS
1971: select count(*) from hz_dup_set_parties where dup_set_id=p_dup_set_id and remove_flag is not null;
1972: BEGIN
1973: open update_dupset(x_dup_Set_id);
1974: fetch update_dupset into update_count;
1975: close update_dupset;