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_LIST_HEADERS_B

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 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 334: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c

330: WHEN no_data_found THEN
331: BEGIN
332: SELECT 'Y'
333: INTO x_is_used
334: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
335: WHERE a.pricing_attribute_context = p_context_code
336: AND a.pricing_attribute = p_attribute_code
337: AND a.price_formula_id = b.price_by_formula_id
338: AND b.list_header_id = c.list_header_id

Line 366: AND exists (select 'x' from qp_list_headers_b b

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));
368: EXCEPTION
369: WHEN no_data_found THEN
370: BEGIN

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;

Line 4042: ( p_list_header_id IN qp_list_headers_b.list_header_id%type

4038: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
4039: -- mkarya for bug 2442212, Prevent update of modifier if PTE does not match with Profile value
4040: -- New procedure created
4041: PROCEDURE Check_Source_System_Code
4042: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
4043: , p_list_line_id IN qp_list_lines.list_line_id%type
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: )
4046: is

Line 4047: l_source_system_code qp_list_headers_b.source_system_code%type;

4043: , p_list_line_id IN qp_list_lines.list_line_id%type
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: )
4046: is
4047: l_source_system_code qp_list_headers_b.source_system_code%type;
4048: l_list_type_code qp_list_headers_b.list_type_code%type;
4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4050: l_profile_pte_code qp_list_headers_b.pte_code%type;
4051: l_pte_code qp_list_headers_b.pte_code%type;

Line 4048: l_list_type_code qp_list_headers_b.list_type_code%type;

4044: , x_return_status OUT NOCOPY VARCHAR2
4045: )
4046: is
4047: l_source_system_code qp_list_headers_b.source_system_code%type;
4048: l_list_type_code qp_list_headers_b.list_type_code%type;
4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4050: l_profile_pte_code qp_list_headers_b.pte_code%type;
4051: l_pte_code qp_list_headers_b.pte_code%type;
4052: BEGIN

Line 4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;

4045: )
4046: is
4047: l_source_system_code qp_list_headers_b.source_system_code%type;
4048: l_list_type_code qp_list_headers_b.list_type_code%type;
4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4050: l_profile_pte_code qp_list_headers_b.pte_code%type;
4051: l_pte_code qp_list_headers_b.pte_code%type;
4052: BEGIN
4053: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4050: l_profile_pte_code qp_list_headers_b.pte_code%type;

4046: is
4047: l_source_system_code qp_list_headers_b.source_system_code%type;
4048: l_list_type_code qp_list_headers_b.list_type_code%type;
4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4050: l_profile_pte_code qp_list_headers_b.pte_code%type;
4051: l_pte_code qp_list_headers_b.pte_code%type;
4052: BEGIN
4053: x_return_status := FND_API.G_RET_STS_SUCCESS;
4054:

Line 4051: l_pte_code qp_list_headers_b.pte_code%type;

4047: l_source_system_code qp_list_headers_b.source_system_code%type;
4048: l_list_type_code qp_list_headers_b.list_type_code%type;
4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4050: l_profile_pte_code qp_list_headers_b.pte_code%type;
4051: l_pte_code qp_list_headers_b.pte_code%type;
4052: BEGIN
4053: x_return_status := FND_API.G_RET_STS_SUCCESS;
4054:
4055: if p_list_header_id is NOT NULL then

Line 4062: from qp_list_headers_b

4058: , pte_code
4059: into l_source_system_code
4060: , l_list_type_code
4061: , l_pte_code
4062: from qp_list_headers_b
4063: where list_header_id = p_list_header_id;
4064: else
4065: select lh.source_system_code
4066: , lh.list_type_code

Line 4071: from qp_list_headers_b lh,

4067: , lh.pte_code
4068: into l_source_system_code
4069: , l_list_type_code
4070: , l_pte_code
4071: from qp_list_headers_b lh,
4072: qp_list_lines ll
4073: where ll.list_line_id = p_list_line_id
4074: and lh.list_header_id = ll.list_header_id;
4075: end if;

Line 4268: qp_list_headers_b d

4264: into l_segment_level
4265: from qp_prc_contexts_b a,
4266: qp_segments_b b,
4267: qp_pte_segments c,
4268: qp_list_headers_b d
4269: where a.prc_context_id = b.prc_context_id
4270: and b.segment_id = c.segment_id
4271: and c.pte_code = d.pte_code
4272: and d.list_header_id = p_list_header_id

Line 5130: FROM qp_list_headers_b

5126: IS
5127: BEGIN
5128: SELECT pte_code, source_system_code
5129: INTO x_pte_code, x_source_system_code
5130: FROM qp_list_headers_b
5131: WHERE list_header_id = p_list_header_id;
5132: EXCEPTION
5133: When OTHERS Then
5134: null;