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.HZ_MATCH_RULE_53 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2147: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2143: END IF;
2144: IF p_restrict_entity = 'CONTACTS'
2145: THEN
2146: OPEN x_cursor FOR
2147: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2148: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2149: WHERE contains( concat_col, p_contains_str)>0
2150: AND d.search_context_id = p_search_ctx_id
2151: AND( (l_search_merged ='Y' )

Line 2148: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2144: IF p_restrict_entity = 'CONTACTS'
2145: THEN
2146: OPEN x_cursor FOR
2147: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2148: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2149: WHERE contains( concat_col, p_contains_str)>0
2150: AND d.search_context_id = p_search_ctx_id
2151: AND( (l_search_merged ='Y' )
2152: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2159: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2155: END IF;
2156: IF p_restrict_entity = 'PARTY_SITES'
2157: THEN
2158: OPEN x_cursor FOR
2159: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2160: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2161: WHERE contains( concat_col, p_contains_str)>0
2162: AND d.search_context_id = p_search_ctx_id
2163: AND( (l_search_merged ='Y' )

Line 2160: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2156: IF p_restrict_entity = 'PARTY_SITES'
2157: THEN
2158: OPEN x_cursor FOR
2159: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2160: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2161: WHERE contains( concat_col, p_contains_str)>0
2162: AND d.search_context_id = p_search_ctx_id
2163: AND( (l_search_merged ='Y' )
2164: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2176: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2172: hz_utility_v2pub.debug(p_message=>'Single Party Scenario',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2173: END IF;
2174: IF p_search_rel_cpts = 'N' THEN
2175: OPEN x_cursor FOR
2176: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2177: FROM HZ_STAGED_CONTACT_POINTS stage
2178: WHERE contains( concat_col, p_contains_str)>0
2179: AND( (l_search_merged ='Y' )
2180: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2177: FROM HZ_STAGED_CONTACT_POINTS stage

2173: END IF;
2174: IF p_search_rel_cpts = 'N' THEN
2175: OPEN x_cursor FOR
2176: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2177: FROM HZ_STAGED_CONTACT_POINTS stage
2178: WHERE contains( concat_col, p_contains_str)>0
2179: AND( (l_search_merged ='Y' )
2180: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2181: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2185: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2181: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2182: AND stage.party_id = p_party_id;
2183: ELSE
2184: OPEN x_cursor FOR
2185: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2186: FROM HZ_STAGED_CONTACT_POINTS stage
2187: WHERE contains( concat_col, p_contains_str)>0
2188: AND( (l_search_merged ='Y' )
2189: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2186: FROM HZ_STAGED_CONTACT_POINTS stage

2182: AND stage.party_id = p_party_id;
2183: ELSE
2184: OPEN x_cursor FOR
2185: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2186: FROM HZ_STAGED_CONTACT_POINTS stage
2187: WHERE contains( concat_col, p_contains_str)>0
2188: AND( (l_search_merged ='Y' )
2189: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2190: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2193: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID

2189: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2190: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2191: AND stage.party_id = p_party_id
2192: UNION
2193: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
2194: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2195: WHERE contains( concat_col, p_contains_str)>0
2196: AND r.object_id = p_party_id
2197: AND( (l_search_merged ='Y' )

Line 2194: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc

2190: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2191: AND stage.party_id = p_party_id
2192: UNION
2193: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
2194: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2195: WHERE contains( concat_col, p_contains_str)>0
2196: AND r.object_id = p_party_id
2197: AND( (l_search_merged ='Y' )
2198: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2216: FROM HZ_STAGED_CONTACT_POINTS stage

2212: hz_utility_v2pub.debug(p_message=>'Either Search context id is null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2213: END IF;
2214: OPEN x_cursor FOR
2215: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2216: FROM HZ_STAGED_CONTACT_POINTS stage
2217: WHERE contains( concat_col, p_contains_str)>0
2218: AND EXISTS (
2219: SELECT 1 FROM HZ_STAGED_PARTIES p
2220: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2235: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2231: hz_utility_v2pub.debug(p_message=>'Search_context_id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2232: END IF;
2233: IF p_person_api = 'Y' THEN
2234: OPEN x_cursor FOR
2235: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2236: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2237: WHERE contains( concat_col, p_contains_str)>0
2238: AND d.search_context_id = p_search_ctx_id
2239: AND d.party_id = stage.party_id

Line 2236: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2232: END IF;
2233: IF p_person_api = 'Y' THEN
2234: OPEN x_cursor FOR
2235: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2236: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2237: WHERE contains( concat_col, p_contains_str)>0
2238: AND d.search_context_id = p_search_ctx_id
2239: AND d.party_id = stage.party_id
2240: AND( (l_search_merged ='Y' )

Line 2245: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID

2241: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2242: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2243: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2244: UNION
2245: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
2246: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2247: WHERE contains( concat_col, p_contains_str)>0
2248: AND d.search_context_id = p_search_ctx_id
2249: AND d.party_id = r.subject_id

Line 2246: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

2242: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2243: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2244: UNION
2245: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
2246: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2247: WHERE contains( concat_col, p_contains_str)>0
2248: AND d.search_context_id = p_search_ctx_id
2249: AND d.party_id = r.subject_id
2250: AND r.relationship_id = oc.party_relationship_id

Line 2258: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2254: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2255: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2256: ELSE
2257: OPEN x_cursor FOR
2258: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2259: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2260: WHERE contains( concat_col, p_contains_str)>0
2261: AND d.search_context_id = p_search_ctx_id
2262: AND d.party_id = stage.party_id

Line 2259: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2255: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2256: ELSE
2257: OPEN x_cursor FOR
2258: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2259: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2260: WHERE contains( concat_col, p_contains_str)>0
2261: AND d.search_context_id = p_search_ctx_id
2262: AND d.party_id = stage.party_id
2263: AND( (l_search_merged ='Y' )

Line 2279: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) /';

2275: IF (l_check_dt > 0 ) THEN
2276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2277: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective_cpt hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2278: END IF;
2279: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2280: ELSIF (l_check > 0 ) THEN
2281: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2282: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2283: END IF;

Line 2284: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) /';

2280: ELSIF (l_check > 0 ) THEN
2281: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2282: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2283: END IF;
2284: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2285: END IF;
2286: IF l_search_merged = 'Y' THEN
2287: l_status_sql := ' ' ;
2288: ELSIF l_search_merged = 'I' THEN

Line 2303: l_sqlstr := ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||

2299: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2300: ELSE
2301: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2302: END IF;
2303: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2304: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2305: ' WHERE contains( concat_col, :cont)>0 '||
2306: ' AND (stage.org_contact_id is null '||
2307: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2304: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2300: ELSE
2301: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2302: END IF;
2303: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2304: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2305: ' WHERE contains( concat_col, :cont)>0 '||
2306: ' AND (stage.org_contact_id is null '||
2307: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2308: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2313: ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||

2309: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2310: ' AND ('||p_restrict_sql||'))' ||
2311: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2312: ' UNION ' ||
2313: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2315: ' WHERE contains( concat_col, :cont)>0 '||
2316: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2317: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2310: ' AND ('||p_restrict_sql||'))' ||
2311: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2312: ' UNION ' ||
2313: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2315: ' WHERE contains( concat_col, :cont)>0 '||
2316: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2317: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2318: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2329: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2325: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2326: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2327: ELSE
2328: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2329: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2330: ' WHERE contains( concat_col, :cont)>0'||
2331: ' AND EXISTS ('||
2332: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2333: ' WHERE p.party_id = stage.party_id ' ||

Line 2346: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2342: ,p_dup_party_id, p_dup_party_id;
2343: END IF;
2344: ELSE
2345: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2346: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2347: ' WHERE contains( concat_col, :cont)>0'||
2348: ' AND EXISTS ('||
2349: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2350: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_53 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2147: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

Line 2148: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2159: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID