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 1767: 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

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

Line 1768: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1777: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1807: FROM HZ_STAGED_PARTY_SITES stage

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

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

1822: 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);
1823: END IF;
1824: IF p_person_api = 'Y' THEN
1825: OPEN x_cursor FOR
1826: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1827: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1828: WHERE contains( concat_col, p_contains_str)>0
1829: AND( (l_search_merged ='Y' )
1830: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1827: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

1845: AND oc.org_contact_id = stage.org_contact_id
1846: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1847: ELSE
1848: OPEN x_cursor FOR
1849: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1851: WHERE contains( concat_col, p_contains_str)>0
1852: AND( (l_search_merged ='Y' )
1853: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1894: 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'||

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

Line 1895: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1904: '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'||

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

Line 1905: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1920: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1937: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_99 dependencies on HZ_STAGED_PARTY_SITES

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