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

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

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

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

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 (
754: -------PARTY_SITES ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES---------
755: -- do an or between all the transformations of an attribute --

Line 770: SELECT 1 FROM HZ_STAGED_PARTIES p1, HZ_STAGED_PARTIES p2

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

Line 918: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2

914: decode(instrb(s2.TX45,s1.TX45),1,200,
915: 0
916: )
917: score , s1.party_osr party_osr, s1.party_os party_os
918: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2
919: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
920: and nvl(s2.status,'A') = 'A'
921: and (
922: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

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

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

Line 979: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2

975: group by f, t, party_osr, party_os
976: )
977: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
978: where EXISTS (
979: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2
980: WHERE p1.batch_id = p_batch_id and p1.party_osr = party_osr and p1.party_os = party_os
981: and p2.party_id = t
982: and
983: -- do an or between all the transformations of an attribute --