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 1581: 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

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

Line 1582: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1594: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1611: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1620: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

Line 1650: FROM HZ_STAGED_CONTACT_POINTS stage

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

Line 1670: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1666: END IF;
1667: IF p_person_api = 'Y' THEN
1668: OPEN x_cursor FOR
1669: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1670: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1671: WHERE contains( concat_col, p_contains_str)>0
1672: AND d.search_context_id = p_search_ctx_id
1673: AND d.party_id = stage.party_id
1674: AND( (l_search_merged ='Y' )

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

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

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

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

Line 1693: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1689: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1690: ELSE
1691: OPEN x_cursor FOR
1692: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1693: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1694: WHERE contains( concat_col, p_contains_str)>0
1695: AND d.search_context_id = p_search_ctx_id
1696: AND d.party_id = stage.party_id
1697: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

Line 1738: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

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

1743: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1744: ' AND ('||p_restrict_sql||'))' ||
1745: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1746: ' UNION ' ||
1747: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1748: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1749: ' WHERE contains( concat_col, :cont)>0 '||
1750: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1751: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1748: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1744: ' AND ('||p_restrict_sql||'))' ||
1745: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1746: ' UNION ' ||
1747: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1748: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1749: ' WHERE contains( concat_col, :cont)>0 '||
1750: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1751: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1752: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1763: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 1780: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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