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

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

1952: END IF;
1953: IF p_restrict_entity = 'CONTACTS'
1954: THEN
1955: OPEN x_cursor FOR
1956: 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
1957: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1958: WHERE contains( concat_col, p_contains_str)>0
1959: AND d.search_context_id = p_search_ctx_id
1960: AND( (l_search_merged ='Y' )

Line 1957: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1953: IF p_restrict_entity = 'CONTACTS'
1954: THEN
1955: OPEN x_cursor FOR
1956: 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
1957: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1958: WHERE contains( concat_col, p_contains_str)>0
1959: AND d.search_context_id = p_search_ctx_id
1960: AND( (l_search_merged ='Y' )
1961: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1964: END IF;
1965: IF p_restrict_entity = 'PARTY_SITES'
1966: THEN
1967: OPEN x_cursor FOR
1968: 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
1969: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1970: WHERE contains( concat_col, p_contains_str)>0
1971: AND d.search_context_id = p_search_ctx_id
1972: AND( (l_search_merged ='Y' )

Line 1969: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1965: IF p_restrict_entity = 'PARTY_SITES'
1966: THEN
1967: OPEN x_cursor FOR
1968: 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
1969: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1970: WHERE contains( concat_col, p_contains_str)>0
1971: AND d.search_context_id = p_search_ctx_id
1972: AND( (l_search_merged ='Y' )
1973: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1981: 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);
1982: END IF;
1983: IF p_search_rel_cpts = 'N' THEN
1984: OPEN x_cursor FOR
1985: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
1986: FROM HZ_STAGED_CONTACT_POINTS stage
1987: WHERE contains( concat_col, p_contains_str)>0
1988: AND( (l_search_merged ='Y' )
1989: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1986: FROM HZ_STAGED_CONTACT_POINTS stage

1982: END IF;
1983: IF p_search_rel_cpts = 'N' THEN
1984: OPEN x_cursor FOR
1985: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
1986: FROM HZ_STAGED_CONTACT_POINTS stage
1987: WHERE contains( concat_col, p_contains_str)>0
1988: AND( (l_search_merged ='Y' )
1989: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1990: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1990: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1991: AND stage.party_id = p_party_id;
1992: ELSE
1993: OPEN x_cursor FOR
1994: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
1995: FROM HZ_STAGED_CONTACT_POINTS stage
1996: WHERE contains( concat_col, p_contains_str)>0
1997: AND( (l_search_merged ='Y' )
1998: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1995: FROM HZ_STAGED_CONTACT_POINTS stage

1991: AND stage.party_id = p_party_id;
1992: ELSE
1993: OPEN x_cursor FOR
1994: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
1995: FROM HZ_STAGED_CONTACT_POINTS stage
1996: WHERE contains( concat_col, p_contains_str)>0
1997: AND( (l_search_merged ='Y' )
1998: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1999: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1998: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1999: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2000: AND stage.party_id = p_party_id
2001: UNION
2002: 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
2003: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2004: WHERE contains( concat_col, p_contains_str)>0
2005: AND r.object_id = p_party_id
2006: AND( (l_search_merged ='Y' )

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

1999: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2000: AND stage.party_id = p_party_id
2001: UNION
2002: 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
2003: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2004: WHERE contains( concat_col, p_contains_str)>0
2005: AND r.object_id = p_party_id
2006: AND( (l_search_merged ='Y' )
2007: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2025: FROM HZ_STAGED_CONTACT_POINTS stage

2021: 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);
2022: END IF;
2023: OPEN x_cursor FOR
2024: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2025: FROM HZ_STAGED_CONTACT_POINTS stage
2026: WHERE contains( concat_col, p_contains_str)>0
2027: AND EXISTS (
2028: SELECT 1 FROM HZ_STAGED_PARTIES p
2029: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2045: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2041: END IF;
2042: IF p_person_api = 'Y' THEN
2043: OPEN x_cursor FOR
2044: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2045: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2046: WHERE contains( concat_col, p_contains_str)>0
2047: AND d.search_context_id = p_search_ctx_id
2048: AND d.party_id = stage.party_id
2049: AND( (l_search_merged ='Y' )

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

2050: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2051: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2052: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2053: UNION
2054: 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
2055: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2056: WHERE contains( concat_col, p_contains_str)>0
2057: AND d.search_context_id = p_search_ctx_id
2058: AND d.party_id = r.subject_id

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

2051: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2052: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2053: UNION
2054: 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
2055: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2056: WHERE contains( concat_col, p_contains_str)>0
2057: AND d.search_context_id = p_search_ctx_id
2058: AND d.party_id = r.subject_id
2059: AND r.relationship_id = oc.party_relationship_id

Line 2068: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2064: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2065: ELSE
2066: OPEN x_cursor FOR
2067: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2068: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2069: WHERE contains( concat_col, p_contains_str)>0
2070: AND d.search_context_id = p_search_ctx_id
2071: AND d.party_id = stage.party_id
2072: AND( (l_search_merged ='Y' )

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

2084: IF (l_check_dt > 0 ) THEN
2085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2086: 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);
2087: END IF;
2088: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2089: ELSIF (l_check > 0 ) THEN
2090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2091: 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);
2092: END IF;

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

2089: ELSIF (l_check > 0 ) THEN
2090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2091: 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);
2092: END IF;
2093: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2094: END IF;
2095: IF l_search_merged = 'Y' THEN
2096: l_status_sql := ' ' ;
2097: ELSIF l_search_merged = 'I' THEN

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

2108: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2109: ELSE
2110: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2111: END IF;
2112: 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'||
2113: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2114: ' WHERE contains( concat_col, :cont)>0 '||
2115: ' AND (stage.org_contact_id is null '||
2116: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2113: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2109: ELSE
2110: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2111: END IF;
2112: 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'||
2113: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2114: ' WHERE contains( concat_col, :cont)>0 '||
2115: ' AND (stage.org_contact_id is null '||
2116: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2117: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2118: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2119: ' AND ('||p_restrict_sql||'))' ||
2120: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2121: ' UNION ' ||
2122: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2123: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2124: ' WHERE contains( concat_col, :cont)>0 '||
2125: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2126: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2123: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2119: ' AND ('||p_restrict_sql||'))' ||
2120: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2121: ' UNION ' ||
2122: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2123: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2124: ' WHERE contains( concat_col, :cont)>0 '||
2125: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2126: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2127: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2138: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2134: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2135: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2136: ELSE
2137: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2138: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2139: ' WHERE contains( concat_col, :cont)>0'||
2140: ' AND EXISTS ('||
2141: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2142: ' WHERE p.party_id = stage.party_id ' ||

Line 2155: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2151: ,p_dup_party_id, p_dup_party_id;
2152: END IF;
2153: ELSE
2154: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1'||
2155: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2156: ' WHERE contains( concat_col, :cont)>0'||
2157: ' AND EXISTS ('||
2158: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2159: ' WHERE p.party_id = stage.party_id ' ||