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_CUST_ACCT_SITES

Line 924: hz_cust_acct_sites_all a,

920: l.state,
921: l.postal_code,
922: ps.identifying_address_flag
923: FROM hz_matched_party_sites_gt gs,
924: hz_cust_acct_sites_all a,
925: hz_party_sites ps,
926: hz_locations l
927: WHERE gs.search_context_id = p_ctx_id
928: AND gs.score < 0

Line 949: hz_cust_acct_sites a,

945: l.state,
946: l.postal_code,
947: ps.identifying_address_flag
948: FROM hz_matched_party_sites_gt gs,
949: hz_cust_acct_sites a,
950: hz_party_sites ps,
951: hz_locations l
952: WHERE gs.search_context_id = p_ctx_id
953: AND gs.score < 0

Line 1137: hz_cust_acct_sites asite,

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

Line 1169: hz_cust_acct_sites_all asite,

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