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_UTIL dependencies on HZ_PARTIES

Line 94: AND subject_table_name = 'HZ_PARTIES'

90: WHERE (subject_id = p_from_party_id
91: OR object_id = p_from_party_id)
92: AND nvl(status, 'A') IN ('A','I')
93: AND directional_flag = 'F'
94: AND subject_table_name = 'HZ_PARTIES'
95: AND object_table_name = 'HZ_PARTIES'
96: AND actual_content_source <> 'DNB';
97:
98: CURSOR c_dup_sub_reln(

Line 95: AND object_table_name = 'HZ_PARTIES'

91: OR object_id = p_from_party_id)
92: AND nvl(status, 'A') IN ('A','I')
93: AND directional_flag = 'F'
94: AND subject_table_name = 'HZ_PARTIES'
95: AND object_table_name = 'HZ_PARTIES'
96: AND actual_content_source <> 'DNB';
97:
98: CURSOR c_dup_sub_reln(
99: cp_party_rel_code VARCHAR2, cp_obj_id NUMBER,

Line 118: AND subject_table_name = 'HZ_PARTIES'

114: AND ((start_date between from_start_date and from_end_date)
115: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
116: or(start_datefrom_end_date))
117: AND nvl(status, 'A') IN ('A','I')
118: AND subject_table_name = 'HZ_PARTIES'
119: AND object_table_name = 'HZ_PARTIES'
120: AND actual_content_source <> 'DNB';
121:
122: --bug 4867151 start

Line 119: AND object_table_name = 'HZ_PARTIES'

115: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
116: or(start_datefrom_end_date))
117: AND nvl(status, 'A') IN ('A','I')
118: AND subject_table_name = 'HZ_PARTIES'
119: AND object_table_name = 'HZ_PARTIES'
120: AND actual_content_source <> 'DNB';
121:
122: --bug 4867151 start
123: CURSOR c_self_reln(rel_id NUMBER, bat_id NUMBER, to_id NUMBER) IS

Line 139: AND subject_table_name = 'HZ_PARTIES'

135: WHERE object_id = p_to_party_id
136: AND subject_id = cp_subj_id
137: AND relationship_code = cp_party_relationship_type
138: AND directional_flag = 'F'
139: AND subject_table_name = 'HZ_PARTIES'
140: AND object_table_name = 'HZ_PARTIES'
141: AND nvl(status, 'A') = 'A';
142: */
143:

Line 140: AND object_table_name = 'HZ_PARTIES'

136: AND subject_id = cp_subj_id
137: AND relationship_code = cp_party_relationship_type
138: AND directional_flag = 'F'
139: AND subject_table_name = 'HZ_PARTIES'
140: AND object_table_name = 'HZ_PARTIES'
141: AND nvl(status, 'A') = 'A';
142: */
143:
144: l_pr_id NUMBER;

Line 291: FROM HZ_RELATIONSHIPS pr, HZ_PARTIES p1, --4500011

287: RETURN VARCHAR2 IS
288:
289: CURSOR c_get_desc IS
290: SELECT '"'||p1.party_name || '"->"' || p2.party_name||'"'
291: FROM HZ_RELATIONSHIPS pr, HZ_PARTIES p1, --4500011
292: HZ_PARTIES p2
293: WHERE p1.party_id = pr.object_id
294: AND p2.party_id = pr.subject_id
295: AND pr.relationship_id = p_party_reln_id

Line 292: HZ_PARTIES p2

288:
289: CURSOR c_get_desc IS
290: SELECT '"'||p1.party_name || '"->"' || p2.party_name||'"'
291: FROM HZ_RELATIONSHIPS pr, HZ_PARTIES p1, --4500011
292: HZ_PARTIES p2
293: WHERE p1.party_id = pr.object_id
294: AND p2.party_id = pr.subject_id
295: AND pr.relationship_id = p_party_reln_id
296: AND pr.subject_table_name = 'HZ_PARTIES'

Line 296: AND pr.subject_table_name = 'HZ_PARTIES'

292: HZ_PARTIES p2
293: WHERE p1.party_id = pr.object_id
294: AND p2.party_id = pr.subject_id
295: AND pr.relationship_id = p_party_reln_id
296: AND pr.subject_table_name = 'HZ_PARTIES'
297: AND pr.object_table_name = 'HZ_PARTIES'
298: AND pr.directional_flag = 'F';
299:
300: l_pr_desc VARCHAR2(2000);

Line 297: AND pr.object_table_name = 'HZ_PARTIES'

293: WHERE p1.party_id = pr.object_id
294: AND p2.party_id = pr.subject_id
295: AND pr.relationship_id = p_party_reln_id
296: AND pr.subject_table_name = 'HZ_PARTIES'
297: AND pr.object_table_name = 'HZ_PARTIES'
298: AND pr.directional_flag = 'F';
299:
300: l_pr_desc VARCHAR2(2000);
301:

Line 326: HZ_PARTIES p1

322:
323: CURSOR c_get_desc IS
324: SELECT p1.party_name
325: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc, --4500011
326: HZ_PARTIES p1
327: WHERE p1.party_id = pr.subject_id
328: AND oc.party_relationship_id = pr.relationship_id
329: AND oc.org_contact_id = p_org_contact_id
330: AND pr.subject_table_name = 'HZ_PARTIES'

Line 330: AND pr.subject_table_name = 'HZ_PARTIES'

326: HZ_PARTIES p1
327: WHERE p1.party_id = pr.subject_id
328: AND oc.party_relationship_id = pr.relationship_id
329: AND oc.org_contact_id = p_org_contact_id
330: AND pr.subject_table_name = 'HZ_PARTIES'
331: AND pr.object_table_name = 'HZ_PARTIES'
332: AND pr.directional_flag = 'F';
333:
334: l_oc_desc VARCHAR2(2000);

Line 331: AND pr.object_table_name = 'HZ_PARTIES'

327: WHERE p1.party_id = pr.subject_id
328: AND oc.party_relationship_id = pr.relationship_id
329: AND oc.org_contact_id = p_org_contact_id
330: AND pr.subject_table_name = 'HZ_PARTIES'
331: AND pr.object_table_name = 'HZ_PARTIES'
332: AND pr.directional_flag = 'F';
333:
334: l_oc_desc VARCHAR2(2000);
335:

Line 384: AND subject_table_name = 'HZ_PARTIES'

380: CURSOR reln_party IS
381: SELECT party_id
382: FROM hz_relationships --4500011
383: WHERE relationship_id = p_party_relationship_id
384: AND subject_table_name = 'HZ_PARTIES'
385: AND object_table_name = 'HZ_PARTIES'
386: AND directional_flag = 'F';
387:
388: l_party_id NUMBER;

Line 385: AND object_table_name = 'HZ_PARTIES'

381: SELECT party_id
382: FROM hz_relationships --4500011
383: WHERE relationship_id = p_party_relationship_id
384: AND subject_table_name = 'HZ_PARTIES'
385: AND object_table_name = 'HZ_PARTIES'
386: AND directional_flag = 'F';
387:
388: l_party_id NUMBER;
389: