APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_SRCH_PSITES

Line 189: INSERT INTO HZ_SRCH_PSITES (

185: END LOOP;
186: SAVEPOINT pop_party_sites;
187: BEGIN
188: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
189: INSERT INTO HZ_SRCH_PSITES (
190: TX11, TX14, TX22, TX9, PARTY_SITE_ID, PARTY_ID, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, NEW_PARTY_FLAG, BATCH_ID, INT_ROW_ID , TX26
191: ) VALUES (
192: H_TX11(I), H_TX14(I), H_TX22(I), H_TX9(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_N_PARTY(I), P_BATCH_ID, H_P_ROW_ID(I) , H_PS_CUST_TX26(I)
193: );

Line 495: INSERT INTO HZ_SRCH_PSITES (

491: END LOOP;
492: SAVEPOINT pop_party_sites_int;
493: BEGIN
494: FORALL I in H_P_PS_OSR.FIRST..H_P_PS_OSR.LAST
495: INSERT INTO HZ_SRCH_PSITES (
496: TX11, TX14, TX22, TX9, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, BATCH_ID, INT_ROW_ID, TX26 , PARTY_ID
497: ) VALUES (
498: H_TX11(I), H_TX14(I), H_TX22(I), H_TX9(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), H_P_PS_OS(I), H_P_PS_OSR(I), P_BATCH_ID, H_P_ROW_ID(I), H_PS_CUST_TX26(I) , H_P_PARTY_ID(I)
499: );

Line 958: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

954: decode(instrb(s2.TX22,s1.TX22),1,5,
955: 0
956: )
957: score , s1.party_osr party_osr, s1.party_os party_os
958: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
959: 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'
960: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
961: and (
962: -------PARTY_SITES ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 1135: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

1131: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1132: s2.PARTY_SITE_ID
1133: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1134: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1135: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1136: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1137: and s1.party_id = s2.party_id
1138: and (
1139: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1351: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2

1347: decode(instrb(s2.TX22,s1.TX22),1,5,
1348: 0
1349: )
1350: score, s1.party_os fos, s2.party_os tos
1351: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1352: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.party_osr <> s2.party_osr
1353: 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)
1354: and (
1355: -------PARTY_SITES ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 1494: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2

1490: )
1491: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1492: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1493: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1494: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1495: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1496: 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) )
1497: and s2.batch_id = p_batch_id and s1.PARTY_SITE_OSR < s2.PARTY_SITE_OSR
1498: and (