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.ARH_DQM_TREE dependencies on HZ_RELATIONSHIPS

Line 305: hz_relationships r,

301: p.party_name,
302: p.party_number
303: from hz_matched_contacts_gt a,
304: hz_org_contacts o,
305: hz_relationships r,
306: hz_parties p
307: where a.search_context_id = i_ctx_id
308: and a.party_id = i_party_id
309: and a.org_contact_id = o.org_contact_id

Line 380: hz_relationships r,

376: r.party_id rel_pty_id,
377: r.relationship_code rel_code
378: FROM hz_matched_contacts_gt gc,
379: hz_org_contacts c,
380: hz_relationships r,
381: hz_parties p
382: WHERE gc.search_context_id = i_ctx_id
383: AND gc.party_id = i_party_id
384: AND gc.org_contact_id = c.org_contact_id

Line 1045: hz_relationships r,

1041: p.party_name,
1042: p.party_number,
1043: o.org_contact_id
1044: from hz_matched_contacts_gt a,
1045: hz_relationships r,
1046: hz_parties p,
1047: hz_cust_account_roles ro,
1048: hz_org_contacts o
1049: where a.search_context_id = i_ctx_id

Line 1134: hz_relationships r,

1130: r.party_id rel_pty_id,
1131: r.relationship_code rel_code ,
1132: o.org_contact_id
1133: FROM hz_matched_contacts_gt gc,
1134: hz_relationships r,
1135: hz_parties p,
1136: hz_cust_account_roles ro,
1137: hz_cust_acct_sites asite,
1138: hz_org_contacts o

Line 1166: hz_relationships r,

1162: r.party_id rel_pty_id,
1163: r.relationship_code rel_code ,
1164: o.org_contact_id
1165: FROM hz_matched_contacts_gt gc,
1166: hz_relationships r,
1167: hz_parties p,
1168: hz_cust_account_roles ro,
1169: hz_cust_acct_sites_all asite,
1170: hz_org_contacts o