eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_STAGED_PARTIES

Line 544: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2

540: decode(instrb(s2.TX45,s1.TX45),1,200,
541: 0
542: )
543: score
544: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2
545: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
546: and nvl(s1.status,'A') = 'A' and nvl(s2.status,'A') = 'A'
547: and 1=decode(trap_explosion,'N',1,decode(rownum,l_party_limit,to_number('A'),1))
548: and (

Line 576: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')

572: )
573: score
574: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
575: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
576: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
577: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
578: and (
579: -------CONTACT_POINTS ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES---------
580: -- do an or between all the transformations of an attribute --

Line 594: SELECT 1 FROM HZ_STAGED_PARTIES p1, HZ_STAGED_PARTIES p2

590: ) group by f, t
591: )
592: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
593: where EXISTS (
594: SELECT 1 FROM HZ_STAGED_PARTIES p1, HZ_STAGED_PARTIES p2
595: WHERE p1.party_id = f and p2.party_id = t
596: and
597: -- do an or between all the transformations of an attribute --
598: (

Line 706: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2

702: decode(instrb(s2.TX45,s1.TX45),1,200,
703: 0
704: )
705: score , s1.party_osr party_osr, s1.party_os party_os
706: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2
707: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
708: and nvl(s2.status,'A') = 'A'
709: and (
710: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 737: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')

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 ---------
740: -- do an or between all the transformations of an attribute --
741: (

Line 755: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2

751: group by f, t, party_osr, party_os
752: )
753: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
754: where EXISTS (
755: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2
756: WHERE p1.batch_id = p_batch_id and p1.party_osr = party_osr and p1.party_os = party_os
757: and p2.party_id = t
758: and
759: -- do an or between all the transformations of an attribute --