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.AS_IMPORT_SL_PVT dependencies on HZ_MATCHED_CPTS_GT

Line 3454: -- Cursor for getting matched contact_point from hz_matched_cpts_gt

3450: AND hzmc.org_contact_id = hzoc.org_contact_id
3451: AND nvl(hzoc.status,'A') = 'A' --bug# 3319259
3452: ORDER BY score desc, hzoc.creation_date desc;
3453:
3454: -- Cursor for getting matched contact_point from hz_matched_cpts_gt
3455: CURSOR C_matched_contact_points(cp_type VARCHAR2, p_plt VARCHAR2)
3456: IS
3457: SELECT hzmcp.party_id, hzmcp.contact_point_id, score , hzcp.creation_date
3458: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp

Line 3458: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp

3454: -- Cursor for getting matched contact_point from hz_matched_cpts_gt
3455: CURSOR C_matched_contact_points(cp_type VARCHAR2, p_plt VARCHAR2)
3456: IS
3457: SELECT hzmcp.party_id, hzmcp.contact_point_id, score , hzcp.creation_date
3458: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp
3459: WHERE search_context_id = l_search_context_id
3460: AND hzmcp.contact_point_id = hzcp.contact_point_id
3461: AND hzcp.contact_point_type = cp_type
3462: AND nvl(hzcp.phone_line_type,'xx') = nvl(p_plt,'xx')