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_PSITES

Line 1285: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch

1281: BEGIN
1282: IF p_party_id IS NOT NULL THEN
1283: OPEN x_cursor FOR
1284: 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
1285: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1286: WHERE
1287: srch.batch_id = -1
1288: AND
1289: (

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

1301: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1302: IF p_search_ctx_id IS NULL THEN
1303: OPEN x_cursor FOR
1304: 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
1305: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p
1306: WHERE
1307: srch.batch_id = -1
1308: AND
1309: (

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

1318: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1319: ELSE
1320: OPEN x_cursor FOR
1321: SELECT /*+ ORDERED 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
1322: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1323: WHERE
1324: srch.batch_id = -1
1325: AND
1326: (

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

1335: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1336: END IF;
1337: ELSE
1338: 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'||
1339: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||
1340: ' WHERE' ||
1341: 'srch.batch_id = -1'||
1342: 'AND'||
1343: '('||

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

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

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

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

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

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

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

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