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_MATCHED_CONTACTS_GT

Line 303: from hz_matched_contacts_gt a,

299: r.relationship_code rel_code,
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

Line 378: FROM hz_matched_contacts_gt gc,

374: p.party_number ,
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

Line 1044: from hz_matched_contacts_gt a,

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

Line 1133: FROM hz_matched_contacts_gt gc,

1129: ro.cust_account_role_id ,
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,

Line 1165: FROM hz_matched_contacts_gt gc,

1161: ro.cust_account_role_id ,
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,