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_LIMITS

Line 209: SELECT 'Y' INTO x_is_used FROM qp_limits

205: AND qualifier_attribute = p_attribute_code AND rownum < 2;
206: EXCEPTION
207: WHEN no_data_found THEN
208: BEGIN
209: SELECT 'Y' INTO x_is_used FROM qp_limits
210: WHERE ((multival_attr1_context = p_context_code
211: AND multival_attribute1 = p_attribute_code)
212: OR (multival_attr2_context = p_context_code
213: AND multival_attribute2 = p_attribute_code)) AND rownum < 2;

Line 269: SELECT 'Y' INTO x_is_used FROM qp_limits

265: AND product_attribute = p_attribute_code);
266: EXCEPTION
267: WHEN no_data_found THEN
268: BEGIN
269: SELECT 'Y' INTO x_is_used FROM qp_limits
270: WHERE ((multival_attr1_context = p_context_code
271: AND multival_attribute1 = p_attribute_code)
272: OR (multival_attr2_context = p_context_code
273: AND multival_attribute2 = p_attribute_code)) AND rownum < 2;

Line 297: SELECT 'Y' INTO x_is_used FROM qp_limits a, qp_list_headers_b b

293: AND active_flag = 'Y' AND rownum < 2;
294: EXCEPTION
295: WHEN no_data_found THEN
296: BEGIN
297: SELECT 'Y' INTO x_is_used FROM qp_limits a, qp_list_headers_b b
298: WHERE ((a.multival_attr1_context = p_context_code
299: AND a.multival_attribute1 = p_attribute_code)
300: OR (a.multival_attr2_context = p_context_code
301: AND a.multival_attribute2 = p_attribute_code))

Line 308: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

304: EXCEPTION
305: WHEN no_data_found THEN
306: BEGIN
307: SELECT 'Y' INTO x_is_used
308: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
309: WHERE a.limit_attribute_context = p_context_code
310: AND a.limit_attribute = p_attribute_code AND a.limit_id = b.limit_id
311: AND b.list_header_id = c.list_header_id AND c.active_flag = 'Y'
312: AND rownum < 2;

Line 371: SELECT 'Y' INTO x_is_used FROM qp_limits a, qp_list_headers_b b

367: where active_flag = 'Y' and a.list_header_id = b.list_header_id));
368: EXCEPTION
369: WHEN no_data_found THEN
370: BEGIN
371: SELECT 'Y' INTO x_is_used FROM qp_limits a, qp_list_headers_b b
372: WHERE ((a.multival_attr1_context = p_context_code
373: AND a.multival_attribute1 = p_attribute_code)
374: OR (a.multival_attr2_context = p_context_code
375: AND a.multival_attribute2 = p_attribute_code))

Line 382: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

378: EXCEPTION
379: WHEN no_data_found THEN
380: BEGIN
381: SELECT 'Y' INTO x_is_used
382: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
383: WHERE a.limit_attribute_context = p_context_code
384: AND a.limit_attribute = p_attribute_code AND a.limit_id = b.limit_id
385: AND b.list_header_id = c.list_header_id AND c.active_flag = 'Y'
386: AND rownum < 2;