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 505: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)

501: if(regid_proc = true) then
502: insert into hz_application_trans_gt(app_id,party_id) select 661, temp.party_id from hz_purge_gt temp where
503:
504:
505: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)
506: 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'))))
507:
508: or exists (select 'Y' from HZ_PARTY_SITES
509: xx where xx.PARTY_ID = temp.party_id

Line 512: (select 'Y' from QP_QUALIFIERS

508: or exists (select 'Y' from HZ_PARTY_SITES
509: xx where xx.PARTY_ID = temp.party_id
510: and (nvl(STATUS, 'A') in ('A','I'))
511: and exists
512: (select 'Y' from QP_QUALIFIERS
513: yy where yy.QUALIFIER_ATTR_VALUE=to_char(xx.PARTY_SITE_ID)
514: and (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
515: else
516: delete from hz_purge_gt temp where

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

515: else
516: delete from hz_purge_gt temp where
517:
518:
519: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)
520: 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'))))
521:
522: or exists (select 'Y' from HZ_PARTY_SITES
523: xx where xx.PARTY_ID = temp.party_id

Line 526: (select 'Y' from QP_QUALIFIERS

522: or exists (select 'Y' from HZ_PARTY_SITES
523: xx where xx.PARTY_ID = temp.party_id
524: and (nvl(STATUS, 'A') in ('A','I'))
525: and exists
526: (select 'Y' from QP_QUALIFIERS
527: yy where yy.QUALIFIER_ATTR_VALUE=to_char(xx.PARTY_SITE_ID)
528: and (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
529: end if;
530: