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 OE_PRICE_ADJ_ATTRIBS

Line 2761: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)

2757: if(regid_proc = true) then
2758: insert into hz_application_trans_gt(app_id,party_id) select 660, temp.party_id from hz_purge_gt temp where
2759:
2760:
2761: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)
2762: and (pricing_context = 'ASOPARTYINFO' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1' OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16' OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3' OR pricing_context = 'PARTY' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2')))
2763:
2764: or exists (select 'Y' from HZ_PARTY_SITES
2765: xx where xx.PARTY_ID = temp.party_id

Line 2768: (select 'Y' from OE_PRICE_ADJ_ATTRIBS

2764: or exists (select 'Y' from HZ_PARTY_SITES
2765: xx where xx.PARTY_ID = temp.party_id
2766: and (nvl(STATUS, 'A') in ('A','I'))
2767: and exists
2768: (select 'Y' from OE_PRICE_ADJ_ATTRIBS
2769: yy where yy.PRICING_ATTR_VALUE_FROM=to_char(xx.PARTY_SITE_ID)
2770: and pricing_context = 'ASOPARTYINFO' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR pricing_context = 'CUSTOMER' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18')));
2771: else
2772: delete from hz_purge_gt temp where

Line 2775: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)

2771: else
2772: delete from hz_purge_gt temp where
2773:
2774:
2775: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)
2776: and (pricing_context = 'ASOPARTYINFO' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1' OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16' OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3' OR pricing_context = 'PARTY' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2')))
2777:
2778: or exists (select 'Y' from HZ_PARTY_SITES
2779: xx where xx.PARTY_ID = temp.party_id

Line 2782: (select 'Y' from OE_PRICE_ADJ_ATTRIBS

2778: or exists (select 'Y' from HZ_PARTY_SITES
2779: xx where xx.PARTY_ID = temp.party_id
2780: and (nvl(STATUS, 'A') in ('A','I'))
2781: and exists
2782: (select 'Y' from OE_PRICE_ADJ_ATTRIBS
2783: yy where yy.PRICING_ATTR_VALUE_FROM=to_char(xx.PARTY_SITE_ID)
2784: and pricing_context = 'ASOPARTYINFO' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR pricing_context = 'CUSTOMER' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18')));
2785: end if;
2786: