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_36 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2081: 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

2077: END IF;
2078: IF p_restrict_entity = 'CONTACTS'
2079: THEN
2080: OPEN x_cursor FOR
2081: 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
2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2083: WHERE contains( concat_col, p_contains_str)>0
2084: AND d.search_context_id = p_search_ctx_id
2085: AND( (l_search_merged ='Y' )

Line 2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2078: IF p_restrict_entity = 'CONTACTS'
2079: THEN
2080: OPEN x_cursor FOR
2081: 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
2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2083: WHERE contains( concat_col, p_contains_str)>0
2084: AND d.search_context_id = p_search_ctx_id
2085: AND( (l_search_merged ='Y' )
2086: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2093: 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

2089: END IF;
2090: IF p_restrict_entity = 'PARTY_SITES'
2091: THEN
2092: OPEN x_cursor FOR
2093: 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
2094: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2095: WHERE contains( concat_col, p_contains_str)>0
2096: AND d.search_context_id = p_search_ctx_id
2097: AND( (l_search_merged ='Y' )

Line 2094: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2090: IF p_restrict_entity = 'PARTY_SITES'
2091: THEN
2092: OPEN x_cursor FOR
2093: 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
2094: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2095: WHERE contains( concat_col, p_contains_str)>0
2096: AND d.search_context_id = p_search_ctx_id
2097: AND( (l_search_merged ='Y' )
2098: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2106: 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);
2107: END IF;
2108: IF p_search_rel_cpts = 'N' THEN
2109: OPEN x_cursor FOR
2110: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2111: FROM HZ_STAGED_CONTACT_POINTS stage
2112: WHERE contains( concat_col, p_contains_str)>0
2113: AND( (l_search_merged ='Y' )
2114: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2111: FROM HZ_STAGED_CONTACT_POINTS stage

2107: END IF;
2108: IF p_search_rel_cpts = 'N' THEN
2109: OPEN x_cursor FOR
2110: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2111: FROM HZ_STAGED_CONTACT_POINTS stage
2112: WHERE contains( concat_col, p_contains_str)>0
2113: AND( (l_search_merged ='Y' )
2114: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2115: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2115: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2116: AND stage.party_id = p_party_id;
2117: ELSE
2118: OPEN x_cursor FOR
2119: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2120: FROM HZ_STAGED_CONTACT_POINTS stage
2121: WHERE contains( concat_col, p_contains_str)>0
2122: AND( (l_search_merged ='Y' )
2123: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2120: FROM HZ_STAGED_CONTACT_POINTS stage

2116: AND stage.party_id = p_party_id;
2117: ELSE
2118: OPEN x_cursor FOR
2119: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2120: FROM HZ_STAGED_CONTACT_POINTS stage
2121: WHERE contains( concat_col, p_contains_str)>0
2122: AND( (l_search_merged ='Y' )
2123: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2124: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2127: 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

2123: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2124: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2125: AND stage.party_id = p_party_id
2126: UNION
2127: 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
2128: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2129: WHERE contains( concat_col, p_contains_str)>0
2130: AND r.object_id = p_party_id
2131: AND( (l_search_merged ='Y' )

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

2124: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2125: AND stage.party_id = p_party_id
2126: UNION
2127: 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
2128: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2129: WHERE contains( concat_col, p_contains_str)>0
2130: AND r.object_id = p_party_id
2131: AND( (l_search_merged ='Y' )
2132: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2150: FROM HZ_STAGED_CONTACT_POINTS stage

2146: 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);
2147: END IF;
2148: OPEN x_cursor FOR
2149: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2150: FROM HZ_STAGED_CONTACT_POINTS stage
2151: WHERE contains( concat_col, p_contains_str)>0
2152: AND EXISTS (
2153: SELECT 1 FROM HZ_STAGED_PARTIES p
2154: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2169: 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

2165: 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);
2166: END IF;
2167: IF p_person_api = 'Y' THEN
2168: OPEN x_cursor FOR
2169: 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
2170: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2171: WHERE contains( concat_col, p_contains_str)>0
2172: AND d.search_context_id = p_search_ctx_id
2173: AND d.party_id = stage.party_id

Line 2170: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2166: END IF;
2167: IF p_person_api = 'Y' THEN
2168: OPEN x_cursor FOR
2169: 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
2170: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2171: WHERE contains( concat_col, p_contains_str)>0
2172: AND d.search_context_id = p_search_ctx_id
2173: AND d.party_id = stage.party_id
2174: AND( (l_search_merged ='Y' )

Line 2179: 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

2175: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2176: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2177: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2178: UNION
2179: 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
2180: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2181: WHERE contains( concat_col, p_contains_str)>0
2182: AND d.search_context_id = p_search_ctx_id
2183: AND d.party_id = r.subject_id

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

2176: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2177: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2178: UNION
2179: 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
2180: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2181: WHERE contains( concat_col, p_contains_str)>0
2182: AND d.search_context_id = p_search_ctx_id
2183: AND d.party_id = r.subject_id
2184: AND r.relationship_id = oc.party_relationship_id

Line 2192: 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

2188: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2189: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2190: ELSE
2191: OPEN x_cursor FOR
2192: 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
2193: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2194: WHERE contains( concat_col, p_contains_str)>0
2195: AND d.search_context_id = p_search_ctx_id
2196: AND d.party_id = stage.party_id

Line 2193: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2189: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2190: ELSE
2191: OPEN x_cursor FOR
2192: 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
2193: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2194: WHERE contains( concat_col, p_contains_str)>0
2195: AND d.search_context_id = p_search_ctx_id
2196: AND d.party_id = stage.party_id
2197: AND( (l_search_merged ='Y' )

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

2209: IF (l_check_dt > 0 ) THEN
2210: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2211: 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);
2212: END IF;
2213: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2214: ELSIF (l_check > 0 ) THEN
2215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2216: 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);
2217: END IF;

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

2214: ELSIF (l_check > 0 ) THEN
2215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2216: 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);
2217: END IF;
2218: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2219: END IF;
2220: IF l_search_merged = 'Y' THEN
2221: l_status_sql := ' ' ;
2222: ELSIF l_search_merged = 'I' THEN

Line 2237: 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 '||

2233: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2234: ELSE
2235: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2236: END IF;
2237: 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 '||
2238: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2239: ' WHERE contains( concat_col, :cont)>0 '||
2240: ' AND (stage.org_contact_id is null '||
2241: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2238: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2234: ELSE
2235: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2236: END IF;
2237: 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 '||
2238: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2239: ' WHERE contains( concat_col, :cont)>0 '||
2240: ' AND (stage.org_contact_id is null '||
2241: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2242: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2243: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2244: ' AND ('||p_restrict_sql||'))' ||
2245: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2246: ' UNION ' ||
2247: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2248: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2249: ' WHERE contains( concat_col, :cont)>0 '||
2250: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2251: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2248: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2244: ' AND ('||p_restrict_sql||'))' ||
2245: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2246: ' UNION ' ||
2247: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2248: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2249: ' WHERE contains( concat_col, :cont)>0 '||
2250: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2251: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2252: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2263: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2259: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2260: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2261: ELSE
2262: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2263: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2264: ' WHERE contains( concat_col, :cont)>0'||
2265: ' AND EXISTS ('||
2266: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2267: ' WHERE p.party_id = stage.party_id ' ||

Line 2280: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2276: ,p_dup_party_id, p_dup_party_id;
2277: END IF;
2278: ELSE
2279: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2280: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2281: ' WHERE contains( concat_col, :cont)>0'||
2282: ' AND EXISTS ('||
2283: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2284: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_36 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2081: 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 2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2093: 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