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

Line 1844: 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 , TX2

1840: END IF;
1841: IF p_restrict_entity = 'CONTACTS'
1842: THEN
1843: OPEN x_cursor FOR
1844: 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 , TX2
1845: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1846: WHERE contains( concat_col, p_contains_str)>0
1847: AND d.search_context_id = p_search_ctx_id
1848: AND( (l_search_merged ='Y' )

Line 1845: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1841: IF p_restrict_entity = 'CONTACTS'
1842: THEN
1843: OPEN x_cursor FOR
1844: 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 , TX2
1845: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1846: WHERE contains( concat_col, p_contains_str)>0
1847: AND d.search_context_id = p_search_ctx_id
1848: AND( (l_search_merged ='Y' )
1849: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1856: 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 , TX2

1852: END IF;
1853: IF p_restrict_entity = 'PARTY_SITES'
1854: THEN
1855: OPEN x_cursor FOR
1856: 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 , TX2
1857: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1858: WHERE contains( concat_col, p_contains_str)>0
1859: AND d.search_context_id = p_search_ctx_id
1860: AND( (l_search_merged ='Y' )

Line 1857: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1853: IF p_restrict_entity = 'PARTY_SITES'
1854: THEN
1855: OPEN x_cursor FOR
1856: 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 , TX2
1857: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1858: WHERE contains( concat_col, p_contains_str)>0
1859: AND d.search_context_id = p_search_ctx_id
1860: AND( (l_search_merged ='Y' )
1861: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1869: 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);
1870: END IF;
1871: IF p_search_rel_cpts = 'N' THEN
1872: OPEN x_cursor FOR
1873: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1874: FROM HZ_STAGED_CONTACT_POINTS stage
1875: WHERE contains( concat_col, p_contains_str)>0
1876: AND( (l_search_merged ='Y' )
1877: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1874: FROM HZ_STAGED_CONTACT_POINTS stage

1870: END IF;
1871: IF p_search_rel_cpts = 'N' THEN
1872: OPEN x_cursor FOR
1873: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1874: FROM HZ_STAGED_CONTACT_POINTS stage
1875: WHERE contains( concat_col, p_contains_str)>0
1876: AND( (l_search_merged ='Y' )
1877: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1878: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1878: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1879: AND stage.party_id = p_party_id;
1880: ELSE
1881: OPEN x_cursor FOR
1882: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1883: FROM HZ_STAGED_CONTACT_POINTS stage
1884: WHERE contains( concat_col, p_contains_str)>0
1885: AND( (l_search_merged ='Y' )
1886: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1883: FROM HZ_STAGED_CONTACT_POINTS stage

1879: AND stage.party_id = p_party_id;
1880: ELSE
1881: OPEN x_cursor FOR
1882: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1883: FROM HZ_STAGED_CONTACT_POINTS stage
1884: WHERE contains( concat_col, p_contains_str)>0
1885: AND( (l_search_merged ='Y' )
1886: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1887: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1890: 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 , TX2

1886: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1887: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1888: AND stage.party_id = p_party_id
1889: UNION
1890: 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 , TX2
1891: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1892: WHERE contains( concat_col, p_contains_str)>0
1893: AND r.object_id = p_party_id
1894: AND( (l_search_merged ='Y' )

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

1887: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1888: AND stage.party_id = p_party_id
1889: UNION
1890: 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 , TX2
1891: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1892: WHERE contains( concat_col, p_contains_str)>0
1893: AND r.object_id = p_party_id
1894: AND( (l_search_merged ='Y' )
1895: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1913: FROM HZ_STAGED_CONTACT_POINTS stage

1909: 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);
1910: END IF;
1911: OPEN x_cursor FOR
1912: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1913: FROM HZ_STAGED_CONTACT_POINTS stage
1914: WHERE contains( concat_col, p_contains_str)>0
1915: AND EXISTS (
1916: SELECT 1 FROM HZ_STAGED_PARTIES p
1917: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1929: END IF;
1930: IF p_person_api = 'Y' THEN
1931: OPEN x_cursor FOR
1932: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1934: WHERE contains( concat_col, p_contains_str)>0
1935: AND d.search_context_id = p_search_ctx_id
1936: AND d.party_id = stage.party_id
1937: AND( (l_search_merged ='Y' )

Line 1942: 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 , TX2

1938: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1939: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1940: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1941: UNION
1942: 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 , TX2
1943: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1944: WHERE contains( concat_col, p_contains_str)>0
1945: AND d.search_context_id = p_search_ctx_id
1946: AND d.party_id = r.subject_id

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

1939: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1940: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1941: UNION
1942: 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 , TX2
1943: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1944: WHERE contains( concat_col, p_contains_str)>0
1945: AND d.search_context_id = p_search_ctx_id
1946: AND d.party_id = r.subject_id
1947: AND r.relationship_id = oc.party_relationship_id

Line 1956: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1952: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1953: ELSE
1954: OPEN x_cursor FOR
1955: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1956: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1957: WHERE contains( concat_col, p_contains_str)>0
1958: AND d.search_context_id = p_search_ctx_id
1959: AND d.party_id = stage.party_id
1960: AND( (l_search_merged ='Y' )

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

1972: IF (l_check_dt > 0 ) THEN
1973: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1974: 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);
1975: END IF;
1976: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1977: ELSIF (l_check > 0 ) THEN
1978: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1979: 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);
1980: END IF;

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

1977: ELSIF (l_check > 0 ) THEN
1978: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1979: 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);
1980: END IF;
1981: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1982: END IF;
1983: IF l_search_merged = 'Y' THEN
1984: l_status_sql := ' ' ;
1985: ELSIF l_search_merged = 'I' THEN

Line 2000: 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 , TX2'||

1996: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1997: ELSE
1998: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1999: END IF;
2000: 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 , TX2'||
2001: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2002: ' WHERE contains( concat_col, :cont)>0 '||
2003: ' AND (stage.org_contact_id is null '||
2004: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2001: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1997: ELSE
1998: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1999: END IF;
2000: 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 , TX2'||
2001: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2002: ' WHERE contains( concat_col, :cont)>0 '||
2003: ' AND (stage.org_contact_id is null '||
2004: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2005: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

2006: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2007: ' AND ('||p_restrict_sql||'))' ||
2008: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2009: ' UNION ' ||
2010: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2'||
2011: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2012: ' WHERE contains( concat_col, :cont)>0 '||
2013: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2014: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2011: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2007: ' AND ('||p_restrict_sql||'))' ||
2008: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2009: ' UNION ' ||
2010: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2'||
2011: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2012: ' WHERE contains( concat_col, :cont)>0 '||
2013: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2014: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2015: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2026: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2022: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2023: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2024: ELSE
2025: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2'||
2026: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2027: ' WHERE contains( concat_col, :cont)>0'||
2028: ' AND EXISTS ('||
2029: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2030: ' WHERE p.party_id = stage.party_id ' ||

Line 2043: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2039: ,p_dup_party_id, p_dup_party_id;
2040: END IF;
2041: ELSE
2042: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2'||
2043: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2044: ' WHERE contains( concat_col, :cont)>0'||
2045: ' AND EXISTS ('||
2046: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2047: ' WHERE p.party_id = stage.party_id ' ||