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_51 dependencies on HZ_SRCH_CPTS

Line 1166: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1162: BEGIN
1163: IF p_party_id IS NOT NULL THEN
1164: OPEN x_cursor FOR
1165: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX158, stage.TX10
1166: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1167: WHERE
1168: srch.batch_id = -1
1169: AND
1170: (

Line 1191: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage

1187: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1188: IF p_search_ctx_id IS NULL THEN
1189: OPEN x_cursor FOR
1190: SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX158, stage.TX10
1191: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage
1192: WHERE
1193: srch.batch_id = -1
1194: AND
1195: (

Line 1215: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1212: ELSE
1213: OPEN x_cursor FOR
1214: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX158, stage.TX10
1215: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1216: WHERE
1217: srch.batch_id = -1
1218: AND
1219: (

Line 1237: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||

1233: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1234: END IF;
1235: ELSE
1236: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX158, stage.TX10'||
1237: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||
1238: ' WHERE'||
1239: 'srch.batch_id = -1'||
1240: 'AND'||
1241: '('||

Line 4125: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;

4121: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4122: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4123: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4124: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4125: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4128: END IF;
4129: EXCEPTION

Line 4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;

4131: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

Line 4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;

4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: WHEN OTHERS THEN
4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

Line 4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;

4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;

Line 4937: insert into HZ_SRCH_CPTS(batch_id,party_id, party_osr,party_os, contact_point_id,contact_pt_osr, contact_pt_os,contact_point_type,new_party_flag ,TX5,TX158,TX10) values(-1,-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX5,x_stage_list(I).TX158,x_stage_list(I).TX10);

4933: END IF;
4934: END LOOP;
4935: IF p_search_ctx THEN
4936: FOR I IN 1..p_search_list.COUNT LOOP
4937: insert into HZ_SRCH_CPTS(batch_id,party_id, party_osr,party_os, contact_point_id,contact_pt_osr, contact_pt_os,contact_point_type,new_party_flag ,TX5,TX158,TX10) values(-1,-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX5,x_stage_list(I).TX158,x_stage_list(I).TX10);
4938: END LOOP;
4939: END IF;
4940: EXCEPTION
4941: WHEN OTHERS THEN