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.OZF_PRE_PROCESS_PVT dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 6420: -- Cursor for getting matched party_site from hz_matched_party_sites_gt

6416: AND hzp.party_id = hzmp.party_id
6417: ORDER BY score desc, hzp.creation_date desc )
6418: WHERE rownum = 1;
6419:
6420: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
6421: CURSOR C_matched_party_sites ( pc_search_id NUMBER)
6422: IS
6423: SELECT hzmps.party_id,
6424: hzmps.party_site_id,

Line 6427: FROM hz_matched_party_sites_gt hzmps,

6423: SELECT hzmps.party_id,
6424: hzmps.party_site_id,
6425: score ,
6426: hzps.creation_date
6427: FROM hz_matched_party_sites_gt hzmps,
6428: hz_party_sites hzps
6429: WHERE search_context_id = pc_search_id
6430: AND hzps.party_site_id = hzmps.party_site_id
6431: AND hzps.party_id = hzmps.party_id