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

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

2352: END IF;
2353: IF p_restrict_entity = 'CONTACTS'
2354: THEN
2355: OPEN x_cursor FOR
2356: 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
2357: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2358: WHERE contains( concat_col, p_contains_str)>0
2359: AND d.search_context_id = p_search_ctx_id
2360: AND( (l_search_merged ='Y' )

Line 2357: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2353: IF p_restrict_entity = 'CONTACTS'
2354: THEN
2355: OPEN x_cursor FOR
2356: 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
2357: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2358: WHERE contains( concat_col, p_contains_str)>0
2359: AND d.search_context_id = p_search_ctx_id
2360: AND( (l_search_merged ='Y' )
2361: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2364: END IF;
2365: IF p_restrict_entity = 'PARTY_SITES'
2366: THEN
2367: OPEN x_cursor FOR
2368: 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
2369: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2370: WHERE contains( concat_col, p_contains_str)>0
2371: AND d.search_context_id = p_search_ctx_id
2372: AND( (l_search_merged ='Y' )

Line 2369: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2365: IF p_restrict_entity = 'PARTY_SITES'
2366: THEN
2367: OPEN x_cursor FOR
2368: 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
2369: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2370: WHERE contains( concat_col, p_contains_str)>0
2371: AND d.search_context_id = p_search_ctx_id
2372: AND( (l_search_merged ='Y' )
2373: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2381: 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);
2382: END IF;
2383: IF p_search_rel_cpts = 'N' THEN
2384: OPEN x_cursor FOR
2385: 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
2386: FROM HZ_STAGED_CONTACT_POINTS stage
2387: WHERE contains( concat_col, p_contains_str)>0
2388: AND( (l_search_merged ='Y' )
2389: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2386: FROM HZ_STAGED_CONTACT_POINTS stage

2382: END IF;
2383: IF p_search_rel_cpts = 'N' THEN
2384: OPEN x_cursor FOR
2385: 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
2386: FROM HZ_STAGED_CONTACT_POINTS stage
2387: WHERE contains( concat_col, p_contains_str)>0
2388: AND( (l_search_merged ='Y' )
2389: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2390: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2390: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2391: AND stage.party_id = p_party_id;
2392: ELSE
2393: OPEN x_cursor FOR
2394: 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
2395: FROM HZ_STAGED_CONTACT_POINTS stage
2396: WHERE contains( concat_col, p_contains_str)>0
2397: AND( (l_search_merged ='Y' )
2398: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2395: FROM HZ_STAGED_CONTACT_POINTS stage

2391: AND stage.party_id = p_party_id;
2392: ELSE
2393: OPEN x_cursor FOR
2394: 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
2395: FROM HZ_STAGED_CONTACT_POINTS stage
2396: WHERE contains( concat_col, p_contains_str)>0
2397: AND( (l_search_merged ='Y' )
2398: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2399: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2398: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2399: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2400: AND stage.party_id = p_party_id
2401: UNION
2402: 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
2403: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2404: WHERE contains( concat_col, p_contains_str)>0
2405: AND r.object_id = p_party_id
2406: AND( (l_search_merged ='Y' )

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

2399: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2400: AND stage.party_id = p_party_id
2401: UNION
2402: 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
2403: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2404: WHERE contains( concat_col, p_contains_str)>0
2405: AND r.object_id = p_party_id
2406: AND( (l_search_merged ='Y' )
2407: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2425: FROM HZ_STAGED_CONTACT_POINTS stage

2421: 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);
2422: END IF;
2423: OPEN x_cursor FOR
2424: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2425: FROM HZ_STAGED_CONTACT_POINTS stage
2426: WHERE contains( concat_col, p_contains_str)>0
2427: AND EXISTS (
2428: SELECT 1 FROM HZ_STAGED_PARTIES p
2429: WHERE p.PARTY_ID = stage.PARTY_ID

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

2440: 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);
2441: END IF;
2442: IF p_person_api = 'Y' THEN
2443: OPEN x_cursor FOR
2444: 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
2445: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2446: WHERE contains( concat_col, p_contains_str)>0
2447: AND d.search_context_id = p_search_ctx_id
2448: AND d.party_id = stage.party_id

Line 2445: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2441: END IF;
2442: IF p_person_api = 'Y' THEN
2443: OPEN x_cursor FOR
2444: 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
2445: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2446: WHERE contains( concat_col, p_contains_str)>0
2447: AND d.search_context_id = p_search_ctx_id
2448: AND d.party_id = stage.party_id
2449: AND( (l_search_merged ='Y' )

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

2450: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2451: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2452: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2453: UNION
2454: 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
2455: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2456: WHERE contains( concat_col, p_contains_str)>0
2457: AND d.search_context_id = p_search_ctx_id
2458: AND d.party_id = r.subject_id

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

2451: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2452: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2453: UNION
2454: 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
2455: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2456: WHERE contains( concat_col, p_contains_str)>0
2457: AND d.search_context_id = p_search_ctx_id
2458: AND d.party_id = r.subject_id
2459: AND r.relationship_id = oc.party_relationship_id

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

2463: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2464: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2465: ELSE
2466: OPEN x_cursor FOR
2467: 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
2468: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2469: WHERE contains( concat_col, p_contains_str)>0
2470: AND d.search_context_id = p_search_ctx_id
2471: AND d.party_id = stage.party_id

Line 2468: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2464: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2465: ELSE
2466: OPEN x_cursor FOR
2467: 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
2468: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2469: WHERE contains( concat_col, p_contains_str)>0
2470: AND d.search_context_id = p_search_ctx_id
2471: AND d.party_id = stage.party_id
2472: AND( (l_search_merged ='Y' )

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

2484: IF (l_check_dt > 0 ) THEN
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: 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);
2487: END IF;
2488: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2489: ELSIF (l_check > 0 ) THEN
2490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2491: 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);
2492: END IF;

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

2489: ELSIF (l_check > 0 ) THEN
2490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2491: 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);
2492: END IF;
2493: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2494: END IF;
2495: IF l_search_merged = 'Y' THEN
2496: l_status_sql := ' ' ;
2497: ELSIF l_search_merged = 'I' THEN

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

2508: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2509: ELSE
2510: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2511: END IF;
2512: 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'||
2513: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2514: ' WHERE contains( concat_col, :cont)>0 '||
2515: ' AND (stage.org_contact_id is null '||
2516: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2513: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2509: ELSE
2510: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2511: END IF;
2512: 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'||
2513: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2514: ' WHERE contains( concat_col, :cont)>0 '||
2515: ' AND (stage.org_contact_id is null '||
2516: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2517: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2518: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2519: ' AND ('||p_restrict_sql||'))' ||
2520: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2521: ' UNION ' ||
2522: ' 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'||
2523: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2524: ' WHERE contains( concat_col, :cont)>0 '||
2525: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2526: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2523: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2519: ' AND ('||p_restrict_sql||'))' ||
2520: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2521: ' UNION ' ||
2522: ' 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'||
2523: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2524: ' WHERE contains( concat_col, :cont)>0 '||
2525: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2526: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2527: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2538: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2534: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2535: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2536: ELSE
2537: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2538: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2539: ' WHERE contains( concat_col, :cont)>0'||
2540: ' AND EXISTS ('||
2541: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2542: ' WHERE p.party_id = stage.party_id ' ||

Line 2555: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2551: ,p_dup_party_id, p_dup_party_id;
2552: END IF;
2553: ELSE
2554: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2555: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2556: ' WHERE contains( concat_col, :cont)>0'||
2557: ' AND EXISTS ('||
2558: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2559: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_33 dependencies on HZ_STAGED_CONTACT_POINTS

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

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