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

Line 1889: 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 , TX8, TX7

1885: END IF;
1886: IF p_restrict_entity = 'CONTACTS'
1887: THEN
1888: OPEN x_cursor FOR
1889: 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 , TX8, TX7
1890: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1891: WHERE contains( concat_col, p_contains_str)>0
1892: AND d.search_context_id = p_search_ctx_id
1893: AND( (l_search_merged ='Y' )

Line 1890: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1886: IF p_restrict_entity = 'CONTACTS'
1887: THEN
1888: OPEN x_cursor FOR
1889: 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 , TX8, TX7
1890: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1891: WHERE contains( concat_col, p_contains_str)>0
1892: AND d.search_context_id = p_search_ctx_id
1893: AND( (l_search_merged ='Y' )
1894: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1901: 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 , TX8, TX7

1897: END IF;
1898: IF p_restrict_entity = 'PARTY_SITES'
1899: THEN
1900: OPEN x_cursor FOR
1901: 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 , TX8, TX7
1902: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1903: WHERE contains( concat_col, p_contains_str)>0
1904: AND d.search_context_id = p_search_ctx_id
1905: AND( (l_search_merged ='Y' )

Line 1902: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1898: IF p_restrict_entity = 'PARTY_SITES'
1899: THEN
1900: OPEN x_cursor FOR
1901: 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 , TX8, TX7
1902: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1903: WHERE contains( concat_col, p_contains_str)>0
1904: AND d.search_context_id = p_search_ctx_id
1905: AND( (l_search_merged ='Y' )
1906: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1914: 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);
1915: END IF;
1916: IF p_search_rel_cpts = 'N' THEN
1917: OPEN x_cursor FOR
1918: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1919: FROM HZ_STAGED_CONTACT_POINTS stage
1920: WHERE contains( concat_col, p_contains_str)>0
1921: AND( (l_search_merged ='Y' )
1922: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1919: FROM HZ_STAGED_CONTACT_POINTS stage

1915: END IF;
1916: IF p_search_rel_cpts = 'N' THEN
1917: OPEN x_cursor FOR
1918: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1919: FROM HZ_STAGED_CONTACT_POINTS stage
1920: WHERE contains( concat_col, p_contains_str)>0
1921: AND( (l_search_merged ='Y' )
1922: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1923: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1923: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1924: AND stage.party_id = p_party_id;
1925: ELSE
1926: OPEN x_cursor FOR
1927: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1928: FROM HZ_STAGED_CONTACT_POINTS stage
1929: WHERE contains( concat_col, p_contains_str)>0
1930: AND( (l_search_merged ='Y' )
1931: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1928: FROM HZ_STAGED_CONTACT_POINTS stage

1924: AND stage.party_id = p_party_id;
1925: ELSE
1926: OPEN x_cursor FOR
1927: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1928: FROM HZ_STAGED_CONTACT_POINTS stage
1929: WHERE contains( concat_col, p_contains_str)>0
1930: AND( (l_search_merged ='Y' )
1931: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1932: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1935: 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 , TX8, TX7

1931: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1932: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1933: AND stage.party_id = p_party_id
1934: UNION
1935: 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 , TX8, TX7
1936: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1937: WHERE contains( concat_col, p_contains_str)>0
1938: AND r.object_id = p_party_id
1939: AND( (l_search_merged ='Y' )

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

1932: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1933: AND stage.party_id = p_party_id
1934: UNION
1935: 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 , TX8, TX7
1936: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1937: WHERE contains( concat_col, p_contains_str)>0
1938: AND r.object_id = p_party_id
1939: AND( (l_search_merged ='Y' )
1940: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1958: FROM HZ_STAGED_CONTACT_POINTS stage

1954: 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);
1955: END IF;
1956: OPEN x_cursor FOR
1957: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1958: FROM HZ_STAGED_CONTACT_POINTS stage
1959: WHERE contains( concat_col, p_contains_str)>0
1960: AND EXISTS (
1961: SELECT 1 FROM HZ_STAGED_PARTIES p
1962: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1978: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1974: END IF;
1975: IF p_person_api = 'Y' THEN
1976: OPEN x_cursor FOR
1977: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1978: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1979: WHERE contains( concat_col, p_contains_str)>0
1980: AND d.search_context_id = p_search_ctx_id
1981: AND d.party_id = stage.party_id
1982: AND( (l_search_merged ='Y' )

Line 1987: 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 , TX8, TX7

1983: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1984: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1985: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1986: UNION
1987: 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 , TX8, TX7
1988: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1989: WHERE contains( concat_col, p_contains_str)>0
1990: AND d.search_context_id = p_search_ctx_id
1991: AND d.party_id = r.subject_id

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

1984: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1985: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1986: UNION
1987: 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 , TX8, TX7
1988: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1989: WHERE contains( concat_col, p_contains_str)>0
1990: AND d.search_context_id = p_search_ctx_id
1991: AND d.party_id = r.subject_id
1992: AND r.relationship_id = oc.party_relationship_id

Line 2001: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1997: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1998: ELSE
1999: OPEN x_cursor FOR
2000: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
2001: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2002: WHERE contains( concat_col, p_contains_str)>0
2003: AND d.search_context_id = p_search_ctx_id
2004: AND d.party_id = stage.party_id
2005: AND( (l_search_merged ='Y' )

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

2017: IF (l_check_dt > 0 ) THEN
2018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2019: 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);
2020: END IF;
2021: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2022: ELSIF (l_check > 0 ) THEN
2023: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2024: 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);
2025: END IF;

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

2022: ELSIF (l_check > 0 ) THEN
2023: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2024: 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);
2025: END IF;
2026: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2027: END IF;
2028: IF l_search_merged = 'Y' THEN
2029: l_status_sql := ' ' ;
2030: ELSIF l_search_merged = 'I' THEN

Line 2045: 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 , TX8, TX7'||

2041: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2042: ELSE
2043: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2044: END IF;
2045: 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 , TX8, TX7'||
2046: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2047: ' WHERE contains( concat_col, :cont)>0 '||
2048: ' AND (stage.org_contact_id is null '||
2049: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2046: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2042: ELSE
2043: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2044: END IF;
2045: 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 , TX8, TX7'||
2046: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2047: ' WHERE contains( concat_col, :cont)>0 '||
2048: ' AND (stage.org_contact_id is null '||
2049: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2050: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2051: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2052: ' AND ('||p_restrict_sql||'))' ||
2053: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2054: ' UNION ' ||
2055: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7'||
2056: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2057: ' WHERE contains( concat_col, :cont)>0 '||
2058: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2059: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2056: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2052: ' AND ('||p_restrict_sql||'))' ||
2053: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2054: ' UNION ' ||
2055: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7'||
2056: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2057: ' WHERE contains( concat_col, :cont)>0 '||
2058: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2059: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2060: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2071: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2067: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2068: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2069: ELSE
2070: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7'||
2071: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2072: ' WHERE contains( concat_col, :cont)>0'||
2073: ' AND EXISTS ('||
2074: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2075: ' WHERE p.party_id = stage.party_id ' ||

Line 2088: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2084: ,p_dup_party_id, p_dup_party_id;
2085: END IF;
2086: ELSE
2087: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7'||
2088: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2089: ' WHERE contains( concat_col, :cont)>0'||
2090: ' AND EXISTS ('||
2091: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2092: ' WHERE p.party_id = stage.party_id ' ||