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

Line 2022: from hz_org_contacts org ,hz_relationships rel

2018:
2019: --//Table hz_org_contacts
2020: cursor c_org_cont_id is
2021: select rel.object_id
2022: from hz_org_contacts org ,hz_relationships rel
2023: where org.org_contact_id = p_owner_table_id
2024: and org.party_relationship_id = rel.relationship_id
2025: and rel.directional_flag = 'F';
2026: --and org.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'

Line 2031: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel

2027:
2028: --//Table hz_org_contact_roles
2029: cursor c_org_cont_role_id is
2030: select rel.object_id
2031: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel
2032: where roles.org_contact_role_id = p_owner_table_id
2033: and roles.org_contact_id = org.org_contact_id
2034: and org.party_relationship_id = rel.relationship_id
2035: and rel.directional_flag = 'F';