APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_SRCH_CPTS

Line 251: INSERT INTO HZ_SRCH_CPTS (

247: END LOOP;
248: SAVEPOINT POP_CP;
249: BEGIN
250: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
251: INSERT INTO HZ_SRCH_CPTS (
252: TX5, TX7, 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
253: ) VALUES (
254: H_TX5(I), H_TX7(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)
255: );

Line 556: INSERT INTO HZ_SRCH_CPTS (

552: END LOOP;
553: SAVEPOINT pop_cp_int;
554: BEGIN
555: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
556: INSERT INTO HZ_SRCH_CPTS (
557: TX5, TX7, 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
558: ) VALUES (
559: H_TX5(I), H_TX7(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)
560: );

Line 966: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

962: 0
963: )
964: )
965: score , s1.party_osr party_osr, s1.party_os party_os
966: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
967: 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'
968: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
969: and (
970: -------CONTACT_POINTS ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 1152: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

1148: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1149: s2.CONTACT_POINT_ID
1150: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1151: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1152: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1153: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1154: and s1.party_id = s2.party_id
1155: and (
1156: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1377: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2

1373: 0
1374: )
1375: )
1376: score, s1.party_os fos, s2.party_os tos
1377: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1378: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.party_osr <> s2.party_osr
1379: 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)
1380: and s1.contact_point_type = s2.contact_point_type
1381: and (

Line 1529: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2

1525: )
1526: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1527: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1528: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1529: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1530: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1531: 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) )
1532: and s2.batch_id = p_batch_id and s1.CONTACT_PT_OSR < s2.CONTACT_PT_OSR
1533: and s1.contact_point_type = s2.contact_point_type