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

Line 435: FROM hz_relationships r -- Bug 4654753

431: -- default contact id based on cust_acct_id and pseudo contact_id
432: CURSOR contact_id_csr(p_cust_account_id in number,
433: p_party_relationship_id in number) is
434: SELECT p.party_id -- ,p.party_name
435: FROM hz_relationships r -- Bug 4654753
436: , hz_parties p
437: , hz_cust_accounts c
438: WHERE r.subject_id = p.party_id
439: AND r.relationship_id = p_party_relationship_id -- Bug 4654753

Line 464: , hz_relationships rel

460: CURSOR contact_party_id_csr (p_contact_id in number) is
461: select p.party_id
462: from hz_parties p
463: , hz_cust_account_roles r
464: , hz_relationships rel
465: where r.cust_account_role_id = p_contact_id
466: and r.party_id = rel.party_id
467: and rel.subject_id = p.party_id
468: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 8385: hz_relationships r,

8381: p_relation_type in varchar2,
8382: p_party_id in number) IS
8383: SELECT count(p.party_id)
8384: FROM hz_parties p,
8385: hz_relationships r,
8386: hz_cust_accounts c
8387: WHERE p.party_id = r.subject_id
8388: AND r.relationship_code = p_relation_type
8389: AND r.object_id = c.party_id