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_CONTACTS

Line 1382: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1378: BEGIN
1379: IF p_party_id IS NOT NULL THEN
1380: OPEN x_cursor FOR
1381: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1382: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1383: WHERE
1384: srch.batch_id = -1
1385: AND
1386: (

Line 1402: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage

1398: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1399: IF p_search_ctx_id IS NULL THEN
1400: OPEN x_cursor FOR
1401: SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1402: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage
1403: WHERE
1404: srch.batch_id = -1
1405: AND
1406: (

Line 1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1417: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1418: ELSE
1419: OPEN x_cursor FOR
1420: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1421: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1422: WHERE
1423: srch.batch_id = -1
1424: AND
1425: (

Line 1438: ' FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage'||

1434: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1435: END IF;
1436: ELSE
1437: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID , stage.TX2, stage.TX23, stage.TX22'||
1438: ' FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage'||
1439: ' WHERE '||
1440: 'srch.batch_id = -1'||
1441: 'AND'||
1442: '('||

Line 4536: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4532: END IF;
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;

Line 4546: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4542: WHEN FND_API.G_EXC_ERROR THEN
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 ---------------------

Line 4553: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

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 ;
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 ---------------------

Line 4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4556: WHEN OTHERS THEN
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 );

Line 5359: insert into HZ_SRCH_CONTACTS(batch_id,party_id, party_osr,party_os, org_contact_id,contact_osr, contact_os,new_party_flag ,TX23,TX2,TX22) values(-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX23,x_stage_list(I).TX2,x_stage_list(I).TX22);

5355: END IF;
5356: END LOOP;
5357: IF p_search_ctx THEN
5358: FOR I IN 1..p_search_list.COUNT LOOP
5359: insert into HZ_SRCH_CONTACTS(batch_id,party_id, party_osr,party_os, org_contact_id,contact_osr, contact_os,new_party_flag ,TX23,TX2,TX22) values(-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX23,x_stage_list(I).TX2,x_stage_list(I).TX22);
5360: END LOOP;
5361: END IF;
5362: EXCEPTION
5363: WHEN OTHERS THEN