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_LOCATIONS

Line 214: hz_locations l

210: l.postal_code,
211: s.identifying_address_flag
212: FROM hz_matched_party_sites_gt gs,
213: hz_party_sites s,
214: hz_locations l
215: WHERE gs.search_context_id = i_ctx_id
216: AND gs.party_id = i_party_id
217: AND NVL(gs.score,0) >= 0
218: AND gs.party_site_id = s.party_site_id

Line 926: hz_locations l

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
929: AND -gs.party_id = p_cust_acct_id
930: AND -gs.party_site_id = a.cust_acct_site_id

Line 951: hz_locations l

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
954: AND -gs.party_id = p_cust_acct_id
955: AND -gs.party_site_id = a.cust_acct_site_id