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_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_RELATIONSHIPS

Line 19: from hz_relationships r, hz_org_contacts oc

15: function get_id(p_org_cont_id in number, p_type in varchar2 ) return number is
16:
17: cursor get_cont_info_csr is
18: select r.subject_id, r.party_id
19: from hz_relationships r, hz_org_contacts oc
20: where r.relationship_id = oc.party_relationship_id
21: and oc.org_contact_id = p_org_cont_id
22: and r.subject_type = 'PERSON';
23:

Line 585: FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS R

581: HZ_EMAIL_CP_BO_TBL(),
582: HZ_WEB_CP_BO_TBL(),
583: HZ_SMS_CP_BO_TBL(),
584: HZ_CONTACT_PREF_OBJ_TBL())
585: FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS R
586: WHERE OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
587: AND R.SUBJECT_ID = P.PARTY_ID
588: AND R.OBJECT_TYPE = 'PERSON'
589: AND ((P_ORG_CONTACT_ID IS NULL AND P.PARTY_ID = P_ORGANIZATION_ID)