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_CONTACTS

Line 2209: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID, TX6, TX5

2205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2206: 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);
2207: END IF;
2208: OPEN x_cursor FOR
2209: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
2210: FROM HZ_STAGED_CONTACTS stage
2211: WHERE contains( concat_col, p_contains_str)>0
2212: AND EXISTS (
2213: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 2210: FROM HZ_STAGED_CONTACTS stage

2206: 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);
2207: END IF;
2208: OPEN x_cursor FOR
2209: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
2210: FROM HZ_STAGED_CONTACTS stage
2211: WHERE contains( concat_col, p_contains_str)>0
2212: AND EXISTS (
2213: SELECT 1 FROM HZ_STAGED_PARTIES p
2214: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2233: FROM HZ_STAGED_CONTACTS stage

2229: 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);
2230: END IF;
2231: OPEN x_cursor FOR
2232: SELECT ORG_CONTACT_ID, PARTY_ID, TX6, TX5
2233: FROM HZ_STAGED_CONTACTS stage
2234: WHERE contains( concat_col, p_contains_str)>0
2235: AND EXISTS (
2236: SELECT 1 FROM HZ_STAGED_PARTIES p
2237: WHERE p.PARTY_ID = stage.PARTY_ID

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

2247: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2248: 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);
2249: END IF;
2250: OPEN x_cursor FOR
2251: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX6, TX5
2252: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2253: WHERE contains( concat_col, p_contains_str)>0
2254: AND d.search_context_id = p_search_ctx_id
2255: AND d.party_id = stage.party_id

Line 2252: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2248: 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);
2249: END IF;
2250: OPEN x_cursor FOR
2251: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX6, TX5
2252: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2253: WHERE contains( concat_col, p_contains_str)>0
2254: AND d.search_context_id = p_search_ctx_id
2255: AND d.party_id = stage.party_id
2256: AND( (l_search_merged ='Y' )

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

2267: IF (l_check_dt > 0 ) THEN
2268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2269: 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);
2270: END IF;
2271: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
2272: ELSIF (l_check > 0 ) THEN
2273: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2274: 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);
2275: END IF;

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

2272: ELSIF (l_check > 0 ) THEN
2273: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2274: 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);
2275: END IF;
2276: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2277: END IF;
2278: IF l_search_merged = 'Y' THEN
2279: l_status_sql := ' ' ;
2280: ELSIF l_search_merged = 'I' THEN

Line 2286: ' FROM HZ_STAGED_CONTACTS stage'||

2282: ELSE
2283: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2284: END IF;
2285: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX6, TX5'||
2286: ' FROM HZ_STAGED_CONTACTS stage'||
2287: ' WHERE contains( concat_col, :cont)>0'||
2288: ' AND EXISTS ('||
2289: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2290: ' WHERE p.party_id = stage.party_id ' ||

Line 3917: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID, TX6, TX5

3913: p_search_ctx_id NUMBER,
3914: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3915: BEGIN
3916: OPEN x_cursor FOR
3917: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
3918: FROM HZ_STAGED_CONTACTS stage
3919: WHERE contains( concat_col, p_contains_str)>0
3920: AND ORG_CONTACT_ID in (
3921: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3918: FROM HZ_STAGED_CONTACTS stage

3914: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3915: BEGIN
3916: OPEN x_cursor FOR
3917: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
3918: FROM HZ_STAGED_CONTACTS stage
3919: WHERE contains( concat_col, p_contains_str)>0
3920: AND ORG_CONTACT_ID in (
3921: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3922: org_contact_id

APPS.HZ_MATCH_RULE_33 dependencies on HZ_STAGED_CONTACTS

Line 2209: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5