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_ORG_CONTACT_ROLES

Line 2028: --//Table hz_org_contact_roles

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'
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

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';

Line 2081: elsif p_owner_table_name = 'HZ_ORG_CONTACT_ROLES' then

2077: open c_org_cont_id;
2078: fetch c_org_cont_id into x_party_id;
2079: close c_org_cont_id;
2080:
2081: elsif p_owner_table_name = 'HZ_ORG_CONTACT_ROLES' then
2082: open c_org_cont_role_id;
2083: fetch c_org_cont_role_id into x_party_id;
2084: close c_org_cont_role_id;
2085: