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

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

2079: END IF;
2080: IF p_restrict_entity = 'CONTACTS'
2081: THEN
2082: OPEN x_cursor FOR
2083: 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
2084: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2085: WHERE contains( concat_col, p_contains_str)>0
2086: AND d.search_context_id = p_search_ctx_id
2087: AND( (l_search_merged ='Y' )

Line 2084: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2080: IF p_restrict_entity = 'CONTACTS'
2081: THEN
2082: OPEN x_cursor FOR
2083: 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
2084: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2085: WHERE contains( concat_col, p_contains_str)>0
2086: AND d.search_context_id = p_search_ctx_id
2087: AND( (l_search_merged ='Y' )
2088: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2091: END IF;
2092: IF p_restrict_entity = 'PARTY_SITES'
2093: THEN
2094: OPEN x_cursor FOR
2095: 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
2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2097: WHERE contains( concat_col, p_contains_str)>0
2098: AND d.search_context_id = p_search_ctx_id
2099: AND( (l_search_merged ='Y' )

Line 2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2092: IF p_restrict_entity = 'PARTY_SITES'
2093: THEN
2094: OPEN x_cursor FOR
2095: 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
2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2097: WHERE contains( concat_col, p_contains_str)>0
2098: AND d.search_context_id = p_search_ctx_id
2099: AND( (l_search_merged ='Y' )
2100: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2112: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2108: 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);
2109: END IF;
2110: IF p_search_rel_cpts = 'N' THEN
2111: OPEN x_cursor FOR
2112: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2113: FROM HZ_STAGED_CONTACT_POINTS stage
2114: WHERE contains( concat_col, p_contains_str)>0
2115: AND( (l_search_merged ='Y' )
2116: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2113: FROM HZ_STAGED_CONTACT_POINTS stage

2109: END IF;
2110: IF p_search_rel_cpts = 'N' THEN
2111: OPEN x_cursor FOR
2112: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2113: FROM HZ_STAGED_CONTACT_POINTS stage
2114: WHERE contains( concat_col, p_contains_str)>0
2115: AND( (l_search_merged ='Y' )
2116: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2117: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2121: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

2117: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2118: AND stage.party_id = p_party_id;
2119: ELSE
2120: OPEN x_cursor FOR
2121: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2122: FROM HZ_STAGED_CONTACT_POINTS stage
2123: WHERE contains( concat_col, p_contains_str)>0
2124: AND( (l_search_merged ='Y' )
2125: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2122: FROM HZ_STAGED_CONTACT_POINTS stage

2118: AND stage.party_id = p_party_id;
2119: ELSE
2120: OPEN x_cursor FOR
2121: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2122: FROM HZ_STAGED_CONTACT_POINTS stage
2123: WHERE contains( concat_col, p_contains_str)>0
2124: AND( (l_search_merged ='Y' )
2125: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2126: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2125: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2126: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2127: AND stage.party_id = p_party_id
2128: UNION
2129: 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
2130: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2131: WHERE contains( concat_col, p_contains_str)>0
2132: AND r.object_id = p_party_id
2133: AND( (l_search_merged ='Y' )

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

2126: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2127: AND stage.party_id = p_party_id
2128: UNION
2129: 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
2130: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2131: WHERE contains( concat_col, p_contains_str)>0
2132: AND r.object_id = p_party_id
2133: AND( (l_search_merged ='Y' )
2134: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2152: FROM HZ_STAGED_CONTACT_POINTS stage

2148: 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);
2149: END IF;
2150: OPEN x_cursor FOR
2151: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2152: FROM HZ_STAGED_CONTACT_POINTS stage
2153: WHERE contains( concat_col, p_contains_str)>0
2154: AND EXISTS (
2155: SELECT 1 FROM HZ_STAGED_PARTIES p
2156: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2172: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2168: END IF;
2169: IF p_person_api = 'Y' THEN
2170: OPEN x_cursor FOR
2171: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2172: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2173: WHERE contains( concat_col, p_contains_str)>0
2174: AND d.search_context_id = p_search_ctx_id
2175: AND d.party_id = stage.party_id
2176: AND( (l_search_merged ='Y' )

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

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') )
2179: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2180: UNION
2181: 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
2182: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2183: WHERE contains( concat_col, p_contains_str)>0
2184: AND d.search_context_id = p_search_ctx_id
2185: AND d.party_id = r.subject_id

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

2178: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2179: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2180: UNION
2181: 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
2182: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2183: WHERE contains( concat_col, p_contains_str)>0
2184: AND d.search_context_id = p_search_ctx_id
2185: AND d.party_id = r.subject_id
2186: AND r.relationship_id = oc.party_relationship_id

Line 2195: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2191: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2192: ELSE
2193: OPEN x_cursor FOR
2194: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2195: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2196: WHERE contains( concat_col, p_contains_str)>0
2197: AND d.search_context_id = p_search_ctx_id
2198: AND d.party_id = stage.party_id
2199: AND( (l_search_merged ='Y' )

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

2211: IF (l_check_dt > 0 ) THEN
2212: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2213: 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);
2214: END IF;
2215: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2216: ELSIF (l_check > 0 ) THEN
2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2218: 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);
2219: END IF;

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

2216: ELSIF (l_check > 0 ) THEN
2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2218: 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);
2219: END IF;
2220: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2221: END IF;
2222: IF l_search_merged = 'Y' THEN
2223: l_status_sql := ' ' ;
2224: ELSIF l_search_merged = 'I' THEN

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

2235: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2236: ELSE
2237: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2238: END IF;
2239: 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 '||
2240: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2241: ' WHERE contains( concat_col, :cont)>0 '||
2242: ' AND (stage.org_contact_id is null '||
2243: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2240: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2236: ELSE
2237: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2238: END IF;
2239: 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 '||
2240: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2241: ' WHERE contains( concat_col, :cont)>0 '||
2242: ' AND (stage.org_contact_id is null '||
2243: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2244: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2249: ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||

2245: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2246: ' AND ('||p_restrict_sql||'))' ||
2247: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2248: ' UNION ' ||
2249: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2250: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2251: ' WHERE contains( concat_col, :cont)>0 '||
2252: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2253: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2250: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2246: ' AND ('||p_restrict_sql||'))' ||
2247: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2248: ' UNION ' ||
2249: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2250: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2251: ' WHERE contains( concat_col, :cont)>0 '||
2252: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2253: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2254: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2265: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2261: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2262: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2263: ELSE
2264: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2265: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2266: ' WHERE contains( concat_col, :cont)>0'||
2267: ' AND EXISTS ('||
2268: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2269: ' WHERE p.party_id = stage.party_id ' ||

Line 2282: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2278: ,p_dup_party_id, p_dup_party_id;
2279: END IF;
2280: ELSE
2281: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2282: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2283: ' WHERE contains( concat_col, :cont)>0'||
2284: ' AND EXISTS ('||
2285: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2286: ' WHERE p.party_id = stage.party_id ' ||