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

Line 883: FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps

879: ,ps.PERSON_TITLE
880: ,ps.PLACE_OF_BIRTH
881: ,ps.TAX_NAME
882: ,ps.TAX_REFERENCE
883: FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps
884: WHERE o.party_relationship_id = pr.relationship_id
885: AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
886: AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
887: AND pr.DIRECTIONAL_FLAG = 'F'

Line 1454: from HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_parties p

1450: RETURN VARCHAR2 IS
1451:
1452: CURSOR cname IS
1453: select party_name
1454: from HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_parties p
1455: WHERE o.party_relationship_id = pr.relationship_id
1456: AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1457: AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1458: AND pr.DIRECTIONAL_FLAG = 'F'