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

Line 1769: 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, TX22

1765: 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);
1766: END IF;
1767: IF p_search_rel_sites = 'N' THEN
1768: OPEN x_cursor FOR
1769: 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, TX22
1770: FROM HZ_STAGED_PARTY_SITES stage
1771: WHERE contains( concat_col, p_contains_str)>0
1772: AND( (l_search_merged ='Y' )
1773: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1770: FROM HZ_STAGED_PARTY_SITES stage

1766: END IF;
1767: IF p_search_rel_sites = 'N' THEN
1768: OPEN x_cursor FOR
1769: 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, TX22
1770: FROM HZ_STAGED_PARTY_SITES stage
1771: WHERE contains( concat_col, p_contains_str)>0
1772: AND( (l_search_merged ='Y' )
1773: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1774: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1778: 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, TX22

1774: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1775: AND stage.party_id = p_party_id;
1776: ELSE
1777: OPEN x_cursor FOR
1778: 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, TX22
1779: FROM HZ_STAGED_PARTY_SITES stage
1780: WHERE contains( concat_col, p_contains_str)>0
1781: AND( (l_search_merged ='Y' )
1782: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1779: FROM HZ_STAGED_PARTY_SITES stage

1775: AND stage.party_id = p_party_id;
1776: ELSE
1777: OPEN x_cursor FOR
1778: 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, TX22
1779: FROM HZ_STAGED_PARTY_SITES stage
1780: WHERE contains( concat_col, p_contains_str)>0
1781: AND( (l_search_merged ='Y' )
1782: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1783: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1786: 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, TX22

1782: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1783: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1784: AND stage.party_id = p_party_id
1785: UNION
1786: 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, TX22
1787: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1788: WHERE contains( concat_col, p_contains_str)>0
1789: AND( (l_search_merged ='Y' )
1790: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1783: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1784: AND stage.party_id = p_party_id
1785: UNION
1786: 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, TX22
1787: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1788: WHERE contains( concat_col, p_contains_str)>0
1789: AND( (l_search_merged ='Y' )
1790: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1791: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1809: FROM HZ_STAGED_PARTY_SITES stage

1805: 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);
1806: END IF;
1807: OPEN x_cursor FOR
1808: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1809: FROM HZ_STAGED_PARTY_SITES stage
1810: WHERE contains( concat_col, p_contains_str)>0
1811: AND EXISTS (
1812: SELECT 1 FROM HZ_STAGED_PARTIES p
1813: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1829: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1825: END IF;
1826: IF p_person_api = 'Y' THEN
1827: OPEN x_cursor FOR
1828: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1829: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1830: WHERE contains( concat_col, p_contains_str)>0
1831: AND( (l_search_merged ='Y' )
1832: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1833: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1838: 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, TX22

1834: AND d.search_context_id = p_search_ctx_id
1835: AND d.party_id = stage.party_id
1836: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1837: UNION
1838: 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, TX22
1839: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1840: WHERE contains( concat_col, p_contains_str)>0
1841: AND( (l_search_merged ='Y' )
1842: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1835: AND d.party_id = stage.party_id
1836: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1837: UNION
1838: 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, TX22
1839: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1840: WHERE contains( concat_col, p_contains_str)>0
1841: AND( (l_search_merged ='Y' )
1842: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1843: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1852: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1848: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1849: ELSE
1850: OPEN x_cursor FOR
1851: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1852: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1853: WHERE contains( concat_col, p_contains_str)>0
1854: AND( (l_search_merged ='Y' )
1855: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1856: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1868: IF (l_check_dt > 0 ) THEN
1869: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1870: 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);
1871: END IF;
1872: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1873: ELSIF (l_check > 0 ) THEN
1874: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1875: 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);
1876: END IF;

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

1873: ELSIF (l_check > 0 ) THEN
1874: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1875: 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);
1876: END IF;
1877: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1878: END IF;
1879: IF l_search_merged = 'Y' THEN
1880: l_status_sql := ' ' ;
1881: ELSIF l_search_merged = 'I' THEN

Line 1896: 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, TX22'||

1892: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1893: ELSE
1894: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1895: END IF;
1896: 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, TX22'||
1897: ' FROM HZ_STAGED_PARTY_SITES stage'||
1898: ' WHERE contains( concat_col, :cont)>0'||
1899: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1900: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1897: ' FROM HZ_STAGED_PARTY_SITES stage'||

1893: ELSE
1894: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1895: END IF;
1896: 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, TX22'||
1897: ' FROM HZ_STAGED_PARTY_SITES stage'||
1898: ' WHERE contains( concat_col, :cont)>0'||
1899: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1900: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1901: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1906: '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, TX22'||

1902: ' AND (ORG_CONTACT_ID IS NULL ' ||
1903: ' AND ('||p_restrict_sql||'))' ||
1904: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1905: ' UNION ' ||
1906: '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, TX22'||
1907: ' FROM HZ_STAGED_PARTY_SITES stage'||
1908: ' WHERE contains( concat_col, :cont)>0'||
1909: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1910: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1907: ' FROM HZ_STAGED_PARTY_SITES stage'||

1903: ' AND ('||p_restrict_sql||'))' ||
1904: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1905: ' UNION ' ||
1906: '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, TX22'||
1907: ' FROM HZ_STAGED_PARTY_SITES stage'||
1908: ' WHERE contains( concat_col, :cont)>0'||
1909: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1910: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1911: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1922: ' FROM HZ_STAGED_PARTY_SITES stage'||

1918: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1919: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1920: ELSE
1921: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
1922: ' FROM HZ_STAGED_PARTY_SITES stage'||
1923: ' WHERE contains( concat_col, :cont)>0'||
1924: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1925: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1926: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1939: ' FROM HZ_STAGED_PARTY_SITES stage'||

1935: ,p_dup_party_id, p_dup_party_id;
1936: END IF;
1937: ELSE
1938: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
1939: ' FROM HZ_STAGED_PARTY_SITES stage'||
1940: ' WHERE contains( concat_col, :cont)>0'||
1941: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1942: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1943: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||