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

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

1990: 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);
1991: END IF;
1992: IF p_search_rel_sites = 'N' THEN
1993: OPEN x_cursor FOR
1994: 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
1995: FROM HZ_STAGED_PARTY_SITES stage
1996: WHERE contains( concat_col, p_contains_str)>0
1997: AND( (l_search_merged ='Y' )
1998: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1995: FROM HZ_STAGED_PARTY_SITES stage

1991: END IF;
1992: IF p_search_rel_sites = 'N' THEN
1993: OPEN x_cursor FOR
1994: 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
1995: FROM HZ_STAGED_PARTY_SITES stage
1996: WHERE contains( concat_col, p_contains_str)>0
1997: AND( (l_search_merged ='Y' )
1998: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1999: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1999: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2000: AND stage.party_id = p_party_id;
2001: ELSE
2002: OPEN x_cursor FOR
2003: 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
2004: FROM HZ_STAGED_PARTY_SITES stage
2005: WHERE contains( concat_col, p_contains_str)>0
2006: AND( (l_search_merged ='Y' )
2007: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2004: FROM HZ_STAGED_PARTY_SITES stage

2000: AND stage.party_id = p_party_id;
2001: ELSE
2002: OPEN x_cursor FOR
2003: 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
2004: FROM HZ_STAGED_PARTY_SITES stage
2005: WHERE contains( concat_col, p_contains_str)>0
2006: AND( (l_search_merged ='Y' )
2007: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2008: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2007: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2008: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2009: AND stage.party_id = p_party_id
2010: UNION
2011: 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
2012: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2013: WHERE contains( concat_col, p_contains_str)>0
2014: AND( (l_search_merged ='Y' )
2015: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2008: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2009: AND stage.party_id = p_party_id
2010: UNION
2011: 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
2012: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2013: WHERE contains( concat_col, p_contains_str)>0
2014: AND( (l_search_merged ='Y' )
2015: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2016: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2034: FROM HZ_STAGED_PARTY_SITES stage

2030: 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);
2031: END IF;
2032: OPEN x_cursor FOR
2033: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2034: FROM HZ_STAGED_PARTY_SITES stage
2035: WHERE contains( concat_col, p_contains_str)>0
2036: AND EXISTS (
2037: SELECT 1 FROM HZ_STAGED_PARTIES p
2038: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2054: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2050: END IF;
2051: IF p_person_api = 'Y' THEN
2052: OPEN x_cursor FOR
2053: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2054: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2055: WHERE contains( concat_col, p_contains_str)>0
2056: AND( (l_search_merged ='Y' )
2057: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2058: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2059: AND d.search_context_id = p_search_ctx_id
2060: AND d.party_id = stage.party_id
2061: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2062: UNION
2063: 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
2064: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2065: WHERE contains( concat_col, p_contains_str)>0
2066: AND( (l_search_merged ='Y' )
2067: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2060: AND d.party_id = stage.party_id
2061: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2062: UNION
2063: 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
2064: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2065: WHERE contains( concat_col, p_contains_str)>0
2066: AND( (l_search_merged ='Y' )
2067: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2068: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2077: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2073: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2074: ELSE
2075: OPEN x_cursor FOR
2076: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2077: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2078: WHERE contains( concat_col, p_contains_str)>0
2079: AND( (l_search_merged ='Y' )
2080: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2081: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2093: IF (l_check_dt > 0 ) THEN
2094: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2095: 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);
2096: END IF;
2097: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2098: ELSIF (l_check > 0 ) THEN
2099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2100: 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);
2101: END IF;

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

2098: ELSIF (l_check > 0 ) THEN
2099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2100: 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);
2101: END IF;
2102: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2103: END IF;
2104: IF l_search_merged = 'Y' THEN
2105: l_status_sql := ' ' ;
2106: ELSIF l_search_merged = 'I' THEN

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

2117: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2118: ELSE
2119: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2120: END IF;
2121: 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'||
2122: ' FROM HZ_STAGED_PARTY_SITES stage'||
2123: ' WHERE contains( concat_col, :cont)>0'||
2124: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2125: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2122: ' FROM HZ_STAGED_PARTY_SITES stage'||

2118: ELSE
2119: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2120: END IF;
2121: 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'||
2122: ' FROM HZ_STAGED_PARTY_SITES stage'||
2123: ' WHERE contains( concat_col, :cont)>0'||
2124: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2125: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2126: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

2127: ' AND (ORG_CONTACT_ID IS NULL ' ||
2128: ' AND ('||p_restrict_sql||'))' ||
2129: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2130: ' UNION ' ||
2131: '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'||
2132: ' FROM HZ_STAGED_PARTY_SITES stage'||
2133: ' WHERE contains( concat_col, :cont)>0'||
2134: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2135: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2132: ' FROM HZ_STAGED_PARTY_SITES stage'||

2128: ' AND ('||p_restrict_sql||'))' ||
2129: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2130: ' UNION ' ||
2131: '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'||
2132: ' FROM HZ_STAGED_PARTY_SITES stage'||
2133: ' WHERE contains( concat_col, :cont)>0'||
2134: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2135: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2136: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2147: ' FROM HZ_STAGED_PARTY_SITES stage'||

2143: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2144: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2145: ELSE
2146: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
2147: ' FROM HZ_STAGED_PARTY_SITES stage'||
2148: ' WHERE contains( concat_col, :cont)>0'||
2149: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2150: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2151: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2164: ' FROM HZ_STAGED_PARTY_SITES stage'||

2160: ,p_dup_party_id, p_dup_party_id;
2161: END IF;
2162: ELSE
2163: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
2164: ' FROM HZ_STAGED_PARTY_SITES stage'||
2165: ' WHERE contains( concat_col, :cont)>0'||
2166: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2167: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2168: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||