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_PARTY_SITES

Line 2144: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22

2140: 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);
2141: END IF;
2142: IF p_search_rel_sites = 'N' THEN
2143: OPEN x_cursor FOR
2144: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2145: FROM HZ_STAGED_PARTY_SITES stage
2146: WHERE contains( concat_col, p_contains_str)>0
2147: AND( (l_search_merged ='Y' )
2148: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2145: FROM HZ_STAGED_PARTY_SITES stage

2141: END IF;
2142: IF p_search_rel_sites = 'N' THEN
2143: OPEN x_cursor FOR
2144: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2145: FROM HZ_STAGED_PARTY_SITES stage
2146: WHERE contains( concat_col, p_contains_str)>0
2147: AND( (l_search_merged ='Y' )
2148: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2149: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2153: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22

2149: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2150: AND stage.party_id = p_party_id;
2151: ELSE
2152: OPEN x_cursor FOR
2153: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2154: FROM HZ_STAGED_PARTY_SITES stage
2155: WHERE contains( concat_col, p_contains_str)>0
2156: AND( (l_search_merged ='Y' )
2157: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2154: FROM HZ_STAGED_PARTY_SITES stage

2150: AND stage.party_id = p_party_id;
2151: ELSE
2152: OPEN x_cursor FOR
2153: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2154: FROM HZ_STAGED_PARTY_SITES stage
2155: WHERE contains( concat_col, p_contains_str)>0
2156: AND( (l_search_merged ='Y' )
2157: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2158: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2161: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22

2157: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2158: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2159: AND stage.party_id = p_party_id
2160: UNION
2161: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2162: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2163: WHERE contains( concat_col, p_contains_str)>0
2164: AND( (l_search_merged ='Y' )
2165: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2162: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

2158: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2159: AND stage.party_id = p_party_id
2160: UNION
2161: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2162: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2163: WHERE contains( concat_col, p_contains_str)>0
2164: AND( (l_search_merged ='Y' )
2165: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2166: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2184: FROM HZ_STAGED_PARTY_SITES stage

2180: hz_utility_v2pub.debug(p_message=>'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);
2181: END IF;
2182: OPEN x_cursor FOR
2183: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2184: FROM HZ_STAGED_PARTY_SITES stage
2185: WHERE contains( concat_col, p_contains_str)>0
2186: AND EXISTS (
2187: SELECT 1 FROM HZ_STAGED_PARTIES p
2188: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2204: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2200: END IF;
2201: IF p_person_api = 'Y' THEN
2202: OPEN x_cursor FOR
2203: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2204: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2205: WHERE contains( concat_col, p_contains_str)>0
2206: AND( (l_search_merged ='Y' )
2207: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2208: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2213: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22

2209: AND d.search_context_id = p_search_ctx_id
2210: AND d.party_id = stage.party_id
2211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2212: UNION
2213: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2214: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2215: WHERE contains( concat_col, p_contains_str)>0
2216: AND( (l_search_merged ='Y' )
2217: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2214: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

2210: AND d.party_id = stage.party_id
2211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2212: UNION
2213: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2214: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2215: WHERE contains( concat_col, p_contains_str)>0
2216: AND( (l_search_merged ='Y' )
2217: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2218: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2227: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2223: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2224: ELSE
2225: OPEN x_cursor FOR
2226: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2227: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2228: WHERE contains( concat_col, p_contains_str)>0
2229: AND( (l_search_merged ='Y' )
2230: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2231: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2247: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

2243: IF (l_check_dt > 0 ) THEN
2244: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2245: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ps hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2246: END IF;
2247: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2248: ELSIF (l_check > 0 ) THEN
2249: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2250: 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);
2251: END IF;

Line 2252: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) /';

2248: ELSIF (l_check > 0 ) THEN
2249: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2250: 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);
2251: END IF;
2252: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2253: END IF;
2254: IF l_search_merged = 'Y' THEN
2255: l_status_sql := ' ' ;
2256: ELSIF l_search_merged = 'I' THEN

Line 2271: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||

2267: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2268: ELSE
2269: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2270: END IF;
2271: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||
2272: ' FROM HZ_STAGED_PARTY_SITES stage'||
2273: ' WHERE contains( concat_col, :cont)>0'||
2274: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2275: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2272: ' FROM HZ_STAGED_PARTY_SITES stage'||

2268: ELSE
2269: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2270: END IF;
2271: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||
2272: ' FROM HZ_STAGED_PARTY_SITES stage'||
2273: ' WHERE contains( concat_col, :cont)>0'||
2274: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2275: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2276: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2281: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||

2277: ' AND (ORG_CONTACT_ID IS NULL ' ||
2278: ' AND ('||p_restrict_sql||'))' ||
2279: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2280: ' UNION ' ||
2281: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||
2282: ' FROM HZ_STAGED_PARTY_SITES stage'||
2283: ' WHERE contains( concat_col, :cont)>0'||
2284: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2285: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2282: ' FROM HZ_STAGED_PARTY_SITES stage'||

2278: ' AND ('||p_restrict_sql||'))' ||
2279: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2280: ' UNION ' ||
2281: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||
2282: ' FROM HZ_STAGED_PARTY_SITES stage'||
2283: ' WHERE contains( concat_col, :cont)>0'||
2284: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2285: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2286: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2297: ' FROM HZ_STAGED_PARTY_SITES stage'||

2293: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2294: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2295: ELSE
2296: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||
2297: ' FROM HZ_STAGED_PARTY_SITES stage'||
2298: ' WHERE contains( concat_col, :cont)>0'||
2299: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2300: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2301: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2314: ' FROM HZ_STAGED_PARTY_SITES stage'||

2310: ,p_dup_party_id, p_dup_party_id;
2311: END IF;
2312: ELSE
2313: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22'||
2314: ' FROM HZ_STAGED_PARTY_SITES stage'||
2315: ' WHERE contains( concat_col, :cont)>0'||
2316: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2317: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2318: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||