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

Line 1437: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1433: BEGIN
1434: IF p_party_id IS NOT NULL THEN
1435: OPEN x_cursor FOR
1436: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10
1437: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1438: WHERE
1439: srch.batch_id = -1
1440: AND
1441: (

Line 1462: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage

1458: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1459: IF p_search_ctx_id IS NULL THEN
1460: OPEN x_cursor FOR
1461: SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10
1462: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage
1463: WHERE
1464: srch.batch_id = -1
1465: AND
1466: (

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

1482: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1483: ELSE
1484: OPEN x_cursor FOR
1485: 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.TX7, stage.TX158, stage.TX10
1486: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1487: WHERE
1488: srch.batch_id = -1
1489: AND
1490: (

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

1504: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1505: END IF;
1506: ELSE
1507: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10'||
1508: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||
1509: ' WHERE'||
1510: 'srch.batch_id = -1'||
1511: 'AND'||
1512: '('||

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

4435: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4436: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4437: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4438: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4439: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4441: 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);
4442: END IF;
4443: EXCEPTION

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

4445: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4446: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4447: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4448: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4449: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4450: RAISE FND_API.G_EXC_ERROR;
4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4452: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4453: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

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

4452: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4453: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4454: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4455: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4456: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4458: WHEN OTHERS THEN
4459: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4460: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

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

4459: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4460: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4461: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4462: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4463: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;

Line 5384: 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 ,TX158,TX10,TX8,TX7) values(-1,-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX158,x_stage_list(I).TX10,x_stage_list(I).TX8,x_stage_list(I).TX7);

5380: END IF;
5381: END LOOP;
5382: IF p_search_ctx THEN
5383: FOR I IN 1..p_search_list.COUNT LOOP
5384: 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 ,TX158,TX10,TX8,TX7) values(-1,-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX158,x_stage_list(I).TX10,x_stage_list(I).TX8,x_stage_list(I).TX7);
5385: END LOOP;
5386: END IF;
5387: EXCEPTION
5388: WHEN OTHERS THEN