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 2142: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22

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

Line 2143: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 2152: FROM HZ_STAGED_PARTY_SITES stage

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

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

2155: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2156: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2157: AND stage.party_id = p_party_id
2158: UNION
2159: 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
2160: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2161: WHERE contains( concat_col, p_contains_str)>0
2162: AND( (l_search_merged ='Y' )
2163: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2156: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2157: AND stage.party_id = p_party_id
2158: UNION
2159: 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
2160: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2161: WHERE contains( concat_col, p_contains_str)>0
2162: AND( (l_search_merged ='Y' )
2163: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2164: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2182: FROM HZ_STAGED_PARTY_SITES stage

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

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

2197: 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);
2198: END IF;
2199: IF p_person_api = 'Y' THEN
2200: OPEN x_cursor FOR
2201: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2202: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2203: WHERE contains( concat_col, p_contains_str)>0
2204: AND( (l_search_merged ='Y' )
2205: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2202: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

2207: AND d.search_context_id = p_search_ctx_id
2208: AND d.party_id = stage.party_id
2209: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2210: UNION
2211: 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
2212: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2213: WHERE contains( concat_col, p_contains_str)>0
2214: AND( (l_search_merged ='Y' )
2215: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2208: AND d.party_id = stage.party_id
2209: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2210: UNION
2211: 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
2212: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2213: WHERE contains( concat_col, p_contains_str)>0
2214: AND( (l_search_merged ='Y' )
2215: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2216: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2220: AND oc.org_contact_id = stage.org_contact_id
2221: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2222: ELSE
2223: OPEN x_cursor FOR
2224: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2225: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2226: WHERE contains( concat_col, p_contains_str)>0
2227: AND( (l_search_merged ='Y' )
2228: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2225: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

2241: IF (l_check_dt > 0 ) THEN
2242: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2243: 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);
2244: END IF;
2245: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2246: ELSIF (l_check > 0 ) THEN
2247: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2248: 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);
2249: END IF;

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

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

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

2265: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2266: ELSE
2267: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2268: END IF;
2269: 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'||
2270: ' FROM HZ_STAGED_PARTY_SITES stage'||
2271: ' WHERE contains( concat_col, :cont)>0'||
2272: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2273: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2270: ' FROM HZ_STAGED_PARTY_SITES stage'||

2266: ELSE
2267: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2268: END IF;
2269: 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'||
2270: ' FROM HZ_STAGED_PARTY_SITES stage'||
2271: ' WHERE contains( concat_col, :cont)>0'||
2272: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2273: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2274: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

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

Line 2280: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 2295: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 2312: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_32 dependencies on HZ_STAGED_PARTY_SITES

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