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

Line 1847: 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, TX6, TX5

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

Line 1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1859: 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, TX6, TX5

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

Line 1860: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1877: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1886: FROM HZ_STAGED_CONTACT_POINTS stage

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

Line 1893: 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, TX6, TX5

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

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

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

Line 1916: FROM HZ_STAGED_CONTACT_POINTS stage

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

Line 1935: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1931: hz_utility_v2pub.debug(p_message=>'Search_context_id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1932: END IF;
1933: IF p_person_api = 'Y' THEN
1934: OPEN x_cursor FOR
1935: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1936: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1937: WHERE contains( concat_col, p_contains_str)>0
1938: AND d.search_context_id = p_search_ctx_id
1939: AND d.party_id = stage.party_id

Line 1936: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1932: END IF;
1933: IF p_person_api = 'Y' THEN
1934: OPEN x_cursor FOR
1935: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1936: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1937: WHERE contains( concat_col, p_contains_str)>0
1938: AND d.search_context_id = p_search_ctx_id
1939: AND d.party_id = stage.party_id
1940: AND( (l_search_merged ='Y' )

Line 1945: 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, TX6, TX5

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

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

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

Line 1958: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1954: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1955: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1956: ELSE
1957: OPEN x_cursor FOR
1958: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1959: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1960: WHERE contains( concat_col, p_contains_str)>0
1961: AND d.search_context_id = p_search_ctx_id
1962: AND d.party_id = stage.party_id

Line 1959: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1955: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1956: ELSE
1957: OPEN x_cursor FOR
1958: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1959: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1960: WHERE contains( concat_col, p_contains_str)>0
1961: AND d.search_context_id = p_search_ctx_id
1962: AND d.party_id = stage.party_id
1963: AND( (l_search_merged ='Y' )

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

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

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

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

Line 2003: 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, TX6, TX5'||

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

Line 2004: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

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

2009: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2010: ' AND ('||p_restrict_sql||'))' ||
2011: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2012: ' UNION ' ||
2013: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2014: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2015: ' WHERE contains( concat_col, :cont)>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: ' AND ('||p_restrict_sql||'))' ||
2011: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2012: ' UNION ' ||
2013: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2014: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2015: ' WHERE contains( concat_col, :cont)>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 2029: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 2046: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

APPS.HZ_MATCH_RULE_41 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1847: 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, TX6, TX5

Line 1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 1859: 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, TX6, TX5