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_ORG_CONTACTS

Line 304: hz_org_contacts o,

300: p.party_id person_id,
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

Line 379: hz_org_contacts c,

375: p.party_id person_id,
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

Line 1048: hz_org_contacts o

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
1050: and a.score < 0
1051: and -a.party_id = i_cust_acct_id
1052: and -a.org_contact_id = ro.cust_account_role_id

Line 1138: hz_org_contacts o

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
1139: WHERE gc.search_context_id = i_ctx_id
1140: AND gc.score < 0
1141: AND -gc.party_id = i_cust_acct_id
1142: AND -gc.org_contact_id = ro.cust_account_role_id

Line 1170: hz_org_contacts o

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
1171: WHERE gc.search_context_id = i_ctx_id
1172: AND gc.score < 0
1173: AND -gc.party_id = i_cust_acct_id
1174: AND -gc.org_contact_id = ro.cust_account_role_id