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_RELATIONSHIPS

Line 412: HZ_RELATIONSHIPS r

408: where code.class_category = 'RELATIONSHIP_TYPE_GROUP'
409: and code.class_code = 'PARTY_REL_GRP_CONTACTS'
410: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
411: and exists ( select 1 from hz_relationship_types rt,
412: HZ_RELATIONSHIPS r
413: where r.relationship_id = p_relationship_id
414: and r.relationship_type = rt.relationship_type
415: and r.relationship_code = rt.forward_rel_code
416: and r.subject_type = rt.subject_type

Line 497: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE; --4500011

493: l_org NUMBER;
494: l_object_version_number NUMBER;
495: db_object_version_number NUMBER;
496:
497: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE; --4500011
498: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE; --4500011
499: rel_batch_party_id NUMBER;
500: l_from_rel_party_id NUMBER;
501: l_to_rel_party_id NUMBER;

Line 498: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE; --4500011

494: l_object_version_number NUMBER;
495: db_object_version_number NUMBER;
496:
497: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE; --4500011
498: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE; --4500011
499: rel_batch_party_id NUMBER;
500: l_from_rel_party_id NUMBER;
501: l_to_rel_party_id NUMBER;
502: l_rel_party_count NUMBER;

Line 707: from hz_relationships pr1, hz_relationships pr2 --bug 4500011 replaced hz_party_relationships with hz_relationships

703: --check if the relationship types are same
704: select pr1.relationship_code from_rel_type,
705: pr2.relationship_code to_rel_type
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'

Line 892: -- HZ_RELATIONSHIPS etc.

888: -- ARGUMENTS
889: -- IN:
890: -- p_batch_party_id Batch_Party_id from the merge tables
891: -- p_entity Name of the entity HZ_PARTY_SITES,
892: -- HZ_RELATIONSHIPS etc.
893: -- p_from_entity_id ID of the from record
894: -- p_to_entity_id ID of the to record
895:
896: -- OUT:

Line 928: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

924: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
925: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
926: l_from_site_party_id NUMBER;
927: l_to_site_party_id NUMBER;
928: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
929: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
930: l_from_dflag HZ_RELATIONSHIPS.directional_flag%type;
931: l_to_dflag HZ_RELATIONSHIPS.directional_flag%type;
932:

Line 929: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

925: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
926: l_from_site_party_id NUMBER;
927: l_to_site_party_id NUMBER;
928: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
929: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
930: l_from_dflag HZ_RELATIONSHIPS.directional_flag%type;
931: l_to_dflag HZ_RELATIONSHIPS.directional_flag%type;
932:
933: l_map_dtl_count NUMBER;

Line 930: l_from_dflag HZ_RELATIONSHIPS.directional_flag%type;

926: l_from_site_party_id NUMBER;
927: l_to_site_party_id NUMBER;
928: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
929: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
930: l_from_dflag HZ_RELATIONSHIPS.directional_flag%type;
931: l_to_dflag HZ_RELATIONSHIPS.directional_flag%type;
932:
933: l_map_dtl_count NUMBER;
934: rel_batch_party_id NUMBER;

Line 931: l_to_dflag HZ_RELATIONSHIPS.directional_flag%type;

927: l_to_site_party_id NUMBER;
928: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
929: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
930: l_from_dflag HZ_RELATIONSHIPS.directional_flag%type;
931: l_to_dflag HZ_RELATIONSHIPS.directional_flag%type;
932:
933: l_map_dtl_count NUMBER;
934: rel_batch_party_id NUMBER;
935: l_from_rel_party_id NUMBER;

Line 1168: from hz_relationships r1, hz_relationships r2

1164: r2.relationship_type to_rel_type,
1165: r2.directional_flag to_dflag
1166: into l_from_rel_type, l_from_dflag,
1167: l_to_rel_type , l_to_dflag
1168: from hz_relationships r1, hz_relationships r2
1169: where r1.relationship_id = p_from_entity_id
1170: and r1.object_id = l_from_party_id
1171: and r2.relationship_id = p_to_entity_id
1172: and r2.object_id = l_to_party_id;

Line 1773: FROM HZ_RELATIONSHIPS r

1769:
1770: CURSOR c_from_reln(l_batch_id NUMBER,merge_type VARCHAR2) IS
1771: SELECT relationship_id, subject_id, object_id,
1772: relationship_code, actual_content_source, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
1773: FROM HZ_RELATIONSHIPS r
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'

Line 1795: FROM HZ_RELATIONSHIPS r

1791: c_batch_id NUMBER,cp_party_rel_code VARCHAR2, cp_obj_id NUMBER,
1792: cp_subj_id NUMBER, from_start_date date, from_end_date date,merge_type VARCHAR2)
1793: IS
1794: SELECT relationship_id, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
1795: FROM HZ_RELATIONSHIPS r
1796: WHERE subject_id = cp_subj_id
1797: AND object_id = cp_obj_id
1798: AND relationship_code = cp_party_rel_code
1799: --OR exists (select 1 from hz_relationship_types where relationship_type = cp_party_relationship_type

Line 1831: FROM HZ_RELATIONSHIPS r

1827: c_batch_id NUMBER, cp_party_rel_code VARCHAR2, cp_subj_id NUMBER,
1828: from_start_date date, from_end_date date)
1829: IS
1830: SELECT relationship_id, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
1831: FROM HZ_RELATIONSHIPS r
1832: WHERE
1833: relationship_id in (select distinct b.merge_to_entity_id
1834: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b
1835: where a.batch_party_id = b.batch_party_id

Line 1853: FROM HZ_RELATIONSHIPS r

1849: c_batch_id NUMBER, cp_party_rel_code VARCHAR2, cp_obj_id NUMBER,
1850: from_start_date date, from_end_date date)
1851: IS
1852: SELECT relationship_id, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
1853: FROM HZ_RELATIONSHIPS r
1854: WHERE
1855: relationship_id in (select distinct b.merge_to_entity_id
1856: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b
1857: where a.batch_party_id = b.batch_party_id

Line 1876: select 'Y' from hz_relationships where relationship_id=rel_id

1872:
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

Line 1886: FROM HZ_RELATIONSHIPS

1882: /* Commented out for BugNo:2940087 */
1883: /*CURSOR c_dup_ob_reln(cp_party_relationship_type VARCHAR2, cp_subj_id NUMBER)
1884: IS
1885: SELECT relationship_id
1886: FROM HZ_RELATIONSHIPS
1887: WHERE object_id = p_to_party_id
1888: AND subject_id = cp_subj_id
1889: AND relationship_code = cp_party_relationship_type
1890: AND nvl(status, 'A') = 'A'

Line 1898: l_dup_start_date HZ_RELATIONSHIPS.start_date%TYPE;

1894: AND actual_content_source <> 'DNB';
1895: */
1896: l_pr_id NUMBER;
1897: l_dup_pr_id NUMBER;
1898: l_dup_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1899: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1900:
1901: l_subj_id NUMBER;
1902: l_obj_id NUMBER;

Line 1899: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;

1895: */
1896: l_pr_id NUMBER;
1897: l_dup_pr_id NUMBER;
1898: l_dup_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1899: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1900:
1901: l_subj_id NUMBER;
1902: l_obj_id NUMBER;
1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;

Line 1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;

1899: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1900:
1901: l_subj_id NUMBER;
1902: l_obj_id NUMBER;
1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
1904: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
1905: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
1906: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1907: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;

Line 1904: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;

1900:
1901: l_subj_id NUMBER;
1902: l_obj_id NUMBER;
1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
1904: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
1905: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
1906: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1907: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1908:

Line 1905: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;

1901: l_subj_id NUMBER;
1902: l_obj_id NUMBER;
1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
1904: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
1905: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
1906: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1907: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1908:
1909: l_batch_id NUMBER;

Line 1906: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;

1902: l_obj_id NUMBER;
1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
1904: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
1905: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
1906: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1907: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1908:
1909: l_batch_id NUMBER;
1910: l_batch_party_id NUMBER;

Line 1907: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;

1903: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
1904: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
1905: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
1906: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
1907: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
1908:
1909: l_batch_id NUMBER;
1910: l_batch_party_id NUMBER;
1911: l_mandatory_merge VARCHAR2(1);

Line 1927: from hz_relationships

1923: l_to_id number;
1924: l_to_rel_status VARCHAR2(1); --6703948
1925: cursor c_get_rel_status(cp_id number) is
1926: select status
1927: from hz_relationships
1928: where relationship_id = cp_id
1929: and rownum = 1;
1930:
1931: cursor c_check_inactive_to_id(cp_id number) is

Line 2761: , HZ_RELATIONSHIPS rel

2757: cursor not_mandatory_reln_mp is
2758: select rel.relationship_id, rel.relationship_type, rel.relationship_code, rel.object_id, rel.subject_id, rel.subject_type, rel.object_type
2759: from HZ_MERGE_PARTYDTLS_SUGG mpd
2760: , HZ_MERGE_PARTIES_SUGG mp
2761: , HZ_RELATIONSHIPS rel
2762: where mpd.batch_party_id = mp.batch_party_id
2763: and mp.batch_id = p_batch_id
2764: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'
2765: and mpd.merge_from_entity_id = mpd.merge_to_entity_id

Line 2778: from HZ_RELATIONSHIPS rel

2774:
2775: -- this is for cleanse single party, pass in subject master which is the party to be cleansed
2776: cursor not_mandatory_reln_sp(l_master_party_id NUMBER) is
2777: select rel.relationship_id, rel.relationship_type, rel.relationship_code, rel.object_id, rel.subject_type, rel.object_type
2778: from HZ_RELATIONSHIPS rel
2779: where subject_id = l_master_party_id
2780: and not exists
2781: ( select 1
2782: from HZ_MERGE_PARTIES_SUGG mp

Line 2784: , HZ_RELATIONSHIPS rel2

2780: and not exists
2781: ( select 1
2782: from HZ_MERGE_PARTIES_SUGG mp
2783: , HZ_MERGE_PARTYDTLS_SUGG mpd
2784: , HZ_RELATIONSHIPS rel2
2785: where mp.batch_id = p_batch_id
2786: and mp.batch_party_id = mpd.batch_party_id
2787: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'
2788: and mpd.merge_from_entity_id = rel2.relationship_id

Line 2810: from HZ_MATCHED_PARTIES_GT mpgt, HZ_RELATIONSHIPS rel

2806: cursor get_suggested_reln(l_search_ctx_id NUMBER, l_reln_obj_id NUMBER, l_master_party NUMBER
2807: , l_reln_type VARCHAR2, l_reln_code VARCHAR2, l_reln_sbj_type VARCHAR2
2808: , l_reln_obj_type VARCHAR2) is
2809: select relationship_id
2810: from HZ_MATCHED_PARTIES_GT mpgt, HZ_RELATIONSHIPS rel
2811: where mpgt.search_context_id = l_search_ctx_id
2812: and mpgt.party_id <> l_reln_obj_id
2813: and mpgt.party_id = rel.object_id
2814: and rel.subject_id = l_master_party

Line 2839: from hz_orig_systems_b o,hz_relationships r

2835:
2836: --4114254
2837: CURSOR c_get_orig_system_r(rel_id NUMBER) IS
2838: select o.orig_system
2839: from hz_orig_systems_b o,hz_relationships r
2840: where r.relationship_id = rel_id
2841: and o.orig_system = r.actual_content_source
2842: and o.orig_system_type = 'PURCHASED'
2843: and directional_flag = 'F';

Line 2848: from hz_relationships

2844: --4114254
2845:
2846: cursor c_get_rel_status(cp_id number) is
2847: select status
2848: from hz_relationships
2849: where relationship_id = cp_id
2850: and rownum = 1;
2851:
2852: TYPE merge_from_reln_tbl IS TABLE OF NUMBER;

Line 2904: ' FROM HZ_RELATIONSHIPS rel' ||

2900: p_init_msg_list => FND_API.G_TRUE
2901: ,p_rule_id => p_rule_id
2902: ,p_party_id => l_reln_obj_id
2903: ,p_restrict_sql => 'stage.PARTY_ID IN (SELECT /*+ SELECTIVE */ OBJECT_ID' ||
2904: ' FROM HZ_RELATIONSHIPS rel' ||
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' ||

Line 2927: from hz_orig_systems_b o,hz_relationships r

2923: -- if found any matches
2924: IF (l_num_matches > 0) THEN
2925:
2926: select o.orig_system,o.orig_system_type into l_to_orig_system,l_to_orig_system_type
2927: from hz_orig_systems_b o,hz_relationships r
2928: where r.relationship_id = l_reln_id
2929: and o.orig_system = r.actual_content_source
2930: and directional_flag = 'F';
2931:

Line 2941: from hz_relationships

2937: if l_num_matches = 1 and l_rel_status = 'I'
2938: then
2939: begin
2940: select relationship_id into l_reln_id --get active rel id
2941: from hz_relationships
2942: where object_id = l_reln_obj_id
2943: and status = 'A'
2944: and rownum = 1;
2945: exception WHEN NO_DATA_FOUND THEN null;

Line 2967: , HZ_RELATIONSHIPS rel

2963: ( SELECT rel.relationship_id
2964: FROM HZ_MATCHED_PARTIES_GT matchpty
2965: , HZ_MERGE_PARTYDTLS_SUGG mpd
2966: , HZ_MERGE_PARTIES_SUGG mps
2967: , HZ_RELATIONSHIPS rel
2968: , HZ_ORIG_SYSTEMS_B O
2969: WHERE matchpty.search_context_id = l_search_ctx_id
2970: AND matchpty.party_id = rel.object_id
2971: AND rel.relationship_code = l_reln_code

Line 3043: ' FROM HZ_RELATIONSHIPS rel' ||

3039: p_init_msg_list => FND_API.G_TRUE
3040: ,p_rule_id => p_rule_id
3041: ,p_party_id => l_reln_obj_id
3042: ,p_restrict_sql => 'stage.PARTY_ID IN (SELECT /*+ SELECTIVE */ OBJECT_ID' ||
3043: ' FROM HZ_RELATIONSHIPS rel' ||
3044: ' WHERE rel.SUBJECT_ID = '|| l_master_party||
3045: ' AND rel.SUBJECT_TYPE = '''||l_reln_sbj_type||''''||
3046: ' AND rel.OBJECT_TYPE = '''||l_reln_obj_type||''''||
3047: ' AND rel.relationship_type = '''||l_reln_type||''''||

Line 3374: -- p_entity_name HZ_PARTY_SITES - Addresses or HZ_RELATIONSHIPS - Relationships

3370: --
3371: -- ARGUMENTS
3372: -- IN:
3373: -- p_batch_id ID of the merge batch
3374: -- p_entity_name HZ_PARTY_SITES - Addresses or HZ_RELATIONSHIPS - Relationships
3375: -- p_merge_type Merge type of the dup set
3376: --
3377: -- OUT:
3378: -- x_return_status Return status after the call. The status can

Line 3446: -- if entity is HZ_RELATIONSHIPS, insert DUPLICATE_RELN_PARTY record to

3442: ( SELECT batch_party_id
3443: FROM HZ_MERGE_PARTIES_SUGG
3444: WHERE batch_id = p_batch_id );
3445:
3446: -- if entity is HZ_RELATIONSHIPS, insert DUPLICATE_RELN_PARTY record to
3447: -- HZ_MERGE_PARTIES table as well
3448:
3449: IF(p_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN
3450:

Line 3531: -- p_entity_name HZ_PARTY_SITES - Addresses or HZ_RELATIONSHIPS - Relationships

3527: --
3528: -- ARGUMENTS
3529: -- IN:
3530: -- p_batch_id ID of the merge batch
3531: -- p_entity_name HZ_PARTY_SITES - Addresses or HZ_RELATIONSHIPS - Relationships
3532: -- p_merge_type Merge type of the dup set
3533: --
3534: -- OUT:
3535: -- x_return_status Return status after the call. The status can

Line 3780: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel

3776:
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'

Line 3800: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel

3796:
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

Line 3825: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel

3821:
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'

Line 3845: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel

3841:
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

Line 4252: -- HZ_RELATIONSHIPS etc.

4248: -- ARGUMENTS
4249: -- IN:
4250: -- p_merge_batch_id ID of the merge batch
4251: -- p_entity Name of the entity HZ_PARTY_SITES,
4252: -- HZ_RELATIONSHIPS etc.
4253: -- p_entity_id ID of the entity
4254: -- p_merge_type Merge type of the dup set
4255: --
4256: -- OUT: