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_35 dependencies on HZ_STAGED_PARTY_SITES

Line 1625: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

1621: 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);
1622: END IF;
1623: IF p_search_rel_sites = 'N' THEN
1624: OPEN x_cursor FOR
1625: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1626: FROM HZ_STAGED_PARTY_SITES stage
1627: WHERE contains( concat_col, p_contains_str)>0
1628: AND( (l_search_merged ='Y' )
1629: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1626: FROM HZ_STAGED_PARTY_SITES stage

1622: END IF;
1623: IF p_search_rel_sites = 'N' THEN
1624: OPEN x_cursor FOR
1625: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1626: FROM HZ_STAGED_PARTY_SITES stage
1627: WHERE contains( concat_col, p_contains_str)>0
1628: AND( (l_search_merged ='Y' )
1629: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1630: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1634: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

1630: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1631: AND stage.party_id = p_party_id;
1632: ELSE
1633: OPEN x_cursor FOR
1634: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1635: FROM HZ_STAGED_PARTY_SITES stage
1636: WHERE contains( concat_col, p_contains_str)>0
1637: AND( (l_search_merged ='Y' )
1638: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1635: FROM HZ_STAGED_PARTY_SITES stage

1631: AND stage.party_id = p_party_id;
1632: ELSE
1633: OPEN x_cursor FOR
1634: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1635: FROM HZ_STAGED_PARTY_SITES stage
1636: WHERE contains( concat_col, p_contains_str)>0
1637: AND( (l_search_merged ='Y' )
1638: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1639: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1642: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

1638: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1639: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1640: AND stage.party_id = p_party_id
1641: UNION
1642: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1643: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1644: WHERE contains( concat_col, p_contains_str)>0
1645: AND( (l_search_merged ='Y' )
1646: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1643: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

1639: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1640: AND stage.party_id = p_party_id
1641: UNION
1642: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1643: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1644: WHERE contains( concat_col, p_contains_str)>0
1645: AND( (l_search_merged ='Y' )
1646: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1647: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1665: FROM HZ_STAGED_PARTY_SITES stage

1661: hz_utility_v2pub.debug(p_message=>'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);
1662: END IF;
1663: OPEN x_cursor FOR
1664: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1665: FROM HZ_STAGED_PARTY_SITES stage
1666: WHERE contains( concat_col, p_contains_str)>0
1667: AND EXISTS (
1668: SELECT 1 FROM HZ_STAGED_PARTIES p
1669: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1684: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

1680: 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);
1681: END IF;
1682: IF p_person_api = 'Y' THEN
1683: OPEN x_cursor FOR
1684: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1685: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1686: WHERE contains( concat_col, p_contains_str)>0
1687: AND( (l_search_merged ='Y' )
1688: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1685: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1681: END IF;
1682: IF p_person_api = 'Y' THEN
1683: OPEN x_cursor FOR
1684: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1685: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1686: WHERE contains( concat_col, p_contains_str)>0
1687: AND( (l_search_merged ='Y' )
1688: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1689: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1694: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

1690: AND d.search_context_id = p_search_ctx_id
1691: AND d.party_id = stage.party_id
1692: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1693: UNION
1694: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1695: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1696: WHERE contains( concat_col, p_contains_str)>0
1697: AND( (l_search_merged ='Y' )
1698: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1695: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1691: AND d.party_id = stage.party_id
1692: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1693: UNION
1694: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1695: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1696: WHERE contains( concat_col, p_contains_str)>0
1697: AND( (l_search_merged ='Y' )
1698: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1699: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1707: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

1703: AND oc.org_contact_id = stage.org_contact_id
1704: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1705: ELSE
1706: OPEN x_cursor FOR
1707: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1709: WHERE contains( concat_col, p_contains_str)>0
1710: AND( (l_search_merged ='Y' )
1711: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1704: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1705: ELSE
1706: OPEN x_cursor FOR
1707: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1709: WHERE contains( concat_col, p_contains_str)>0
1710: AND( (l_search_merged ='Y' )
1711: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1712: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1728: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

1724: IF (l_check_dt > 0 ) THEN
1725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1726: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ps hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1727: END IF;
1728: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1729: ELSIF (l_check > 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 hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1732: END IF;

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

1729: ELSIF (l_check > 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 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_PARTY_SITES_N1) */';
1734: END IF;
1735: IF l_search_merged = 'Y' THEN
1736: l_status_sql := ' ' ;
1737: ELSIF l_search_merged = 'I' THEN

Line 1752: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||

1748: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1749: ELSE
1750: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1751: END IF;
1752: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||
1753: ' FROM HZ_STAGED_PARTY_SITES stage'||
1754: ' WHERE contains( concat_col, :cont)>0'||
1755: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1756: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1753: ' FROM HZ_STAGED_PARTY_SITES stage'||

1749: ELSE
1750: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1751: END IF;
1752: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||
1753: ' FROM HZ_STAGED_PARTY_SITES stage'||
1754: ' WHERE contains( concat_col, :cont)>0'||
1755: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1756: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1757: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1762: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||

1758: ' AND (ORG_CONTACT_ID IS NULL ' ||
1759: ' AND ('||p_restrict_sql||'))' ||
1760: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1761: ' UNION ' ||
1762: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||
1763: ' FROM HZ_STAGED_PARTY_SITES stage'||
1764: ' WHERE contains( concat_col, :cont)>0'||
1765: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1766: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1763: ' FROM HZ_STAGED_PARTY_SITES stage'||

1759: ' AND ('||p_restrict_sql||'))' ||
1760: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1761: ' UNION ' ||
1762: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||
1763: ' FROM HZ_STAGED_PARTY_SITES stage'||
1764: ' WHERE contains( concat_col, :cont)>0'||
1765: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1766: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1767: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1778: ' FROM HZ_STAGED_PARTY_SITES stage'||

1774: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1775: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1776: ELSE
1777: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||
1778: ' FROM HZ_STAGED_PARTY_SITES stage'||
1779: ' WHERE contains( concat_col, :cont)>0'||
1780: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1781: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1782: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1795: ' FROM HZ_STAGED_PARTY_SITES stage'||

1791: ,p_dup_party_id, p_dup_party_id;
1792: END IF;
1793: ELSE
1794: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX14, TX22'||
1795: ' FROM HZ_STAGED_PARTY_SITES stage'||
1796: ' WHERE contains( concat_col, :cont)>0'||
1797: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1798: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1799: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_35 dependencies on HZ_STAGED_PARTY_SITES

Line 1625: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22