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 5967: -- Cursor for getting matched party_site from hz_matched_party_sites_gt

5963: AND hzp.party_id = hzmp.party_id
5964: ORDER BY score desc, hzp.creation_date desc )
5965: WHERE rownum = 1;
5966:
5967: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
5968: CURSOR C_matched_party_sites ( pc_search_id NUMBER)
5969: IS
5970: SELECT hzmps.party_id,
5971: hzmps.party_site_id,

Line 5974: FROM hz_matched_party_sites_gt hzmps,

5970: SELECT hzmps.party_id,
5971: hzmps.party_site_id,
5972: score ,
5973: hzps.creation_date
5974: FROM hz_matched_party_sites_gt hzmps,
5975: hz_party_sites hzps
5976: WHERE search_context_id = pc_search_id
5977: AND hzps.party_site_id = hzmps.party_site_id
5978: AND hzps.party_id = hzmps.party_id