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.

[Home] [Help]

APPS.HZ_MATCH_RULE_51 dependencies on HZ_SRCH_PSITES

Line 1058: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch

1054: BEGIN
1055: IF p_party_id IS NOT NULL THEN
1056: OPEN x_cursor FOR
1057: 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
1058: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1059: WHERE
1060: srch.batch_id = -1
1061: AND
1062: (

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

1074: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1075: IF p_search_ctx_id IS NULL THEN
1076: OPEN x_cursor FOR
1077: 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
1078: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p
1079: WHERE
1080: srch.batch_id = -1
1081: AND
1082: (

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

1091: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1092: ELSE
1093: OPEN x_cursor FOR
1094: SELECT stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1095: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1096: WHERE
1097: srch.batch_id = -1
1098: AND
1099: (

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

1108: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1109: END IF;
1110: ELSE
1111: 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'||
1112: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||
1113: ' WHERE' ||
1114: 'srch.batch_id = -1'||
1115: 'AND'||
1116: '('||

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

4119: CLOSE l_contact_pt_cur;
4120: END IF;
4121: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4122: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4123: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4124: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4125: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: 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 4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

4129: EXCEPTION
4130: WHEN FND_API.G_EXC_ERROR THEN
4131: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: WHEN OTHERS THEN

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

4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: WHEN OTHERS THEN
4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');

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

4789: END IF;
4790: END LOOP;
4791: IF p_search_ctx THEN
4792: FOR I IN 1..p_search_list.COUNT LOOP
4793: 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);
4794: END LOOP;
4795: END IF;
4796: EXCEPTION
4797: WHEN OTHERS THEN