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_BULK_VALIDATE dependencies on QP_PRICING_ATTRIBUTES

Line 64: from qp_pricing_attributes

60: end;
61: begin
62: select count(*)
63: into l_count1
64: from qp_pricing_attributes
65: where orig_sys_line_ref = p_orig_sys_line_ref
66: and orig_sys_header_ref = p_orig_sys_header_ref;
67: exception
68: when others then

Line 77: from qp_pricing_attributes

73: ELSE
74: begin
75: select count(*)
76: into l_count
77: from qp_pricing_attributes
78: where orig_sys_line_ref = p_orig_sys_line_ref
79: and orig_sys_header_ref = p_orig_sys_header_ref;
80: exception
81: when others then

Line 240: from qp_interface_pricing_attribs a, qp_pricing_attributes b

236: -- Bug 5234939 RAVI START
237: ,a.orig_sys_pricing_attr_ref
238: ,b.orig_sys_pricing_attr_ref
239: -- Bug 5234939 RAVI END
240: from qp_interface_pricing_attribs a, qp_pricing_attributes b
241: -- Bug 5234939 RAVI
242: where a.request_id = p_request_id
243: and a.process_status_flag ='P'
244: and b.orig_sys_line_ref <> a.orig_sys_line_ref

Line 284: from qp_pricing_attributes qpa

280: pricing_attribute,
281: pricing_attr_value_from,
282: pricing_attr_value_to,
283: comparison_operator_code
284: from qp_pricing_attributes qpa
285: where qpa.orig_sys_line_ref = l_orig_sys_line_ref
286: -- Bug 5246745 Use Composite Index for Ref columns
287: and qpa.orig_sys_header_ref = l_orig_sys_header_ref
288: and qpa.pricing_attribute_context is not null

Line 454: from qp_pricing_attributes b

450: where a.orig_sys_line_ref=l_dup_lin_rec.a_orig_sys_line_ref(I)
451: and a.request_id = p_request_id;
452:
453: select count(*) into l_pr_attrbs_count
454: from qp_pricing_attributes b
455: where b.orig_sys_line_ref=l_dup_lin_rec.a_orig_sys_line_ref(I)
456: -- Bug 5246745 Use Composite Index for Ref columns
457: and b.orig_sys_header_ref=l_dup_lin_rec.orig_sys_header_ref(I)
458: and b.list_line_id=l_dup_lin_rec.b_list_line_id(I);

Line 2040: from qp_pricing_attributes qpa, mtl_system_items_vl msiv

2036:
2037: if l_exist=0 then
2038: begin
2039: select count(*) into l_exist
2040: from qp_pricing_attributes qpa, mtl_system_items_vl msiv
2041: where qpa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2042: -- Bug 5246745 Use Composite Index for Ref columns
2043: and qpa.orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
2044: and qpa.product_attribute_context = 'ITEM'

Line 3465: qp_pricing_attributes pb

3461: FROM qp_list_lines la,
3462: qp_rltd_modifiers ra,
3463: qp_rltd_modifiers rb,
3464: qp_interface_pricing_attribs pa,
3465: qp_pricing_attributes pb
3466: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3467: -- Bug 5246745 Use Composite Index for Ref columns
3468: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3469: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3525: qp_pricing_attributes pb

3521: FROM qp_list_lines la,
3522: qp_rltd_modifiers ra,
3523: qp_rltd_modifiers rb,
3524: qp_interface_pricing_attribs pa,
3525: qp_pricing_attributes pb
3526: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3527: -- Bug 5246745 Use Composite Index for Ref columns
3528: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3529: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3579: qp_pricing_attributes pb

3575: FROM qp_list_lines la,
3576: qp_rltd_modifiers ra,
3577: qp_rltd_modifiers rb,
3578: qp_interface_pricing_attribs pa,
3579: qp_pricing_attributes pb
3580: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3581: -- Bug 5246745 Use Composite Index for Ref columns
3582: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3583: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3633: qp_pricing_attributes pb

3629: FROM qp_list_lines la,
3630: qp_rltd_modifiers ra,
3631: qp_rltd_modifiers rb,
3632: qp_interface_pricing_attribs pa,
3633: qp_pricing_attributes pb
3634: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3635: -- Bug 5246745 Use Composite Index for Ref columns
3636: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3637: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3840: FROM qp_pricing_attributes

3836: -- Check for the uniqueness of orig_sys_pricing_attr_ref
3837: l_exist:=null;
3838: BEGIN
3839: SELECT 1,pricing_attribute_id INTO l_exist,l_pricing_attribute_id
3840: FROM qp_pricing_attributes
3841: WHERE orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3842: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3843: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
3844: EXCEPTION

Line 3953: FROM qp_pricing_attributes

3949: OR p_pricing_attr_rec.pricing_attribute(I) IS NULL THEN
3950: l_exist := 0;
3951: BEGIN
3952: SELECT count(*) INTO l_exist
3953: FROM qp_pricing_attributes
3954: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3955: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
3956: AND pricing_attribute_context IS NULL
3957: AND pricing_attribute IS NULL

Line 4003: FROM qp_pricing_attributes

3999: AND p_pricing_attr_rec.pricing_attribute(I) IS NOT NULL THEN
4000: l_exist := 0;
4001: BEGIN
4002: SELECT count(*) INTO l_exist
4003: FROM qp_pricing_attributes
4004: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4005: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4006: AND pricing_attribute_context <> p_pricing_attr_rec.pricing_attribute_context(I)
4007: AND orig_sys_pricing_attr_ref <> p_pricing_attr_rec.orig_sys_pricing_attr_ref(I);

Line 4082: FROM qp_pricing_attributes

4078:
4079: BEGIN
4080: l_exist := NULL;
4081: SELECT count(*) INTO l_exist
4082: FROM qp_pricing_attributes
4083: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4084: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4085: AND product_attribute_context <> p_pricing_attr_rec.product_attribute_context(I)
4086: AND product_attribute <> p_pricing_attr_rec.product_attribute(I)

Line 4363: FROM qp_list_lines l, qp_pricing_attributes a

4359: -- Bug# 5228284 RAVI
4360: -- Do not consider the line if it's already the primary flag
4361: SELECT count(*)
4362: INTO l_count
4363: FROM qp_list_lines l, qp_pricing_attributes a
4364: WHERE l.list_line_id = a.list_line_id
4365: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id(I)
4366: AND a.product_attribute_context=p_PRICING_ATTR_rec.product_attribute_context(I)
4367: AND a.product_attribute = p_PRICING_ATTR_rec.product_attribute(I)

Line 4503: qp_pricing_attributes pb,

4499: /* SELECT COUNT(1) INTO l_count
4500: FROM
4501: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ /*DISTINCT pb.pricing_attribute
4502: FROM qp_list_lines la,
4503: qp_pricing_attributes pb,
4504: qp_rltd_modifiers ra
4505: WHERE ra.to_rltd_modifier_id = la.list_line_id
4506: AND pb.list_line_id = ra.to_rltd_modifier_id
4507: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id

Line 4553: qp_pricing_attributes pb,

4549: rb.rltd_modifier_grp_type = 'PRICE BREAK'
4550: UNION
4551: SELECT /*+ leading(la) */ DISTINCT pb.pricing_attribute
4552: FROM qp_list_lines la,
4553: qp_pricing_attributes pb,
4554: qp_rltd_modifiers ra,
4555: qp_rltd_modifiers rb
4556: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4557: la.list_line_type_code = 'PLL' AND

Line 4845: (p_flex_name =>'QP_PRICING_ATTRIBUTES'

4841: IF l_pricing_attr_flex_enabled = 'Y' THEN
4842: qp_bulk_loader_pub.write_log( 'Pricing Attr Flex enabled ');
4843:
4844: IF NOT Init_Desc_Flex
4845: (p_flex_name =>'QP_PRICING_ATTRIBUTES'
4846: ,p_context => p_pricing_attr_rec.context(i)
4847: ,p_attribute1 => p_pricing_attr_rec.attribute1(i)
4848: ,p_attribute2 => p_pricing_attr_rec.attribute2(i)
4849: ,p_attribute3 => p_pricing_attr_rec.attribute3(i)