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

Line 731: FROM hz_matched_cpts_gt a,

727: RETURN VARCHAR2
728: IS
729: CURSOR c1 IS
730: SELECT 'Y'
731: FROM hz_matched_cpts_gt a,
732: hz_contact_points b
733: WHERE a.search_context_id = p_ctx_id
734: AND a.contact_point_id = b.contact_point_id
735: AND b.owner_table_name = 'HZ_PARTY_SITES'

Line 854: FROM hz_matched_cpts_gt

850: AND party_id = p_party_id;
851: /*
852: CURSOR c3 IS
853: SELECT 'Y'
854: FROM hz_matched_cpts_gt
855: WHERE search_context_id = p_ctx_id
856: AND NVL(score,0) >= 0
857: AND party_id = p_party_id;
858: */

Line 891: FROM hz_matched_cpts_gt a,

887: RETURN VARCHAR2
888: IS
889: CURSOR c1 IS
890: SELECT 'Y'
891: FROM hz_matched_cpts_gt a,
892: hz_contact_points b
893: WHERE a.search_context_id = p_ctx_id
894: AND a.contact_point_id = b.contact_point_id
895: AND b.owner_table_name = 'HZ_PARTIES'