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 2854: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)

2850: if(regid_proc = true) then
2851: insert into hz_application_trans_gt(app_id,party_id) select 660, temp.party_id from hz_purge_gt temp where
2852:
2853:
2854: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)
2855: 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'))))
2856:
2857: or exists (select 'Y' from HZ_PARTY_SITES
2858: xx where xx.PARTY_ID = temp.party_id

Line 2861: (select 'Y' from OE_PRICE_ADJ_ATTRIBS

2857: or exists (select 'Y' from HZ_PARTY_SITES
2858: xx where xx.PARTY_ID = temp.party_id
2859: and (nvl(STATUS, 'A') in ('A','I'))
2860: and exists
2861: (select 'Y' from OE_PRICE_ADJ_ATTRIBS
2862: yy where yy.PRICING_ATTR_VALUE_FROM=to_char(xx.PARTY_SITE_ID)
2863: and (pricing_context = 'ASOPARTYINFO' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR pricing_context = 'CUSTOMER' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
2864: else
2865: delete from hz_purge_gt temp where

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

2864: else
2865: delete from hz_purge_gt temp where
2866:
2867:
2868: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)
2869: 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'))))
2870:
2871: or exists (select 'Y' from HZ_PARTY_SITES
2872: xx where xx.PARTY_ID = temp.party_id

Line 2875: (select 'Y' from OE_PRICE_ADJ_ATTRIBS

2871: or exists (select 'Y' from HZ_PARTY_SITES
2872: xx where xx.PARTY_ID = temp.party_id
2873: and (nvl(STATUS, 'A') in ('A','I'))
2874: and exists
2875: (select 'Y' from OE_PRICE_ADJ_ATTRIBS
2876: yy where yy.PRICING_ATTR_VALUE_FROM=to_char(xx.PARTY_SITE_ID)
2877: and (pricing_context = 'ASOPARTYINFO' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR pricing_context = 'CUSTOMER' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
2878: end if;
2879: