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

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

2383: END IF;
2384: IF p_restrict_entity = 'CONTACTS'
2385: THEN
2386: OPEN x_cursor FOR
2387: 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
2388: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2389: WHERE contains( concat_col, p_contains_str)>0
2390: AND d.search_context_id = p_search_ctx_id
2391: AND( (l_search_merged ='Y' )

Line 2388: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2384: IF p_restrict_entity = 'CONTACTS'
2385: THEN
2386: OPEN x_cursor FOR
2387: 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
2388: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2389: WHERE contains( concat_col, p_contains_str)>0
2390: AND d.search_context_id = p_search_ctx_id
2391: AND( (l_search_merged ='Y' )
2392: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2395: END IF;
2396: IF p_restrict_entity = 'PARTY_SITES'
2397: THEN
2398: OPEN x_cursor FOR
2399: 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
2400: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2401: WHERE contains( concat_col, p_contains_str)>0
2402: AND d.search_context_id = p_search_ctx_id
2403: AND( (l_search_merged ='Y' )

Line 2400: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2396: IF p_restrict_entity = 'PARTY_SITES'
2397: THEN
2398: OPEN x_cursor FOR
2399: 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
2400: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2401: WHERE contains( concat_col, p_contains_str)>0
2402: AND d.search_context_id = p_search_ctx_id
2403: AND( (l_search_merged ='Y' )
2404: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2412: 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);
2413: END IF;
2414: IF p_search_rel_cpts = 'N' THEN
2415: OPEN x_cursor FOR
2416: 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
2417: FROM HZ_STAGED_CONTACT_POINTS stage
2418: WHERE contains( concat_col, p_contains_str)>0
2419: AND( (l_search_merged ='Y' )
2420: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2417: FROM HZ_STAGED_CONTACT_POINTS stage

2413: END IF;
2414: IF p_search_rel_cpts = 'N' THEN
2415: OPEN x_cursor FOR
2416: 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
2417: FROM HZ_STAGED_CONTACT_POINTS stage
2418: WHERE contains( concat_col, p_contains_str)>0
2419: AND( (l_search_merged ='Y' )
2420: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2421: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2421: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2422: AND stage.party_id = p_party_id;
2423: ELSE
2424: OPEN x_cursor FOR
2425: 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
2426: FROM HZ_STAGED_CONTACT_POINTS stage
2427: WHERE contains( concat_col, p_contains_str)>0
2428: AND( (l_search_merged ='Y' )
2429: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2426: FROM HZ_STAGED_CONTACT_POINTS stage

2422: AND stage.party_id = p_party_id;
2423: ELSE
2424: OPEN x_cursor FOR
2425: 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
2426: FROM HZ_STAGED_CONTACT_POINTS stage
2427: WHERE contains( concat_col, p_contains_str)>0
2428: AND( (l_search_merged ='Y' )
2429: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2430: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2429: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2430: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2431: AND stage.party_id = p_party_id
2432: UNION
2433: 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
2434: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2435: WHERE contains( concat_col, p_contains_str)>0
2436: AND r.object_id = p_party_id
2437: AND( (l_search_merged ='Y' )

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

2430: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2431: AND stage.party_id = p_party_id
2432: UNION
2433: 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
2434: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2435: WHERE contains( concat_col, p_contains_str)>0
2436: AND r.object_id = p_party_id
2437: AND( (l_search_merged ='Y' )
2438: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2456: FROM HZ_STAGED_CONTACT_POINTS stage

2452: 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);
2453: END IF;
2454: OPEN x_cursor FOR
2455: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2456: FROM HZ_STAGED_CONTACT_POINTS stage
2457: WHERE contains( concat_col, p_contains_str)>0
2458: AND EXISTS (
2459: SELECT 1 FROM HZ_STAGED_PARTIES p
2460: WHERE p.PARTY_ID = stage.PARTY_ID

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

2471: 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);
2472: END IF;
2473: IF p_person_api = 'Y' THEN
2474: OPEN x_cursor FOR
2475: 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
2476: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2477: WHERE contains( concat_col, p_contains_str)>0
2478: AND d.search_context_id = p_search_ctx_id
2479: AND d.party_id = stage.party_id

Line 2476: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2472: END IF;
2473: IF p_person_api = 'Y' THEN
2474: OPEN x_cursor FOR
2475: 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
2476: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2477: WHERE contains( concat_col, p_contains_str)>0
2478: AND d.search_context_id = p_search_ctx_id
2479: AND d.party_id = stage.party_id
2480: AND( (l_search_merged ='Y' )

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

2481: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2482: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2483: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2484: UNION
2485: 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
2486: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2487: WHERE contains( concat_col, p_contains_str)>0
2488: AND d.search_context_id = p_search_ctx_id
2489: AND d.party_id = r.subject_id

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

2482: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2483: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2484: UNION
2485: 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
2486: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2487: WHERE contains( concat_col, p_contains_str)>0
2488: AND d.search_context_id = p_search_ctx_id
2489: AND d.party_id = r.subject_id
2490: AND r.relationship_id = oc.party_relationship_id

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

2494: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2495: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2496: ELSE
2497: OPEN x_cursor FOR
2498: 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
2499: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2500: WHERE contains( concat_col, p_contains_str)>0
2501: AND d.search_context_id = p_search_ctx_id
2502: AND d.party_id = stage.party_id

Line 2499: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2495: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2496: ELSE
2497: OPEN x_cursor FOR
2498: 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
2499: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2500: WHERE contains( concat_col, p_contains_str)>0
2501: AND d.search_context_id = p_search_ctx_id
2502: AND d.party_id = stage.party_id
2503: AND( (l_search_merged ='Y' )

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

2515: IF (l_check_dt > 0 ) THEN
2516: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2517: 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);
2518: END IF;
2519: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2520: ELSIF (l_check > 0 ) THEN
2521: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2522: 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);
2523: END IF;

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

2520: ELSIF (l_check > 0 ) THEN
2521: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2522: 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);
2523: END IF;
2524: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2525: END IF;
2526: IF l_search_merged = 'Y' THEN
2527: l_status_sql := ' ' ;
2528: ELSIF l_search_merged = 'I' THEN

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

2539: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2540: ELSE
2541: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2542: END IF;
2543: 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'||
2544: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2545: ' WHERE contains( concat_col, :cont)>0 '||
2546: ' AND (stage.org_contact_id is null '||
2547: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2544: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2540: ELSE
2541: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2542: END IF;
2543: 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'||
2544: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2545: ' WHERE contains( concat_col, :cont)>0 '||
2546: ' AND (stage.org_contact_id is null '||
2547: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2548: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2549: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2550: ' AND ('||p_restrict_sql||'))' ||
2551: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2552: ' UNION ' ||
2553: ' 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'||
2554: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2555: ' WHERE contains( concat_col, :cont)>0 '||
2556: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2557: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2554: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2550: ' AND ('||p_restrict_sql||'))' ||
2551: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2552: ' UNION ' ||
2553: ' 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'||
2554: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2555: ' WHERE contains( concat_col, :cont)>0 '||
2556: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2557: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2558: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2569: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2565: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2566: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2567: ELSE
2568: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2569: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2570: ' WHERE contains( concat_col, :cont)>0'||
2571: ' AND EXISTS ('||
2572: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2573: ' WHERE p.party_id = stage.party_id ' ||

Line 2586: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2582: ,p_dup_party_id, p_dup_party_id;
2583: END IF;
2584: ELSE
2585: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2586: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2587: ' WHERE contains( concat_col, :cont)>0'||
2588: ' AND EXISTS ('||
2589: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2590: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_60 dependencies on HZ_STAGED_CONTACT_POINTS

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

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