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: ORDER BY decode(dup_party_id,cp_winner_party_id,2,1);
119:

Line 1820: FROM hz_dup_set_parties

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

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

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

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

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

Line 2769: from HZ_DUP_SET_PARTIES

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

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

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

Line 3810: from HZ_DUP_SET_PARTIES

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

Line 3815: from HZ_DUP_SET_PARTIES

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

Line 3855: from HZ_DUP_SET_PARTIES

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

Line 3860: from HZ_DUP_SET_PARTIES

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

Line 4409: from hz_dup_set_parties dsp

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

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

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

Line 4458: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

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