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

Line 1968: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22

1964: 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);
1965: END IF;
1966: IF p_search_rel_sites = 'N' THEN
1967: OPEN x_cursor FOR
1968: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1969: FROM HZ_STAGED_PARTY_SITES stage
1970: WHERE contains( concat_col, p_contains_str)>0
1971: AND( (l_search_merged ='Y' )
1972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1969: FROM HZ_STAGED_PARTY_SITES stage

1965: END IF;
1966: IF p_search_rel_sites = 'N' THEN
1967: OPEN x_cursor FOR
1968: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1969: FROM HZ_STAGED_PARTY_SITES stage
1970: WHERE contains( concat_col, p_contains_str)>0
1971: AND( (l_search_merged ='Y' )
1972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1977: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22

1973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1974: AND stage.party_id = p_party_id;
1975: ELSE
1976: OPEN x_cursor FOR
1977: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1978: FROM HZ_STAGED_PARTY_SITES stage
1979: WHERE contains( concat_col, p_contains_str)>0
1980: AND( (l_search_merged ='Y' )
1981: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1978: FROM HZ_STAGED_PARTY_SITES stage

1974: AND stage.party_id = p_party_id;
1975: ELSE
1976: OPEN x_cursor FOR
1977: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1978: FROM HZ_STAGED_PARTY_SITES stage
1979: WHERE contains( concat_col, p_contains_str)>0
1980: AND( (l_search_merged ='Y' )
1981: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1982: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1985: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22

1981: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1982: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1983: AND stage.party_id = p_party_id
1984: UNION
1985: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1986: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1987: WHERE contains( concat_col, p_contains_str)>0
1988: AND( (l_search_merged ='Y' )
1989: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1982: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1983: AND stage.party_id = p_party_id
1984: UNION
1985: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1986: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1987: WHERE contains( concat_col, p_contains_str)>0
1988: AND( (l_search_merged ='Y' )
1989: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1990: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2008: FROM HZ_STAGED_PARTY_SITES stage

2004: 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);
2005: END IF;
2006: OPEN x_cursor FOR
2007: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2008: FROM HZ_STAGED_PARTY_SITES stage
2009: WHERE contains( concat_col, p_contains_str)>0
2010: AND EXISTS (
2011: SELECT 1 FROM HZ_STAGED_PARTIES p
2012: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2024: END IF;
2025: IF p_person_api = 'Y' THEN
2026: OPEN x_cursor FOR
2027: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2029: WHERE contains( concat_col, p_contains_str)>0
2030: AND( (l_search_merged ='Y' )
2031: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2032: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2037: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22

2033: AND d.search_context_id = p_search_ctx_id
2034: AND d.party_id = stage.party_id
2035: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2036: UNION
2037: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2038: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2039: WHERE contains( concat_col, p_contains_str)>0
2040: AND( (l_search_merged ='Y' )
2041: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2034: AND d.party_id = stage.party_id
2035: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2036: UNION
2037: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2038: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2039: WHERE contains( concat_col, p_contains_str)>0
2040: AND( (l_search_merged ='Y' )
2041: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2042: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2051: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2047: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2048: ELSE
2049: OPEN x_cursor FOR
2050: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2051: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2052: WHERE contains( concat_col, p_contains_str)>0
2053: AND( (l_search_merged ='Y' )
2054: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2055: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2067: IF (l_check_dt > 0 ) THEN
2068: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2069: 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);
2070: END IF;
2071: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2072: ELSIF (l_check > 0 ) THEN
2073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2074: 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);
2075: END IF;

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

2072: ELSIF (l_check > 0 ) THEN
2073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2074: 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);
2075: END IF;
2076: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2077: END IF;
2078: IF l_search_merged = 'Y' THEN
2079: l_status_sql := ' ' ;
2080: ELSIF l_search_merged = 'I' THEN

Line 2095: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||

2091: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2092: ELSE
2093: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2094: END IF;
2095: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2096: ' FROM HZ_STAGED_PARTY_SITES stage'||
2097: ' WHERE contains( concat_col, :cont)>0'||
2098: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2099: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2096: ' FROM HZ_STAGED_PARTY_SITES stage'||

2092: ELSE
2093: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2094: END IF;
2095: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2096: ' FROM HZ_STAGED_PARTY_SITES stage'||
2097: ' WHERE contains( concat_col, :cont)>0'||
2098: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2099: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2100: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2105: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||

2101: ' AND (ORG_CONTACT_ID IS NULL ' ||
2102: ' AND ('||p_restrict_sql||'))' ||
2103: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2104: ' UNION ' ||
2105: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2106: ' FROM HZ_STAGED_PARTY_SITES stage'||
2107: ' WHERE contains( concat_col, :cont)>0'||
2108: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2109: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2106: ' FROM HZ_STAGED_PARTY_SITES stage'||

2102: ' AND ('||p_restrict_sql||'))' ||
2103: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2104: ' UNION ' ||
2105: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2106: ' FROM HZ_STAGED_PARTY_SITES stage'||
2107: ' WHERE contains( concat_col, :cont)>0'||
2108: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2109: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2110: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2121: ' FROM HZ_STAGED_PARTY_SITES stage'||

2117: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2118: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2119: ELSE
2120: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2121: ' FROM HZ_STAGED_PARTY_SITES stage'||
2122: ' WHERE contains( concat_col, :cont)>0'||
2123: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2124: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2125: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2138: ' FROM HZ_STAGED_PARTY_SITES stage'||

2134: ,p_dup_party_id, p_dup_party_id;
2135: END IF;
2136: ELSE
2137: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2138: ' FROM HZ_STAGED_PARTY_SITES stage'||
2139: ' WHERE contains( concat_col, :cont)>0'||
2140: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2141: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2142: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||