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

Line 2132: 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, TX6, TX5

2128: END IF;
2129: IF p_restrict_entity = 'CONTACTS'
2130: THEN
2131: OPEN x_cursor FOR
2132: 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, TX6, TX5
2133: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2134: WHERE contains( concat_col, p_contains_str)>0
2135: AND d.search_context_id = p_search_ctx_id
2136: AND( (l_search_merged ='Y' )

Line 2133: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2129: IF p_restrict_entity = 'CONTACTS'
2130: THEN
2131: OPEN x_cursor FOR
2132: 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, TX6, TX5
2133: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2134: WHERE contains( concat_col, p_contains_str)>0
2135: AND d.search_context_id = p_search_ctx_id
2136: AND( (l_search_merged ='Y' )
2137: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2144: 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, TX6, TX5

2140: END IF;
2141: IF p_restrict_entity = 'PARTY_SITES'
2142: THEN
2143: OPEN x_cursor FOR
2144: 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, TX6, TX5
2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2146: WHERE contains( concat_col, p_contains_str)>0
2147: AND d.search_context_id = p_search_ctx_id
2148: AND( (l_search_merged ='Y' )

Line 2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2141: IF p_restrict_entity = 'PARTY_SITES'
2142: THEN
2143: OPEN x_cursor FOR
2144: 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, TX6, TX5
2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2146: WHERE contains( concat_col, p_contains_str)>0
2147: AND d.search_context_id = p_search_ctx_id
2148: AND( (l_search_merged ='Y' )
2149: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2157: 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);
2158: END IF;
2159: IF p_search_rel_cpts = 'N' THEN
2160: OPEN x_cursor FOR
2161: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2162: FROM HZ_STAGED_CONTACT_POINTS stage
2163: WHERE contains( concat_col, p_contains_str)>0
2164: AND( (l_search_merged ='Y' )
2165: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2162: FROM HZ_STAGED_CONTACT_POINTS stage

2158: END IF;
2159: IF p_search_rel_cpts = 'N' THEN
2160: OPEN x_cursor FOR
2161: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2162: FROM HZ_STAGED_CONTACT_POINTS stage
2163: WHERE contains( concat_col, p_contains_str)>0
2164: AND( (l_search_merged ='Y' )
2165: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2166: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2166: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2167: AND stage.party_id = p_party_id;
2168: ELSE
2169: OPEN x_cursor FOR
2170: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2171: FROM HZ_STAGED_CONTACT_POINTS stage
2172: WHERE contains( concat_col, p_contains_str)>0
2173: AND( (l_search_merged ='Y' )
2174: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2171: FROM HZ_STAGED_CONTACT_POINTS stage

2167: AND stage.party_id = p_party_id;
2168: ELSE
2169: OPEN x_cursor FOR
2170: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2171: FROM HZ_STAGED_CONTACT_POINTS stage
2172: WHERE contains( concat_col, p_contains_str)>0
2173: AND( (l_search_merged ='Y' )
2174: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2175: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2178: 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, TX6, TX5

2174: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2175: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2176: AND stage.party_id = p_party_id
2177: UNION
2178: 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, TX6, TX5
2179: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2180: WHERE contains( concat_col, p_contains_str)>0
2181: AND r.object_id = p_party_id
2182: AND( (l_search_merged ='Y' )

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

2175: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2176: AND stage.party_id = p_party_id
2177: UNION
2178: 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, TX6, TX5
2179: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2180: WHERE contains( concat_col, p_contains_str)>0
2181: AND r.object_id = p_party_id
2182: AND( (l_search_merged ='Y' )
2183: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2201: FROM HZ_STAGED_CONTACT_POINTS stage

2197: 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);
2198: END IF;
2199: OPEN x_cursor FOR
2200: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2201: FROM HZ_STAGED_CONTACT_POINTS stage
2202: WHERE contains( concat_col, p_contains_str)>0
2203: AND EXISTS (
2204: SELECT 1 FROM HZ_STAGED_PARTIES p
2205: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2220: 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, TX6, TX5

2216: 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);
2217: END IF;
2218: IF p_person_api = 'Y' THEN
2219: OPEN x_cursor FOR
2220: 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, TX6, TX5
2221: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2222: WHERE contains( concat_col, p_contains_str)>0
2223: AND d.search_context_id = p_search_ctx_id
2224: AND d.party_id = stage.party_id

Line 2221: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2217: END IF;
2218: IF p_person_api = 'Y' THEN
2219: OPEN x_cursor FOR
2220: 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, TX6, TX5
2221: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2222: WHERE contains( concat_col, p_contains_str)>0
2223: AND d.search_context_id = p_search_ctx_id
2224: AND d.party_id = stage.party_id
2225: AND( (l_search_merged ='Y' )

Line 2230: 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, TX6, TX5

2226: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2227: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2228: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2229: UNION
2230: 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, TX6, TX5
2231: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2232: WHERE contains( concat_col, p_contains_str)>0
2233: AND d.search_context_id = p_search_ctx_id
2234: AND d.party_id = r.subject_id

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

2227: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2228: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2229: UNION
2230: 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, TX6, TX5
2231: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2232: WHERE contains( concat_col, p_contains_str)>0
2233: AND d.search_context_id = p_search_ctx_id
2234: AND d.party_id = r.subject_id
2235: AND r.relationship_id = oc.party_relationship_id

Line 2243: 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, TX6, TX5

2239: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2240: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2241: ELSE
2242: OPEN x_cursor FOR
2243: 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, TX6, TX5
2244: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2245: WHERE contains( concat_col, p_contains_str)>0
2246: AND d.search_context_id = p_search_ctx_id
2247: AND d.party_id = stage.party_id

Line 2244: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2240: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2241: ELSE
2242: OPEN x_cursor FOR
2243: 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, TX6, TX5
2244: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2245: WHERE contains( concat_col, p_contains_str)>0
2246: AND d.search_context_id = p_search_ctx_id
2247: AND d.party_id = stage.party_id
2248: AND( (l_search_merged ='Y' )

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

2260: IF (l_check_dt > 0 ) THEN
2261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2262: 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);
2263: END IF;
2264: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2265: ELSIF (l_check > 0 ) THEN
2266: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2267: 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);
2268: END IF;

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

2265: ELSIF (l_check > 0 ) THEN
2266: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2267: 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);
2268: END IF;
2269: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2270: END IF;
2271: IF l_search_merged = 'Y' THEN
2272: l_status_sql := ' ' ;
2273: ELSIF l_search_merged = 'I' THEN

Line 2288: 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, TX6, TX5'||

2284: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2285: ELSE
2286: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2287: END IF;
2288: 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, TX6, TX5'||
2289: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2290: ' WHERE contains( concat_col, :cont)>0 '||
2291: ' AND (stage.org_contact_id is null '||
2292: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2289: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2285: ELSE
2286: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2287: END IF;
2288: 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, TX6, TX5'||
2289: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2290: ' WHERE contains( concat_col, :cont)>0 '||
2291: ' AND (stage.org_contact_id is null '||
2292: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2293: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2294: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2295: ' AND ('||p_restrict_sql||'))' ||
2296: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2297: ' UNION ' ||
2298: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2299: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2300: ' WHERE contains( concat_col, :cont)>0 '||
2301: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2302: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2299: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2295: ' AND ('||p_restrict_sql||'))' ||
2296: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2297: ' UNION ' ||
2298: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2299: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2300: ' WHERE contains( concat_col, :cont)>0 '||
2301: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2302: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2303: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2310: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2311: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2312: ELSE
2313: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2315: ' WHERE contains( concat_col, :cont)>0'||
2316: ' AND EXISTS ('||
2317: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2318: ' WHERE p.party_id = stage.party_id ' ||

Line 2331: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2327: ,p_dup_party_id, p_dup_party_id;
2328: END IF;
2329: ELSE
2330: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2331: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2332: ' WHERE contains( concat_col, :cont)>0'||
2333: ' AND EXISTS ('||
2334: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2335: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_38 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2132: 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, TX6, TX5

Line 2133: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2144: 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, TX6, TX5