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 4019: ( p_list_header_id IN qp_list_headers_b.list_header_id%type

4015: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
4016: -- mkarya for bug 2442212, Prevent update of modifier if PTE does not match with Profile value
4017: -- New procedure created
4018: PROCEDURE Check_Source_System_Code
4019: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
4020: , p_list_line_id IN qp_list_lines.list_line_id%type
4021: , x_return_status OUT NOCOPY VARCHAR2
4022: )
4023: is

Line 4024: l_source_system_code qp_list_headers_b.source_system_code%type;

4020: , p_list_line_id IN qp_list_lines.list_line_id%type
4021: , x_return_status OUT NOCOPY VARCHAR2
4022: )
4023: is
4024: l_source_system_code qp_list_headers_b.source_system_code%type;
4025: l_list_type_code qp_list_headers_b.list_type_code%type;
4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4027: l_profile_pte_code qp_list_headers_b.pte_code%type;
4028: l_pte_code qp_list_headers_b.pte_code%type;

Line 4025: l_list_type_code qp_list_headers_b.list_type_code%type;

4021: , x_return_status OUT NOCOPY VARCHAR2
4022: )
4023: is
4024: l_source_system_code qp_list_headers_b.source_system_code%type;
4025: l_list_type_code qp_list_headers_b.list_type_code%type;
4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4027: l_profile_pte_code qp_list_headers_b.pte_code%type;
4028: l_pte_code qp_list_headers_b.pte_code%type;
4029: BEGIN

Line 4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;

4022: )
4023: is
4024: l_source_system_code qp_list_headers_b.source_system_code%type;
4025: l_list_type_code qp_list_headers_b.list_type_code%type;
4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4027: l_profile_pte_code qp_list_headers_b.pte_code%type;
4028: l_pte_code qp_list_headers_b.pte_code%type;
4029: BEGIN
4030: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4027: l_profile_pte_code qp_list_headers_b.pte_code%type;

4023: is
4024: l_source_system_code qp_list_headers_b.source_system_code%type;
4025: l_list_type_code qp_list_headers_b.list_type_code%type;
4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4027: l_profile_pte_code qp_list_headers_b.pte_code%type;
4028: l_pte_code qp_list_headers_b.pte_code%type;
4029: BEGIN
4030: x_return_status := FND_API.G_RET_STS_SUCCESS;
4031:

Line 4028: l_pte_code qp_list_headers_b.pte_code%type;

4024: l_source_system_code qp_list_headers_b.source_system_code%type;
4025: l_list_type_code qp_list_headers_b.list_type_code%type;
4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4027: l_profile_pte_code qp_list_headers_b.pte_code%type;
4028: l_pte_code qp_list_headers_b.pte_code%type;
4029: BEGIN
4030: x_return_status := FND_API.G_RET_STS_SUCCESS;
4031:
4032: if p_list_header_id is NOT NULL then

Line 4039: from qp_list_headers_b

4035: , pte_code
4036: into l_source_system_code
4037: , l_list_type_code
4038: , l_pte_code
4039: from qp_list_headers_b
4040: where list_header_id = p_list_header_id;
4041: else
4042: select lh.source_system_code
4043: , lh.list_type_code

Line 4048: from qp_list_headers_b lh,

4044: , lh.pte_code
4045: into l_source_system_code
4046: , l_list_type_code
4047: , l_pte_code
4048: from qp_list_headers_b lh,
4049: qp_list_lines ll
4050: where ll.list_line_id = p_list_line_id
4051: and lh.list_header_id = ll.list_header_id;
4052: end if;

Line 4245: qp_list_headers_b d

4241: into l_segment_level
4242: from qp_prc_contexts_b a,
4243: qp_segments_b b,
4244: qp_pte_segments c,
4245: qp_list_headers_b d
4246: where a.prc_context_id = b.prc_context_id
4247: and b.segment_id = c.segment_id
4248: and c.pte_code = d.pte_code
4249: and d.list_header_id = p_list_header_id

Line 5107: FROM qp_list_headers_b

5103: IS
5104: BEGIN
5105: SELECT pte_code, source_system_code
5106: INTO x_pte_code, x_source_system_code
5107: FROM qp_list_headers_b
5108: WHERE list_header_id = p_list_header_id;
5109: EXCEPTION
5110: When OTHERS Then
5111: null;