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 1620: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11

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

Line 1621: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1630: FROM HZ_STAGED_PARTY_SITES stage

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

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

1633: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1634: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1635: AND stage.party_id = p_party_id
1636: UNION
1637: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1638: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1639: WHERE contains( concat_col, p_contains_str)>0
1640: AND( (l_search_merged ='Y' )
1641: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1634: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1635: AND stage.party_id = p_party_id
1636: UNION
1637: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1638: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1639: WHERE contains( concat_col, p_contains_str)>0
1640: AND( (l_search_merged ='Y' )
1641: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1642: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1660: FROM HZ_STAGED_PARTY_SITES stage

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

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

1675: 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);
1676: END IF;
1677: IF p_person_api = 'Y' THEN
1678: OPEN x_cursor FOR
1679: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1680: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1681: WHERE contains( concat_col, p_contains_str)>0
1682: AND( (l_search_merged ='Y' )
1683: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1680: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

1698: AND oc.org_contact_id = stage.org_contact_id
1699: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1700: ELSE
1701: OPEN x_cursor FOR
1702: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1704: WHERE contains( concat_col, p_contains_str)>0
1705: AND( (l_search_merged ='Y' )
1706: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

1743: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1744: ELSE
1745: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1746: END IF;
1747: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1748: ' FROM HZ_STAGED_PARTY_SITES 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_PARTY_SITES stage'||

1744: ELSE
1745: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1746: END IF;
1747: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||
1748: ' FROM HZ_STAGED_PARTY_SITES 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 1757: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX11'||

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

Line 1758: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1773: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1790: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_6 dependencies on HZ_STAGED_PARTY_SITES

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