APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_STAGED_PARTY_SITES

Line 749: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2

745: decode(instrb(s2.TX22,s1.TX22),1,5,
746: 0
747: )
748: score
749: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
750: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
751: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
752: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
753: and (

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 ------------------------