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 344: select 1 FROM HZ_RELATIONSHIPS r

340: AND op.effective_end_date IS NULL
341: AND ( mp.to_party_id = cp_to_party_id
342: OR (pt.party_type = 'PARTY_RELATIONSHIP'
343: AND exists (
344: select 1 FROM HZ_RELATIONSHIPS r
345: WHERE (r.party_id = mp.to_party_id or r.party_id = mp.from_party_id)
346: AND r.OBJECT_ID IN (SELECT from_party_id
347: FROM hz_merge_parties
348: WHERE batch_id = cp_batch_id AND to_party_id = cp_to_party_id))) )

Line 453: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

449:
450: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
451: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
452:
453: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
454: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
455:
456: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
457: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

Line 454: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

450: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
451: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
452:
453: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
454: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
455:
456: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
457: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
458:

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

1742: END IF;
1743:
1744: IF l_hint IS NULL THEN
1745: IF (l_sub_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN --4500011
1746: l_subrec_str := 'SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS'
1747: ||' WHERE '|| l_sub_fk_column_name;
1748: ELSE
1749: l_subrec_str := 'SELECT ' || l_sub_pk_column_name || ' FROM '
1750: ||l_sub_entity_name || ' WHERE '|| l_sub_fk_column_name;

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

2274: rec_delete := 'UPDATE ' || l_entity_name ||
2275: ' SET STATUS = ''D'' WHERE ' ||
2276: l_pkcol || ' = :pk';
2277: ELSIF l_entity_name = 'HZ_PARTY_RELATIONSHIPS' THEN --4500011
2278: rec_delete := 'UPDATE HZ_RELATIONSHIPS' ||
2279: ' SET STATUS = ''D'' WHERE ' ||
2280: 'RELATIONSHIP_ID' || ' = :pk'||'AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES'' AND directional_flag = ''F''';
2281: ELSE
2282: -- Construct dynamic SQL query to fetch description

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

2318: -- Counstruct dynamic SQL query to fetch description
2319: --4500011
2320:
2321: IF (p_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN
2322: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'
2323: || ' WHERE RELATIONSHIP_ID = '|| ':pk'
2324: || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES'' AND directional_flag = ''F''';
2325:
2326: ELSE

Line 2944: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;

2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2942: l_new_party_site_id hz_party_sites.party_site_id%type;
2943: l_proc_name hz_merge_dictionary.procedure_name%type;
2944: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2945: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
2946:
2947: l_return_status VARCHAR2(200);
2948:

Line 2945: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;

2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2942: l_new_party_site_id hz_party_sites.party_site_id%type;
2943: l_proc_name hz_merge_dictionary.procedure_name%type;
2944: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2945: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
2946:
2947: l_return_status VARCHAR2(200);
2948:
2949: l_from_party_id NUMBER;

Line 3056: ----------Pre merge for HZ_RELATIONSHIPS ---------------

3052: END IF;
3053: END LOOP;
3054:
3055: l_return_status := FND_API.G_RET_STS_SUCCESS;
3056: ----------Pre merge for HZ_RELATIONSHIPS ---------------
3057:
3058: --Initialise the log variables
3059: l_from_rec_desc := null;
3060: l_to_rec_desc := null;

Line 3073: from HZ_RELATIONSHIPS --4500011

3069:
3070: ----subject object stuff------
3071: select subject_id , object_id
3072: into l_subject_id , l_object_id
3073: from HZ_RELATIONSHIPS --4500011
3074: where relationship_id = l_merge_to_entity_id
3075: and subject_table_name = 'HZ_PARTIES'
3076: and object_table_name = 'HZ_PARTIES'
3077: and directional_flag = 'F';

Line 3441: FROM HZ_RELATIONSHIPS --4500011

3437: AND nvl(status, 'A') = 'A';
3438:
3439: CURSOR c_branch IS
3440: SELECT 1
3441: FROM HZ_RELATIONSHIPS --4500011
3442: WHERE content_source_type = 'DNB'
3443: AND subject_id = p_from_id
3444: AND object_id = x_to_id
3445: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'

Line 3617: -- Handle DNB data in HZ_RELATIONSHIPS

3613: AND actual_content_source = 'DNB'
3614: AND nvl(status,'A') in ('A','I');
3615:
3616: -- *******************************************
3617: -- Handle DNB data in HZ_RELATIONSHIPS
3618: -- Keep only master party relationships
3619: FOR FROM_REL IN (
3620: SELECT relationship_id, relationship_type, subject_id, party_id, start_date, end_date, relationship_code,
3621: direction_code

Line 3622: FROM HZ_RELATIONSHIPS

3618: -- Keep only master party relationships
3619: FOR FROM_REL IN (
3620: SELECT relationship_id, relationship_type, subject_id, party_id, start_date, end_date, relationship_code,
3621: direction_code
3622: FROM HZ_RELATIONSHIPS
3623: WHERE actual_content_source = 'DNB'
3624: AND nvl(status, 'A') IN ('A','I')
3625: AND object_id = p_from_id
3626: AND (end_date is null OR end_date>SYSDATE)) LOOP

Line 3628: UPDATE HZ_RELATIONSHIPS

3624: AND nvl(status, 'A') IN ('A','I')
3625: AND object_id = p_from_id
3626: AND (end_date is null OR end_date>SYSDATE)) LOOP
3627:
3628: UPDATE HZ_RELATIONSHIPS
3629: SET end_date = TRUNC(SYSDATE-1),
3630: status = 'M',
3631: last_update_date = hz_utility_pub.last_update_date,
3632: last_updated_by = hz_utility_pub.user_id,