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.HZ_DQM_DUP_ID_PKG dependencies on HZ_PARTY_SITES

Line 1372: from hz_imp_dup_details a, hz_party_sites b

1368: where h.batch_id = p_batch_id
1369: and
1370: (
1371: exists (select a.dup_record_id
1372: from hz_imp_dup_details a, hz_party_sites b
1373: where a.party_id = h.party_id
1374: and a.batch_id = p_batch_id
1375: and a.record_id = b.party_site_id
1376: and b.request_id = p_request_id

Line 1424: from hz_imp_dup_details a, hz_party_sites b

1420:
1421: -- Updating counts to Batch Summary
1422: -- Party Site Count
1423: select count(distinct a.dup_record_id) into ps_count
1424: from hz_imp_dup_details a, hz_party_sites b
1425: where a.batch_id = p_batch_id
1426: and a.record_id = b.party_site_id
1427: and b.request_id = p_request_id ;
1428: update hz_imp_batch_summary h