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 349: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);

345: log('Delete dup sets with one party from hz_dup_set_parties, dup set id'||l_dup_dup_set);
346: DELETE from hz_dup_set_parties
347: WHERE dup_set_id=l_dup_dup_set;
348:
349: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);
350: DELETE from hz_dup_sets
351: WHERE dup_set_id=l_dup_dup_set;
352: END IF;
353: ELSE

Line 350: DELETE from hz_dup_sets

346: DELETE from hz_dup_set_parties
347: WHERE dup_set_id=l_dup_dup_set;
348:
349: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);
350: DELETE from hz_dup_sets
351: WHERE dup_set_id=l_dup_dup_set;
352: END IF;
353: ELSE
354: FIRST:=FALSE;

Line 362: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id

358: CLOSE dup_party_sets;
359: END LOOP;
360: CLOSE dup_dup_parties;
361:
362: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
363: AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
364: WHERE dup_set_id = d1.dup_set_id);
365: log('Delete dup sets with no parties from hz_dup_sets'||SQL%ROWCOUNT);
366:

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

361:
362: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
363: AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
364: WHERE dup_set_id = d1.dup_set_id);
365: log('Delete dup sets with no parties from hz_dup_sets'||SQL%ROWCOUNT);
366:
367: log('');
368: log('***********************************************************');
369:

Line 872: --SELECT dup_set_id FROM hz_dup_sets d1

868: log(' All Parties processed successfully. Commencing Sanitization');
869:
870: /* Fix non-mutually exclusive sets if any */
871: --DELETE FROM hz_dup_set_parties WHERE dup_set_id IN (
872: --SELECT dup_set_id FROM hz_dup_sets d1
873: --WHERE dup_batch_id = l_batch_id
874: --AND EXISTS ( --Bug No: 4244529
875: --SELECT 1
876: --FROM hz_dup_set_parties dp

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

877: --WHERE dp.DUP_SET_BATCH_ID = d1.dup_batch_id
878: --AND dp.DUP_PARTY_ID = d1.winner_party_id
879: --AND dp.DUP_SET_ID <> d1.dup_set_id));
880:
881: --DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
882: --AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
883: --WHERE dup_set_id = d1.dup_set_id);
884:
885: log('');

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

997: IF (dupset_count=1) THEN
998: SELECT COUNT(*) INTO winner_count FROM HZ_DUP_SET_PARTIES
999: WHERE DUP_SET_ID = p_dup_set_id
1000: and dup_party_id in
1001: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);
1002:
1003: if(winner_count=1) then
1004: DELETE FROM HZ_DUP_SET_PARTIES WHERE DUP_SET_ID=p_dup_set_id;
1005: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;

Line 1005: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;

1001: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);
1002:
1003: if(winner_count=1) then
1004: DELETE FROM HZ_DUP_SET_PARTIES WHERE DUP_SET_ID=p_dup_set_id;
1005: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;
1006: end if;
1007:
1008: END IF;
1009:

Line 1089: l_dup_set_creation_date HZ_DUP_SETS.creation_date%type;

1085:
1086: l_num_matches NUMBER;
1087: l_count NUMBER;
1088:
1089: l_dup_set_creation_date HZ_DUP_SETS.creation_date%type;
1090: l_mr_last_updated_date HZ_MATCH_RULES_VL.last_update_date%type;
1091: l_mr_comp_flag VARCHAR2(1);
1092:
1093: BEGIN

Line 1111: FROM HZ_DUP_SETS

1107: END IF;
1108:
1109: l_rule_id := p_rule_id;
1110: SELECT winner_party_id,creation_date INTO l_winner_party_id,l_dup_set_creation_date
1111: FROM HZ_DUP_SETS
1112: WHERE dup_set_id = p_dup_set_id;
1113:
1114: select last_update_date,compilation_flag INTO l_mr_last_updated_date,l_mr_comp_flag
1115: from HZ_MATCH_RULES_VL