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

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

1906: END IF;
1907: IF p_restrict_entity = 'CONTACTS'
1908: THEN
1909: OPEN x_cursor FOR
1910: 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
1911: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1912: WHERE contains( concat_col, p_contains_str)>0
1913: AND d.search_context_id = p_search_ctx_id
1914: AND( (l_search_merged ='Y' )

Line 1911: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1907: IF p_restrict_entity = 'CONTACTS'
1908: THEN
1909: OPEN x_cursor FOR
1910: 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
1911: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1912: WHERE contains( concat_col, p_contains_str)>0
1913: AND d.search_context_id = p_search_ctx_id
1914: AND( (l_search_merged ='Y' )
1915: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1918: END IF;
1919: IF p_restrict_entity = 'PARTY_SITES'
1920: THEN
1921: OPEN x_cursor FOR
1922: 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
1923: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1924: WHERE contains( concat_col, p_contains_str)>0
1925: AND d.search_context_id = p_search_ctx_id
1926: AND( (l_search_merged ='Y' )

Line 1923: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1919: IF p_restrict_entity = 'PARTY_SITES'
1920: THEN
1921: OPEN x_cursor FOR
1922: 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
1923: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1924: WHERE contains( concat_col, p_contains_str)>0
1925: AND d.search_context_id = p_search_ctx_id
1926: AND( (l_search_merged ='Y' )
1927: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1935: 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);
1936: END IF;
1937: IF p_search_rel_cpts = 'N' THEN
1938: OPEN x_cursor FOR
1939: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1940: FROM HZ_STAGED_CONTACT_POINTS stage
1941: WHERE contains( concat_col, p_contains_str)>0
1942: AND( (l_search_merged ='Y' )
1943: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1940: FROM HZ_STAGED_CONTACT_POINTS stage

1936: END IF;
1937: IF p_search_rel_cpts = 'N' THEN
1938: OPEN x_cursor FOR
1939: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1940: FROM HZ_STAGED_CONTACT_POINTS stage
1941: WHERE contains( concat_col, p_contains_str)>0
1942: AND( (l_search_merged ='Y' )
1943: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1944: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1944: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1945: AND stage.party_id = p_party_id;
1946: ELSE
1947: OPEN x_cursor FOR
1948: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1949: FROM HZ_STAGED_CONTACT_POINTS stage
1950: WHERE contains( concat_col, p_contains_str)>0
1951: AND( (l_search_merged ='Y' )
1952: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1949: FROM HZ_STAGED_CONTACT_POINTS stage

1945: AND stage.party_id = p_party_id;
1946: ELSE
1947: OPEN x_cursor FOR
1948: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1949: FROM HZ_STAGED_CONTACT_POINTS stage
1950: WHERE contains( concat_col, p_contains_str)>0
1951: AND( (l_search_merged ='Y' )
1952: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1953: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1952: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1953: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1954: AND stage.party_id = p_party_id
1955: UNION
1956: 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
1957: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1958: WHERE contains( concat_col, p_contains_str)>0
1959: AND r.object_id = p_party_id
1960: AND( (l_search_merged ='Y' )

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

1953: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1954: AND stage.party_id = p_party_id
1955: UNION
1956: 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
1957: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1958: WHERE contains( concat_col, p_contains_str)>0
1959: AND r.object_id = p_party_id
1960: AND( (l_search_merged ='Y' )
1961: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1979: FROM HZ_STAGED_CONTACT_POINTS stage

1975: 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);
1976: END IF;
1977: OPEN x_cursor FOR
1978: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1979: FROM HZ_STAGED_CONTACT_POINTS stage
1980: WHERE contains( concat_col, p_contains_str)>0
1981: AND EXISTS (
1982: SELECT 1 FROM HZ_STAGED_PARTIES p
1983: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1999: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1995: END IF;
1996: IF p_person_api = 'Y' THEN
1997: OPEN x_cursor FOR
1998: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1999: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2000: WHERE contains( concat_col, p_contains_str)>0
2001: AND d.search_context_id = p_search_ctx_id
2002: AND d.party_id = stage.party_id
2003: AND( (l_search_merged ='Y' )

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

2004: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2005: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2006: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2007: UNION
2008: 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
2009: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2010: WHERE contains( concat_col, p_contains_str)>0
2011: AND d.search_context_id = p_search_ctx_id
2012: AND d.party_id = r.subject_id

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

2005: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2006: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2007: UNION
2008: 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
2009: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2010: WHERE contains( concat_col, p_contains_str)>0
2011: AND d.search_context_id = p_search_ctx_id
2012: AND d.party_id = r.subject_id
2013: AND r.relationship_id = oc.party_relationship_id

Line 2022: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2018: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2019: ELSE
2020: OPEN x_cursor FOR
2021: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2022: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2023: WHERE contains( concat_col, p_contains_str)>0
2024: AND d.search_context_id = p_search_ctx_id
2025: AND d.party_id = stage.party_id
2026: AND( (l_search_merged ='Y' )

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

2038: IF (l_check_dt > 0 ) THEN
2039: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2040: 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);
2041: END IF;
2042: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2043: ELSIF (l_check > 0 ) THEN
2044: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2045: 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);
2046: END IF;

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

2043: ELSIF (l_check > 0 ) THEN
2044: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2045: 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);
2046: END IF;
2047: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2048: END IF;
2049: IF l_search_merged = 'Y' THEN
2050: l_status_sql := ' ' ;
2051: ELSIF l_search_merged = 'I' THEN

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

2062: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2063: ELSE
2064: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2065: END IF;
2066: 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 '||
2067: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2068: ' WHERE contains( concat_col, :cont)>0 '||
2069: ' AND (stage.org_contact_id is null '||
2070: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2067: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2063: ELSE
2064: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2065: END IF;
2066: 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 '||
2067: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2068: ' WHERE contains( concat_col, :cont)>0 '||
2069: ' AND (stage.org_contact_id is null '||
2070: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2071: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2072: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2073: ' AND ('||p_restrict_sql||'))' ||
2074: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2075: ' UNION ' ||
2076: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2077: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2078: ' WHERE contains( concat_col, :cont)>0 '||
2079: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2080: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2077: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2073: ' AND ('||p_restrict_sql||'))' ||
2074: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2075: ' UNION ' ||
2076: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2077: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2078: ' WHERE contains( concat_col, :cont)>0 '||
2079: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2080: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2081: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2092: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2088: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2089: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2090: ELSE
2091: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2092: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2093: ' WHERE contains( concat_col, :cont)>0'||
2094: ' AND EXISTS ('||
2095: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2096: ' WHERE p.party_id = stage.party_id ' ||

Line 2109: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2105: ,p_dup_party_id, p_dup_party_id;
2106: END IF;
2107: ELSE
2108: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
2109: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2110: ' WHERE contains( concat_col, :cont)>0'||
2111: ' AND EXISTS ('||
2112: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2113: ' WHERE p.party_id = stage.party_id ' ||