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

Line 1483: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1479: BEGIN
1480: IF p_party_id IS NOT NULL THEN
1481: OPEN x_cursor FOR
1482: 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.TX7, stage.TX10, stage.TX158
1483: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1484: WHERE
1485: srch.batch_id = -1
1486: AND
1487: (

Line 1513: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage

1509: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1510: IF p_search_ctx_id IS NULL THEN
1511: OPEN x_cursor FOR
1512: SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158
1513: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage
1514: WHERE
1515: srch.batch_id = -1
1516: AND
1517: (

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

1538: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1539: ELSE
1540: OPEN x_cursor FOR
1541: 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.TX7, stage.TX10, stage.TX158
1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1543: WHERE
1544: srch.batch_id = -1
1545: AND
1546: (

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

1565: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1566: END IF;
1567: ELSE
1568: 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.TX7, stage.TX10, stage.TX158'||
1569: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||
1570: ' WHERE'||
1571: 'srch.batch_id = -1'||
1572: 'AND'||
1573: '('||

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

4533: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4534: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4535: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4536: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4537: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4539: 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);
4540: END IF;
4541: EXCEPTION

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

4543: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4544: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4545: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4546: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4547: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4551: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

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

4550: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4551: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4552: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4553: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4554: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4556: WHEN OTHERS THEN
4557: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4558: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

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

4557: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4558: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4559: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4561: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;

Line 5477: 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,TX7) 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,x_stage_list(I).TX7);

5473: END IF;
5474: END LOOP;
5475: IF p_search_ctx THEN
5476: FOR I IN 1..p_search_list.COUNT LOOP
5477: 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,TX7) 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,x_stage_list(I).TX7);
5478: END LOOP;
5479: END IF;
5480: EXCEPTION
5481: WHEN OTHERS THEN