APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_SRCH_CPTS

Line 250: INSERT INTO HZ_SRCH_CPTS (

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

Line 555: INSERT INTO HZ_SRCH_CPTS (

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

Line 1011: from hz_imp_dup_parties h1, HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

1007: 0
1008: )
1009: )
1010: score
1011: from hz_imp_dup_parties h1, HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1012: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1013: and s1.batch_id = h1.batch_id and s1.party_osr = h1.party_osr and s1.party_os = h1.party_os and s2.party_id = h1.dup_party_id
1014: and (
1015: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1188: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

1184: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1185: s2.CONTACT_POINT_ID
1186: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1187: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1188: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1189: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1190: and s1.party_id = s2.party_id
1191: and (
1192: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1405: from hz_int_dup_results h1, HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2

1401: 0
1402: )
1403: )
1404: score
1405: from hz_int_dup_results h1, HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1406: where
1407: s1.party_osr = h1.f_osr and s2.party_osr = h1.t_osr and h1.batch_id = p_batch_id
1408: and s1.party_osr between from_osr and to_osr
1409: and s1.contact_point_type = s2.contact_point_type

Line 1539: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2

1535: )
1536: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1537: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1538: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1539: from HZ_SRCH_CPTS s1, HZ_SRCH_CPTS s2
1540: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1541: 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) )
1542: and s2.batch_id = p_batch_id and s1.CONTACT_PT_OSR < s2.CONTACT_PT_OSR
1543: and s1.contact_point_type = s2.contact_point_type