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_58 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1932: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1928: END IF;
1929: IF p_restrict_entity = 'CONTACTS'
1930: THEN
1931: OPEN x_cursor FOR
1932: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1934: WHERE contains( concat_col, p_contains_str)>0
1935: AND d.search_context_id = p_search_ctx_id
1936: AND( (l_search_merged ='Y' )

Line 1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1929: IF p_restrict_entity = 'CONTACTS'
1930: THEN
1931: OPEN x_cursor FOR
1932: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1934: WHERE contains( concat_col, p_contains_str)>0
1935: AND d.search_context_id = p_search_ctx_id
1936: AND( (l_search_merged ='Y' )
1937: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1944: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1940: END IF;
1941: IF p_restrict_entity = 'PARTY_SITES'
1942: THEN
1943: OPEN x_cursor FOR
1944: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1945: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1946: WHERE contains( concat_col, p_contains_str)>0
1947: AND d.search_context_id = p_search_ctx_id
1948: AND( (l_search_merged ='Y' )

Line 1945: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1941: IF p_restrict_entity = 'PARTY_SITES'
1942: THEN
1943: OPEN x_cursor FOR
1944: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1945: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1946: WHERE contains( concat_col, p_contains_str)>0
1947: AND d.search_context_id = p_search_ctx_id
1948: AND( (l_search_merged ='Y' )
1949: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1961: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1957: 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);
1958: END IF;
1959: IF p_search_rel_cpts = 'N' THEN
1960: OPEN x_cursor FOR
1961: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1962: FROM HZ_STAGED_CONTACT_POINTS stage
1963: WHERE contains( concat_col, p_contains_str)>0
1964: AND( (l_search_merged ='Y' )
1965: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1962: FROM HZ_STAGED_CONTACT_POINTS stage

1958: END IF;
1959: IF p_search_rel_cpts = 'N' THEN
1960: OPEN x_cursor FOR
1961: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1962: FROM HZ_STAGED_CONTACT_POINTS stage
1963: WHERE contains( concat_col, p_contains_str)>0
1964: AND( (l_search_merged ='Y' )
1965: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1966: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1970: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1966: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1967: AND stage.party_id = p_party_id;
1968: ELSE
1969: OPEN x_cursor FOR
1970: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1971: FROM HZ_STAGED_CONTACT_POINTS stage
1972: WHERE contains( concat_col, p_contains_str)>0
1973: AND( (l_search_merged ='Y' )
1974: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1971: FROM HZ_STAGED_CONTACT_POINTS stage

1967: AND stage.party_id = p_party_id;
1968: ELSE
1969: OPEN x_cursor FOR
1970: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1971: FROM HZ_STAGED_CONTACT_POINTS stage
1972: WHERE contains( concat_col, p_contains_str)>0
1973: AND( (l_search_merged ='Y' )
1974: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1975: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1978: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5

1974: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1975: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1976: AND stage.party_id = p_party_id
1977: UNION
1978: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
1979: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1980: WHERE contains( concat_col, p_contains_str)>0
1981: AND r.object_id = p_party_id
1982: AND( (l_search_merged ='Y' )

Line 1979: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc

1975: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1976: AND stage.party_id = p_party_id
1977: UNION
1978: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
1979: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1980: WHERE contains( concat_col, p_contains_str)>0
1981: AND r.object_id = p_party_id
1982: AND( (l_search_merged ='Y' )
1983: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2001: FROM HZ_STAGED_CONTACT_POINTS stage

1997: hz_utility_v2pub.debug(p_message=>'Either 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);
1998: END IF;
1999: OPEN x_cursor FOR
2000: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2001: FROM HZ_STAGED_CONTACT_POINTS stage
2002: WHERE contains( concat_col, p_contains_str)>0
2003: AND EXISTS (
2004: SELECT 1 FROM HZ_STAGED_PARTIES p
2005: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2021: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2017: END IF;
2018: IF p_person_api = 'Y' THEN
2019: OPEN x_cursor FOR
2020: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2021: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2022: WHERE contains( concat_col, p_contains_str)>0
2023: AND d.search_context_id = p_search_ctx_id
2024: AND d.party_id = stage.party_id
2025: AND( (l_search_merged ='Y' )

Line 2030: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5

2026: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2028: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2029: UNION
2030: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2031: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2032: WHERE contains( concat_col, p_contains_str)>0
2033: AND d.search_context_id = p_search_ctx_id
2034: AND d.party_id = r.subject_id

Line 2031: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2028: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2029: UNION
2030: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2031: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2032: WHERE contains( concat_col, p_contains_str)>0
2033: AND d.search_context_id = p_search_ctx_id
2034: AND d.party_id = r.subject_id
2035: AND r.relationship_id = oc.party_relationship_id

Line 2044: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2040: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2041: ELSE
2042: OPEN x_cursor FOR
2043: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2044: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2045: WHERE contains( concat_col, p_contains_str)>0
2046: AND d.search_context_id = p_search_ctx_id
2047: AND d.party_id = stage.party_id
2048: AND( (l_search_merged ='Y' )

Line 2064: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) /';

2060: IF (l_check_dt > 0 ) THEN
2061: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2062: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective_cpt hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2063: END IF;
2064: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2065: ELSIF (l_check > 0 ) THEN
2066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2067: 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);
2068: END IF;

Line 2069: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) /';

2065: ELSIF (l_check > 0 ) THEN
2066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2067: 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);
2068: END IF;
2069: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2070: END IF;
2071: IF l_search_merged = 'Y' THEN
2072: l_status_sql := ' ' ;
2073: ELSIF l_search_merged = 'I' THEN

Line 2088: l_sqlstr := ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||

2084: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2085: ELSE
2086: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2087: END IF;
2088: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2089: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2090: ' WHERE contains( concat_col, :cont)>0 '||
2091: ' AND (stage.org_contact_id is null '||
2092: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2089: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2085: ELSE
2086: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2087: END IF;
2088: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2089: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2090: ' WHERE contains( concat_col, :cont)>0 '||
2091: ' AND (stage.org_contact_id is null '||
2092: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2093: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2098: ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||

2094: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2095: ' AND ('||p_restrict_sql||'))' ||
2096: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2097: ' UNION ' ||
2098: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2099: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2100: ' WHERE contains( concat_col, :cont)>0 '||
2101: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2102: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2099: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2095: ' AND ('||p_restrict_sql||'))' ||
2096: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2097: ' UNION ' ||
2098: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2099: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2100: ' WHERE contains( concat_col, :cont)>0 '||
2101: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2102: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2103: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2114: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2110: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2111: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2112: ELSE
2113: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2114: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2115: ' WHERE contains( concat_col, :cont)>0'||
2116: ' AND EXISTS ('||
2117: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2118: ' WHERE p.party_id = stage.party_id ' ||

Line 2131: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2127: ,p_dup_party_id, p_dup_party_id;
2128: END IF;
2129: ELSE
2130: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2131: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2132: ' WHERE contains( concat_col, :cont)>0'||
2133: ' AND EXISTS ('||
2134: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2135: ' WHERE p.party_id = stage.party_id ' ||