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

Line 1693: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1689: 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);
1690: END IF;
1691: IF p_search_rel_sites = 'N' THEN
1692: OPEN x_cursor FOR
1693: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1694: FROM HZ_STAGED_PARTY_SITES stage
1695: WHERE contains( concat_col, p_contains_str)>0
1696: AND( (l_search_merged ='Y' )
1697: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1694: FROM HZ_STAGED_PARTY_SITES stage

1690: END IF;
1691: IF p_search_rel_sites = 'N' THEN
1692: OPEN x_cursor FOR
1693: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1694: FROM HZ_STAGED_PARTY_SITES stage
1695: WHERE contains( concat_col, p_contains_str)>0
1696: AND( (l_search_merged ='Y' )
1697: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1698: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1702: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1698: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1699: AND stage.party_id = p_party_id;
1700: ELSE
1701: OPEN x_cursor FOR
1702: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1703: FROM 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_STAGED_PARTY_SITES stage

1699: AND stage.party_id = p_party_id;
1700: ELSE
1701: OPEN x_cursor FOR
1702: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1703: FROM 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 1710: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

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') )
1708: AND stage.party_id = p_party_id
1709: UNION
1710: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1711: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1712: WHERE contains( concat_col, p_contains_str)>0
1713: AND( (l_search_merged ='Y' )
1714: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1707: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1708: AND stage.party_id = p_party_id
1709: UNION
1710: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1711: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1712: WHERE contains( concat_col, p_contains_str)>0
1713: AND( (l_search_merged ='Y' )
1714: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1715: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1733: FROM HZ_STAGED_PARTY_SITES stage

1729: 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);
1730: END IF;
1731: OPEN x_cursor FOR
1732: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1733: FROM HZ_STAGED_PARTY_SITES stage
1734: WHERE contains( concat_col, p_contains_str)>0
1735: AND EXISTS (
1736: SELECT 1 FROM HZ_STAGED_PARTIES p
1737: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1753: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1749: END IF;
1750: IF p_person_api = 'Y' THEN
1751: OPEN x_cursor FOR
1752: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1753: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1754: WHERE contains( concat_col, p_contains_str)>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) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1758: AND d.search_context_id = p_search_ctx_id
1759: AND d.party_id = stage.party_id
1760: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1761: UNION
1762: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1763: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1764: WHERE contains( concat_col, p_contains_str)>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_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1759: AND d.party_id = stage.party_id
1760: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1761: UNION
1762: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1763: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1764: WHERE contains( concat_col, p_contains_str)>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 1776: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1772: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1773: ELSE
1774: OPEN x_cursor FOR
1775: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1776: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1777: WHERE contains( concat_col, p_contains_str)>0
1778: AND( (l_search_merged ='Y' )
1779: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1780: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1792: IF (l_check_dt > 0 ) THEN
1793: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1794: 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);
1795: END IF;
1796: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1797: ELSIF (l_check > 0 ) THEN
1798: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1799: 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);
1800: END IF;

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

1797: ELSIF (l_check > 0 ) THEN
1798: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1799: 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);
1800: END IF;
1801: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1802: END IF;
1803: IF l_search_merged = 'Y' THEN
1804: l_status_sql := ' ' ;
1805: ELSIF l_search_merged = 'I' THEN

Line 1820: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||

1816: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1817: ELSE
1818: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1819: END IF;
1820: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1821: ' FROM HZ_STAGED_PARTY_SITES stage'||
1822: ' WHERE contains( concat_col, :cont)>0'||
1823: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1824: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1821: ' FROM HZ_STAGED_PARTY_SITES stage'||

1817: ELSE
1818: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1819: END IF;
1820: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1821: ' FROM HZ_STAGED_PARTY_SITES stage'||
1822: ' WHERE contains( concat_col, :cont)>0'||
1823: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1824: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1825: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1830: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||

1826: ' AND (ORG_CONTACT_ID IS NULL ' ||
1827: ' AND ('||p_restrict_sql||'))' ||
1828: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1829: ' UNION ' ||
1830: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1831: ' FROM HZ_STAGED_PARTY_SITES stage'||
1832: ' WHERE contains( concat_col, :cont)>0'||
1833: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1834: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1831: ' FROM HZ_STAGED_PARTY_SITES stage'||

1827: ' AND ('||p_restrict_sql||'))' ||
1828: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1829: ' UNION ' ||
1830: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1831: ' FROM HZ_STAGED_PARTY_SITES stage'||
1832: ' WHERE contains( concat_col, :cont)>0'||
1833: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1834: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1835: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1846: ' FROM HZ_STAGED_PARTY_SITES stage'||

1842: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1843: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1844: ELSE
1845: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1846: ' FROM HZ_STAGED_PARTY_SITES stage'||
1847: ' WHERE contains( concat_col, :cont)>0'||
1848: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1849: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1850: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1863: ' FROM HZ_STAGED_PARTY_SITES stage'||

1859: ,p_dup_party_id, p_dup_party_id;
1860: END IF;
1861: ELSE
1862: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1863: ' FROM HZ_STAGED_PARTY_SITES stage'||
1864: ' WHERE contains( concat_col, :cont)>0'||
1865: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1866: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1867: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||