APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_SRCH_CPTS

Line 236: INSERT INTO HZ_SRCH_CPTS (

232: END LOOP;
233: SAVEPOINT POP_CP;
234: BEGIN
235: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
236: INSERT INTO HZ_SRCH_CPTS (
237: TX5, PARTY_SITE_ID, PARTY_ID, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, CONTACT_POINT_ID, CONTACT_PT_OS, CONTACT_PT_OSR, NEW_PARTY_FLAG, BATCH_ID, INT_ROW_ID, CONTACT_POINT_TYPE , TX10, TX158
238: ) VALUES (
239: H_TX5(I), H_P_PARTY_SITE_ID(I), H_P_PARTY_ID(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), H_P_PS_OS(I), H_P_PS_OSR(I) , H_P_CONTACT_POINT_ID(I), H_P_CP_OS(I), H_P_CP_OSR(I), H_P_N_PARTY(I), P_BATCH_ID, H_P_ROW_ID(I), H_P_CP_TYPE(I) , H_CP_CUST_TX10(I), H_CP_CUST_TX158(I)
240: );

Line 457: INSERT INTO HZ_SRCH_CPTS (

453: END LOOP;
454: SAVEPOINT pop_cp_int;
455: BEGIN
456: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
457: INSERT INTO HZ_SRCH_CPTS (
458: TX5, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, CONTACT_PT_OS, CONTACT_PT_OSR, BATCH_ID, INT_ROW_ID, CONTACT_POINT_TYPE, TX10, TX158 , PARTY_ID
459: ) VALUES (
460: H_TX5(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), H_P_PS_OS(I), H_P_PS_OSR(I), H_P_CP_OS(I), H_P_CP_OSR(I), P_BATCH_ID, H_P_ROW_ID(I), H_P_CP_TYPE(I), H_CP_CUST_TX10(I), H_CP_CUST_TX158(I) ,H_P_PARTY_ID(I)
461: );

Line 735: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

731: 0
732: )
733: )
734: score , s1.party_osr party_osr, s1.party_os party_os
735: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
736: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'I'
737: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
738: and (
739: -------CONTACT_POINTS ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 878: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

874: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
875: s2.CONTACT_POINT_ID
876: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
877: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
878: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
879: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
880: and s1.party_id = s2.party_id
881: and (
882: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1038: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2

1034: 0
1035: )
1036: )
1037: score, s1.party_os fos, s2.party_os tos
1038: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1039: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.party_osr <> s2.party_osr
1040: and s2.batch_id = p_batch_id and not exists (select 1 from HZ_INT_DUP_RESULTS WHERE t_osr = s1.party_osr and batch_id = p_batch_id)
1041: and s1.contact_point_type = s2.contact_point_type
1042: and (

Line 1145: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2

1141: )
1142: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1143: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1144: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1145: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1146: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1147: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )
1148: and s2.batch_id = p_batch_id and s1.CONTACT_PT_OSR < s2.CONTACT_PT_OSR
1149: and s1.contact_point_type = s2.contact_point_type