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

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

1597: END IF;
1598: IF p_restrict_entity = 'CONTACTS'
1599: THEN
1600: OPEN x_cursor FOR
1601: 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
1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1603: WHERE contains( concat_col, p_contains_str)>0
1604: AND d.search_context_id = p_search_ctx_id
1605: AND( (l_search_merged ='Y' )

Line 1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1598: IF p_restrict_entity = 'CONTACTS'
1599: THEN
1600: OPEN x_cursor FOR
1601: 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
1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1603: WHERE contains( concat_col, p_contains_str)>0
1604: AND d.search_context_id = p_search_ctx_id
1605: AND( (l_search_merged ='Y' )
1606: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1609: END IF;
1610: IF p_restrict_entity = 'PARTY_SITES'
1611: THEN
1612: OPEN x_cursor FOR
1613: 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
1614: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1615: WHERE contains( concat_col, p_contains_str)>0
1616: AND d.search_context_id = p_search_ctx_id
1617: AND( (l_search_merged ='Y' )

Line 1614: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1610: IF p_restrict_entity = 'PARTY_SITES'
1611: THEN
1612: OPEN x_cursor FOR
1613: 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
1614: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1615: WHERE contains( concat_col, p_contains_str)>0
1616: AND d.search_context_id = p_search_ctx_id
1617: AND( (l_search_merged ='Y' )
1618: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1626: 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);
1627: END IF;
1628: IF p_search_rel_cpts = 'N' THEN
1629: OPEN x_cursor FOR
1630: 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
1631: FROM HZ_STAGED_CONTACT_POINTS stage
1632: WHERE contains( concat_col, p_contains_str)>0
1633: AND( (l_search_merged ='Y' )
1634: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1631: FROM HZ_STAGED_CONTACT_POINTS stage

1627: END IF;
1628: IF p_search_rel_cpts = 'N' THEN
1629: OPEN x_cursor FOR
1630: 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
1631: FROM HZ_STAGED_CONTACT_POINTS stage
1632: WHERE contains( concat_col, p_contains_str)>0
1633: AND( (l_search_merged ='Y' )
1634: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1635: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1635: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1636: AND stage.party_id = p_party_id;
1637: ELSE
1638: OPEN x_cursor FOR
1639: 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
1640: FROM HZ_STAGED_CONTACT_POINTS stage
1641: WHERE contains( concat_col, p_contains_str)>0
1642: AND( (l_search_merged ='Y' )
1643: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1640: FROM HZ_STAGED_CONTACT_POINTS stage

1636: AND stage.party_id = p_party_id;
1637: ELSE
1638: OPEN x_cursor FOR
1639: 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
1640: FROM HZ_STAGED_CONTACT_POINTS stage
1641: WHERE contains( concat_col, p_contains_str)>0
1642: AND( (l_search_merged ='Y' )
1643: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1644: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1643: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1644: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1645: AND stage.party_id = p_party_id
1646: UNION
1647: 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
1648: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1649: WHERE contains( concat_col, p_contains_str)>0
1650: AND r.object_id = p_party_id
1651: AND( (l_search_merged ='Y' )

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

1644: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1645: AND stage.party_id = p_party_id
1646: UNION
1647: 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
1648: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1649: WHERE contains( concat_col, p_contains_str)>0
1650: AND r.object_id = p_party_id
1651: AND( (l_search_merged ='Y' )
1652: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1670: FROM HZ_STAGED_CONTACT_POINTS stage

1666: 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);
1667: END IF;
1668: OPEN x_cursor FOR
1669: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1670: FROM HZ_STAGED_CONTACT_POINTS stage
1671: WHERE contains( concat_col, p_contains_str)>0
1672: AND EXISTS (
1673: SELECT 1 FROM HZ_STAGED_PARTIES p
1674: WHERE p.PARTY_ID = stage.PARTY_ID

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

1685: 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);
1686: END IF;
1687: IF p_person_api = 'Y' THEN
1688: OPEN x_cursor FOR
1689: 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
1690: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1691: WHERE contains( concat_col, p_contains_str)>0
1692: AND d.search_context_id = p_search_ctx_id
1693: AND d.party_id = stage.party_id

Line 1690: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1686: END IF;
1687: IF p_person_api = 'Y' THEN
1688: OPEN x_cursor FOR
1689: 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
1690: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1691: WHERE contains( concat_col, p_contains_str)>0
1692: AND d.search_context_id = p_search_ctx_id
1693: AND d.party_id = stage.party_id
1694: AND( (l_search_merged ='Y' )

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

1695: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1696: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1697: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1698: UNION
1699: 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
1700: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1701: WHERE contains( concat_col, p_contains_str)>0
1702: AND d.search_context_id = p_search_ctx_id
1703: AND d.party_id = r.subject_id

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

1696: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1697: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1698: UNION
1699: 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
1700: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1701: WHERE contains( concat_col, p_contains_str)>0
1702: AND d.search_context_id = p_search_ctx_id
1703: AND d.party_id = r.subject_id
1704: AND r.relationship_id = oc.party_relationship_id

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

1708: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1709: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1710: ELSE
1711: OPEN x_cursor FOR
1712: 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
1713: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1714: WHERE contains( concat_col, p_contains_str)>0
1715: AND d.search_context_id = p_search_ctx_id
1716: AND d.party_id = stage.party_id

Line 1713: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1709: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1710: ELSE
1711: OPEN x_cursor FOR
1712: 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
1713: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1714: WHERE contains( concat_col, p_contains_str)>0
1715: AND d.search_context_id = p_search_ctx_id
1716: AND d.party_id = stage.party_id
1717: AND( (l_search_merged ='Y' )

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

1729: IF (l_check_dt > 0 ) THEN
1730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1731: 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);
1732: END IF;
1733: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1734: ELSIF (l_check > 0 ) THEN
1735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1736: 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);
1737: END IF;

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

1734: ELSIF (l_check > 0 ) THEN
1735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1736: 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);
1737: END IF;
1738: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1739: END IF;
1740: IF l_search_merged = 'Y' THEN
1741: l_status_sql := ' ' ;
1742: ELSIF l_search_merged = 'I' THEN

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

1753: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1754: ELSE
1755: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1756: END IF;
1757: 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'||
1758: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1759: ' WHERE contains( concat_col, :cont)>0 '||
1760: ' AND (stage.org_contact_id is null '||
1761: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1758: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1754: ELSE
1755: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1756: END IF;
1757: 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'||
1758: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1759: ' WHERE contains( concat_col, :cont)>0 '||
1760: ' AND (stage.org_contact_id is null '||
1761: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1762: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1763: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1764: ' AND ('||p_restrict_sql||'))' ||
1765: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1766: ' UNION ' ||
1767: ' 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'||
1768: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1769: ' WHERE contains( concat_col, :cont)>0 '||
1770: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1771: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1768: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1764: ' AND ('||p_restrict_sql||'))' ||
1765: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1766: ' UNION ' ||
1767: ' 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'||
1768: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1769: ' WHERE contains( concat_col, :cont)>0 '||
1770: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1771: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1772: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1783: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1779: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1780: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1781: ELSE
1782: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1783: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1784: ' WHERE contains( concat_col, :cont)>0'||
1785: ' AND EXISTS ('||
1786: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1787: ' WHERE p.party_id = stage.party_id ' ||

Line 1800: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1796: ,p_dup_party_id, p_dup_party_id;
1797: END IF;
1798: ELSE
1799: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
1800: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1801: ' WHERE contains( concat_col, :cont)>0'||
1802: ' AND EXISTS ('||
1803: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1804: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_3 dependencies on HZ_STAGED_CONTACT_POINTS

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

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