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_PARTY_MERGE dependencies on HZ_RELATIONSHIPS

Line 323: select 1 FROM HZ_RELATIONSHIPS r

319: AND op.actual_content_source(+) = 'DNB'
320: AND ( mp.to_party_id = cp_to_party_id
321: OR (pt.party_type = 'PARTY_RELATIONSHIP'
322: AND exists (
323: select 1 FROM HZ_RELATIONSHIPS r
324: WHERE (r.party_id = mp.to_party_id or r.party_id = mp.from_party_id)
325: AND r.OBJECT_ID = cp_to_party_id)) )
326: ORDER BY decode(pt.party_type, 'PARTY_RELATIONSHIP',1,
327: decode(mp.merge_type, 'PARTY_MERGE',2,

Line 430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

426:
427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
429:
430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
432:
433: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
434: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

Line 431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
429:
430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
432:
433: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
434: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
435:

Line 1706: l_subrec_str := 'SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS'

1702: END IF;
1703:
1704: IF l_hint IS NULL THEN
1705: IF (l_sub_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN --4500011
1706: l_subrec_str := 'SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS'
1707: ||' WHERE '|| l_sub_fk_column_name;
1708: ELSE
1709: l_subrec_str := 'SELECT ' || l_sub_pk_column_name || ' FROM '
1710: ||l_sub_entity_name || ' WHERE '|| l_sub_fk_column_name;

Line 2238: rec_delete := 'UPDATE HZ_RELATIONSHIPS' ||

2234: rec_delete := 'UPDATE ' || l_entity_name ||
2235: ' SET STATUS = ''D'' WHERE ' ||
2236: l_pkcol || ' = :pk';
2237: ELSIF l_entity_name = 'HZ_PARTY_RELATIONSHIPS' THEN --4500011
2238: rec_delete := 'UPDATE HZ_RELATIONSHIPS' ||
2239: ' SET STATUS = ''D'' WHERE ' ||
2240: 'RELATIONSHIP_ID' || ' = :pk'||'AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES'' AND directional_flag = ''F''';
2241: ELSE
2242: -- Construct dynamic SQL query to fetch description

Line 2282: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'

2278: -- Counstruct dynamic SQL query to fetch description
2279: --4500011
2280:
2281: IF (p_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN
2282: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'
2283: || ' WHERE RELATIONSHIP_ID = '|| ':pk'
2284: || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES'' AND directional_flag = ''F''';
2285:
2286: ELSE

Line 2904: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;

2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2901: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2902: l_new_party_site_id hz_party_sites.party_site_id%type;
2903: l_proc_name hz_merge_dictionary.procedure_name%type;
2904: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2905: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
2906:
2907: l_return_status VARCHAR2(200);
2908:

Line 2905: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;

2901: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2902: l_new_party_site_id hz_party_sites.party_site_id%type;
2903: l_proc_name hz_merge_dictionary.procedure_name%type;
2904: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2905: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
2906:
2907: l_return_status VARCHAR2(200);
2908:
2909: l_from_party_id NUMBER;

Line 3016: ----------Pre merge for HZ_RELATIONSHIPS ---------------

3012: END IF;
3013: END LOOP;
3014:
3015: l_return_status := FND_API.G_RET_STS_SUCCESS;
3016: ----------Pre merge for HZ_RELATIONSHIPS ---------------
3017:
3018: --Initialise the log variables
3019: l_from_rec_desc := null;
3020: l_to_rec_desc := null;

Line 3033: from HZ_RELATIONSHIPS --4500011

3029:
3030: ----subject object stuff------
3031: select subject_id , object_id
3032: into l_subject_id , l_object_id
3033: from HZ_RELATIONSHIPS --4500011
3034: where relationship_id = l_merge_to_entity_id
3035: and subject_table_name = 'HZ_PARTIES'
3036: and object_table_name = 'HZ_PARTIES'
3037: and directional_flag = 'F';

Line 3401: FROM HZ_RELATIONSHIPS --4500011

3397: AND nvl(status, 'A') = 'A';
3398:
3399: CURSOR c_branch IS
3400: SELECT 1
3401: FROM HZ_RELATIONSHIPS --4500011
3402: WHERE content_source_type = 'DNB'
3403: AND subject_id = p_from_id
3404: AND object_id = x_to_id
3405: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'

Line 3446: FROM HZ_RELATIONSHIPS

3442:
3443: --5404244
3444: CURSOR c_check_duplicates(from_subject_id number,from_start_date date, from_end_date date, from_rel_code varchar2, from_directional_flag varchar2) IS
3445: SELECT relationship_id, party_id
3446: FROM HZ_RELATIONSHIPS
3447: WHERE object_id = x_to_id
3448: AND actual_content_source = 'USER_ENTERED'
3449: AND subject_id = from_subject_id
3450: AND subject_id NOT IN

Line 3830: -- Handle DNB data in HZ_RELATIONSHIPS

3826: END IF;
3827: END LOOP;
3828:
3829: -- *******************************************
3830: -- Handle DNB data in HZ_RELATIONSHIPS
3831: FOR FROM_REL IN (
3832: SELECT relationship_id, relationship_type, subject_id, DIRECTIONAL_FLAG, PARTY_ID, relationship_code, start_date, end_date --5404244
3833: FROM HZ_RELATIONSHIPS
3834: WHERE actual_content_source = 'DNB'

Line 3833: FROM HZ_RELATIONSHIPS

3829: -- *******************************************
3830: -- Handle DNB data in HZ_RELATIONSHIPS
3831: FOR FROM_REL IN (
3832: SELECT relationship_id, relationship_type, subject_id, DIRECTIONAL_FLAG, PARTY_ID, relationship_code, start_date, end_date --5404244
3833: FROM HZ_RELATIONSHIPS
3834: WHERE actual_content_source = 'DNB'
3835: AND nvl(status, 'A') = 'A'
3836: AND object_id = p_from_id
3837: AND (end_date is null OR end_date>SYSDATE)) LOOP

Line 3843: FROM HZ_RELATIONSHIPS

3839: BEGIN
3840: SELECT relationship_id, subject_id, party_id INTO l_to, l_to_subj_id, l_rel_to_party_id
3841: FROM (
3842: SELECT relationship_id, subject_id, party_id
3843: FROM HZ_RELATIONSHIPS
3844: WHERE actual_content_source = 'DNB'
3845: AND nvl(status, 'A') = 'A'
3846: AND relationship_type = FROM_REL.relationship_type
3847: AND object_id = x_to_id

Line 3975: UPDATE HZ_RELATIONSHIPS

3971: -- From Newer
3972: -- End Date the to-relationship
3973: --Instead of updating the status to 'I'and end_date to SYSDATE
3974: -- Updating the Actual content source to UE.
3975: UPDATE HZ_RELATIONSHIPS
3976: SET actual_content_source = 'USER_ENTERED',
3977: last_update_date = hz_utility_pub.last_update_date,
3978: last_updated_by = hz_utility_pub.user_id,
3979: last_update_login = hz_utility_pub.last_update_login,

Line 4002: /*--Bug 4114254 UPDATE HZ_RELATIONSHIPS

3998: AND ORIG_SYSTEM = 'DNB'
3999: AND STATUS = 'A';
4000:
4001:
4002: /*--Bug 4114254 UPDATE HZ_RELATIONSHIPS
4003: SET end_date = TRUNC(SYSDATE-1),
4004: status = 'I',
4005: last_update_date = hz_utility_pub.last_update_date,
4006: last_updated_by = hz_utility_pub.user_id,

Line 4016: UPDATE HZ_RELATIONSHIPS

4012: WHERE relationship_id = l_to;*/
4013: ELSE -- To Newer
4014: -- End Date the from-relationship
4015:
4016: UPDATE HZ_RELATIONSHIPS
4017: SET actual_content_source = 'USER_ENTERED',
4018: last_update_date = hz_utility_pub.last_update_date,
4019: last_updated_by = hz_utility_pub.user_id,
4020: last_update_login = hz_utility_pub.last_update_login,

Line 4042: /* --Bug 4114254 UPDATE HZ_RELATIONSHIPS

4038: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
4039: AND OWNER_TABLE_ID = FROM_REL.PARTY_ID
4040: AND ORIG_SYSTEM = 'DNB'
4041: AND STATUS = 'A';
4042: /* --Bug 4114254 UPDATE HZ_RELATIONSHIPS
4043: SET status = 'I',
4044: end_date = TRUNC(SYSDATE-1),
4045: last_update_date = hz_utility_pub.last_update_date,
4046: last_updated_by = hz_utility_pub.user_id,