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_PARTIES

Line 101: FROM HZ_DUP_SETS, HZ_PARTIES

97:
98: CURSOR c_batch_name IS
99: SELECT substrb(party_name, 1, 60) || ' (' || p_dup_set_id||')',
100: winner_party_id, merge_type
101: FROM HZ_DUP_SETS, HZ_PARTIES
102: WHERE winner_party_id = party_id
103: AND dup_set_id = p_dup_set_id;
104:
105: cursor get_automerge_flag_csr is

Line 252: FROM HZ_PARTIES

248:
249: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',
250: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
251: 'HZ_ORGANIZATION_PROFILES') INTO l_party_type
252: FROM HZ_PARTIES
253: WHERE party_id=l_merge_to;
254:
255: HZ_MERGE_ENTITY_ATTRI_PVT.create_merge_attributes(
256: l_batch_id, l_merge_to, l_party_type,

Line 710: AND pr1.subject_table_name = 'HZ_PARTIES'

706: into l_from_rel_type,l_to_rel_type
707: from hz_relationships pr1, hz_relationships pr2 --bug 4500011 replaced hz_party_relationships with hz_relationships
708: where pr1.relationship_id = p_from_entity_id
709: and pr2.relationship_id = p_to_entity_id
710: AND pr1.subject_table_name = 'HZ_PARTIES'
711: AND pr1.object_table_name = 'HZ_PARTIES'
712: AND pr1.directional_flag = 'F'
713: AND pr2.subject_table_name = 'HZ_PARTIES'
714: AND pr2.object_table_name = 'HZ_PARTIES'

Line 711: AND pr1.object_table_name = 'HZ_PARTIES'

707: from hz_relationships pr1, hz_relationships pr2 --bug 4500011 replaced hz_party_relationships with hz_relationships
708: where pr1.relationship_id = p_from_entity_id
709: and pr2.relationship_id = p_to_entity_id
710: AND pr1.subject_table_name = 'HZ_PARTIES'
711: AND pr1.object_table_name = 'HZ_PARTIES'
712: AND pr1.directional_flag = 'F'
713: AND pr2.subject_table_name = 'HZ_PARTIES'
714: AND pr2.object_table_name = 'HZ_PARTIES'
715: AND pr2.directional_flag = 'F';

Line 713: AND pr2.subject_table_name = 'HZ_PARTIES'

709: and pr2.relationship_id = p_to_entity_id
710: AND pr1.subject_table_name = 'HZ_PARTIES'
711: AND pr1.object_table_name = 'HZ_PARTIES'
712: AND pr1.directional_flag = 'F'
713: AND pr2.subject_table_name = 'HZ_PARTIES'
714: AND pr2.object_table_name = 'HZ_PARTIES'
715: AND pr2.directional_flag = 'F';
716:
717: IF l_from_rel_type <> l_to_rel_type THEN

Line 714: AND pr2.object_table_name = 'HZ_PARTIES'

710: AND pr1.subject_table_name = 'HZ_PARTIES'
711: AND pr1.object_table_name = 'HZ_PARTIES'
712: AND pr1.directional_flag = 'F'
713: AND pr2.subject_table_name = 'HZ_PARTIES'
714: AND pr2.object_table_name = 'HZ_PARTIES'
715: AND pr2.directional_flag = 'F';
716:
717: IF l_from_rel_type <> l_to_rel_type THEN
718:

Line 1606: from hz_parties

1602: l_batch_party_id := null;
1603:
1604: -- 5194384
1605: select status into l_rel_status
1606: from hz_parties
1607: where party_id = l_to_reln_party_id;
1608:
1609: --Bug6703948
1610: select status into l_from_rel_status

Line 1611: from hz_parties

1607: where party_id = l_to_reln_party_id;
1608:
1609: --Bug6703948
1610: select status into l_from_rel_status
1611: from hz_parties
1612: where party_id = l_from_reln_party_id;
1613:
1614: IF l_from_rel_status <> 'I' THEN --Bug6703948
1615:

Line 1778: AND subject_table_name = 'HZ_PARTIES'

1774: WHERE (subject_id = p_from_party_id
1775: OR object_id = p_from_party_id)
1776: AND nvl(status, 'A') IN ('A','I')
1777: AND directional_flag = 'F'
1778: AND subject_table_name = 'HZ_PARTIES'
1779: AND object_table_name = 'HZ_PARTIES'
1780: AND (merge_type ='S' OR actual_content_source <> 'DNB')--Bug No. 4114254
1781: AND not exists
1782: ( select 1

Line 1779: AND object_table_name = 'HZ_PARTIES'

1775: OR object_id = p_from_party_id)
1776: AND nvl(status, 'A') IN ('A','I')
1777: AND directional_flag = 'F'
1778: AND subject_table_name = 'HZ_PARTIES'
1779: AND object_table_name = 'HZ_PARTIES'
1780: AND (merge_type ='S' OR actual_content_source <> 'DNB')--Bug No. 4114254
1781: AND not exists
1782: ( select 1
1783: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

Line 1806: AND subject_table_name = 'HZ_PARTIES'

1802: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
1803: or(start_datefrom_end_date))
1804: AND nvl(status, 'A') IN ('A','I') --BugNo:2940087
1805: --AND directional_flag = 'F' --BugNo:2940087
1806: AND subject_table_name = 'HZ_PARTIES'
1807: AND object_table_name = 'HZ_PARTIES'
1808: AND (merge_type ='S' OR actual_content_source <> 'DNB') --Bug No. 4114254
1809: AND not exists --4651128
1810: ( select 1

Line 1807: AND object_table_name = 'HZ_PARTIES'

1803: or(start_datefrom_end_date))
1804: AND nvl(status, 'A') IN ('A','I') --BugNo:2940087
1805: --AND directional_flag = 'F' --BugNo:2940087
1806: AND subject_table_name = 'HZ_PARTIES'
1807: AND object_table_name = 'HZ_PARTIES'
1808: AND (merge_type ='S' OR actual_content_source <> 'DNB') --Bug No. 4114254
1809: AND not exists --4651128
1810: ( select 1
1811: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

Line 1845: AND subject_table_name = 'HZ_PARTIES'

1841: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
1842: or(start_datefrom_end_date))
1843: AND nvl(status, 'A') IN ('A','I')
1844: AND directional_flag = 'F'
1845: AND subject_table_name = 'HZ_PARTIES'
1846: AND object_table_name = 'HZ_PARTIES';
1847:
1848: CURSOR check_dup_obj_reln(
1849: c_batch_id NUMBER, cp_party_rel_code VARCHAR2, cp_obj_id NUMBER,

Line 1846: AND object_table_name = 'HZ_PARTIES';

1842: or(start_datefrom_end_date))
1843: AND nvl(status, 'A') IN ('A','I')
1844: AND directional_flag = 'F'
1845: AND subject_table_name = 'HZ_PARTIES'
1846: AND object_table_name = 'HZ_PARTIES';
1847:
1848: CURSOR check_dup_obj_reln(
1849: c_batch_id NUMBER, cp_party_rel_code VARCHAR2, cp_obj_id NUMBER,
1850: from_start_date date, from_end_date date)

Line 1867: AND subject_table_name = 'HZ_PARTIES'

1863: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
1864: or(start_datefrom_end_date))
1865: AND nvl(status, 'A') IN ('A','I')
1866: AND directional_flag = 'F'
1867: AND subject_table_name = 'HZ_PARTIES'
1868: AND object_table_name = 'HZ_PARTIES';
1869: --4651128
1870:
1871:

Line 1868: AND object_table_name = 'HZ_PARTIES';

1864: or(start_datefrom_end_date))
1865: AND nvl(status, 'A') IN ('A','I')
1866: AND directional_flag = 'F'
1867: AND subject_table_name = 'HZ_PARTIES'
1868: AND object_table_name = 'HZ_PARTIES';
1869: --4651128
1870:
1871:
1872:

Line 1892: AND subject_table_name = 'HZ_PARTIES'

1888: AND subject_id = cp_subj_id
1889: AND relationship_code = cp_party_relationship_type
1890: AND nvl(status, 'A') = 'A'
1891: AND directional_flag = 'F'
1892: AND subject_table_name = 'HZ_PARTIES'
1893: AND object_table_name = 'HZ_PARTIES'
1894: AND actual_content_source <> 'DNB';
1895: */
1896: l_pr_id NUMBER;

Line 1893: AND object_table_name = 'HZ_PARTIES'

1889: AND relationship_code = cp_party_relationship_type
1890: AND nvl(status, 'A') = 'A'
1891: AND directional_flag = 'F'
1892: AND subject_table_name = 'HZ_PARTIES'
1893: AND object_table_name = 'HZ_PARTIES'
1894: AND actual_content_source <> 'DNB';
1895: */
1896: l_pr_id NUMBER;
1897: l_dup_pr_id NUMBER;

Line 3781: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

3777: CURSOR get_reln_party_sp IS
3778: select to_rel.subject_id, count(1)
3779: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3780: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3781: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3782: where mpd.batch_party_id = mp.batch_party_id
3783: and mp.batch_id = p_batch_id
3784: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'
3785: and mpd.merge_from_entity_id = from_rel.relationship_id

Line 3801: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

3797: CURSOR get_reln_party_mp IS
3798: select to_rel.subject_id, count(1)
3799: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3800: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3801: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3802: where mpd.batch_party_id = mp.batch_party_id
3803: and mpd.merge_from_entity_id <> mpd.merge_to_entity_id
3804: and mp.batch_id = p_batch_id
3805: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'

Line 3826: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

3822: CURSOR get_reln_from_party_sp(l_to_party_id NUMBER) IS
3823: select from_rel.subject_id
3824: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3825: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3826: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3827: where mpd.batch_party_id = mp.batch_party_id
3828: and mp.batch_id = p_batch_id
3829: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'
3830: and mpd.merge_from_entity_id = from_rel.relationship_id

Line 3846: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

3842: CURSOR get_reln_from_party_mp(l_to_party_id NUMBER) IS
3843: select from_rel.subject_id
3844: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3845: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3846: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3847: where mpd.batch_party_id = mp.batch_party_id
3848: and mpd.merge_from_entity_id <> mpd.merge_to_entity_id
3849: and mp.batch_id = p_batch_id
3850: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'

Line 3869: from HZ_DUP_SETS a, HZ_PARTIES b

3865: and to_rel.subject_id = l_to_party_id;
3866:
3867: CURSOR get_master_party is
3868: select party_name
3869: from HZ_DUP_SETS a, HZ_PARTIES b
3870: where a.winner_party_id = b.party_id
3871: and a.dup_set_id = p_batch_id;
3872:
3873: CURSOR get_cand_party(l_party_id NUMBER) is

Line 3875: from HZ_PARTIES

3871: and a.dup_set_id = p_batch_id;
3872:
3873: CURSOR get_cand_party(l_party_id NUMBER) is
3874: select party_name
3875: from HZ_PARTIES
3876: where party_id = l_party_id;
3877:
3878: cursor is_sugg_request_done_csr is
3879: select count(*)

Line 4167: FROM HZ_DUP_SETS a, HZ_PARTIES pty

4163: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
4164: 'HZ_ORGANIZATION_PROFILES'),
4165: a.winner_party_id
4166: INTO l_party_type, l_merge_to
4167: FROM HZ_DUP_SETS a, HZ_PARTIES pty
4168: WHERE a.dup_set_id = p_batch_id
4169: AND a.winner_party_id = pty.party_id;
4170:
4171: HZ_MERGE_ENTITY_ATTRI_PVT.create_merge_attributes(

Line 4390: from hz_parties

4386: function get_party_number(p_party_id in number) return varchar2 is
4387:
4388: cursor get_party_number_csr is
4389: select party_number
4390: from hz_parties
4391: where party_id = p_party_id;
4392: l_party_number varchar2(30);
4393: begin
4394: open get_party_number_csr;

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 4470: from hz_parties party, hz_merge_parties mp, hz_merge_batch mb

4466: and ds.dup_set_id = p_dup_set_id;
4467:
4468: cursor batch_overlap_merged_party_csr is
4469: select distinct party.party_number
4470: from hz_parties party, hz_merge_parties mp, hz_merge_batch mb
4471: where (party.party_id = mp.from_party_id or party.party_id = mp.to_party_id)
4472: and party.status = 'M'
4473: and mp.batch_id = p_merge_batch_id
4474: and mb.batch_id = mp.batch_id

Line 4485: from hz_parties p1, hz_merge_parties mp2

4481: where dup_set_id = p_merge_batch_id;
4482:
4483: cursor get_merged_rel_party_csr is
4484: select mp2.batch_party_id
4485: from hz_parties p1, hz_merge_parties mp2
4486: where p1.party_id = mp2.from_party_id
4487: and p1.status = 'M'
4488: and mp2.merge_reason_code = 'DUPLICATE_RELN_PARTY'
4489: and mp2.batch_id = p_merge_batch_id;

Line 4648: hz_parties hp

4644: from hz_merge_parties p,
4645: hz_merge_party_details pd,
4646: hz_party_sites s,
4647: hz_locations l,
4648: hz_parties hp
4649: where p.batch_party_id = pd.batch_party_id
4650: and pd.entity_name = 'HZ_PARTY_SITES'
4651: and pd.merge_from_entity_id = s.party_site_id
4652: and s.location_id = l.location_id