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.

[Home] [Help]

APPS.AS_IMPORT_SL_PVT dependencies on HZ_MATCHED_CPTS_GT

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

3469: AND hzmc.org_contact_id = hzoc.org_contact_id
3470: AND nvl(hzoc.status,'A') = 'A' --bug# 3319259
3471: ORDER BY score desc, hzoc.creation_date desc;
3472:
3473: -- Cursor for getting matched contact_point from hz_matched_cpts_gt
3474: CURSOR C_matched_contact_points(cp_type VARCHAR2, p_plt VARCHAR2)
3475: IS
3476: SELECT hzmcp.party_id, hzmcp.contact_point_id, score , hzcp.creation_date
3477: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp

Line 3477: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp

3473: -- Cursor for getting matched contact_point from hz_matched_cpts_gt
3474: CURSOR C_matched_contact_points(cp_type VARCHAR2, p_plt VARCHAR2)
3475: IS
3476: SELECT hzmcp.party_id, hzmcp.contact_point_id, score , hzcp.creation_date
3477: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp
3478: WHERE search_context_id = l_search_context_id
3479: AND hzmcp.contact_point_id = hzcp.contact_point_id
3480: AND hzcp.contact_point_type = cp_type
3481: AND nvl(hzcp.phone_line_type,'xx') = nvl(p_plt,'xx')