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_CONTACTS_GT

Line 5981: -- Cursor for getting matched contacts from hz_matched_contacts_gt

5977: AND hzps.party_site_id = hzmps.party_site_id
5978: AND hzps.party_id = hzmps.party_id
5979: ORDER BY score desc, hzps.creation_date desc;
5980:
5981: -- Cursor for getting matched contacts from hz_matched_contacts_gt
5982: CURSOR C_matched_contacts ( pc_search_id NUMBER)
5983: IS
5984: SELECT hzmc.party_id,
5985: hzmc.org_contact_id,

Line 5987: FROM hz_matched_contacts_gt hzmc

5983: IS
5984: SELECT hzmc.party_id,
5985: hzmc.org_contact_id,
5986: score
5987: FROM hz_matched_contacts_gt hzmc
5988: WHERE search_context_id = pc_search_id;
5989:
5990:
5991: CURSOR get_match_rule ( pc_rule_name VARCHAR2)