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

Line 2772: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID, TX5, TX2

2768: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2769: 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);
2770: END IF;
2771: OPEN x_cursor FOR
2772: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
2773: FROM HZ_STAGED_CONTACTS stage
2774: WHERE contains( concat_col, p_contains_str)>0
2775: AND EXISTS (
2776: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 2773: FROM HZ_STAGED_CONTACTS stage

2769: 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);
2770: END IF;
2771: OPEN x_cursor FOR
2772: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
2773: FROM HZ_STAGED_CONTACTS stage
2774: WHERE contains( concat_col, p_contains_str)>0
2775: AND EXISTS (
2776: SELECT 1 FROM HZ_STAGED_PARTIES p
2777: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2796: FROM HZ_STAGED_CONTACTS stage

2792: 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);
2793: END IF;
2794: OPEN x_cursor FOR
2795: SELECT ORG_CONTACT_ID, PARTY_ID, TX5, TX2
2796: FROM HZ_STAGED_CONTACTS stage
2797: WHERE contains( concat_col, p_contains_str)>0
2798: AND EXISTS (
2799: SELECT 1 FROM HZ_STAGED_PARTIES p
2800: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2814: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2

2810: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2811: 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);
2812: END IF;
2813: OPEN x_cursor FOR
2814: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
2815: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2816: WHERE contains( concat_col, p_contains_str)>0
2817: AND d.search_context_id = p_search_ctx_id
2818: AND d.party_id = stage.party_id

Line 2815: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2811: 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);
2812: END IF;
2813: OPEN x_cursor FOR
2814: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
2815: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2816: WHERE contains( concat_col, p_contains_str)>0
2817: AND d.search_context_id = p_search_ctx_id
2818: AND d.party_id = stage.party_id
2819: AND( (l_search_merged ='Y' )

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

2830: IF (l_check_dt > 0 ) THEN
2831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2832: 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);
2833: END IF;
2834: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
2835: ELSIF (l_check > 0 ) THEN
2836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2837: 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);
2838: END IF;

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

2835: ELSIF (l_check > 0 ) THEN
2836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2837: 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);
2838: END IF;
2839: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2840: END IF;
2841: IF l_search_merged = 'Y' THEN
2842: l_status_sql := ' ' ;
2843: ELSIF l_search_merged = 'I' THEN

Line 2849: ' FROM HZ_STAGED_CONTACTS stage'||

2845: ELSE
2846: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2847: END IF;
2848: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX5, TX2'||
2849: ' FROM HZ_STAGED_CONTACTS stage'||
2850: ' WHERE contains( concat_col, :cont)>0'||
2851: ' AND EXISTS ('||
2852: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2853: ' WHERE p.party_id = stage.party_id ' ||

Line 4488: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID, TX5, TX2

4484: p_search_ctx_id NUMBER,
4485: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4486: BEGIN
4487: OPEN x_cursor FOR
4488: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
4489: FROM HZ_STAGED_CONTACTS stage
4490: WHERE contains( concat_col, p_contains_str)>0
4491: AND ORG_CONTACT_ID in (
4492: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 4489: FROM HZ_STAGED_CONTACTS stage

4485: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4486: BEGIN
4487: OPEN x_cursor FOR
4488: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
4489: FROM HZ_STAGED_CONTACTS stage
4490: WHERE contains( concat_col, p_contains_str)>0
4491: AND ORG_CONTACT_ID in (
4492: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4493: org_contact_id

APPS.HZ_MATCH_RULE_42 dependencies on HZ_STAGED_CONTACTS

Line 2772: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2