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

Line 80: l_merge_from HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;

76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2 ) IS
79:
80: l_merge_from HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
81: l_merge_to HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
82: l_merge_type HZ_DUP_SETS.MERGE_TYPE%TYPE;
83: l_merge_type2 HZ_DUP_SETS.MERGE_TYPE%TYPE;
84: l_count NUMBER := 0;

Line 81: l_merge_to HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;

77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2 ) IS
79:
80: l_merge_from HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
81: l_merge_to HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
82: l_merge_type HZ_DUP_SETS.MERGE_TYPE%TYPE;
83: l_merge_type2 HZ_DUP_SETS.MERGE_TYPE%TYPE;
84: l_count NUMBER := 0;
85: l_dup_set_count NUMBER;

Line 91: l_batch_party_id HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;

87: l_party_type VARCHAR2(255);
88:
89: l_batch_id HZ_MERGE_BATCH.BATCH_ID%TYPE;
90: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
91: l_batch_party_id HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
92: l_object_version_number NUMBER;
93: db_object_version_number NUMBER;
94: l_automerge_flag varchar2(1);
95: l_addr_match_rule NUMBER := 0;

Line 115: FROM HZ_DUP_SET_PARTIES

111:
112: --Cursor to get the parties to be merged
113: CURSOR get_merge_parties_csr(cp_winner_party_id NUMBER) IS
114: SELECT DUP_PARTY_ID
115: FROM HZ_DUP_SET_PARTIES
116: WHERE DUP_SET_ID = p_dup_set_id
117: AND nvl(MERGE_FLAG,'Y')<>'N';
118:
119: cursor sugg_request_exist_csr is

Line 1819: FROM hz_dup_set_parties

1815:
1816: --4651128
1817: CURSOR c_get_from_parties(c_batch_id NUMBER) IS
1818: SELECT dup_party_id
1819: FROM hz_dup_set_parties
1820: WHERE dup_set_id = c_batch_id
1821: AND dup_party_id <> p_from_party_id
1822: AND dup_party_id <> p_to_party_id;
1823:

Line 1876: and (subject_id IN (SELECT dup_party_id FROM HZ_dup_set_PARTIES WHERE dup_set_id=batch_id))

1872:
1873: --bug 4867151 start
1874: CURSOR c_self_reln(rel_id NUMBER, batch_id NUMBER, to_id NUMBER) IS
1875: select 'Y' from hz_relationships where relationship_id=rel_id
1876: and (subject_id IN (SELECT dup_party_id FROM HZ_dup_set_PARTIES WHERE dup_set_id=batch_id))
1877: and (object_id IN (SELECT dup_party_id FROM HZ_dup_set_PARTIES WHERE dup_set_id=batch_id))
1878: AND directional_flag='F';
1879: --bug 4867151 end
1880:

Line 1877: and (object_id IN (SELECT dup_party_id FROM HZ_dup_set_PARTIES WHERE dup_set_id=batch_id))

1873: --bug 4867151 start
1874: CURSOR c_self_reln(rel_id NUMBER, batch_id NUMBER, to_id NUMBER) IS
1875: select 'Y' from hz_relationships where relationship_id=rel_id
1876: and (subject_id IN (SELECT dup_party_id FROM HZ_dup_set_PARTIES WHERE dup_set_id=batch_id))
1877: and (object_id IN (SELECT dup_party_id FROM HZ_dup_set_PARTIES WHERE dup_set_id=batch_id))
1878: AND directional_flag='F';
1879: --bug 4867151 end
1880:
1881: /* Commented out for BugNo:2940087 */

Line 2768: from HZ_DUP_SET_PARTIES

2764: and mpd.merge_from_entity_id = mpd.merge_to_entity_id
2765: and mpd.merge_from_entity_id = rel.relationship_id
2766: and rel.subject_id in (
2767: select dup_party_id
2768: from HZ_DUP_SET_PARTIES
2769: where dup_set_id = p_batch_id
2770: and nvl(merge_flag,'Y') <> 'N'
2771: ) ;
2772:

Line 2907: ' from HZ_DUP_SET_PARTIES where dup_set_id = '|| p_batch_id||

2903: ' WHERE rel.SUBJECT_TYPE = '''||l_reln_sbj_type||''''||
2904: ' AND rel.OBJECT_TYPE = '''||l_reln_obj_type||''''||
2905: ' AND rel.RELATIONSHIP_TYPE = '''||l_reln_type||''''||
2906: ' AND rel.SUBJECT_ID IN (select dup_party_id' ||
2907: ' from HZ_DUP_SET_PARTIES where dup_set_id = '|| p_batch_id||
2908: ' and nvl(merge_flag,''Y'''||')'||' <> ''N'''||')'||
2909: ' AND rel.RELATIONSHIP_CODE = '''|| l_reln_code||''' )'
2910: ,p_match_type => 'OR'
2911: ,p_dup_batch_id => NULL

Line 3808: from HZ_DUP_SET_PARTIES

3804: and mpd.merge_from_entity_id = from_rel.relationship_id
3805: and mpd.merge_to_entity_id = to_rel.relationship_id
3806: and from_rel.object_id in
3807: ( select dup_party_id
3808: from HZ_DUP_SET_PARTIES
3809: where dup_set_id = p_batch_id
3810: and nvl(merge_flag,'Y') <> 'N' )
3811: and to_rel.object_id in
3812: ( select dup_party_id

Line 3813: from HZ_DUP_SET_PARTIES

3809: where dup_set_id = p_batch_id
3810: and nvl(merge_flag,'Y') <> 'N' )
3811: and to_rel.object_id in
3812: ( select dup_party_id
3813: from HZ_DUP_SET_PARTIES
3814: where dup_set_id = p_batch_id
3815: and nvl(merge_flag,'Y') <> 'N' )
3816: and from_rel.subject_id = from_pty.party_id
3817: and to_rel.subject_id = to_pty.party_id

Line 3853: from HZ_DUP_SET_PARTIES

3849: and mpd.merge_from_entity_id = from_rel.relationship_id
3850: and mpd.merge_to_entity_id = to_rel.relationship_id
3851: and from_rel.object_id in
3852: ( select dup_party_id
3853: from HZ_DUP_SET_PARTIES
3854: where dup_set_id = p_batch_id
3855: and nvl(merge_flag,'Y') <> 'N' )
3856: and to_rel.object_id in
3857: ( select dup_party_id

Line 3858: from HZ_DUP_SET_PARTIES

3854: where dup_set_id = p_batch_id
3855: and nvl(merge_flag,'Y') <> 'N' )
3856: and to_rel.object_id in
3857: ( select dup_party_id
3858: from HZ_DUP_SET_PARTIES
3859: where dup_set_id = p_batch_id
3860: and nvl(merge_flag,'Y') <> 'N' )
3861: and from_rel.subject_id = from_pty.party_id
3862: and to_rel.subject_id = to_pty.party_id

Line 4407: from hz_dup_set_parties dsp

4403: /* select 'x'
4404: from hz_merge_parties mp
4405: where mp.batch_id = p_merge_batch_id
4406: and not exists ( select 'x'
4407: from hz_dup_set_parties dsp
4408: where dsp.dup_set_id = mp.batch_id
4409: and mp.batch_id = p_merge_batch_id); */
4410: -- Added new column created_by_module in hz_merge_batch instead of above checking
4411: select 'x'

Line 4446: from hz_parties party, hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

4442: x_msg_data OUT NOCOPY VARCHAR2 ) is
4443:
4444: cursor dset_overlap_merged_party_csr is
4445: select party.party_number,ds.object_version_number
4446: from hz_parties party, hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4447: where party.party_id =dsp.dup_party_id
4448: and db.dup_batch_id = ds.dup_batch_id
4449: and ds.dup_set_id = dsp.dup_set_id
4450: and party.status = 'M'

Line 4456: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

4452:
4453: cursor dset_overlap_req_party_csr is
4454: select distinct mp.batch_id,dsp.dup_party_id,ds.object_version_number
4455: from hz_merge_batch mb, hz_merge_parties mp,
4456: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4457: where mp.batch_id <> ds.dup_set_id
4458: and mb.batch_id = mp.batch_id
4459: and db.dup_batch_id = ds.dup_batch_id
4460: and ds.dup_set_id = dsp.dup_set_id