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_CONTACTS

Line 1336: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch

1332: BEGIN
1333: IF p_party_id IS NOT NULL THEN
1334: OPEN x_cursor FOR
1335: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1336: FROM HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1337: WHERE
1338: srch.batch_id = -1
1339: AND
1340: (

Line 1356: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage

1352: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1353: IF p_search_ctx_id IS NULL THEN
1354: OPEN x_cursor FOR
1355: SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1356: FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage
1357: WHERE
1358: srch.batch_id = -1
1359: AND
1360: (

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

1371: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1372: ELSE
1373: OPEN x_cursor FOR
1374: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ stage.ORG_CONTACT_ID, stage.PARTY_ID, stage.TX2, stage.TX23, stage.TX22
1375: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage, HZ_SRCH_CONTACTS srch
1376: WHERE
1377: srch.batch_id = -1
1378: AND
1379: (

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

1388: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1389: END IF;
1390: ELSE
1391: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.ORG_CONTACT_ID, stage.PARTY_ID , stage.TX2, stage.TX23, stage.TX22'||
1392: ' FROM HZ_SRCH_CONTACTS srch, HZ_STAGED_CONTACTS stage'||
1393: ' WHERE '||
1394: 'srch.batch_id = -1'||
1395: 'AND'||
1396: '('||

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

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

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

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

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

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

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

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

Line 5259: 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);

5255: END IF;
5256: END LOOP;
5257: IF p_search_ctx THEN
5258: FOR I IN 1..p_search_list.COUNT LOOP
5259: 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);
5260: END LOOP;
5261: END IF;
5262: EXCEPTION
5263: WHEN OTHERS THEN