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_RELATIONSHIPS

Line 89: FROM HZ_RELATIONSHIPS r

85:
86: CURSOR c_from_reln(l_batch_id NUMBER) IS
87: SELECT relationship_id, subject_id, object_id,
88: relationship_code, actual_content_source, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
89: FROM HZ_RELATIONSHIPS r
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'

Line 103: FROM HZ_RELATIONSHIPS

99: cp_party_rel_code VARCHAR2, cp_obj_id NUMBER,
100: cp_subj_id NUMBER, from_start_date date, from_end_date date,p_self_rel varchar2) --Bug No: 4609894
101: IS
102: SELECT relationship_id, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
103: FROM HZ_RELATIONSHIPS
104: WHERE ( (subject_id = cp_subj_id AND object_id = cp_obj_id)
105: OR (p_self_rel ='Y' and ( (subject_id = cp_subj_id AND object_id = cp_subj_id) -- (in case of P1-Supplier-P1 ,P2-Supplier-P2 and Merge P1 into P2)
106: OR (object_id = cp_subj_id AND subject_id = cp_obj_id) -- (in case of P1-Supplier-P1(Forward) , P2-Customer-P1(Forward) and Merge P1 into P2)
107: OR (subject_id = cp_subj_id AND object_id = p_from_party_id ) -- (in case of P1-Supplier-P2 ,P2-Supplier-P1 and Merge P1 into P2)

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

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
124: select 'Y' from hz_relationships where relationship_id=rel_id
125: and (subject_id IN (p_from_party_id,p_to_party_id))
126: and (object_id IN (p_from_party_id,p_to_party_id))
127: AND directional_flag='F';
128: --bug 4867151 end

Line 134: FROM HZ_RELATIONSHIPS

130:
131: /* Commented out for BugNo:2940087 */
132: /*CURSOR c_dup_ob_reln(cp_party_relationship_type VARCHAR2, cp_subj_id NUMBER) IS
133: SELECT relationship_id
134: FROM HZ_RELATIONSHIPS
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'

Line 146: l_dup_start_date HZ_RELATIONSHIPS.start_date%TYPE;

142: */
143:
144: l_pr_id NUMBER;
145: l_dup_pr_id NUMBER;
146: l_dup_start_date HZ_RELATIONSHIPS.start_date%TYPE;
147: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;
148:
149: l_subj_id NUMBER;
150: l_obj_id NUMBER;

Line 147: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;

143:
144: l_pr_id NUMBER;
145: l_dup_pr_id NUMBER;
146: l_dup_start_date HZ_RELATIONSHIPS.start_date%TYPE;
147: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;
148:
149: l_subj_id NUMBER;
150: l_obj_id NUMBER;
151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;

Line 151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;

147: l_dup_end_date HZ_RELATIONSHIPS.end_date%TYPE;
148:
149: l_subj_id NUMBER;
150: l_obj_id NUMBER;
151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
152: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
153: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
154: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
155: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;

Line 152: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;

148:
149: l_subj_id NUMBER;
150: l_obj_id NUMBER;
151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
152: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
153: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
154: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
155: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
156:

Line 153: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;

149: l_subj_id NUMBER;
150: l_obj_id NUMBER;
151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
152: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
153: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
154: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
155: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
156:
157: l_batch_id NUMBER;

Line 154: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;

150: l_obj_id NUMBER;
151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
152: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
153: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
154: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
155: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
156:
157: l_batch_id NUMBER;
158: l_batch_party_id NUMBER;

Line 155: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;

151: l_reltype HZ_RELATIONSHIPS.relationship_code%TYPE;
152: l_relcode HZ_RELATIONSHIPS.relationship_code%TYPE;
153: l_contype HZ_RELATIONSHIPS.actual_content_source%TYPE;
154: l_start_date HZ_RELATIONSHIPS.start_date%TYPE;
155: l_end_date HZ_RELATIONSHIPS.end_date%TYPE;
156:
157: l_batch_id NUMBER;
158: l_batch_party_id NUMBER;
159: l_mandatory_merge VARCHAR2(1);

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 325: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc, --4500011

321: RETURN VARCHAR2 IS
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

Line 382: FROM hz_relationships --4500011

378: RETURN NUMBER IS
379:
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';