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.QP_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 229: INTO x_is_used FROM qp_pricing_attributes

225: END;
226: ELSIF p_context_type='PRICING_ATTRIBUTE' THEN
227: BEGIN
228: SELECT 'Y'
229: INTO x_is_used FROM qp_pricing_attributes
230: WHERE pricing_attribute_context = p_context_code
231: AND pricing_attribute = p_attribute_code AND rownum < 2;
232: EXCEPTION
233: WHEN no_data_found THEN

Line 263: FROM qp_pricing_attributes

259: ELSIF p_context_type='PRODUCT' THEN
260: BEGIN
261: SELECT 'Y' INTO x_is_used FROM dual
262: where exists(SELECT 'Y'
263: FROM qp_pricing_attributes
264: WHERE product_attribute_context = p_context_code
265: AND product_attribute = p_attribute_code);
266: EXCEPTION
267: WHEN no_data_found THEN

Line 323: where exists(SELECT 'Y' FROM qp_pricing_attributes qpa, qp_list_headers_b qph

319: ELSIF p_context_type='PRICING_ATTRIBUTE' THEN
320: BEGIN
321: --modified query to improve performance.
322: SELECT 'Y' INTO x_is_used FROM dual
323: where exists(SELECT 'Y' FROM qp_pricing_attributes qpa, qp_list_headers_b qph
324: WHERE qpa.pricing_attribute_context = p_context_code
325: AND qpa.pricing_attribute = p_attribute_code
326: AND qpa.list_header_id = qph.list_header_id
327: AND qph.active_flag = 'Y'

Line 363: FROM qp_pricing_attributes a

359: BEGIN
360: SELECT 'Y'
361: INTO x_is_used FROM dual
362: WHERE exists (SELECT 'Y'
363: FROM qp_pricing_attributes a
364: WHERE product_attribute_context = p_context_code
365: AND product_attribute = p_attribute_code
366: AND exists (select 'x' from qp_list_headers_b b
367: where active_flag = 'Y' and a.list_header_id = b.list_header_id));