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.PVX_PARTY_MERGE_PKG dependencies on HZ_RELATIONSHIPS

Line 182: hz_relationships hzr

178:
179: CURSOR intVendOrg_csr(cv_party_id NUMBER, cv_partner_id NUMBER) IS
180: SELECT hzr.object_id
181: FROM pv_partner_profiles ppp,
182: hz_relationships hzr
183: WHERE ppp.partner_party_id = cv_party_id
184: AND ppp.partner_id = cv_partner_id
185: AND hzr.subject_id = ppp.partner_party_id
186: AND hzr.party_id = ppp.partner_id

Line 280: -- hz_relationships. We don't need any that have been "merged."

276: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
277:
278: -- ------------------------------------------------------------------
279: -- These are the "from" records that are still "active" in
280: -- hz_relationships. We don't need any that have been "merged."
281: -- ------------------------------------------------------------------
282: /* CURSOR c1 IS
283: SELECT DISTINCT a.partner_profile_id, a.partner_party_id, b.party_id partner_id
284: FROM pv_partner_profiles a,

Line 285: hz_relationships b

281: -- ------------------------------------------------------------------
282: /* CURSOR c1 IS
283: SELECT DISTINCT a.partner_profile_id, a.partner_party_id, b.party_id partner_id
284: FROM pv_partner_profiles a,
285: hz_relationships b
286: WHERE a.partner_party_id = p_from_fk_id AND
287: a.partner_id = b.party_id AND
288: b.relationship_code = 'PARTNER_OF' AND
289: b.status = 'A'; */