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 581: from qp_rltd_modifiers qrm, qp_list_lines b

577: if i_mode = 2 then
578: begin
579: select 'x'
580: into l_dummy
581: from qp_rltd_modifiers qrm, qp_list_lines b
582: where b.orig_sys_header_ref = l_dup_lin_rec.orig_sys_header_ref(I)
583: and b.orig_sys_line_ref = l_dup_lin_rec.b_orig_sys_line_ref(I)
584: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'
585: and qrm.to_rltd_modifier_id = b.list_line_id;

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

2167: -- Bug# 5228560 RAVI START
2168: l_dummy:= null;
2169:
2170: select count(*) into l_dummy
2171: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2172: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2173: -- Bug 5246745 Use Composite Index for Ref columns
2174: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2175: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

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

2193: p_LINE_rec.price_break_type_code(I) = 'POINT')
2194: THEN
2195: -- SELECT count(*)
2196: -- INTO l_dummy
2197: -- FROM qp_list_lines pl, qp_list_lines cl,qp_rltd_modifiers rtd
2198: -- WHERE pl.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2199: -- AND rtd.from_rltd_modifier_id = pl.list_line_id
2200: -- AND cl.list_line_id = rtd.to_rltd_modifier_id
2201: -- AND (cl.arithmetic_operator = 'UNIT_PRICE' OR cl.recurring_value IS NOT NULL);

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

2218: IF p_LINE_rec.arithmetic_operator(I) = 'BLOCK_PRICE' THEN
2219: l_dummy := null;
2220: IF p_LINE_rec.price_break_type_code(I) = 'RANGE' THEN
2221: select count(*) into l_dummy
2222: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2223: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2224: -- Bug 5246745 Use Composite Index for Ref columns
2225: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2226: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

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

2237:
2238: l_dummy := null;
2239: IF p_LINE_rec.price_break_type_code(I) = 'POINT' THEN
2240: select count(*) into l_dummy
2241: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2242: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2243: -- Bug 5246745 Use Composite Index for Ref columns
2244: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2245: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

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

2337:
2338: --Get the PBH details
2339: SELECT L2.price_break_type_code, L2.arithmetic_operator
2340: INTO l_pb_type_code, l_art_opr
2341: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2342: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2343: -- Bug 5246745 Use Composite Index for Ref columns
2344: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2345: and l1.list_line_id=l3.TO_RLTD_MODIFIER_ID

Line 3462: qp_rltd_modifiers ra,

3458: Check for overlap of price breaks
3459: **/
3460: SELECT 'OVERLAP'
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

Line 3463: qp_rltd_modifiers rb,

3459: **/
3460: SELECT 'OVERLAP'
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

Line 3522: qp_rltd_modifiers ra,

3518: SELECT count(*) old_break_pa_count,
3519: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3520: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
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

Line 3523: qp_rltd_modifiers rb,

3519: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3520: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
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

Line 3552: qp_rltd_modifiers ra,

3548: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3549: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3550: FROM qp_list_lines la,
3551: qp_list_lines lb,
3552: qp_rltd_modifiers ra,
3553: qp_rltd_modifiers rb,
3554: qp_interface_pricing_attribs pa,
3555: qp_interface_pricing_attribs pb
3556: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3553: qp_rltd_modifiers rb,

3549: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3550: FROM qp_list_lines la,
3551: qp_list_lines lb,
3552: qp_rltd_modifiers ra,
3553: qp_rltd_modifiers rb,
3554: qp_interface_pricing_attribs pa,
3555: qp_interface_pricing_attribs pb
3556: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3557: -- Bug 5246745 Use Composite Index for Ref columns

Line 3576: qp_rltd_modifiers ra,

3572: -- Bug 5246745 Use Composite Index for Ref columns
3573: p_orig_sys_header_ref VARCHAR2) IS
3574: SELECT count(*) l_from_value_old
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

Line 3577: qp_rltd_modifiers rb,

3573: p_orig_sys_header_ref VARCHAR2) IS
3574: SELECT count(*) l_from_value_old
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

Line 3605: qp_rltd_modifiers ra,

3601: p_orig_sys_header_ref VARCHAR2) IS
3602: SELECT count(*) l_from_value_new
3603: FROM qp_list_lines la,
3604: qp_list_lines lb,
3605: qp_rltd_modifiers ra,
3606: qp_rltd_modifiers rb,
3607: qp_interface_pricing_attribs pa,
3608: qp_interface_pricing_attribs pb
3609: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3606: qp_rltd_modifiers rb,

3602: SELECT count(*) l_from_value_new
3603: FROM qp_list_lines la,
3604: qp_list_lines lb,
3605: qp_rltd_modifiers ra,
3606: qp_rltd_modifiers rb,
3607: qp_interface_pricing_attribs pa,
3608: qp_interface_pricing_attribs pb
3609: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3610: -- Bug 5246745 Use Composite Index for Ref columns

Line 3630: qp_rltd_modifiers ra,

3626: -- Bug 5246745 Use Composite Index for Ref columns
3627: p_orig_sys_header_ref VARCHAR2) IS
3628: SELECT count(*) l_to_value_old
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

Line 3631: qp_rltd_modifiers rb,

3627: p_orig_sys_header_ref VARCHAR2) IS
3628: SELECT count(*) l_to_value_old
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

Line 3659: qp_rltd_modifiers ra,

3655: p_orig_sys_header_ref VARCHAR2) IS
3656: SELECT count(*) l_to_value_new
3657: FROM qp_list_lines la,
3658: qp_list_lines lb,
3659: qp_rltd_modifiers ra,
3660: qp_rltd_modifiers rb,
3661: qp_interface_pricing_attribs pa,
3662: qp_interface_pricing_attribs pb
3663: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3660: qp_rltd_modifiers rb,

3656: SELECT count(*) l_to_value_new
3657: FROM qp_list_lines la,
3658: qp_list_lines lb,
3659: qp_rltd_modifiers ra,
3660: qp_rltd_modifiers rb,
3661: qp_interface_pricing_attribs pa,
3662: qp_interface_pricing_attribs pb
3663: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3664: -- Bug 5246745 Use Composite Index for Ref columns

Line 3683: qp_rltd_modifiers ra,

3679: SELECT /*+ leading(la) index(pa QP_INTERFACE_PRCNG_ATTRIBS_N4) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ --7433219
3680: 'OVERLAP'
3681: FROM qp_list_lines la,
3682: qp_list_lines lb,
3683: qp_rltd_modifiers ra,
3684: qp_rltd_modifiers rb,
3685: qp_interface_pricing_attribs pa,
3686: qp_interface_pricing_attribs pb
3687: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref

Line 3684: qp_rltd_modifiers rb,

3680: 'OVERLAP'
3681: FROM qp_list_lines la,
3682: qp_list_lines lb,
3683: qp_rltd_modifiers ra,
3684: qp_rltd_modifiers rb,
3685: qp_interface_pricing_attribs pa,
3686: qp_interface_pricing_attribs pb
3687: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3688: -- Bug 5246745 Use Composite Index for Ref columns

Line 4320: FROM qp_list_lines l, qp_rltd_modifiers r

4316: --Bug# 5528754 RAVI
4317: --Check if the pricing attribute is for a PRICE BREAK
4318: SELECT r.rltd_modifier_grp_type
4319: INTO l_pa_price_break
4320: FROM qp_list_lines l, qp_rltd_modifiers r
4321: WHERE l.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4322: -- Bug 5246745 Use Composite Index for Ref columns
4323: AND l.orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4324: AND r.to_rltd_modifier_id = l.list_line_id

Line 4504: qp_rltd_modifiers ra

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
4508: from qp_rltd_modifiers, qp_list_lines

Line 4508: from qp_rltd_modifiers, qp_list_lines

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
4508: from qp_rltd_modifiers, qp_list_lines
4509: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4510: -- Bug 5246745 Use Composite Index for Ref columns
4511: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4512: and to_rltd_modifier_id = list_line_id)

Line 4518: qp_rltd_modifiers ra

4514: UNION
4515: SELECT /*+ leading(la) */ /*DISTINCT pb.pricing_attribute
4516: FROM qp_list_lines la,
4517: qp_interface_pricing_attribs pb,
4518: qp_rltd_modifiers ra
4519: WHERE ra.to_rltd_modifier_id = la.list_line_id
4520: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4521: AND pb.request_id = p_pricing_attr_rec.request_id(I)
4522: AND pb.process_status_flag = 'P' --IS NULL

Line 4524: from qp_rltd_modifiers, qp_list_lines

4520: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4521: AND pb.request_id = p_pricing_attr_rec.request_id(I)
4522: AND pb.process_status_flag = 'P' --IS NULL
4523: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4524: from qp_rltd_modifiers, qp_list_lines
4525: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4526: -- Bug 5246745 Use Composite Index for Ref columns
4527: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4528: and to_rltd_modifier_id = list_line_id)

Line 4536: qp_rltd_modifiers ra,

4532: SELECT COUNT(1) INTO l_count
4533: FROM
4534: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
4535: FROM qp_list_lines la,
4536: qp_rltd_modifiers ra,
4537: qp_rltd_modifiers rb,
4538: qp_list_lines lb,
4539: qp_interface_pricing_attribs pb
4540: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND

Line 4537: qp_rltd_modifiers rb,

4533: FROM
4534: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
4535: FROM qp_list_lines la,
4536: qp_rltd_modifiers ra,
4537: qp_rltd_modifiers rb,
4538: qp_list_lines lb,
4539: qp_interface_pricing_attribs pb
4540: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4541: la.list_line_type_code = 'PLL' AND

Line 4554: qp_rltd_modifiers ra,

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
4558: la.pricing_phase_id = 1 AND

Line 4555: qp_rltd_modifiers rb

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
4558: la.pricing_phase_id = 1 AND
4559: ra.to_rltd_modifier_id = la.list_line_id AND