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_PARTY_SITES

Line 213: hz_party_sites s,

209: l.state,
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

Line 560: AND ctpt.owner_table_name = 'HZ_PARTY_SITES'

556: hz_contact_points ctpt
557: WHERE gcpt.search_context_id = i_ctx_id
558: AND gcpt.party_id = i_party_id
559: AND NVL(gcpt.score,0) >= 0
560: AND ctpt.owner_table_name = 'HZ_PARTY_SITES'
561: AND ctpt.owner_table_id = i_pty_site_id
562: AND gcpt.contact_point_id = ctpt.contact_point_id;
563: -- AND DECODE(i_status, 'ALL', 'ALL', NVL(ctpt.status,'A')) = i_status;
564: l_rec c1%ROWTYPE;

Line 925: hz_party_sites ps,

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

Line 950: hz_party_sites ps,

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