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_36 dependencies on HZ_STAGED_CONTACTS

Line 1934: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID

1930: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1931: 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);
1932: END IF;
1933: OPEN x_cursor FOR
1934: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1935: FROM HZ_STAGED_CONTACTS stage
1936: WHERE contains( concat_col, p_contains_str)>0
1937: AND EXISTS (
1938: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 1935: FROM HZ_STAGED_CONTACTS stage

1931: 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);
1932: END IF;
1933: OPEN x_cursor FOR
1934: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1935: FROM HZ_STAGED_CONTACTS stage
1936: WHERE contains( concat_col, p_contains_str)>0
1937: AND EXISTS (
1938: SELECT 1 FROM HZ_STAGED_PARTIES p
1939: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1958: FROM HZ_STAGED_CONTACTS stage

1954: 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);
1955: END IF;
1956: OPEN x_cursor FOR
1957: SELECT ORG_CONTACT_ID, PARTY_ID
1958: FROM HZ_STAGED_CONTACTS stage
1959: WHERE contains( concat_col, p_contains_str)>0
1960: AND EXISTS (
1961: SELECT 1 FROM HZ_STAGED_PARTIES p
1962: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1976: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID

1972: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1973: 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);
1974: END IF;
1975: OPEN x_cursor FOR
1976: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1977: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1978: WHERE contains( concat_col, p_contains_str)>0
1979: AND d.search_context_id = p_search_ctx_id
1980: AND d.party_id = stage.party_id

Line 1977: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1973: 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);
1974: END IF;
1975: OPEN x_cursor FOR
1976: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1977: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1978: WHERE contains( concat_col, p_contains_str)>0
1979: AND d.search_context_id = p_search_ctx_id
1980: AND d.party_id = stage.party_id
1981: AND( (l_search_merged ='Y' )

Line 1996: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACTS_U1) /';

1992: IF (l_check_dt > 0 ) THEN
1993: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1994: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ct hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1995: END IF;
1996: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
1997: ELSIF (l_check > 0 ) THEN
1998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1999: 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);
2000: END IF;

Line 2001: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACTS_N1) /';

1997: ELSIF (l_check > 0 ) THEN
1998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1999: 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);
2000: END IF;
2001: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2002: END IF;
2003: IF l_search_merged = 'Y' THEN
2004: l_status_sql := ' ' ;
2005: ELSIF l_search_merged = 'I' THEN

Line 2011: ' FROM HZ_STAGED_CONTACTS stage'||

2007: ELSE
2008: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2009: END IF;
2010: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
2011: ' FROM HZ_STAGED_CONTACTS stage'||
2012: ' WHERE contains( concat_col, :cont)>0'||
2013: ' AND EXISTS ('||
2014: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2015: ' WHERE p.party_id = stage.party_id ' ||

Line 3632: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID

3628: p_search_ctx_id NUMBER,
3629: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3630: BEGIN
3631: OPEN x_cursor FOR
3632: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3633: FROM HZ_STAGED_CONTACTS stage
3634: WHERE contains( concat_col, p_contains_str)>0
3635: AND ORG_CONTACT_ID in (
3636: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3633: FROM HZ_STAGED_CONTACTS stage

3629: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3630: BEGIN
3631: OPEN x_cursor FOR
3632: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3633: FROM HZ_STAGED_CONTACTS stage
3634: WHERE contains( concat_col, p_contains_str)>0
3635: AND ORG_CONTACT_ID in (
3636: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3637: org_contact_id

APPS.HZ_MATCH_RULE_36 dependencies on HZ_STAGED_CONTACTS

Line 1934: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID