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

Line 549: FROM HZ_RELATIONSHIPS

545: BEGIN
546:
547: SELECT OBJECT_ID
548: INTO l_object_id
549: FROM HZ_RELATIONSHIPS
550: WHERE RELATIONSHIP_ID = p_org_contact_rec.party_rel_rec.relationship_id
551: AND DIRECTIONAL_FLAG = 'F';
552:
553:

Line 612: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C

608: THEN
609: BEGIN
610: SELECT P.PERSON_PRE_NAME_ADJUNCT,P.PARTY_ID INTO
611: l_person_pre_name,l_party_id
612: FROM HZ_PARTIES P, HZ_RELATIONSHIPS R, HZ_ORG_CONTACTS C
613: WHERE
614: C.ORG_CONTACT_ID = p_org_contact_rec.org_contact_id
615: AND R.RELATIONSHIP_ID = C.PARTY_RELATIONSHIP_ID
616: AND R.DIRECTIONAL_FLAG = 'F'

Line 724: FROM HZ_RELATIONSHIPS

720: BEGIN
721: SELECT SUBJECT_ID,OBJECT_ID
722: INTO p_org_contact_rec.party_rel_rec.object_id,
723: p_org_contact_rec.party_rel_rec.subject_id
724: FROM HZ_RELATIONSHIPS
725: WHERE RELATIONSHIP_ID = p_org_contact_rec.party_rel_rec.relationship_id
726: AND DIRECTIONAL_FLAG = 'F';
727:
728: EXCEPTION