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

Line 2010: 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 , TX1

2006: END IF;
2007: IF p_restrict_entity = 'CONTACTS'
2008: THEN
2009: OPEN x_cursor FOR
2010: 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 , TX1
2011: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2012: WHERE contains( concat_col, p_contains_str)>0
2013: AND d.search_context_id = p_search_ctx_id
2014: AND( (l_search_merged ='Y' )

Line 2011: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2022: 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 , TX1

2018: END IF;
2019: IF p_restrict_entity = 'PARTY_SITES'
2020: THEN
2021: OPEN x_cursor FOR
2022: 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 , TX1
2023: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2024: WHERE contains( concat_col, p_contains_str)>0
2025: AND d.search_context_id = p_search_ctx_id
2026: AND( (l_search_merged ='Y' )

Line 2023: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 2040: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 2049: FROM HZ_STAGED_CONTACT_POINTS stage

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

Line 2056: 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 , TX1

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

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

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

Line 2079: FROM HZ_STAGED_CONTACT_POINTS stage

2075: 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);
2076: END IF;
2077: OPEN x_cursor FOR
2078: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2079: FROM HZ_STAGED_CONTACT_POINTS stage
2080: WHERE contains( concat_col, p_contains_str)>0
2081: AND EXISTS (
2082: SELECT 1 FROM HZ_STAGED_PARTIES p
2083: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2098: 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 , TX1

2094: 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);
2095: END IF;
2096: IF p_person_api = 'Y' THEN
2097: OPEN x_cursor FOR
2098: 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 , TX1
2099: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2100: WHERE contains( concat_col, p_contains_str)>0
2101: AND d.search_context_id = p_search_ctx_id
2102: AND d.party_id = stage.party_id

Line 2099: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2108: 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 , TX1

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

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

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

Line 2121: 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 , TX1

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

Line 2122: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

2138: IF (l_check_dt > 0 ) THEN
2139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2140: 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);
2141: END IF;
2142: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2143: ELSIF (l_check > 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 hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2146: END IF;

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

2143: ELSIF (l_check > 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 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_N1) */';
2148: END IF;
2149: IF l_search_merged = 'Y' THEN
2150: l_status_sql := ' ' ;
2151: ELSIF l_search_merged = 'I' THEN

Line 2166: 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 , TX1'||

2162: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2163: ELSE
2164: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2165: END IF;
2166: 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 , TX1'||
2167: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2168: ' WHERE contains( concat_col, :cont)>0 '||
2169: ' AND (stage.org_contact_id is null '||
2170: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2167: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

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

2172: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2173: ' AND ('||p_restrict_sql||'))' ||
2174: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2175: ' UNION ' ||
2176: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2177: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2178: ' WHERE contains( concat_col, :cont)>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: ' AND ('||p_restrict_sql||'))' ||
2174: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2175: ' UNION ' ||
2176: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2177: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2178: ' WHERE contains( concat_col, :cont)>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 2192: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2188: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2189: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2190: ELSE
2191: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2192: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2193: ' WHERE contains( concat_col, :cont)>0'||
2194: ' AND EXISTS ('||
2195: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2196: ' WHERE p.party_id = stage.party_id ' ||

Line 2209: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2205: ,p_dup_party_id, p_dup_party_id;
2206: END IF;
2207: ELSE
2208: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2209: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2210: ' WHERE contains( concat_col, :cont)>0'||
2211: ' AND EXISTS ('||
2212: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2213: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_6 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2010: 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 , TX1

Line 2011: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2022: 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 , TX1