APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_RLTD_MODIFIERS

Line 498: QP_RLTD_MODIFIERS qrm

494: ,p_list_line_type_code varchar2
495: ,l_modifier_grp_type varchar2) IS
496: SELECT count(1)
497: FROM QP_LIST_LINES qll,
498: QP_RLTD_MODIFIERS qrm
499: WHERE qll.list_line_id = p_list_line_id
500: AND qll.list_line_id= qrm.from_rltd_modifier_id
501: --AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
502: AND qrm.rltd_modifier_grp_type = l_modifier_grp_type

Line 639: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA

635: Cursor C_break_lines(p_list_line_id number) IS
636: --Begin Bug No: 7321885
637: SELECT PRICING_ATTR_VALUE_FROM_NUMBER,
638: PRICING_ATTR_VALUE_TO_NUMBER
639: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA
640: WHERE QRMA.FROM_RLTD_MODIFIER_ID = p_list_line_id AND
641: QRMA.TO_RLTD_MODIFIER_ID = QPBVA.LIST_LINE_ID
642: AND QRMA.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
643: AND QPBVA.PRICING_ATTRIBUTE_DATATYPE = 'N'

Line 743: from qp_list_lines ql, qp_pricing_attributes qpa,qp_rltd_modifiers qrm

739:
740: Cursor c_break_lines_attr_values(p_list_line_id number) IS
741: SELECT qpa.PRICING_ATTR_VALUE_FROM,
742: qpa.PRICING_ATTR_VALUE_TO
743: from qp_list_lines ql, qp_pricing_attributes qpa,qp_rltd_modifiers qrm
744: WHERE ql.list_line_id = qpa.list_line_id
745: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
746: and qrm.to_rltd_modifier_id = ql.list_line_id
747: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 861: from qp_list_lines ql,qp_pricing_attributes qpa,qp_rltd_modifiers qrm

857: SELECT qpa.PRICING_ATTR_VALUE_FROM_NUMBER,
858: qpa.PRICING_ATTR_VALUE_FROM,
859: qpa.PRICING_ATTR_VALUE_TO_NUMBER,
860: qpa.PRICING_ATTR_VALUE_TO
861: from qp_list_lines ql,qp_pricing_attributes qpa,qp_rltd_modifiers qrm
862: WHERE ql.list_line_id = qpa.list_line_id
863: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
864: and qrm.to_rltd_modifier_id = ql.list_line_id
865: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 1320: from qp_rltd_modifiers qprltd

1316: set qpl.qualification_ind=nvl(qualification_ind,0) + 1
1317: where qpl.list_header_id=p_list_header_id
1318: and exists (
1319: select 'X'
1320: from qp_rltd_modifiers qprltd
1321: where qprltd.to_rltd_modifier_id=qpl.list_line_id
1322: and rltd_modifier_grp_type<>'COUPON');
1323:
1324:

Line 1598: from qp_rltd_modifiers qprltd

1594: set qpl.qualification_ind=nvl(qualification_ind,0) + 1
1595: where qpl.list_line_id=p_list_line_id
1596: and exists (
1597: select 'X'
1598: from qp_rltd_modifiers qprltd
1599: where qprltd.to_rltd_modifier_id=p_list_line_id
1600: and rltd_modifier_grp_type<>'COUPON')
1601: returning qpl.qualification_ind into l_qualification_ind;
1602:

Line 1757: from qp_rltd_modifiers

1753: IF (l_pricing_phase_id = 1) THEN
1754: update qp_list_lines qpl
1755: set qpl.price_break_type_code = l_price_break_type
1756: where qpl.list_line_id in ( select to_rltd_modifier_id
1757: from qp_rltd_modifiers
1758: where from_rltd_modifier_id = p_list_line_id );
1759: IF (l_arithmetic_operator = 'UNIT_PRICE') THEN
1760: update qp_list_lines qpl
1761: set qpl.arithmetic_operator = 'UNIT_PRICE'

Line 1763: from qp_rltd_modifiers

1759: IF (l_arithmetic_operator = 'UNIT_PRICE') THEN
1760: update qp_list_lines qpl
1761: set qpl.arithmetic_operator = 'UNIT_PRICE'
1762: where qpl.list_line_id in ( select to_rltd_modifier_id
1763: from qp_rltd_modifiers
1764: where from_rltd_modifier_id = p_list_line_id )
1765: and qpl.arithmetic_operator <> 'UNIT_PRICE';
1766: END IF;
1767:

Line 1772: from qp_rltd_modifiers

1768: IF (l_arithmetic_operator = 'BLOCK_PRICE' and l_price_break_type = 'POINT') THEN
1769: update qp_list_lines qpl
1770: set qpl.arithmetic_operator = 'BLOCK_PRICE'
1771: where qpl.list_line_id in ( select to_rltd_modifier_id
1772: from qp_rltd_modifiers
1773: where from_rltd_modifier_id = p_list_line_id )
1774: and qpl.arithmetic_operator <> 'BLOCK_PRICE';
1775: END IF;
1776:

Line 1781: from qp_rltd_modifiers

1777: IF (l_arithmetic_operator = 'BLOCK_PRICE' and l_price_break_type = 'RANGE') THEN
1778: update qp_list_lines qpl
1779: set qpl.arithmetic_operator = 'BLOCK_PRICE'
1780: where qpl.list_line_id in ( select to_rltd_modifier_id
1781: from qp_rltd_modifiers
1782: where from_rltd_modifier_id = p_list_line_id )
1783: and qpl.arithmetic_operator not in ('BLOCK_PRICE', 'BREAKUNIT_PRICE');
1784: END IF;
1785:

Line 1807: from qp_rltd_modifiers

1803: ,expiration_period_start_date = i.expiration_period_start_date
1804: ,expiration_period_uom = i.expiration_period_uom
1805: ,number_expiration_periods = i.number_expiration_periods
1806: WHERE list_line_id in (select to_rltd_modifier_id
1807: from qp_rltd_modifiers
1808: where from_rltd_modifier_id = p_list_line_id);
1809:
1810: END LOOP;
1811: END IF;

Line 1880: from qp_rltd_modifiers qrm

1876: ,Product_attribute = i.Product_attribute
1877: ,Product_attr_value = i.Product_attr_value
1878: ,Product_uom_code = i.Product_Uom_Code
1879: WHERE list_line_id IN (select to_rltd_modifier_id
1880: from qp_rltd_modifiers qrm
1881: where from_rltd_modifier_id = p_list_line_id);
1882:
1883: END LOOP;
1884:

Line 2549: from qp_rltd_modifiers qpr,

2545: and qph.active_flag = 'Y'
2546: and rownum = 1
2547: union
2548: select 'Y'
2549: from qp_rltd_modifiers qpr,
2550: qp_list_lines qpl,
2551: qp_list_headers_b qph
2552: where qpl.list_line_id = p_list_line_id
2553: and qpr.to_rltd_modifier_id = p_list_line_id

Line 2650: from qp_rltd_modifiers qpr,

2646: and qph.active_flag = 'Y'
2647: and rownum = 1
2648: union
2649: select 'Y'
2650: from qp_rltd_modifiers qpr,
2651: qp_list_lines qpl,
2652: qp_pricing_attributes qpa,
2653: qp_list_headers_b qph
2654: where qpa.pricing_phase_id = p_old_pricing_phase_id

Line 2764: from qp_rltd_modifiers qpr,

2760: and qph.active_flag = 'Y'
2761: and rownum = 1
2762: union
2763: select 'Y'
2764: from qp_rltd_modifiers qpr,
2765: qp_list_lines qpl,
2766: qp_pricing_attributes qpa,
2767: qp_list_headers_b qph
2768: where qpa.pricing_phase_id = line_cursor.pricing_phase_id