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

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

2528: END IF;
2529: IF p_restrict_entity = 'CONTACTS'
2530: THEN
2531: OPEN x_cursor FOR
2532: 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
2533: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2534: WHERE contains( concat_col, p_contains_str)>0
2535: AND d.search_context_id = p_search_ctx_id
2536: AND( (l_search_merged ='Y' )

Line 2533: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2529: IF p_restrict_entity = 'CONTACTS'
2530: THEN
2531: OPEN x_cursor FOR
2532: 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
2533: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2534: WHERE contains( concat_col, p_contains_str)>0
2535: AND d.search_context_id = p_search_ctx_id
2536: AND( (l_search_merged ='Y' )
2537: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2540: END IF;
2541: IF p_restrict_entity = 'PARTY_SITES'
2542: THEN
2543: OPEN x_cursor FOR
2544: 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
2545: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2546: WHERE contains( concat_col, p_contains_str)>0
2547: AND d.search_context_id = p_search_ctx_id
2548: AND( (l_search_merged ='Y' )

Line 2545: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2541: IF p_restrict_entity = 'PARTY_SITES'
2542: THEN
2543: OPEN x_cursor FOR
2544: 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
2545: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2546: WHERE contains( concat_col, p_contains_str)>0
2547: AND d.search_context_id = p_search_ctx_id
2548: AND( (l_search_merged ='Y' )
2549: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2557: 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);
2558: END IF;
2559: IF p_search_rel_cpts = 'N' THEN
2560: OPEN x_cursor FOR
2561: 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
2562: FROM HZ_STAGED_CONTACT_POINTS stage
2563: WHERE contains( concat_col, p_contains_str)>0
2564: AND( (l_search_merged ='Y' )
2565: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2562: FROM HZ_STAGED_CONTACT_POINTS stage

2558: END IF;
2559: IF p_search_rel_cpts = 'N' THEN
2560: OPEN x_cursor FOR
2561: 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
2562: FROM HZ_STAGED_CONTACT_POINTS stage
2563: WHERE contains( concat_col, p_contains_str)>0
2564: AND( (l_search_merged ='Y' )
2565: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2566: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2566: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2567: AND stage.party_id = p_party_id;
2568: ELSE
2569: OPEN x_cursor FOR
2570: 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
2571: FROM HZ_STAGED_CONTACT_POINTS stage
2572: WHERE contains( concat_col, p_contains_str)>0
2573: AND( (l_search_merged ='Y' )
2574: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2571: FROM HZ_STAGED_CONTACT_POINTS stage

2567: AND stage.party_id = p_party_id;
2568: ELSE
2569: OPEN x_cursor FOR
2570: 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
2571: FROM HZ_STAGED_CONTACT_POINTS stage
2572: WHERE contains( concat_col, p_contains_str)>0
2573: AND( (l_search_merged ='Y' )
2574: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2575: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2574: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2575: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2576: AND stage.party_id = p_party_id
2577: UNION
2578: 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
2579: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2580: WHERE contains( concat_col, p_contains_str)>0
2581: AND r.object_id = p_party_id
2582: AND( (l_search_merged ='Y' )

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

2575: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2576: AND stage.party_id = p_party_id
2577: UNION
2578: 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
2579: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2580: WHERE contains( concat_col, p_contains_str)>0
2581: AND r.object_id = p_party_id
2582: AND( (l_search_merged ='Y' )
2583: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2601: FROM HZ_STAGED_CONTACT_POINTS stage

2597: 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);
2598: END IF;
2599: OPEN x_cursor FOR
2600: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2601: FROM HZ_STAGED_CONTACT_POINTS stage
2602: WHERE contains( concat_col, p_contains_str)>0
2603: AND EXISTS (
2604: SELECT 1 FROM HZ_STAGED_PARTIES p
2605: WHERE p.PARTY_ID = stage.PARTY_ID

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

2616: 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);
2617: END IF;
2618: IF p_person_api = 'Y' THEN
2619: OPEN x_cursor FOR
2620: 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
2621: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2622: WHERE contains( concat_col, p_contains_str)>0
2623: AND d.search_context_id = p_search_ctx_id
2624: AND d.party_id = stage.party_id

Line 2621: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2617: END IF;
2618: IF p_person_api = 'Y' THEN
2619: OPEN x_cursor FOR
2620: 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
2621: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2622: WHERE contains( concat_col, p_contains_str)>0
2623: AND d.search_context_id = p_search_ctx_id
2624: AND d.party_id = stage.party_id
2625: AND( (l_search_merged ='Y' )

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

2626: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2627: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2628: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2629: UNION
2630: 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
2631: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2632: WHERE contains( concat_col, p_contains_str)>0
2633: AND d.search_context_id = p_search_ctx_id
2634: AND d.party_id = r.subject_id

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

2627: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2628: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2629: UNION
2630: 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
2631: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2632: WHERE contains( concat_col, p_contains_str)>0
2633: AND d.search_context_id = p_search_ctx_id
2634: AND d.party_id = r.subject_id
2635: AND r.relationship_id = oc.party_relationship_id

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

2639: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2640: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2641: ELSE
2642: OPEN x_cursor FOR
2643: 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
2644: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2645: WHERE contains( concat_col, p_contains_str)>0
2646: AND d.search_context_id = p_search_ctx_id
2647: AND d.party_id = stage.party_id

Line 2644: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2640: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2641: ELSE
2642: OPEN x_cursor FOR
2643: 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
2644: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2645: WHERE contains( concat_col, p_contains_str)>0
2646: AND d.search_context_id = p_search_ctx_id
2647: AND d.party_id = stage.party_id
2648: AND( (l_search_merged ='Y' )

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

2660: IF (l_check_dt > 0 ) THEN
2661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2662: 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);
2663: END IF;
2664: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2665: ELSIF (l_check > 0 ) THEN
2666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2667: 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);
2668: END IF;

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

2665: ELSIF (l_check > 0 ) THEN
2666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2667: 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);
2668: END IF;
2669: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2670: END IF;
2671: IF l_search_merged = 'Y' THEN
2672: l_status_sql := ' ' ;
2673: ELSIF l_search_merged = 'I' THEN

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

2684: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2685: ELSE
2686: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2687: END IF;
2688: 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'||
2689: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2690: ' WHERE contains( concat_col, :cont)>0 '||
2691: ' AND (stage.org_contact_id is null '||
2692: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2689: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2685: ELSE
2686: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2687: END IF;
2688: 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'||
2689: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2690: ' WHERE contains( concat_col, :cont)>0 '||
2691: ' AND (stage.org_contact_id is null '||
2692: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2693: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2694: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2695: ' AND ('||p_restrict_sql||'))' ||
2696: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2697: ' UNION ' ||
2698: ' 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'||
2699: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2700: ' WHERE contains( concat_col, :cont)>0 '||
2701: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2702: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2699: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2695: ' AND ('||p_restrict_sql||'))' ||
2696: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2697: ' UNION ' ||
2698: ' 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'||
2699: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2700: ' WHERE contains( concat_col, :cont)>0 '||
2701: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2702: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2703: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2714: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2710: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2711: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2712: ELSE
2713: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2714: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2715: ' WHERE contains( concat_col, :cont)>0'||
2716: ' AND EXISTS ('||
2717: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2718: ' WHERE p.party_id = stage.party_id ' ||

Line 2731: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2727: ,p_dup_party_id, p_dup_party_id;
2728: END IF;
2729: ELSE
2730: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2731: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2732: ' WHERE contains( concat_col, :cont)>0'||
2733: ' AND EXISTS ('||
2734: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2735: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_32 dependencies on HZ_STAGED_CONTACT_POINTS

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

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