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_PURGE_GEN dependencies on QP_QUALIFIERS

Line 687: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)

683: if(regid_proc = true) then
684: insert into hz_application_trans_gt(app_id,party_id) select 661, temp.party_id from hz_purge_gt temp where
685:
686:
687: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)
688: and ((qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16' OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3' OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))
689:
690: or exists (select 'Y' from HZ_PARTY_SITES
691: xx where xx.PARTY_ID = temp.party_id

Line 694: (select 'Y' from QP_QUALIFIERS

690: or exists (select 'Y' from HZ_PARTY_SITES
691: xx where xx.PARTY_ID = temp.party_id
692: and (nvl(STATUS, 'A') in ('A','I'))
693: and exists
694: (select 'Y' from QP_QUALIFIERS
695: yy where yy.QUALIFIER_ATTR_VALUE=to_char(xx.PARTY_SITE_ID)
696: and (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
697: else
698: delete from hz_purge_gt temp where

Line 701: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)

697: else
698: delete from hz_purge_gt temp where
699:
700:
701: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)
702: and ((qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16' OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3' OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))
703:
704: or exists (select 'Y' from HZ_PARTY_SITES
705: xx where xx.PARTY_ID = temp.party_id

Line 708: (select 'Y' from QP_QUALIFIERS

704: or exists (select 'Y' from HZ_PARTY_SITES
705: xx where xx.PARTY_ID = temp.party_id
706: and (nvl(STATUS, 'A') in ('A','I'))
707: and exists
708: (select 'Y' from QP_QUALIFIERS
709: yy where yy.QUALIFIER_ATTR_VALUE=to_char(xx.PARTY_SITE_ID)
710: and (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
711: end if;
712: