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_PSITES

Line 1239: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch

1235: BEGIN
1236: IF p_party_id IS NOT NULL THEN
1237: OPEN x_cursor FOR
1238: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1239: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1240: WHERE
1241: srch.batch_id = -1
1242: AND
1243: (

Line 1259: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p

1255: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1256: IF p_search_ctx_id IS NULL THEN
1257: OPEN x_cursor FOR
1258: SELECT /*+ ORDERED USE_NL(srch stage p) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1259: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p
1260: WHERE
1261: srch.batch_id = -1
1262: AND
1263: (

Line 1276: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch

1272: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1273: ELSE
1274: OPEN x_cursor FOR
1275: SELECT stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1276: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1277: WHERE
1278: srch.batch_id = -1
1279: AND
1280: (

Line 1293: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||

1289: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1290: END IF;
1291: ELSE
1292: l_sqlstr := 'SELECT /*+ ORDERED USE_NL(srch stage p) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID , stage.TX26, stage.TX9, stage.TX14, stage.TX22'||
1293: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||
1294: ' WHERE' ||
1295: 'srch.batch_id = -1'||
1296: 'AND'||
1297: '('||

Line 4437: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

4433: CLOSE l_contact_pt_cur;
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);

Line 4447: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

4443: EXCEPTION
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

Line 4454: DELETE FROM HZ_SRCH_PSITES 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 ;
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

Line 4461: DELETE FROM HZ_SRCH_PSITES 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 ;
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');

Line 5158: insert into HZ_SRCH_PSITES(batch_id,party_id, party_osr,party_os, party_site_id,party_site_osr, party_site_os,new_party_flag ,TX26,TX9,TX22,TX11,TX14) values(-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX26,x_stage_list(I).TX9,x_stage_list(I).TX22,x_stage_list(I).TX11,x_stage_list(I).TX14);

5154: END IF;
5155: END LOOP;
5156: IF p_search_ctx THEN
5157: FOR I IN 1..p_search_list.COUNT LOOP
5158: insert into HZ_SRCH_PSITES(batch_id,party_id, party_osr,party_os, party_site_id,party_site_osr, party_site_os,new_party_flag ,TX26,TX9,TX22,TX11,TX14) values(-1,-1,-1,-1,-1,-1,-1,'Y',x_stage_list(I).TX26,x_stage_list(I).TX9,x_stage_list(I).TX22,x_stage_list(I).TX11,x_stage_list(I).TX14);
5159: END LOOP;
5160: END IF;
5161: EXCEPTION
5162: WHEN OTHERS THEN