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

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

2011: END IF;
2012: IF p_restrict_entity = 'CONTACTS'
2013: THEN
2014: OPEN x_cursor FOR
2015: 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
2016: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2017: WHERE contains( concat_col, p_contains_str)>0
2018: AND d.search_context_id = p_search_ctx_id
2019: AND( (l_search_merged ='Y' )

Line 2016: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2012: IF p_restrict_entity = 'CONTACTS'
2013: THEN
2014: OPEN x_cursor FOR
2015: 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
2016: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2017: WHERE contains( concat_col, p_contains_str)>0
2018: AND d.search_context_id = p_search_ctx_id
2019: AND( (l_search_merged ='Y' )
2020: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2023: END IF;
2024: IF p_restrict_entity = 'PARTY_SITES'
2025: THEN
2026: OPEN x_cursor FOR
2027: 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
2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2029: WHERE contains( concat_col, p_contains_str)>0
2030: AND d.search_context_id = p_search_ctx_id
2031: AND( (l_search_merged ='Y' )

Line 2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2024: IF p_restrict_entity = 'PARTY_SITES'
2025: THEN
2026: OPEN x_cursor FOR
2027: 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
2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2029: WHERE contains( concat_col, p_contains_str)>0
2030: AND d.search_context_id = p_search_ctx_id
2031: AND( (l_search_merged ='Y' )
2032: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2040: 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);
2041: END IF;
2042: IF p_search_rel_cpts = 'N' THEN
2043: OPEN x_cursor FOR
2044: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2045: FROM HZ_STAGED_CONTACT_POINTS stage
2046: WHERE contains( concat_col, p_contains_str)>0
2047: AND( (l_search_merged ='Y' )
2048: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2045: FROM HZ_STAGED_CONTACT_POINTS stage

2041: END IF;
2042: IF p_search_rel_cpts = 'N' THEN
2043: OPEN x_cursor FOR
2044: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2045: FROM HZ_STAGED_CONTACT_POINTS stage
2046: WHERE contains( concat_col, p_contains_str)>0
2047: AND( (l_search_merged ='Y' )
2048: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2049: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2049: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2050: AND stage.party_id = p_party_id;
2051: ELSE
2052: OPEN x_cursor FOR
2053: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2054: FROM HZ_STAGED_CONTACT_POINTS stage
2055: WHERE contains( concat_col, p_contains_str)>0
2056: AND( (l_search_merged ='Y' )
2057: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2054: FROM HZ_STAGED_CONTACT_POINTS stage

2050: AND stage.party_id = p_party_id;
2051: ELSE
2052: OPEN x_cursor FOR
2053: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2054: FROM HZ_STAGED_CONTACT_POINTS stage
2055: WHERE contains( concat_col, p_contains_str)>0
2056: AND( (l_search_merged ='Y' )
2057: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2058: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2057: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2058: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2059: AND stage.party_id = p_party_id
2060: UNION
2061: 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
2062: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2063: WHERE contains( concat_col, p_contains_str)>0
2064: AND r.object_id = p_party_id
2065: AND( (l_search_merged ='Y' )

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

2058: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2059: AND stage.party_id = p_party_id
2060: UNION
2061: 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
2062: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2063: WHERE contains( concat_col, p_contains_str)>0
2064: AND r.object_id = p_party_id
2065: AND( (l_search_merged ='Y' )
2066: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2084: FROM HZ_STAGED_CONTACT_POINTS stage

2080: 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);
2081: END IF;
2082: OPEN x_cursor FOR
2083: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2084: FROM HZ_STAGED_CONTACT_POINTS stage
2085: WHERE contains( concat_col, p_contains_str)>0
2086: AND EXISTS (
2087: SELECT 1 FROM HZ_STAGED_PARTIES p
2088: WHERE p.PARTY_ID = stage.PARTY_ID

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

2099: 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);
2100: END IF;
2101: IF p_person_api = 'Y' THEN
2102: OPEN x_cursor FOR
2103: 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
2104: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2105: WHERE contains( concat_col, p_contains_str)>0
2106: AND d.search_context_id = p_search_ctx_id
2107: AND d.party_id = stage.party_id

Line 2104: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2100: END IF;
2101: IF p_person_api = 'Y' THEN
2102: OPEN x_cursor FOR
2103: 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
2104: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2105: WHERE contains( concat_col, p_contains_str)>0
2106: AND d.search_context_id = p_search_ctx_id
2107: AND d.party_id = stage.party_id
2108: AND( (l_search_merged ='Y' )

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

2109: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2110: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2111: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2112: UNION
2113: 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
2114: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2115: WHERE contains( concat_col, p_contains_str)>0
2116: AND d.search_context_id = p_search_ctx_id
2117: AND d.party_id = r.subject_id

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

2110: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2111: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2112: UNION
2113: 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
2114: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2115: WHERE contains( concat_col, p_contains_str)>0
2116: AND d.search_context_id = p_search_ctx_id
2117: AND d.party_id = r.subject_id
2118: AND r.relationship_id = oc.party_relationship_id

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

2122: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2123: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2124: ELSE
2125: OPEN x_cursor FOR
2126: 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
2127: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2128: WHERE contains( concat_col, p_contains_str)>0
2129: AND d.search_context_id = p_search_ctx_id
2130: AND d.party_id = stage.party_id

Line 2127: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2123: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2124: ELSE
2125: OPEN x_cursor FOR
2126: 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
2127: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2128: WHERE contains( concat_col, p_contains_str)>0
2129: AND d.search_context_id = p_search_ctx_id
2130: AND d.party_id = stage.party_id
2131: AND( (l_search_merged ='Y' )

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

2143: IF (l_check_dt > 0 ) THEN
2144: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2145: 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);
2146: END IF;
2147: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2148: ELSIF (l_check > 0 ) THEN
2149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2150: 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);
2151: END IF;

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

2148: ELSIF (l_check > 0 ) THEN
2149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2150: 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);
2151: END IF;
2152: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2153: END IF;
2154: IF l_search_merged = 'Y' THEN
2155: l_status_sql := ' ' ;
2156: ELSIF l_search_merged = 'I' THEN

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

2167: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2168: ELSE
2169: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2170: END IF;
2171: 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 '||
2172: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2173: ' WHERE contains( concat_col, :cont)>0 '||
2174: ' AND (stage.org_contact_id is null '||
2175: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2172: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2168: ELSE
2169: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2170: END IF;
2171: 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 '||
2172: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2173: ' WHERE contains( concat_col, :cont)>0 '||
2174: ' AND (stage.org_contact_id is null '||
2175: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2176: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2177: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2178: ' AND ('||p_restrict_sql||'))' ||
2179: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2180: ' UNION ' ||
2181: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2182: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2183: ' WHERE contains( concat_col, :cont)>0 '||
2184: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2185: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2182: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2178: ' AND ('||p_restrict_sql||'))' ||
2179: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2180: ' UNION ' ||
2181: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2182: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2183: ' WHERE contains( concat_col, :cont)>0 '||
2184: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2185: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2186: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2197: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2193: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2194: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2195: ELSE
2196: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2197: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2198: ' WHERE contains( concat_col, :cont)>0'||
2199: ' AND EXISTS ('||
2200: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2201: ' WHERE p.party_id = stage.party_id ' ||

Line 2214: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2210: ,p_dup_party_id, p_dup_party_id;
2211: END IF;
2212: ELSE
2213: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2214: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2215: ' WHERE contains( concat_col, :cont)>0'||
2216: ' AND EXISTS ('||
2217: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2218: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_35 dependencies on HZ_STAGED_CONTACT_POINTS

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

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