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

Line 2144: 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, TX5, TX6, TX8

2140: END IF;
2141: IF p_restrict_entity = 'CONTACTS'
2142: THEN
2143: OPEN x_cursor FOR
2144: 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, TX5, TX6, TX8
2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2146: WHERE contains( concat_col, p_contains_str)>0
2147: AND d.search_context_id = p_search_ctx_id
2148: AND( (l_search_merged ='Y' )

Line 2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2141: IF p_restrict_entity = 'CONTACTS'
2142: THEN
2143: OPEN x_cursor FOR
2144: 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, TX5, TX6, TX8
2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2146: WHERE contains( concat_col, p_contains_str)>0
2147: AND d.search_context_id = p_search_ctx_id
2148: AND( (l_search_merged ='Y' )
2149: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2156: 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, TX5, TX6, TX8

2152: END IF;
2153: IF p_restrict_entity = 'PARTY_SITES'
2154: THEN
2155: OPEN x_cursor FOR
2156: 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, TX5, TX6, TX8
2157: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2158: WHERE contains( concat_col, p_contains_str)>0
2159: AND d.search_context_id = p_search_ctx_id
2160: AND( (l_search_merged ='Y' )

Line 2157: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2153: IF p_restrict_entity = 'PARTY_SITES'
2154: THEN
2155: OPEN x_cursor FOR
2156: 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, TX5, TX6, TX8
2157: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2158: WHERE contains( concat_col, p_contains_str)>0
2159: AND d.search_context_id = p_search_ctx_id
2160: AND( (l_search_merged ='Y' )
2161: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2173: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8

2169: 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);
2170: END IF;
2171: IF p_search_rel_cpts = 'N' THEN
2172: OPEN x_cursor FOR
2173: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2174: FROM HZ_STAGED_CONTACT_POINTS stage
2175: WHERE contains( concat_col, p_contains_str)>0
2176: AND( (l_search_merged ='Y' )
2177: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2174: FROM HZ_STAGED_CONTACT_POINTS stage

2170: END IF;
2171: IF p_search_rel_cpts = 'N' THEN
2172: OPEN x_cursor FOR
2173: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2174: FROM HZ_STAGED_CONTACT_POINTS stage
2175: WHERE contains( concat_col, p_contains_str)>0
2176: AND( (l_search_merged ='Y' )
2177: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2178: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2182: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8

2178: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2179: AND stage.party_id = p_party_id;
2180: ELSE
2181: OPEN x_cursor FOR
2182: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2183: FROM HZ_STAGED_CONTACT_POINTS stage
2184: WHERE contains( concat_col, p_contains_str)>0
2185: AND( (l_search_merged ='Y' )
2186: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2183: FROM HZ_STAGED_CONTACT_POINTS stage

2179: AND stage.party_id = p_party_id;
2180: ELSE
2181: OPEN x_cursor FOR
2182: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2183: FROM HZ_STAGED_CONTACT_POINTS stage
2184: WHERE contains( concat_col, p_contains_str)>0
2185: AND( (l_search_merged ='Y' )
2186: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2187: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2190: 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, TX5, TX6, TX8

2186: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2187: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2188: AND stage.party_id = p_party_id
2189: UNION
2190: 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, TX5, TX6, TX8
2191: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2192: WHERE contains( concat_col, p_contains_str)>0
2193: AND r.object_id = p_party_id
2194: AND( (l_search_merged ='Y' )

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

2187: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2188: AND stage.party_id = p_party_id
2189: UNION
2190: 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, TX5, TX6, TX8
2191: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2192: WHERE contains( concat_col, p_contains_str)>0
2193: AND r.object_id = p_party_id
2194: AND( (l_search_merged ='Y' )
2195: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2213: FROM HZ_STAGED_CONTACT_POINTS stage

2209: 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);
2210: END IF;
2211: OPEN x_cursor FOR
2212: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2213: FROM HZ_STAGED_CONTACT_POINTS stage
2214: WHERE contains( concat_col, p_contains_str)>0
2215: AND EXISTS (
2216: SELECT 1 FROM HZ_STAGED_PARTIES p
2217: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2232: 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, TX5, TX6, TX8

2228: 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);
2229: END IF;
2230: IF p_person_api = 'Y' THEN
2231: OPEN x_cursor FOR
2232: 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, TX5, TX6, TX8
2233: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2234: WHERE contains( concat_col, p_contains_str)>0
2235: AND d.search_context_id = p_search_ctx_id
2236: AND d.party_id = stage.party_id

Line 2233: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2229: END IF;
2230: IF p_person_api = 'Y' THEN
2231: OPEN x_cursor FOR
2232: 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, TX5, TX6, TX8
2233: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2234: WHERE contains( concat_col, p_contains_str)>0
2235: AND d.search_context_id = p_search_ctx_id
2236: AND d.party_id = stage.party_id
2237: AND( (l_search_merged ='Y' )

Line 2242: 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, TX5, TX6, TX8

2238: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2239: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2240: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2241: UNION
2242: 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, TX5, TX6, TX8
2243: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2244: WHERE contains( concat_col, p_contains_str)>0
2245: AND d.search_context_id = p_search_ctx_id
2246: AND d.party_id = r.subject_id

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

2239: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2240: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2241: UNION
2242: 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, TX5, TX6, TX8
2243: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2244: WHERE contains( concat_col, p_contains_str)>0
2245: AND d.search_context_id = p_search_ctx_id
2246: AND d.party_id = r.subject_id
2247: AND r.relationship_id = oc.party_relationship_id

Line 2255: 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, TX5, TX6, TX8

2251: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2252: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2253: ELSE
2254: OPEN x_cursor FOR
2255: 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, TX5, TX6, TX8
2256: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2257: WHERE contains( concat_col, p_contains_str)>0
2258: AND d.search_context_id = p_search_ctx_id
2259: AND d.party_id = stage.party_id

Line 2256: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2252: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2253: ELSE
2254: OPEN x_cursor FOR
2255: 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, TX5, TX6, TX8
2256: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2257: WHERE contains( concat_col, p_contains_str)>0
2258: AND d.search_context_id = p_search_ctx_id
2259: AND d.party_id = stage.party_id
2260: AND( (l_search_merged ='Y' )

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

2272: IF (l_check_dt > 0 ) THEN
2273: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2274: 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);
2275: END IF;
2276: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2277: ELSIF (l_check > 0 ) THEN
2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2279: 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);
2280: END IF;

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

2277: ELSIF (l_check > 0 ) THEN
2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2279: 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);
2280: END IF;
2281: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2282: END IF;
2283: IF l_search_merged = 'Y' THEN
2284: l_status_sql := ' ' ;
2285: ELSIF l_search_merged = 'I' THEN

Line 2300: 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, TX5, TX6, TX8'||

2296: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2297: ELSE
2298: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2299: END IF;
2300: 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, TX5, TX6, TX8'||
2301: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2302: ' WHERE contains( concat_col, :cont)>0 '||
2303: ' AND (stage.org_contact_id is null '||
2304: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2301: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2297: ELSE
2298: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2299: END IF;
2300: 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, TX5, TX6, TX8'||
2301: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2302: ' WHERE contains( concat_col, :cont)>0 '||
2303: ' AND (stage.org_contact_id is null '||
2304: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2305: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2306: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2307: ' AND ('||p_restrict_sql||'))' ||
2308: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2309: ' UNION ' ||
2310: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8'||
2311: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2312: ' WHERE contains( concat_col, :cont)>0 '||
2313: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2314: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2311: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2307: ' AND ('||p_restrict_sql||'))' ||
2308: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2309: ' UNION ' ||
2310: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8'||
2311: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2312: ' WHERE contains( concat_col, :cont)>0 '||
2313: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2314: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2315: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2326: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2322: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2323: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2324: ELSE
2325: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8'||
2326: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2327: ' WHERE contains( concat_col, :cont)>0'||
2328: ' AND EXISTS ('||
2329: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2330: ' WHERE p.party_id = stage.party_id ' ||

Line 2343: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2339: ,p_dup_party_id, p_dup_party_id;
2340: END IF;
2341: ELSE
2342: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8'||
2343: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2344: ' WHERE contains( concat_col, :cont)>0'||
2345: ' AND EXISTS ('||
2346: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2347: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_8 dependencies on HZ_STAGED_CONTACT_POINTS

Line 2144: 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, TX5, TX6, TX8

Line 2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 2156: 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, TX5, TX6, TX8