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

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

1980: END IF;
1981: IF p_restrict_entity = 'CONTACTS'
1982: THEN
1983: OPEN x_cursor FOR
1984: 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
1985: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1986: WHERE contains( concat_col, p_contains_str)>0
1987: AND d.search_context_id = p_search_ctx_id
1988: AND( (l_search_merged ='Y' )

Line 1985: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1981: IF p_restrict_entity = 'CONTACTS'
1982: THEN
1983: OPEN x_cursor FOR
1984: 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
1985: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1986: WHERE contains( concat_col, p_contains_str)>0
1987: AND d.search_context_id = p_search_ctx_id
1988: AND( (l_search_merged ='Y' )
1989: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1992: END IF;
1993: IF p_restrict_entity = 'PARTY_SITES'
1994: THEN
1995: OPEN x_cursor FOR
1996: 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
1997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1998: WHERE contains( concat_col, p_contains_str)>0
1999: AND d.search_context_id = p_search_ctx_id
2000: AND( (l_search_merged ='Y' )

Line 1997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1993: IF p_restrict_entity = 'PARTY_SITES'
1994: THEN
1995: OPEN x_cursor FOR
1996: 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
1997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1998: WHERE contains( concat_col, p_contains_str)>0
1999: AND d.search_context_id = p_search_ctx_id
2000: AND( (l_search_merged ='Y' )
2001: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2009: 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);
2010: END IF;
2011: IF p_search_rel_cpts = 'N' THEN
2012: OPEN x_cursor FOR
2013: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2014: FROM HZ_STAGED_CONTACT_POINTS stage
2015: WHERE contains( concat_col, p_contains_str)>0
2016: AND( (l_search_merged ='Y' )
2017: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2014: FROM HZ_STAGED_CONTACT_POINTS stage

2010: END IF;
2011: IF p_search_rel_cpts = 'N' THEN
2012: OPEN x_cursor FOR
2013: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2014: FROM HZ_STAGED_CONTACT_POINTS stage
2015: WHERE contains( concat_col, p_contains_str)>0
2016: AND( (l_search_merged ='Y' )
2017: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2018: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2018: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2019: AND stage.party_id = p_party_id;
2020: ELSE
2021: OPEN x_cursor FOR
2022: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2023: FROM HZ_STAGED_CONTACT_POINTS stage
2024: WHERE contains( concat_col, p_contains_str)>0
2025: AND( (l_search_merged ='Y' )
2026: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2023: FROM HZ_STAGED_CONTACT_POINTS stage

2019: AND stage.party_id = p_party_id;
2020: ELSE
2021: OPEN x_cursor FOR
2022: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2023: FROM HZ_STAGED_CONTACT_POINTS stage
2024: WHERE contains( concat_col, p_contains_str)>0
2025: AND( (l_search_merged ='Y' )
2026: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2026: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2028: AND stage.party_id = p_party_id
2029: UNION
2030: 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
2031: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2032: WHERE contains( concat_col, p_contains_str)>0
2033: AND r.object_id = p_party_id
2034: AND( (l_search_merged ='Y' )

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

2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2028: AND stage.party_id = p_party_id
2029: UNION
2030: 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
2031: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2032: WHERE contains( concat_col, p_contains_str)>0
2033: AND r.object_id = p_party_id
2034: AND( (l_search_merged ='Y' )
2035: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2053: FROM HZ_STAGED_CONTACT_POINTS stage

2049: 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);
2050: END IF;
2051: OPEN x_cursor FOR
2052: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2053: FROM HZ_STAGED_CONTACT_POINTS stage
2054: WHERE contains( concat_col, p_contains_str)>0
2055: AND EXISTS (
2056: SELECT 1 FROM HZ_STAGED_PARTIES p
2057: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2073: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2069: END IF;
2070: IF p_person_api = 'Y' THEN
2071: OPEN x_cursor FOR
2072: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2073: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2074: WHERE contains( concat_col, p_contains_str)>0
2075: AND d.search_context_id = p_search_ctx_id
2076: AND d.party_id = stage.party_id
2077: AND( (l_search_merged ='Y' )

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

2078: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2079: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2080: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2081: UNION
2082: 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
2083: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2084: WHERE contains( concat_col, p_contains_str)>0
2085: AND d.search_context_id = p_search_ctx_id
2086: AND d.party_id = r.subject_id

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

2079: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2080: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2081: UNION
2082: 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
2083: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2084: WHERE contains( concat_col, p_contains_str)>0
2085: AND d.search_context_id = p_search_ctx_id
2086: AND d.party_id = r.subject_id
2087: AND r.relationship_id = oc.party_relationship_id

Line 2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2092: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2093: ELSE
2094: OPEN x_cursor FOR
2095: SELECT 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 d.party_id = stage.party_id
2100: AND( (l_search_merged ='Y' )

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

2112: IF (l_check_dt > 0 ) THEN
2113: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2114: 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);
2115: END IF;
2116: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2117: ELSIF (l_check > 0 ) THEN
2118: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2119: 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);
2120: END IF;

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

2117: ELSIF (l_check > 0 ) THEN
2118: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2119: 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);
2120: END IF;
2121: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2122: END IF;
2123: IF l_search_merged = 'Y' THEN
2124: l_status_sql := ' ' ;
2125: ELSIF l_search_merged = 'I' THEN

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

2136: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2137: ELSE
2138: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2139: END IF;
2140: 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 '||
2141: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2142: ' WHERE contains( concat_col, :cont)>0 '||
2143: ' AND (stage.org_contact_id is null '||
2144: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2141: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2137: ELSE
2138: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2139: END IF;
2140: 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 '||
2141: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2142: ' WHERE contains( concat_col, :cont)>0 '||
2143: ' AND (stage.org_contact_id is null '||
2144: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2145: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2146: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2147: ' AND ('||p_restrict_sql||'))' ||
2148: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2149: ' UNION ' ||
2150: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2151: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2152: ' WHERE contains( concat_col, :cont)>0 '||
2153: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2154: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2151: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2147: ' AND ('||p_restrict_sql||'))' ||
2148: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2149: ' UNION ' ||
2150: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2151: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2152: ' WHERE contains( concat_col, :cont)>0 '||
2153: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2154: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2155: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2166: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2162: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2163: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2164: ELSE
2165: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2166: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2167: ' WHERE contains( concat_col, :cont)>0'||
2168: ' AND EXISTS ('||
2169: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2170: ' WHERE p.party_id = stage.party_id ' ||

Line 2183: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2179: ,p_dup_party_id, p_dup_party_id;
2180: END IF;
2181: ELSE
2182: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2183: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2184: ' WHERE contains( concat_col, :cont)>0'||
2185: ' AND EXISTS ('||
2186: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2187: ' WHERE p.party_id = stage.party_id ' ||