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 251: FROM HZ_PARTIES

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

Line 709: AND pr1.subject_table_name = 'HZ_PARTIES'

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

Line 710: AND pr1.object_table_name = 'HZ_PARTIES'

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

Line 712: AND pr2.subject_table_name = 'HZ_PARTIES'

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

Line 713: AND pr2.object_table_name = 'HZ_PARTIES'

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

Line 1605: from hz_parties

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

Line 1610: from hz_parties

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

Line 1777: AND subject_table_name = 'HZ_PARTIES'

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

Line 1778: AND object_table_name = 'HZ_PARTIES'

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

Line 1805: AND subject_table_name = 'HZ_PARTIES'

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

Line 1806: AND object_table_name = 'HZ_PARTIES'

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

Line 1844: AND subject_table_name = 'HZ_PARTIES'

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

Line 1845: AND object_table_name = 'HZ_PARTIES';

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

Line 1866: AND subject_table_name = 'HZ_PARTIES'

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

Line 1867: AND object_table_name = 'HZ_PARTIES';

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

Line 1891: AND subject_table_name = 'HZ_PARTIES'

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

Line 1892: AND object_table_name = 'HZ_PARTIES'

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

Line 3779: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

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

Line 3799: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

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

Line 3824: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

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

Line 3844: , HZ_PARTIES from_pty, HZ_PARTIES to_pty

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

Line 3867: from HZ_DUP_SETS a, HZ_PARTIES b

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

Line 3873: from HZ_PARTIES

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

Line 4165: FROM HZ_DUP_SETS a, HZ_PARTIES pty

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

Line 4388: from hz_parties

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

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

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

Line 4483: from hz_parties p1, hz_merge_parties mp2

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

Line 4645: hz_parties hp

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