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

Line 2382: 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, TX8, TX7

2378: END IF;
2379: IF p_restrict_entity = 'CONTACTS'
2380: THEN
2381: OPEN x_cursor FOR
2382: 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, TX8, TX7
2383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2384: WHERE contains( concat_col, p_contains_str)>0
2385: AND d.search_context_id = p_search_ctx_id
2386: AND( (l_search_merged ='Y' )

Line 2383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2379: IF p_restrict_entity = 'CONTACTS'
2380: THEN
2381: OPEN x_cursor FOR
2382: 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, TX8, TX7
2383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2384: WHERE contains( concat_col, p_contains_str)>0
2385: AND d.search_context_id = p_search_ctx_id
2386: AND( (l_search_merged ='Y' )
2387: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2394: 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, TX8, TX7

2390: END IF;
2391: IF p_restrict_entity = 'PARTY_SITES'
2392: THEN
2393: OPEN x_cursor FOR
2394: 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, TX8, TX7
2395: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2396: WHERE contains( concat_col, p_contains_str)>0
2397: AND d.search_context_id = p_search_ctx_id
2398: AND( (l_search_merged ='Y' )

Line 2395: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2391: IF p_restrict_entity = 'PARTY_SITES'
2392: THEN
2393: OPEN x_cursor FOR
2394: 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, TX8, TX7
2395: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2396: WHERE contains( concat_col, p_contains_str)>0
2397: AND d.search_context_id = p_search_ctx_id
2398: AND( (l_search_merged ='Y' )
2399: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2407: 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);
2408: END IF;
2409: IF p_search_rel_cpts = 'N' THEN
2410: OPEN x_cursor FOR
2411: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2412: FROM HZ_STAGED_CONTACT_POINTS stage
2413: WHERE contains( concat_col, p_contains_str)>0
2414: AND( (l_search_merged ='Y' )
2415: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2412: FROM HZ_STAGED_CONTACT_POINTS stage

2408: END IF;
2409: IF p_search_rel_cpts = 'N' THEN
2410: OPEN x_cursor FOR
2411: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2412: FROM HZ_STAGED_CONTACT_POINTS stage
2413: WHERE contains( concat_col, p_contains_str)>0
2414: AND( (l_search_merged ='Y' )
2415: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2416: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2416: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2417: AND stage.party_id = p_party_id;
2418: ELSE
2419: OPEN x_cursor FOR
2420: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2421: FROM HZ_STAGED_CONTACT_POINTS stage
2422: WHERE contains( concat_col, p_contains_str)>0
2423: AND( (l_search_merged ='Y' )
2424: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2421: FROM HZ_STAGED_CONTACT_POINTS stage

2417: AND stage.party_id = p_party_id;
2418: ELSE
2419: OPEN x_cursor FOR
2420: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2421: FROM HZ_STAGED_CONTACT_POINTS stage
2422: WHERE contains( concat_col, p_contains_str)>0
2423: AND( (l_search_merged ='Y' )
2424: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2425: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2428: 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, TX8, TX7

2424: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2425: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2426: AND stage.party_id = p_party_id
2427: UNION
2428: 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, TX8, TX7
2429: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2430: WHERE contains( concat_col, p_contains_str)>0
2431: AND r.object_id = p_party_id
2432: AND( (l_search_merged ='Y' )

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

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

Line 2451: FROM HZ_STAGED_CONTACT_POINTS stage

2447: 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);
2448: END IF;
2449: OPEN x_cursor FOR
2450: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2451: FROM HZ_STAGED_CONTACT_POINTS stage
2452: WHERE contains( concat_col, p_contains_str)>0
2453: AND EXISTS (
2454: SELECT 1 FROM HZ_STAGED_PARTIES p
2455: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2470: 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, TX8, TX7

2466: 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);
2467: END IF;
2468: IF p_person_api = 'Y' THEN
2469: OPEN x_cursor FOR
2470: 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, TX8, TX7
2471: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2472: WHERE contains( concat_col, p_contains_str)>0
2473: AND d.search_context_id = p_search_ctx_id
2474: AND d.party_id = stage.party_id

Line 2471: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2467: END IF;
2468: IF p_person_api = 'Y' THEN
2469: OPEN x_cursor FOR
2470: 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, TX8, TX7
2471: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2472: WHERE contains( concat_col, p_contains_str)>0
2473: AND d.search_context_id = p_search_ctx_id
2474: AND d.party_id = stage.party_id
2475: AND( (l_search_merged ='Y' )

Line 2480: 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, TX8, TX7

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

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

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

Line 2493: 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, TX8, TX7

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

Line 2494: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2490: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2491: ELSE
2492: OPEN x_cursor FOR
2493: 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, TX8, TX7
2494: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2495: WHERE contains( concat_col, p_contains_str)>0
2496: AND d.search_context_id = p_search_ctx_id
2497: AND d.party_id = stage.party_id
2498: AND( (l_search_merged ='Y' )

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

2510: IF (l_check_dt > 0 ) THEN
2511: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2512: 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);
2513: END IF;
2514: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2515: ELSIF (l_check > 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 hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2518: END IF;

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

2515: ELSIF (l_check > 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 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_N1) */';
2520: END IF;
2521: IF l_search_merged = 'Y' THEN
2522: l_status_sql := ' ' ;
2523: ELSIF l_search_merged = 'I' THEN

Line 2538: 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, TX8, TX7'||

2534: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2535: ELSE
2536: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2537: END IF;
2538: 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, TX8, TX7'||
2539: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2540: ' WHERE contains( concat_col, :cont)>0 '||
2541: ' AND (stage.org_contact_id is null '||
2542: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2539: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2535: ELSE
2536: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2537: END IF;
2538: 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, TX8, TX7'||
2539: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2540: ' WHERE contains( concat_col, :cont)>0 '||
2541: ' AND (stage.org_contact_id is null '||
2542: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2543: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2544: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2545: ' AND ('||p_restrict_sql||'))' ||
2546: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2547: ' UNION ' ||
2548: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7'||
2549: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2550: ' WHERE contains( concat_col, :cont)>0 '||
2551: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2552: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2549: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2545: ' AND ('||p_restrict_sql||'))' ||
2546: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2547: ' UNION ' ||
2548: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7'||
2549: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2550: ' WHERE contains( concat_col, :cont)>0 '||
2551: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2552: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2553: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2564: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2560: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2561: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2562: ELSE
2563: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7'||
2564: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2565: ' WHERE contains( concat_col, :cont)>0'||
2566: ' AND EXISTS ('||
2567: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2568: ' WHERE p.party_id = stage.party_id ' ||

Line 2581: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2577: ,p_dup_party_id, p_dup_party_id;
2578: END IF;
2579: ELSE
2580: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7'||
2581: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2582: ' WHERE contains( concat_col, :cont)>0'||
2583: ' AND EXISTS ('||
2584: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2585: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_62 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2382: 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, TX8, TX7

Line 2383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2394: 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, TX8, TX7