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

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

2753: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2754: 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);
2755: END IF;
2756: OPEN x_cursor FOR
2757: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
2758: FROM HZ_STAGED_CONTACTS stage
2759: WHERE contains( concat_col, p_contains_str)>0
2760: AND EXISTS (
2761: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 2758: FROM HZ_STAGED_CONTACTS stage

2754: 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);
2755: END IF;
2756: OPEN x_cursor FOR
2757: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
2758: FROM HZ_STAGED_CONTACTS stage
2759: WHERE contains( concat_col, p_contains_str)>0
2760: AND EXISTS (
2761: SELECT 1 FROM HZ_STAGED_PARTIES p
2762: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2781: FROM HZ_STAGED_CONTACTS stage

2777: 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);
2778: END IF;
2779: OPEN x_cursor FOR
2780: SELECT ORG_CONTACT_ID, PARTY_ID
2781: FROM HZ_STAGED_CONTACTS stage
2782: WHERE contains( concat_col, p_contains_str)>0
2783: AND EXISTS (
2784: SELECT 1 FROM HZ_STAGED_PARTIES p
2785: WHERE p.PARTY_ID = stage.PARTY_ID

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

2795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2796: 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);
2797: END IF;
2798: OPEN x_cursor FOR
2799: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2800: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2801: WHERE contains( concat_col, p_contains_str)>0
2802: AND d.search_context_id = p_search_ctx_id
2803: AND d.party_id = stage.party_id

Line 2800: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2796: 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);
2797: END IF;
2798: OPEN x_cursor FOR
2799: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2800: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2801: WHERE contains( concat_col, p_contains_str)>0
2802: AND d.search_context_id = p_search_ctx_id
2803: AND d.party_id = stage.party_id
2804: AND( (l_search_merged ='Y' )

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

2815: IF (l_check_dt > 0 ) THEN
2816: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2817: 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);
2818: END IF;
2819: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
2820: ELSIF (l_check > 0 ) THEN
2821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2822: 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);
2823: END IF;

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

2820: ELSIF (l_check > 0 ) THEN
2821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2822: 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);
2823: END IF;
2824: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2825: END IF;
2826: IF l_search_merged = 'Y' THEN
2827: l_status_sql := ' ' ;
2828: ELSIF l_search_merged = 'I' THEN

Line 2834: ' FROM HZ_STAGED_CONTACTS stage'||

2830: ELSE
2831: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2832: END IF;
2833: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
2834: ' FROM HZ_STAGED_CONTACTS stage'||
2835: ' WHERE contains( concat_col, :cont)>0'||
2836: ' AND EXISTS ('||
2837: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2838: ' WHERE p.party_id = stage.party_id ' ||

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

4471: p_search_ctx_id NUMBER,
4472: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4473: BEGIN
4474: OPEN x_cursor FOR
4475: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
4476: FROM HZ_STAGED_CONTACTS stage
4477: WHERE contains( concat_col, p_contains_str)>0
4478: AND ORG_CONTACT_ID in (
4479: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 4476: FROM HZ_STAGED_CONTACTS stage

4472: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4473: BEGIN
4474: OPEN x_cursor FOR
4475: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
4476: FROM HZ_STAGED_CONTACTS stage
4477: WHERE contains( concat_col, p_contains_str)>0
4478: AND ORG_CONTACT_ID in (
4479: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4480: org_contact_id

APPS.HZ_MATCH_RULE_34 dependencies on HZ_STAGED_CONTACTS

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