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

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

1830: END IF;
1831: IF p_restrict_entity = 'CONTACTS'
1832: THEN
1833: OPEN x_cursor FOR
1834: 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
1835: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1836: WHERE contains( concat_col, p_contains_str)>0
1837: AND d.search_context_id = p_search_ctx_id
1838: AND( (l_search_merged ='Y' )

Line 1835: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1831: IF p_restrict_entity = 'CONTACTS'
1832: THEN
1833: OPEN x_cursor FOR
1834: 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
1835: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1836: WHERE contains( concat_col, p_contains_str)>0
1837: AND d.search_context_id = p_search_ctx_id
1838: AND( (l_search_merged ='Y' )
1839: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

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

Line 1847: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

1859: 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);
1860: END IF;
1861: IF p_search_rel_cpts = 'N' THEN
1862: OPEN x_cursor FOR
1863: 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
1864: FROM HZ_STAGED_CONTACT_POINTS stage
1865: WHERE contains( concat_col, p_contains_str)>0
1866: AND( (l_search_merged ='Y' )
1867: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1864: FROM HZ_STAGED_CONTACT_POINTS stage

1860: END IF;
1861: IF p_search_rel_cpts = 'N' THEN
1862: OPEN x_cursor FOR
1863: 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
1864: FROM HZ_STAGED_CONTACT_POINTS stage
1865: WHERE contains( concat_col, p_contains_str)>0
1866: AND( (l_search_merged ='Y' )
1867: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1868: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1868: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1869: AND stage.party_id = p_party_id;
1870: ELSE
1871: OPEN x_cursor FOR
1872: 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
1873: FROM HZ_STAGED_CONTACT_POINTS stage
1874: WHERE contains( concat_col, p_contains_str)>0
1875: AND( (l_search_merged ='Y' )
1876: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1873: FROM HZ_STAGED_CONTACT_POINTS stage

1869: AND stage.party_id = p_party_id;
1870: ELSE
1871: OPEN x_cursor FOR
1872: 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
1873: FROM HZ_STAGED_CONTACT_POINTS stage
1874: WHERE contains( concat_col, p_contains_str)>0
1875: AND( (l_search_merged ='Y' )
1876: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1877: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1876: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1877: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1878: AND stage.party_id = p_party_id
1879: UNION
1880: 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
1881: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1882: WHERE contains( concat_col, p_contains_str)>0
1883: AND r.object_id = p_party_id
1884: AND( (l_search_merged ='Y' )

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

1877: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1878: AND stage.party_id = p_party_id
1879: UNION
1880: 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
1881: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1882: WHERE contains( concat_col, p_contains_str)>0
1883: AND r.object_id = p_party_id
1884: AND( (l_search_merged ='Y' )
1885: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1903: FROM HZ_STAGED_CONTACT_POINTS stage

1899: 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);
1900: END IF;
1901: OPEN x_cursor FOR
1902: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1903: FROM HZ_STAGED_CONTACT_POINTS stage
1904: WHERE contains( concat_col, p_contains_str)>0
1905: AND EXISTS (
1906: SELECT 1 FROM HZ_STAGED_PARTIES p
1907: WHERE p.PARTY_ID = stage.PARTY_ID

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

1918: 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);
1919: END IF;
1920: IF p_person_api = 'Y' THEN
1921: OPEN x_cursor FOR
1922: 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
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 d.party_id = stage.party_id

Line 1923: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1919: END IF;
1920: IF p_person_api = 'Y' THEN
1921: OPEN x_cursor FOR
1922: 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
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 d.party_id = stage.party_id
1927: AND( (l_search_merged ='Y' )

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

1928: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1929: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1930: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1931: UNION
1932: 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
1933: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, 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 = r.subject_id

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

1929: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1930: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1931: UNION
1932: 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
1933: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, 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 = r.subject_id
1937: AND r.relationship_id = oc.party_relationship_id

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

1941: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1942: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1943: ELSE
1944: OPEN x_cursor FOR
1945: 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
1946: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id

Line 1946: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1942: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1943: ELSE
1944: OPEN x_cursor FOR
1945: 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
1946: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id
1950: AND( (l_search_merged ='Y' )

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

1962: IF (l_check_dt > 0 ) THEN
1963: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1964: 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);
1965: END IF;
1966: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1967: ELSIF (l_check > 0 ) THEN
1968: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1969: 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);
1970: END IF;

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

1967: ELSIF (l_check > 0 ) THEN
1968: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1969: 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);
1970: END IF;
1971: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1972: END IF;
1973: IF l_search_merged = 'Y' THEN
1974: l_status_sql := ' ' ;
1975: ELSIF l_search_merged = 'I' THEN

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

1986: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1987: ELSE
1988: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1989: END IF;
1990: 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'||
1991: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1992: ' WHERE contains( concat_col, :cont)>0 '||
1993: ' AND (stage.org_contact_id is null '||
1994: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1991: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1987: ELSE
1988: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1989: END IF;
1990: 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'||
1991: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1992: ' WHERE contains( concat_col, :cont)>0 '||
1993: ' AND (stage.org_contact_id is null '||
1994: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1995: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1996: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1997: ' AND ('||p_restrict_sql||'))' ||
1998: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1999: ' UNION ' ||
2000: ' 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'||
2001: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2002: ' WHERE contains( concat_col, :cont)>0 '||
2003: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2004: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2001: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1997: ' AND ('||p_restrict_sql||'))' ||
1998: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1999: ' UNION ' ||
2000: ' 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'||
2001: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2002: ' WHERE contains( concat_col, :cont)>0 '||
2003: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
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'') ) '||

Line 2016: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2012: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2013: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2014: ELSE
2015: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2016: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2017: ' WHERE contains( concat_col, :cont)>0'||
2018: ' AND EXISTS ('||
2019: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2020: ' WHERE p.party_id = stage.party_id ' ||

Line 2033: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2029: ,p_dup_party_id, p_dup_party_id;
2030: END IF;
2031: ELSE
2032: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2033: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2034: ' WHERE contains( concat_col, :cont)>0'||
2035: ' AND EXISTS ('||
2036: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2037: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_7 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1834: 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 1835: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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