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

Line 1622: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11

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

Line 1623: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1631: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11

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

Line 1632: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1639: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11

1635: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1636: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1637: AND stage.party_id = p_party_id
1638: UNION
1639: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1640: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

1636: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1637: AND stage.party_id = p_party_id
1638: UNION
1639: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1640: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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 1662: FROM HZ_STAGED_PARTY_SITES stage

1658: 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);
1659: END IF;
1660: OPEN x_cursor FOR
1661: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1662: FROM HZ_STAGED_PARTY_SITES stage
1663: WHERE contains( concat_col, p_contains_str)>0
1664: AND EXISTS (
1665: SELECT 1 FROM HZ_STAGED_PARTIES p
1666: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1682: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1678: END IF;
1679: IF p_person_api = 'Y' THEN
1680: OPEN x_cursor FOR
1681: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1682: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1683: WHERE contains( concat_col, p_contains_str)>0
1684: AND( (l_search_merged ='Y' )
1685: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1686: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1691: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11

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

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

1688: AND d.party_id = stage.party_id
1689: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1690: UNION
1691: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1692: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1693: WHERE contains( concat_col, p_contains_str)>0
1694: AND( (l_search_merged ='Y' )
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') )

Line 1705: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1701: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1702: ELSE
1703: OPEN x_cursor FOR
1704: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1705: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1706: WHERE contains( concat_col, p_contains_str)>0
1707: AND( (l_search_merged ='Y' )
1708: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1709: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1721: IF (l_check_dt > 0 ) THEN
1722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1723: 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);
1724: END IF;
1725: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1726: ELSIF (l_check > 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 hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1729: END IF;

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

1726: ELSIF (l_check > 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 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_N1) */';
1731: END IF;
1732: IF l_search_merged = 'Y' THEN
1733: l_status_sql := ' ' ;
1734: ELSIF l_search_merged = 'I' THEN

Line 1749: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||

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

Line 1750: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1759: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||

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

Line 1760: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1775: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1792: ' FROM HZ_STAGED_PARTY_SITES stage'||

1788: ,p_dup_party_id, p_dup_party_id;
1789: END IF;
1790: ELSE
1791: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1792: ' FROM HZ_STAGED_PARTY_SITES stage'||
1793: ' WHERE contains( concat_col, :cont)>0'||
1794: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1795: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1796: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||