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_BATCH_DUPLICATE dependencies on HZ_DUP_SETS

Line 64: from hz_dup_set_parties dsp, hz_dup_sets ds

60: -- start bug 4773387
61:
62: cursor am_candidates_exist_csr(cp_dup_batch_id NUMBER) is
63: select count(*)
64: from hz_dup_set_parties dsp, hz_dup_sets ds
65: where dsp.dup_set_id = ds.dup_set_id
66: and ds.dup_batch_id = cp_dup_batch_id
67: and ds.winner_party_id <> dsp.dup_party_id
68: and merge_flag = 'Y'

Line 102: where dup_set_id in (select dup_set_id from hz_dup_sets where dup_batch_id=cp_dup_batch_id)

98:
99: CURSOR dup_dup_parties(cp_dup_batch_id NUMBER) IS
100: select dup_party_id
101: from hz_dup_set_parties
102: where dup_set_id in (select dup_set_id from hz_dup_sets where dup_batch_id=cp_dup_batch_id)
103: group by dup_party_id
104: having count(*)>1;
105:
106: CURSOR dup_party_sets(cp_dup_batch_id NUMBER, cp_dup_party_id NUMBER) IS

Line 108: FROM hz_dup_set_parties dsp, hz_dup_sets ds

104: having count(*)>1;
105:
106: CURSOR dup_party_sets(cp_dup_batch_id NUMBER, cp_dup_party_id NUMBER) IS
107: select ds.dup_set_id
108: FROM hz_dup_set_parties dsp, hz_dup_sets ds
109: where dsp.dup_set_id=ds.dup_set_id
110: and ds.dup_batch_id=cp_dup_batch_id
111: and dsp.dup_party_id=cp_dup_party_id
112: order by ds.dup_set_id;

Line 343: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);

339: log('Delete dup sets with one party from hz_dup_set_parties, dup set id'||l_dup_dup_set);
340: DELETE from hz_dup_set_parties
341: WHERE dup_set_id=l_dup_dup_set;
342:
343: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);
344: DELETE from hz_dup_sets
345: WHERE dup_set_id=l_dup_dup_set;
346: END IF;
347: ELSE

Line 344: DELETE from hz_dup_sets

340: DELETE from hz_dup_set_parties
341: WHERE dup_set_id=l_dup_dup_set;
342:
343: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);
344: DELETE from hz_dup_sets
345: WHERE dup_set_id=l_dup_dup_set;
346: END IF;
347: ELSE
348: FIRST:=FALSE;

Line 356: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id

352: CLOSE dup_party_sets;
353: END LOOP;
354: CLOSE dup_dup_parties;
355:
356: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
357: AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
358: WHERE dup_set_id = d1.dup_set_id);
359: log('Delete dup sets with no parties from hz_dup_sets'||SQL%ROWCOUNT);
360:

Line 359: log('Delete dup sets with no parties from hz_dup_sets'||SQL%ROWCOUNT);

355:
356: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
357: AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
358: WHERE dup_set_id = d1.dup_set_id);
359: log('Delete dup sets with no parties from hz_dup_sets'||SQL%ROWCOUNT);
360:
361: log('');
362: log('***********************************************************');
363:

Line 866: --SELECT dup_set_id FROM hz_dup_sets d1

862: log(' All Parties processed successfully. Commencing Sanitization');
863:
864: /* Fix non-mutually exclusive sets if any */
865: --DELETE FROM hz_dup_set_parties WHERE dup_set_id IN (
866: --SELECT dup_set_id FROM hz_dup_sets d1
867: --WHERE dup_batch_id = l_batch_id
868: --AND EXISTS ( --Bug No: 4244529
869: --SELECT 1
870: --FROM hz_dup_set_parties dp

Line 875: --DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id

871: --WHERE dp.DUP_SET_BATCH_ID = d1.dup_batch_id
872: --AND dp.DUP_PARTY_ID = d1.winner_party_id
873: --AND dp.DUP_SET_ID <> d1.dup_set_id));
874:
875: --DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
876: --AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
877: --WHERE dup_set_id = d1.dup_set_id);
878:
879: log('');

Line 995: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);

991: IF (dupset_count=1) THEN
992: SELECT COUNT(*) INTO winner_count FROM HZ_DUP_SET_PARTIES
993: WHERE DUP_SET_ID = p_dup_set_id
994: and dup_party_id in
995: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);
996:
997: if(winner_count=1) then
998: DELETE FROM HZ_DUP_SET_PARTIES WHERE DUP_SET_ID=p_dup_set_id;
999: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;

Line 999: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;

995: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);
996:
997: if(winner_count=1) then
998: DELETE FROM HZ_DUP_SET_PARTIES WHERE DUP_SET_ID=p_dup_set_id;
999: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;
1000: end if;
1001:
1002: END IF;
1003:

Line 1083: l_dup_set_creation_date HZ_DUP_SETS.creation_date%type;

1079:
1080: l_num_matches NUMBER;
1081: l_count NUMBER;
1082:
1083: l_dup_set_creation_date HZ_DUP_SETS.creation_date%type;
1084: l_mr_last_updated_date HZ_MATCH_RULES_VL.last_update_date%type;
1085: l_mr_comp_flag VARCHAR2(1);
1086:
1087: BEGIN

Line 1105: FROM HZ_DUP_SETS

1101: END IF;
1102:
1103: l_rule_id := p_rule_id;
1104: SELECT winner_party_id,creation_date INTO l_winner_party_id,l_dup_set_creation_date
1105: FROM HZ_DUP_SETS
1106: WHERE dup_set_id = p_dup_set_id;
1107:
1108: select last_update_date,compilation_flag INTO l_mr_last_updated_date,l_mr_comp_flag
1109: from HZ_MATCH_RULES_VL