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_52 dependencies on HZ_STAGED_PARTIES

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

705: decode(instrb(s2.TX45,s1.TX45),1,200,
706: 0
707: )
708: score
709: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2
710: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
711: and nvl(s1.status,'A') = 'A' and nvl(s2.status,'A') = 'A'
712: and 1=decode(trap_explosion,'N',1,decode(rownum,l_party_limit,to_number('A'),1))
713: and (

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

746: )
747: score
748: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
749: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
750: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
751: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
752: and (
753: -------CONTACT_POINTS ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES---------
754: -- do an or between all the transformations of an attribute --

Line 773: SELECT 1 FROM HZ_STAGED_PARTIES p1, HZ_STAGED_PARTIES p2

769: ) group by f, t
770: )
771: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
772: where EXISTS (
773: SELECT 1 FROM HZ_STAGED_PARTIES p1, HZ_STAGED_PARTIES p2
774: WHERE p1.party_id = f and p2.party_id = t
775: and
776: -- do an or between all the transformations of an attribute --
777: (

Line 928: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2

924: decode(instrb(s2.TX45,s1.TX45),1,200,
925: 0
926: )
927: score , s1.party_osr party_osr, s1.party_os party_os
928: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2
929: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
930: and nvl(s2.status,'A') = 'A'
931: and (
932: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

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

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

Line 991: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2

987: group by f, t, party_osr, party_os
988: )
989: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
990: where EXISTS (
991: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2
992: WHERE p1.batch_id = p_batch_id and p1.party_osr = party_osr and p1.party_os = party_os
993: and p2.party_id = t
994: and
995: -- do an or between all the transformations of an attribute --