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

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

1575: END IF;
1576: IF p_restrict_entity = 'CONTACTS'
1577: THEN
1578: OPEN x_cursor FOR
1579: 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
1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1581: WHERE contains( concat_col, p_contains_str)>0
1582: AND d.search_context_id = p_search_ctx_id
1583: AND( (l_search_merged ='Y' )

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1576: IF p_restrict_entity = 'CONTACTS'
1577: THEN
1578: OPEN x_cursor FOR
1579: 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
1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1581: WHERE contains( concat_col, p_contains_str)>0
1582: AND d.search_context_id = p_search_ctx_id
1583: AND( (l_search_merged ='Y' )
1584: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1587: END IF;
1588: IF p_restrict_entity = 'PARTY_SITES'
1589: THEN
1590: OPEN x_cursor FOR
1591: 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
1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1593: WHERE contains( concat_col, p_contains_str)>0
1594: AND d.search_context_id = p_search_ctx_id
1595: AND( (l_search_merged ='Y' )

Line 1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1588: IF p_restrict_entity = 'PARTY_SITES'
1589: THEN
1590: OPEN x_cursor FOR
1591: 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
1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1593: WHERE contains( concat_col, p_contains_str)>0
1594: AND d.search_context_id = p_search_ctx_id
1595: AND( (l_search_merged ='Y' )
1596: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1604: 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);
1605: END IF;
1606: IF p_search_rel_cpts = 'N' THEN
1607: OPEN x_cursor FOR
1608: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1609: FROM HZ_STAGED_CONTACT_POINTS stage
1610: WHERE contains( concat_col, p_contains_str)>0
1611: AND( (l_search_merged ='Y' )
1612: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1609: FROM HZ_STAGED_CONTACT_POINTS stage

1605: END IF;
1606: IF p_search_rel_cpts = 'N' THEN
1607: OPEN x_cursor FOR
1608: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1609: FROM HZ_STAGED_CONTACT_POINTS stage
1610: WHERE contains( concat_col, p_contains_str)>0
1611: AND( (l_search_merged ='Y' )
1612: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1613: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1613: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1614: AND stage.party_id = p_party_id;
1615: ELSE
1616: OPEN x_cursor FOR
1617: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1618: FROM HZ_STAGED_CONTACT_POINTS stage
1619: WHERE contains( concat_col, p_contains_str)>0
1620: AND( (l_search_merged ='Y' )
1621: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1618: FROM HZ_STAGED_CONTACT_POINTS stage

1614: AND stage.party_id = p_party_id;
1615: ELSE
1616: OPEN x_cursor FOR
1617: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1618: FROM HZ_STAGED_CONTACT_POINTS stage
1619: WHERE contains( concat_col, p_contains_str)>0
1620: AND( (l_search_merged ='Y' )
1621: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1622: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1621: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1622: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1623: AND stage.party_id = p_party_id
1624: UNION
1625: 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
1626: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1627: WHERE contains( concat_col, p_contains_str)>0
1628: AND r.object_id = p_party_id
1629: AND( (l_search_merged ='Y' )

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

1622: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1623: AND stage.party_id = p_party_id
1624: UNION
1625: 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
1626: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1627: WHERE contains( concat_col, p_contains_str)>0
1628: AND r.object_id = p_party_id
1629: AND( (l_search_merged ='Y' )
1630: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1648: FROM HZ_STAGED_CONTACT_POINTS stage

1644: 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);
1645: END IF;
1646: OPEN x_cursor FOR
1647: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1648: FROM HZ_STAGED_CONTACT_POINTS stage
1649: WHERE contains( concat_col, p_contains_str)>0
1650: AND EXISTS (
1651: SELECT 1 FROM HZ_STAGED_PARTIES p
1652: WHERE p.PARTY_ID = stage.PARTY_ID

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

1663: 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);
1664: END IF;
1665: IF p_person_api = 'Y' THEN
1666: OPEN x_cursor FOR
1667: 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
1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1669: WHERE contains( concat_col, p_contains_str)>0
1670: AND d.search_context_id = p_search_ctx_id
1671: AND d.party_id = stage.party_id

Line 1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1664: END IF;
1665: IF p_person_api = 'Y' THEN
1666: OPEN x_cursor FOR
1667: 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
1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1669: WHERE contains( concat_col, p_contains_str)>0
1670: AND d.search_context_id = p_search_ctx_id
1671: AND d.party_id = stage.party_id
1672: AND( (l_search_merged ='Y' )

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

1673: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1674: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1675: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1676: UNION
1677: 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
1678: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1679: WHERE contains( concat_col, p_contains_str)>0
1680: AND d.search_context_id = p_search_ctx_id
1681: AND d.party_id = r.subject_id

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

1674: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1675: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1676: UNION
1677: 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
1678: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1679: WHERE contains( concat_col, p_contains_str)>0
1680: AND d.search_context_id = p_search_ctx_id
1681: AND d.party_id = r.subject_id
1682: AND r.relationship_id = oc.party_relationship_id

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

1686: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1687: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1688: ELSE
1689: OPEN x_cursor FOR
1690: 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
1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1692: WHERE contains( concat_col, p_contains_str)>0
1693: AND d.search_context_id = p_search_ctx_id
1694: AND d.party_id = stage.party_id

Line 1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1687: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1688: ELSE
1689: OPEN x_cursor FOR
1690: 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
1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1692: WHERE contains( concat_col, p_contains_str)>0
1693: AND d.search_context_id = p_search_ctx_id
1694: AND d.party_id = stage.party_id
1695: AND( (l_search_merged ='Y' )

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

1707: IF (l_check_dt > 0 ) THEN
1708: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1709: 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);
1710: END IF;
1711: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1712: ELSIF (l_check > 0 ) THEN
1713: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1714: 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);
1715: END IF;

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

1712: ELSIF (l_check > 0 ) THEN
1713: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1714: 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);
1715: END IF;
1716: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1717: END IF;
1718: IF l_search_merged = 'Y' THEN
1719: l_status_sql := ' ' ;
1720: ELSIF l_search_merged = 'I' THEN

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

1731: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1732: ELSE
1733: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1734: END IF;
1735: 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 '||
1736: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1737: ' WHERE contains( concat_col, :cont)>0 '||
1738: ' AND (stage.org_contact_id is null '||
1739: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1736: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1732: ELSE
1733: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1734: END IF;
1735: 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 '||
1736: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1737: ' WHERE contains( concat_col, :cont)>0 '||
1738: ' AND (stage.org_contact_id is null '||
1739: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1740: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

1741: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1742: ' AND ('||p_restrict_sql||'))' ||
1743: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1744: ' UNION ' ||
1745: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1746: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1747: ' WHERE contains( concat_col, :cont)>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 ('||p_restrict_sql||'))' ||
1743: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1744: ' UNION ' ||
1745: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1746: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1747: ' WHERE contains( concat_col, :cont)>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 1761: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1757: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1758: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1759: ELSE
1760: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1761: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1762: ' WHERE contains( concat_col, :cont)>0'||
1763: ' AND EXISTS ('||
1764: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1765: ' WHERE p.party_id = stage.party_id ' ||

Line 1778: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1774: ,p_dup_party_id, p_dup_party_id;
1775: END IF;
1776: ELSE
1777: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1778: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1779: ' WHERE contains( concat_col, :cont)>0'||
1780: ' AND EXISTS ('||
1781: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1782: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_5 dependencies on HZ_STAGED_CONTACT_POINTS

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

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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