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

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

1703: END IF;
1704: IF p_restrict_entity = 'CONTACTS'
1705: THEN
1706: OPEN x_cursor FOR
1707: 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
1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1709: WHERE contains( concat_col, p_contains_str)>0
1710: AND d.search_context_id = p_search_ctx_id
1711: AND( (l_search_merged ='Y' )

Line 1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1704: IF p_restrict_entity = 'CONTACTS'
1705: THEN
1706: OPEN x_cursor FOR
1707: 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
1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1709: WHERE contains( concat_col, p_contains_str)>0
1710: AND d.search_context_id = p_search_ctx_id
1711: AND( (l_search_merged ='Y' )
1712: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1715: END IF;
1716: IF p_restrict_entity = 'PARTY_SITES'
1717: THEN
1718: OPEN x_cursor FOR
1719: 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
1720: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1721: WHERE contains( concat_col, p_contains_str)>0
1722: AND d.search_context_id = p_search_ctx_id
1723: AND( (l_search_merged ='Y' )

Line 1720: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1716: IF p_restrict_entity = 'PARTY_SITES'
1717: THEN
1718: OPEN x_cursor FOR
1719: 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
1720: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1721: WHERE contains( concat_col, p_contains_str)>0
1722: AND d.search_context_id = p_search_ctx_id
1723: AND( (l_search_merged ='Y' )
1724: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1732: 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);
1733: END IF;
1734: IF p_search_rel_cpts = 'N' THEN
1735: OPEN x_cursor FOR
1736: 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
1737: FROM HZ_STAGED_CONTACT_POINTS stage
1738: WHERE contains( concat_col, p_contains_str)>0
1739: AND( (l_search_merged ='Y' )
1740: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1737: FROM HZ_STAGED_CONTACT_POINTS stage

1733: END IF;
1734: IF p_search_rel_cpts = 'N' THEN
1735: OPEN x_cursor FOR
1736: 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
1737: FROM HZ_STAGED_CONTACT_POINTS stage
1738: WHERE contains( concat_col, p_contains_str)>0
1739: AND( (l_search_merged ='Y' )
1740: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1741: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1741: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1742: AND stage.party_id = p_party_id;
1743: ELSE
1744: OPEN x_cursor FOR
1745: 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
1746: FROM HZ_STAGED_CONTACT_POINTS stage
1747: WHERE contains( concat_col, p_contains_str)>0
1748: AND( (l_search_merged ='Y' )
1749: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1746: FROM HZ_STAGED_CONTACT_POINTS stage

1742: AND stage.party_id = p_party_id;
1743: ELSE
1744: OPEN x_cursor FOR
1745: 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
1746: FROM HZ_STAGED_CONTACT_POINTS stage
1747: WHERE contains( concat_col, p_contains_str)>0
1748: AND( (l_search_merged ='Y' )
1749: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1750: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1749: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1750: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1751: AND stage.party_id = p_party_id
1752: UNION
1753: 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
1754: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1755: WHERE contains( concat_col, p_contains_str)>0
1756: AND r.object_id = p_party_id
1757: AND( (l_search_merged ='Y' )

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

1750: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1751: AND stage.party_id = p_party_id
1752: UNION
1753: 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
1754: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1755: WHERE contains( concat_col, p_contains_str)>0
1756: AND r.object_id = p_party_id
1757: AND( (l_search_merged ='Y' )
1758: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1776: FROM HZ_STAGED_CONTACT_POINTS stage

1772: 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);
1773: END IF;
1774: OPEN x_cursor FOR
1775: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1776: FROM HZ_STAGED_CONTACT_POINTS stage
1777: WHERE contains( concat_col, p_contains_str)>0
1778: AND EXISTS (
1779: SELECT 1 FROM HZ_STAGED_PARTIES p
1780: WHERE p.PARTY_ID = stage.PARTY_ID

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

1791: 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);
1792: END IF;
1793: IF p_person_api = 'Y' THEN
1794: OPEN x_cursor FOR
1795: 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
1796: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1797: WHERE contains( concat_col, p_contains_str)>0
1798: AND d.search_context_id = p_search_ctx_id
1799: AND d.party_id = stage.party_id

Line 1796: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1792: END IF;
1793: IF p_person_api = 'Y' THEN
1794: OPEN x_cursor FOR
1795: 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
1796: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1797: WHERE contains( concat_col, p_contains_str)>0
1798: AND d.search_context_id = p_search_ctx_id
1799: AND d.party_id = stage.party_id
1800: AND( (l_search_merged ='Y' )

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

1801: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1802: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1803: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1804: UNION
1805: 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
1806: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1807: WHERE contains( concat_col, p_contains_str)>0
1808: AND d.search_context_id = p_search_ctx_id
1809: AND d.party_id = r.subject_id

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

1802: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1803: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1804: UNION
1805: 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
1806: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1807: WHERE contains( concat_col, p_contains_str)>0
1808: AND d.search_context_id = p_search_ctx_id
1809: AND d.party_id = r.subject_id
1810: AND r.relationship_id = oc.party_relationship_id

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

1814: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1815: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1816: ELSE
1817: OPEN x_cursor FOR
1818: 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
1819: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1820: WHERE contains( concat_col, p_contains_str)>0
1821: AND d.search_context_id = p_search_ctx_id
1822: AND d.party_id = stage.party_id

Line 1819: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1815: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1816: ELSE
1817: OPEN x_cursor FOR
1818: 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
1819: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1820: WHERE contains( concat_col, p_contains_str)>0
1821: AND d.search_context_id = p_search_ctx_id
1822: AND d.party_id = stage.party_id
1823: AND( (l_search_merged ='Y' )

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

1835: IF (l_check_dt > 0 ) THEN
1836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1837: 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);
1838: END IF;
1839: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1840: ELSIF (l_check > 0 ) THEN
1841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1842: 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);
1843: END IF;

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

1840: ELSIF (l_check > 0 ) THEN
1841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1842: 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);
1843: END IF;
1844: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1845: END IF;
1846: IF l_search_merged = 'Y' THEN
1847: l_status_sql := ' ' ;
1848: ELSIF l_search_merged = 'I' THEN

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

1859: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1860: ELSE
1861: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1862: END IF;
1863: 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'||
1864: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1865: ' WHERE contains( concat_col, :cont)>0 '||
1866: ' AND (stage.org_contact_id is null '||
1867: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1864: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1860: ELSE
1861: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1862: END IF;
1863: 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'||
1864: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1865: ' WHERE contains( concat_col, :cont)>0 '||
1866: ' AND (stage.org_contact_id is null '||
1867: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1868: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1869: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1870: ' AND ('||p_restrict_sql||'))' ||
1871: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1872: ' UNION ' ||
1873: ' 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'||
1874: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1875: ' WHERE contains( concat_col, :cont)>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: ' AND ('||p_restrict_sql||'))' ||
1871: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1872: ' UNION ' ||
1873: ' 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'||
1874: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1875: ' WHERE contains( concat_col, :cont)>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 1889: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1885: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1886: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1887: ELSE
1888: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1889: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1890: ' WHERE contains( concat_col, :cont)>0'||
1891: ' AND EXISTS ('||
1892: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1893: ' WHERE p.party_id = stage.party_id ' ||

Line 1906: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1902: ,p_dup_party_id, p_dup_party_id;
1903: END IF;
1904: ELSE
1905: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1906: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1907: ' WHERE contains( concat_col, :cont)>0'||
1908: ' AND EXISTS ('||
1909: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1910: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_98 dependencies on HZ_STAGED_CONTACT_POINTS

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

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