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

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

1978: END IF;
1979: IF p_restrict_entity = 'CONTACTS'
1980: THEN
1981: OPEN x_cursor FOR
1982: 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
1983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1984: WHERE contains( concat_col, p_contains_str)>0
1985: AND d.search_context_id = p_search_ctx_id
1986: AND( (l_search_merged ='Y' )

Line 1983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1979: IF p_restrict_entity = 'CONTACTS'
1980: THEN
1981: OPEN x_cursor FOR
1982: 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
1983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1984: WHERE contains( concat_col, p_contains_str)>0
1985: AND d.search_context_id = p_search_ctx_id
1986: AND( (l_search_merged ='Y' )
1987: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1990: END IF;
1991: IF p_restrict_entity = 'PARTY_SITES'
1992: THEN
1993: OPEN x_cursor FOR
1994: 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
1995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1996: WHERE contains( concat_col, p_contains_str)>0
1997: AND d.search_context_id = p_search_ctx_id
1998: AND( (l_search_merged ='Y' )

Line 1995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1991: IF p_restrict_entity = 'PARTY_SITES'
1992: THEN
1993: OPEN x_cursor FOR
1994: 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
1995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1996: WHERE contains( concat_col, p_contains_str)>0
1997: AND d.search_context_id = p_search_ctx_id
1998: AND( (l_search_merged ='Y' )
1999: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2007: 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);
2008: END IF;
2009: IF p_search_rel_cpts = 'N' THEN
2010: OPEN x_cursor FOR
2011: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2012: FROM HZ_STAGED_CONTACT_POINTS stage
2013: WHERE contains( concat_col, p_contains_str)>0
2014: AND( (l_search_merged ='Y' )
2015: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2012: FROM HZ_STAGED_CONTACT_POINTS stage

2008: END IF;
2009: IF p_search_rel_cpts = 'N' THEN
2010: OPEN x_cursor FOR
2011: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2012: FROM HZ_STAGED_CONTACT_POINTS stage
2013: WHERE contains( concat_col, p_contains_str)>0
2014: AND( (l_search_merged ='Y' )
2015: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2016: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2016: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2017: AND stage.party_id = p_party_id;
2018: ELSE
2019: OPEN x_cursor FOR
2020: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2021: FROM HZ_STAGED_CONTACT_POINTS stage
2022: WHERE contains( concat_col, p_contains_str)>0
2023: AND( (l_search_merged ='Y' )
2024: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2021: FROM HZ_STAGED_CONTACT_POINTS stage

2017: AND stage.party_id = p_party_id;
2018: ELSE
2019: OPEN x_cursor FOR
2020: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2021: FROM HZ_STAGED_CONTACT_POINTS stage
2022: WHERE contains( concat_col, p_contains_str)>0
2023: AND( (l_search_merged ='Y' )
2024: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2025: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2024: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2025: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2026: AND stage.party_id = p_party_id
2027: UNION
2028: 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
2029: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2030: WHERE contains( concat_col, p_contains_str)>0
2031: AND r.object_id = p_party_id
2032: AND( (l_search_merged ='Y' )

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

2025: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2026: AND stage.party_id = p_party_id
2027: UNION
2028: 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
2029: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2030: WHERE contains( concat_col, p_contains_str)>0
2031: AND r.object_id = p_party_id
2032: AND( (l_search_merged ='Y' )
2033: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2051: FROM HZ_STAGED_CONTACT_POINTS stage

2047: 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);
2048: END IF;
2049: OPEN x_cursor FOR
2050: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2051: FROM HZ_STAGED_CONTACT_POINTS stage
2052: WHERE contains( concat_col, p_contains_str)>0
2053: AND EXISTS (
2054: SELECT 1 FROM HZ_STAGED_PARTIES p
2055: WHERE p.PARTY_ID = stage.PARTY_ID

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

2066: 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);
2067: END IF;
2068: IF p_person_api = 'Y' THEN
2069: OPEN x_cursor FOR
2070: 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
2071: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2072: WHERE contains( concat_col, p_contains_str)>0
2073: AND d.search_context_id = p_search_ctx_id
2074: AND d.party_id = stage.party_id

Line 2071: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2067: END IF;
2068: IF p_person_api = 'Y' THEN
2069: OPEN x_cursor FOR
2070: 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
2071: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2072: WHERE contains( concat_col, p_contains_str)>0
2073: AND d.search_context_id = p_search_ctx_id
2074: AND d.party_id = stage.party_id
2075: AND( (l_search_merged ='Y' )

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

2076: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2077: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2078: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2079: UNION
2080: 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
2081: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2082: WHERE contains( concat_col, p_contains_str)>0
2083: AND d.search_context_id = p_search_ctx_id
2084: AND d.party_id = r.subject_id

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

2077: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2078: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2079: UNION
2080: 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
2081: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2082: WHERE contains( concat_col, p_contains_str)>0
2083: AND d.search_context_id = p_search_ctx_id
2084: AND d.party_id = r.subject_id
2085: AND r.relationship_id = oc.party_relationship_id

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

2089: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2090: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2091: ELSE
2092: OPEN x_cursor FOR
2093: 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
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 d.party_id = stage.party_id

Line 2094: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2090: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2091: ELSE
2092: OPEN x_cursor FOR
2093: 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
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 d.party_id = stage.party_id
2098: AND( (l_search_merged ='Y' )

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

2110: IF (l_check_dt > 0 ) THEN
2111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2112: 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);
2113: END IF;
2114: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2115: ELSIF (l_check > 0 ) THEN
2116: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2117: 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);
2118: END IF;

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

2115: ELSIF (l_check > 0 ) THEN
2116: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2117: 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);
2118: END IF;
2119: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2120: END IF;
2121: IF l_search_merged = 'Y' THEN
2122: l_status_sql := ' ' ;
2123: ELSIF l_search_merged = 'I' THEN

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

2134: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2135: ELSE
2136: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2137: END IF;
2138: 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 '||
2139: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2140: ' WHERE contains( concat_col, :cont)>0 '||
2141: ' AND (stage.org_contact_id is null '||
2142: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2139: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2135: ELSE
2136: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2137: END IF;
2138: 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 '||
2139: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2140: ' WHERE contains( concat_col, :cont)>0 '||
2141: ' AND (stage.org_contact_id is null '||
2142: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2143: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2144: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2145: ' AND ('||p_restrict_sql||'))' ||
2146: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2147: ' UNION ' ||
2148: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2149: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2150: ' WHERE contains( concat_col, :cont)>0 '||
2151: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2152: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2149: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2145: ' AND ('||p_restrict_sql||'))' ||
2146: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2147: ' UNION ' ||
2148: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2149: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2150: ' WHERE contains( concat_col, :cont)>0 '||
2151: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2152: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2153: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2164: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2160: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2161: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2162: ELSE
2163: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2164: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2165: ' WHERE contains( concat_col, :cont)>0'||
2166: ' AND EXISTS ('||
2167: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2168: ' WHERE p.party_id = stage.party_id ' ||

Line 2181: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2177: ,p_dup_party_id, p_dup_party_id;
2178: END IF;
2179: ELSE
2180: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2181: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2182: ' WHERE contains( concat_col, :cont)>0'||
2183: ' AND EXISTS ('||
2184: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2185: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_48 dependencies on HZ_STAGED_CONTACT_POINTS

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

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