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_RLTD_MODIFIERS

Line 378: FROM qp_rltd_modifiers qrm,

374: ELSIF i_mode = 2 --IF1
375: THEN
376: BEGIN
377: SELECT 'X' INTO l_dummy
378: FROM qp_rltd_modifiers qrm,
379: qp_list_lines b
380: WHERE b.orig_sys_header_ref = l_dup_line_rec.orig_sys_header_ref(i)
381: AND b.orig_sys_line_ref = l_dup_line_rec.b_orig_sys_line_ref(i)
382: AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 2043: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2039: -- Bug# 5228560 RAVI START
2040: l_dummy:= null;
2041:
2042: select count(*) into l_dummy
2043: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2044: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2045: -- Bug 5246745 Use Composite Index for Ref columns
2046: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2047: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

Line 2069: -- FROM qp_list_lines pl, qp_list_lines cl,qp_rltd_modifiers rtd

2065: p_LINE_rec.price_break_type_code(I) = 'POINT')
2066: THEN
2067: -- SELECT count(*)
2068: -- INTO l_dummy
2069: -- FROM qp_list_lines pl, qp_list_lines cl,qp_rltd_modifiers rtd
2070: -- WHERE pl.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2071: -- AND rtd.from_rltd_modifier_id = pl.list_line_id
2072: -- AND cl.list_line_id = rtd.to_rltd_modifier_id
2073: -- AND (cl.arithmetic_operator = 'UNIT_PRICE' OR cl.recurring_value IS NOT NULL);

Line 2094: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2090: IF p_LINE_rec.arithmetic_operator(I) = 'BLOCK_PRICE' THEN
2091: l_dummy := null;
2092: IF p_LINE_rec.price_break_type_code(I) = 'RANGE' THEN
2093: select count(*) into l_dummy
2094: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2095: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2096: -- Bug 5246745 Use Composite Index for Ref columns
2097: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2098: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

Line 2113: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2109:
2110: l_dummy := null;
2111: IF p_LINE_rec.price_break_type_code(I) = 'POINT' THEN
2112: select count(*) into l_dummy
2113: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2114: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2115: -- Bug 5246745 Use Composite Index for Ref columns
2116: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2117: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

Line 2213: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2209:
2210: --Get the PBH details
2211: SELECT L2.price_break_type_code, L2.arithmetic_operator
2212: INTO l_pb_type_code, l_art_opr
2213: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2214: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2215: -- Bug 5246745 Use Composite Index for Ref columns
2216: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2217: and l1.list_line_id=l3.TO_RLTD_MODIFIER_ID

Line 3350: qp_rltd_modifiers ra,

3346: Check for overlap of price breaks
3347: **/
3348: SELECT 'OVERLAP'
3349: FROM qp_list_lines la,
3350: qp_rltd_modifiers ra,
3351: qp_rltd_modifiers rb,
3352: qp_interface_pricing_attribs pa,
3353: qp_pricing_attributes pb
3354: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3351: qp_rltd_modifiers rb,

3347: **/
3348: SELECT 'OVERLAP'
3349: FROM qp_list_lines la,
3350: qp_rltd_modifiers ra,
3351: qp_rltd_modifiers rb,
3352: qp_interface_pricing_attribs pa,
3353: qp_pricing_attributes pb
3354: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3355: -- Bug 5246745 Use Composite Index for Ref columns

Line 3410: qp_rltd_modifiers ra,

3406: SELECT count(*) old_break_pa_count,
3407: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3408: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3409: FROM qp_list_lines la,
3410: qp_rltd_modifiers ra,
3411: qp_rltd_modifiers rb,
3412: qp_interface_pricing_attribs pa,
3413: qp_pricing_attributes pb
3414: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3411: qp_rltd_modifiers rb,

3407: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3408: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3409: FROM qp_list_lines la,
3410: qp_rltd_modifiers ra,
3411: qp_rltd_modifiers rb,
3412: qp_interface_pricing_attribs pa,
3413: qp_pricing_attributes pb
3414: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3415: -- Bug 5246745 Use Composite Index for Ref columns

Line 3440: qp_rltd_modifiers ra,

3436: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3437: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3438: FROM qp_list_lines la,
3439: qp_list_lines lb,
3440: qp_rltd_modifiers ra,
3441: qp_rltd_modifiers rb,
3442: qp_interface_pricing_attribs pa,
3443: qp_interface_pricing_attribs pb
3444: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3441: qp_rltd_modifiers rb,

3437: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3438: FROM qp_list_lines la,
3439: qp_list_lines lb,
3440: qp_rltd_modifiers ra,
3441: qp_rltd_modifiers rb,
3442: qp_interface_pricing_attribs pa,
3443: qp_interface_pricing_attribs pb
3444: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3445: -- Bug 5246745 Use Composite Index for Ref columns

Line 3464: qp_rltd_modifiers ra,

3460: -- Bug 5246745 Use Composite Index for Ref columns
3461: p_orig_sys_header_ref VARCHAR2) IS
3462: SELECT count(*) l_from_value_old
3463: FROM qp_list_lines la,
3464: qp_rltd_modifiers ra,
3465: qp_rltd_modifiers rb,
3466: qp_interface_pricing_attribs pa,
3467: qp_pricing_attributes pb
3468: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3465: qp_rltd_modifiers rb,

3461: p_orig_sys_header_ref VARCHAR2) IS
3462: SELECT count(*) l_from_value_old
3463: FROM qp_list_lines la,
3464: qp_rltd_modifiers ra,
3465: qp_rltd_modifiers rb,
3466: qp_interface_pricing_attribs pa,
3467: qp_pricing_attributes pb
3468: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3469: -- Bug 5246745 Use Composite Index for Ref columns

Line 3493: qp_rltd_modifiers ra,

3489: p_orig_sys_header_ref VARCHAR2) IS
3490: SELECT count(*) l_from_value_new
3491: FROM qp_list_lines la,
3492: qp_list_lines lb,
3493: qp_rltd_modifiers ra,
3494: qp_rltd_modifiers rb,
3495: qp_interface_pricing_attribs pa,
3496: qp_interface_pricing_attribs pb
3497: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3494: qp_rltd_modifiers rb,

3490: SELECT count(*) l_from_value_new
3491: FROM qp_list_lines la,
3492: qp_list_lines lb,
3493: qp_rltd_modifiers ra,
3494: qp_rltd_modifiers rb,
3495: qp_interface_pricing_attribs pa,
3496: qp_interface_pricing_attribs pb
3497: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3498: -- Bug 5246745 Use Composite Index for Ref columns

Line 3518: qp_rltd_modifiers ra,

3514: -- Bug 5246745 Use Composite Index for Ref columns
3515: p_orig_sys_header_ref VARCHAR2) IS
3516: SELECT count(*) l_to_value_old
3517: FROM qp_list_lines la,
3518: qp_rltd_modifiers ra,
3519: qp_rltd_modifiers rb,
3520: qp_interface_pricing_attribs pa,
3521: qp_pricing_attributes pb
3522: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3519: qp_rltd_modifiers rb,

3515: p_orig_sys_header_ref VARCHAR2) IS
3516: SELECT count(*) l_to_value_old
3517: FROM qp_list_lines la,
3518: qp_rltd_modifiers ra,
3519: qp_rltd_modifiers rb,
3520: qp_interface_pricing_attribs pa,
3521: qp_pricing_attributes pb
3522: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3523: -- Bug 5246745 Use Composite Index for Ref columns

Line 3547: qp_rltd_modifiers ra,

3543: p_orig_sys_header_ref VARCHAR2) IS
3544: SELECT count(*) l_to_value_new
3545: FROM qp_list_lines la,
3546: qp_list_lines lb,
3547: qp_rltd_modifiers ra,
3548: qp_rltd_modifiers rb,
3549: qp_interface_pricing_attribs pa,
3550: qp_interface_pricing_attribs pb
3551: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3548: qp_rltd_modifiers rb,

3544: SELECT count(*) l_to_value_new
3545: FROM qp_list_lines la,
3546: qp_list_lines lb,
3547: qp_rltd_modifiers ra,
3548: qp_rltd_modifiers rb,
3549: qp_interface_pricing_attribs pa,
3550: qp_interface_pricing_attribs pb
3551: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3552: -- Bug 5246745 Use Composite Index for Ref columns

Line 3571: qp_rltd_modifiers ra,

3567: SELECT /*+ leading(la) index(pa QP_INTERFACE_PRCNG_ATTRIBS_N4) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ --7433219
3568: 'OVERLAP'
3569: FROM qp_list_lines la,
3570: qp_list_lines lb,
3571: qp_rltd_modifiers ra,
3572: qp_rltd_modifiers rb,
3573: qp_interface_pricing_attribs pa,
3574: qp_interface_pricing_attribs pb
3575: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3572: qp_rltd_modifiers rb,

3568: 'OVERLAP'
3569: FROM qp_list_lines la,
3570: qp_list_lines lb,
3571: qp_rltd_modifiers ra,
3572: qp_rltd_modifiers rb,
3573: qp_interface_pricing_attribs pa,
3574: qp_interface_pricing_attribs pb
3575: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3576: -- Bug 5246745 Use Composite Index for Ref columns

Line 4206: SELECT /+ index(l qp_list_lines_n11) index(r qp_rltd_modifiers_n2) / --bug 9247305

4202: THEN
4203: BEGIN
4204: --Bug# 5528754 RAVI
4205: --Check if the pricing attribute is for a PRICE BREAK
4206: SELECT /*+ index(l qp_list_lines_n11) index(r qp_rltd_modifiers_n2) */ --bug 9247305
4207: r.rltd_modifier_grp_type
4208: INTO l_pa_price_break
4209: FROM qp_list_lines l, qp_rltd_modifiers r
4210: WHERE l.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)

Line 4209: FROM qp_list_lines l, qp_rltd_modifiers r

4205: --Check if the pricing attribute is for a PRICE BREAK
4206: SELECT /*+ index(l qp_list_lines_n11) index(r qp_rltd_modifiers_n2) */ --bug 9247305
4207: r.rltd_modifier_grp_type
4208: INTO l_pa_price_break
4209: FROM qp_list_lines l, qp_rltd_modifiers r
4210: WHERE l.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4211: -- Bug 5246745 Use Composite Index for Ref columns
4212: AND l.orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4213: AND r.to_rltd_modifier_id = l.list_line_id

Line 4492: qp_rltd_modifiers ra

4488: FROM
4489: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ /*DISTINCT pb.pricing_attribute
4490: FROM qp_list_lines la,
4491: qp_pricing_attributes pb,
4492: qp_rltd_modifiers ra
4493: WHERE ra.to_rltd_modifier_id = la.list_line_id
4494: AND pb.list_line_id = ra.to_rltd_modifier_id
4495: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4496: from qp_rltd_modifiers, qp_list_lines

Line 4496: from qp_rltd_modifiers, qp_list_lines

4492: qp_rltd_modifiers ra
4493: WHERE ra.to_rltd_modifier_id = la.list_line_id
4494: AND pb.list_line_id = ra.to_rltd_modifier_id
4495: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4496: from qp_rltd_modifiers, qp_list_lines
4497: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4498: -- Bug 5246745 Use Composite Index for Ref columns
4499: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4500: and to_rltd_modifier_id = list_line_id)

Line 4506: qp_rltd_modifiers ra

4502: UNION
4503: SELECT /*+ leading(la) */ /*DISTINCT pb.pricing_attribute
4504: FROM qp_list_lines la,
4505: qp_interface_pricing_attribs pb,
4506: qp_rltd_modifiers ra
4507: WHERE ra.to_rltd_modifier_id = la.list_line_id
4508: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4509: AND pb.request_id = p_pricing_attr_rec.request_id(I)
4510: AND pb.process_status_flag = 'P' --IS NULL

Line 4512: from qp_rltd_modifiers, qp_list_lines

4508: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4509: AND pb.request_id = p_pricing_attr_rec.request_id(I)
4510: AND pb.process_status_flag = 'P' --IS NULL
4511: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4512: from qp_rltd_modifiers, qp_list_lines
4513: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4514: -- Bug 5246745 Use Composite Index for Ref columns
4515: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4516: and to_rltd_modifier_id = list_line_id)

Line 4524: qp_rltd_modifiers ra,

4520: SELECT COUNT(1) INTO l_count
4521: FROM
4522: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
4523: FROM qp_list_lines la,
4524: qp_rltd_modifiers ra,
4525: qp_rltd_modifiers rb,
4526: qp_list_lines lb,
4527: qp_interface_pricing_attribs pb
4528: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND

Line 4525: qp_rltd_modifiers rb,

4521: FROM
4522: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
4523: FROM qp_list_lines la,
4524: qp_rltd_modifiers ra,
4525: qp_rltd_modifiers rb,
4526: qp_list_lines lb,
4527: qp_interface_pricing_attribs pb
4528: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4529: la.list_line_type_code = 'PLL' AND

Line 4542: qp_rltd_modifiers ra,

4538: UNION
4539: SELECT /*+ leading(la) */ DISTINCT pb.pricing_attribute
4540: FROM qp_list_lines la,
4541: qp_pricing_attributes pb,
4542: qp_rltd_modifiers ra,
4543: qp_rltd_modifiers rb
4544: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4545: la.list_line_type_code = 'PLL' AND
4546: la.pricing_phase_id = 1 AND

Line 4543: qp_rltd_modifiers rb

4539: SELECT /*+ leading(la) */ DISTINCT pb.pricing_attribute
4540: FROM qp_list_lines la,
4541: qp_pricing_attributes pb,
4542: qp_rltd_modifiers ra,
4543: qp_rltd_modifiers rb
4544: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4545: la.list_line_type_code = 'PLL' AND
4546: la.pricing_phase_id = 1 AND
4547: ra.to_rltd_modifier_id = la.list_line_id AND