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 1627: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22

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

Line 1628: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1637: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1667: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1687: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

1692: AND d.search_context_id = p_search_ctx_id
1693: AND d.party_id = stage.party_id
1694: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1695: UNION
1696: 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
1697: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1698: WHERE contains( concat_col, p_contains_str)>0
1699: AND( (l_search_merged ='Y' )
1700: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1693: AND d.party_id = stage.party_id
1694: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1695: UNION
1696: 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
1697: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1698: WHERE contains( concat_col, p_contains_str)>0
1699: AND( (l_search_merged ='Y' )
1700: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1701: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1710: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1755: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1765: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1780: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1797: ' FROM HZ_STAGED_PARTY_SITES stage'||

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