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

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

2153: END IF;
2154: IF p_restrict_entity = 'CONTACTS'
2155: THEN
2156: OPEN x_cursor FOR
2157: 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
2158: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2159: WHERE contains( concat_col, p_contains_str)>0
2160: AND d.search_context_id = p_search_ctx_id
2161: AND( (l_search_merged ='Y' )

Line 2158: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2154: IF p_restrict_entity = 'CONTACTS'
2155: THEN
2156: OPEN x_cursor FOR
2157: 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
2158: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2159: WHERE contains( concat_col, p_contains_str)>0
2160: AND d.search_context_id = p_search_ctx_id
2161: AND( (l_search_merged ='Y' )
2162: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2165: END IF;
2166: IF p_restrict_entity = 'PARTY_SITES'
2167: THEN
2168: OPEN x_cursor FOR
2169: 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
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( (l_search_merged ='Y' )

Line 2170: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2166: IF p_restrict_entity = 'PARTY_SITES'
2167: THEN
2168: OPEN x_cursor FOR
2169: 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
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( (l_search_merged ='Y' )
2174: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2182: 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);
2183: END IF;
2184: IF p_search_rel_cpts = 'N' THEN
2185: OPEN x_cursor FOR
2186: 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
2187: FROM HZ_STAGED_CONTACT_POINTS stage
2188: WHERE contains( concat_col, p_contains_str)>0
2189: AND( (l_search_merged ='Y' )
2190: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2187: FROM HZ_STAGED_CONTACT_POINTS stage

2183: END IF;
2184: IF p_search_rel_cpts = 'N' THEN
2185: OPEN x_cursor FOR
2186: 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
2187: FROM HZ_STAGED_CONTACT_POINTS stage
2188: WHERE contains( concat_col, p_contains_str)>0
2189: AND( (l_search_merged ='Y' )
2190: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2191: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2191: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2192: AND stage.party_id = p_party_id;
2193: ELSE
2194: OPEN x_cursor FOR
2195: 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
2196: FROM HZ_STAGED_CONTACT_POINTS stage
2197: WHERE contains( concat_col, p_contains_str)>0
2198: AND( (l_search_merged ='Y' )
2199: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2196: FROM HZ_STAGED_CONTACT_POINTS stage

2192: AND stage.party_id = p_party_id;
2193: ELSE
2194: OPEN x_cursor FOR
2195: 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
2196: FROM HZ_STAGED_CONTACT_POINTS stage
2197: WHERE contains( concat_col, p_contains_str)>0
2198: AND( (l_search_merged ='Y' )
2199: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2200: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2199: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2200: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2201: AND stage.party_id = p_party_id
2202: UNION
2203: 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
2204: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2205: WHERE contains( concat_col, p_contains_str)>0
2206: AND r.object_id = p_party_id
2207: AND( (l_search_merged ='Y' )

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

2200: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2201: AND stage.party_id = p_party_id
2202: UNION
2203: 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
2204: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2205: WHERE contains( concat_col, p_contains_str)>0
2206: AND r.object_id = p_party_id
2207: AND( (l_search_merged ='Y' )
2208: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2226: FROM HZ_STAGED_CONTACT_POINTS stage

2222: 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);
2223: END IF;
2224: OPEN x_cursor FOR
2225: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2226: FROM HZ_STAGED_CONTACT_POINTS stage
2227: WHERE contains( concat_col, p_contains_str)>0
2228: AND EXISTS (
2229: SELECT 1 FROM HZ_STAGED_PARTIES p
2230: WHERE p.PARTY_ID = stage.PARTY_ID

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

2241: 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);
2242: END IF;
2243: IF p_person_api = 'Y' THEN
2244: OPEN x_cursor FOR
2245: 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
2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2247: WHERE contains( concat_col, p_contains_str)>0
2248: AND d.search_context_id = p_search_ctx_id
2249: AND d.party_id = stage.party_id

Line 2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2242: END IF;
2243: IF p_person_api = 'Y' THEN
2244: OPEN x_cursor FOR
2245: 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
2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2247: WHERE contains( concat_col, p_contains_str)>0
2248: AND d.search_context_id = p_search_ctx_id
2249: AND d.party_id = stage.party_id
2250: AND( (l_search_merged ='Y' )

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

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') )
2253: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2254: UNION
2255: 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
2256: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2257: WHERE contains( concat_col, p_contains_str)>0
2258: AND d.search_context_id = p_search_ctx_id
2259: AND d.party_id = r.subject_id

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

2252: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2253: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2254: UNION
2255: 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
2256: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2257: WHERE contains( concat_col, p_contains_str)>0
2258: AND d.search_context_id = p_search_ctx_id
2259: AND d.party_id = r.subject_id
2260: AND r.relationship_id = oc.party_relationship_id

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

2264: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2265: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2266: ELSE
2267: OPEN x_cursor FOR
2268: 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
2269: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2270: WHERE contains( concat_col, p_contains_str)>0
2271: AND d.search_context_id = p_search_ctx_id
2272: AND d.party_id = stage.party_id

Line 2269: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2265: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2266: ELSE
2267: OPEN x_cursor FOR
2268: 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
2269: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2270: WHERE contains( concat_col, p_contains_str)>0
2271: AND d.search_context_id = p_search_ctx_id
2272: AND d.party_id = stage.party_id
2273: AND( (l_search_merged ='Y' )

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

2285: IF (l_check_dt > 0 ) THEN
2286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2287: 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);
2288: END IF;
2289: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2290: ELSIF (l_check > 0 ) THEN
2291: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2292: 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);
2293: END IF;

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

2290: ELSIF (l_check > 0 ) THEN
2291: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2292: 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);
2293: END IF;
2294: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2295: END IF;
2296: IF l_search_merged = 'Y' THEN
2297: l_status_sql := ' ' ;
2298: ELSIF l_search_merged = 'I' THEN

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

2309: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2310: ELSE
2311: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2312: END IF;
2313: 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'||
2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2315: ' WHERE contains( concat_col, :cont)>0 '||
2316: ' AND (stage.org_contact_id is null '||
2317: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2310: ELSE
2311: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2312: END IF;
2313: 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'||
2314: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2315: ' WHERE contains( concat_col, :cont)>0 '||
2316: ' AND (stage.org_contact_id is null '||
2317: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2318: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2319: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2320: ' AND ('||p_restrict_sql||'))' ||
2321: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2322: ' UNION ' ||
2323: ' 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'||
2324: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2325: ' WHERE contains( concat_col, :cont)>0 '||
2326: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2327: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2324: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2320: ' AND ('||p_restrict_sql||'))' ||
2321: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2322: ' UNION ' ||
2323: ' 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'||
2324: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2325: ' WHERE contains( concat_col, :cont)>0 '||
2326: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2327: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2328: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2339: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2335: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2336: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2337: ELSE
2338: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2339: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2340: ' WHERE contains( concat_col, :cont)>0'||
2341: ' AND EXISTS ('||
2342: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2343: ' WHERE p.party_id = stage.party_id ' ||

Line 2356: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2352: ,p_dup_party_id, p_dup_party_id;
2353: END IF;
2354: ELSE
2355: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2356: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2357: ' WHERE contains( concat_col, :cont)>0'||
2358: ' AND EXISTS ('||
2359: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2360: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_99 dependencies on HZ_STAGED_CONTACT_POINTS

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

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