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

Line 2906: 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, TX3, TX4

2902: END IF;
2903: IF p_restrict_entity = 'CONTACTS'
2904: THEN
2905: OPEN x_cursor FOR
2906: 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, TX3, TX4
2907: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2908: WHERE contains( concat_col, p_contains_str)>0
2909: AND d.search_context_id = p_search_ctx_id
2910: AND( (l_search_merged ='Y' )

Line 2907: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2903: IF p_restrict_entity = 'CONTACTS'
2904: THEN
2905: OPEN x_cursor FOR
2906: 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, TX3, TX4
2907: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2908: WHERE contains( concat_col, p_contains_str)>0
2909: AND d.search_context_id = p_search_ctx_id
2910: AND( (l_search_merged ='Y' )
2911: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2918: 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, TX3, TX4

2914: END IF;
2915: IF p_restrict_entity = 'PARTY_SITES'
2916: THEN
2917: OPEN x_cursor FOR
2918: 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, TX3, TX4
2919: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2920: WHERE contains( concat_col, p_contains_str)>0
2921: AND d.search_context_id = p_search_ctx_id
2922: AND( (l_search_merged ='Y' )

Line 2919: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2915: IF p_restrict_entity = 'PARTY_SITES'
2916: THEN
2917: OPEN x_cursor FOR
2918: 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, TX3, TX4
2919: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2920: WHERE contains( concat_col, p_contains_str)>0
2921: AND d.search_context_id = p_search_ctx_id
2922: AND( (l_search_merged ='Y' )
2923: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2935: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4

2931: 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);
2932: END IF;
2933: IF p_search_rel_cpts = 'N' THEN
2934: OPEN x_cursor FOR
2935: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
2936: FROM HZ_STAGED_CONTACT_POINTS stage
2937: WHERE contains( concat_col, p_contains_str)>0
2938: AND( (l_search_merged ='Y' )
2939: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2936: FROM HZ_STAGED_CONTACT_POINTS stage

2932: END IF;
2933: IF p_search_rel_cpts = 'N' THEN
2934: OPEN x_cursor FOR
2935: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
2936: FROM HZ_STAGED_CONTACT_POINTS stage
2937: WHERE contains( concat_col, p_contains_str)>0
2938: AND( (l_search_merged ='Y' )
2939: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2940: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2944: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4

2940: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2941: AND stage.party_id = p_party_id;
2942: ELSE
2943: OPEN x_cursor FOR
2944: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
2945: FROM HZ_STAGED_CONTACT_POINTS stage
2946: WHERE contains( concat_col, p_contains_str)>0
2947: AND( (l_search_merged ='Y' )
2948: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2945: FROM HZ_STAGED_CONTACT_POINTS stage

2941: AND stage.party_id = p_party_id;
2942: ELSE
2943: OPEN x_cursor FOR
2944: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
2945: FROM HZ_STAGED_CONTACT_POINTS stage
2946: WHERE contains( concat_col, p_contains_str)>0
2947: AND( (l_search_merged ='Y' )
2948: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2949: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2952: 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, TX3, TX4

2948: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2949: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2950: AND stage.party_id = p_party_id
2951: UNION
2952: 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, TX3, TX4
2953: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2954: WHERE contains( concat_col, p_contains_str)>0
2955: AND r.object_id = p_party_id
2956: AND( (l_search_merged ='Y' )

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

2949: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2950: AND stage.party_id = p_party_id
2951: UNION
2952: 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, TX3, TX4
2953: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2954: WHERE contains( concat_col, p_contains_str)>0
2955: AND r.object_id = p_party_id
2956: AND( (l_search_merged ='Y' )
2957: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2975: FROM HZ_STAGED_CONTACT_POINTS stage

2971: 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);
2972: END IF;
2973: OPEN x_cursor FOR
2974: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4
2975: FROM HZ_STAGED_CONTACT_POINTS stage
2976: WHERE contains( concat_col, p_contains_str)>0
2977: AND EXISTS (
2978: SELECT 1 FROM HZ_STAGED_PARTIES p
2979: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2994: 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, TX3, TX4

2990: 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);
2991: END IF;
2992: IF p_person_api = 'Y' THEN
2993: OPEN x_cursor FOR
2994: 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, TX3, TX4
2995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2996: WHERE contains( concat_col, p_contains_str)>0
2997: AND d.search_context_id = p_search_ctx_id
2998: AND d.party_id = stage.party_id

Line 2995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2991: END IF;
2992: IF p_person_api = 'Y' THEN
2993: OPEN x_cursor FOR
2994: 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, TX3, TX4
2995: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2996: WHERE contains( concat_col, p_contains_str)>0
2997: AND d.search_context_id = p_search_ctx_id
2998: AND d.party_id = stage.party_id
2999: AND( (l_search_merged ='Y' )

Line 3004: 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, TX3, TX4

3000: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
3001: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
3002: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
3003: UNION
3004: 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, TX3, TX4
3005: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
3006: WHERE contains( concat_col, p_contains_str)>0
3007: AND d.search_context_id = p_search_ctx_id
3008: AND d.party_id = r.subject_id

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

3001: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
3002: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
3003: UNION
3004: 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, TX3, TX4
3005: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
3006: WHERE contains( concat_col, p_contains_str)>0
3007: AND d.search_context_id = p_search_ctx_id
3008: AND d.party_id = r.subject_id
3009: AND r.relationship_id = oc.party_relationship_id

Line 3017: 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, TX3, TX4

3013: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
3014: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
3015: ELSE
3016: OPEN x_cursor FOR
3017: 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, TX3, TX4
3018: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
3019: WHERE contains( concat_col, p_contains_str)>0
3020: AND d.search_context_id = p_search_ctx_id
3021: AND d.party_id = stage.party_id

Line 3018: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

3014: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
3015: ELSE
3016: OPEN x_cursor FOR
3017: 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, TX3, TX4
3018: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
3019: WHERE contains( concat_col, p_contains_str)>0
3020: AND d.search_context_id = p_search_ctx_id
3021: AND d.party_id = stage.party_id
3022: AND( (l_search_merged ='Y' )

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

3034: IF (l_check_dt > 0 ) THEN
3035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3036: 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);
3037: END IF;
3038: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
3039: ELSIF (l_check > 0 ) THEN
3040: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3041: 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);
3042: END IF;

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

3039: ELSIF (l_check > 0 ) THEN
3040: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3041: 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);
3042: END IF;
3043: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
3044: END IF;
3045: IF l_search_merged = 'Y' THEN
3046: l_status_sql := ' ' ;
3047: ELSIF l_search_merged = 'I' THEN

Line 3062: 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, TX3, TX4'||

3058: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
3059: ELSE
3060: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
3061: END IF;
3062: 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, TX3, TX4'||
3063: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
3064: ' WHERE contains( concat_col, :cont)>0 '||
3065: ' AND (stage.org_contact_id is null '||
3066: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 3063: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

3059: ELSE
3060: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
3061: END IF;
3062: 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, TX3, TX4'||
3063: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
3064: ' WHERE contains( concat_col, :cont)>0 '||
3065: ' AND (stage.org_contact_id is null '||
3066: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
3067: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 3072: ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4'||

3068: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
3069: ' AND ('||p_restrict_sql||'))' ||
3070: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
3071: ' UNION ' ||
3072: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4'||
3073: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
3074: ' WHERE contains( concat_col, :cont)>0 '||
3075: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
3076: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 3073: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

3069: ' AND ('||p_restrict_sql||'))' ||
3070: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
3071: ' UNION ' ||
3072: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4'||
3073: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
3074: ' WHERE contains( concat_col, :cont)>0 '||
3075: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
3076: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
3077: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 3088: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

3084: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
3085: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
3086: ELSE
3087: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4'||
3088: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
3089: ' WHERE contains( concat_col, :cont)>0'||
3090: ' AND EXISTS ('||
3091: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
3092: ' WHERE p.party_id = stage.party_id ' ||

Line 3105: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

3101: ,p_dup_party_id, p_dup_party_id;
3102: END IF;
3103: ELSE
3104: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX3, TX4'||
3105: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
3106: ' WHERE contains( concat_col, :cont)>0'||
3107: ' AND EXISTS ('||
3108: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
3109: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_34 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2906: 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, TX3, TX4

Line 2907: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2918: 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, TX3, TX4