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_DELAYED_REQUESTS_UTIL dependencies on QP_RLTD_MODIFIERS

Line 506: QP_RLTD_MODIFIERS qrm

502: ,p_list_line_type_code varchar2
503: ,l_modifier_grp_type varchar2) IS
504: SELECT count(1)
505: FROM QP_LIST_LINES qll,
506: QP_RLTD_MODIFIERS qrm
507: WHERE qll.list_line_id = p_list_line_id
508: AND qll.list_line_id= qrm.from_rltd_modifier_id
509: --AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
510: AND qrm.rltd_modifier_grp_type = l_modifier_grp_type

Line 647: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA

643: Cursor C_break_lines(p_list_line_id number) IS
644: --Begin Bug No: 7321885
645: SELECT PRICING_ATTR_VALUE_FROM_NUMBER,
646: PRICING_ATTR_VALUE_TO_NUMBER
647: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA
648: WHERE QRMA.FROM_RLTD_MODIFIER_ID = p_list_line_id AND
649: QRMA.TO_RLTD_MODIFIER_ID = QPBVA.LIST_LINE_ID
650: AND QRMA.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
651: AND QPBVA.PRICING_ATTRIBUTE_DATATYPE = 'N'

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

747:
748: Cursor c_break_lines_attr_values(p_list_line_id number) IS
749: SELECT qpa.PRICING_ATTR_VALUE_FROM,
750: qpa.PRICING_ATTR_VALUE_TO
751: from qp_list_lines ql, qp_pricing_attributes qpa,qp_rltd_modifiers qrm
752: WHERE ql.list_line_id = qpa.list_line_id
753: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
754: and qrm.to_rltd_modifier_id = ql.list_line_id
755: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

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

865: SELECT qpa.PRICING_ATTR_VALUE_FROM_NUMBER,
866: qpa.PRICING_ATTR_VALUE_FROM,
867: qpa.PRICING_ATTR_VALUE_TO_NUMBER,
868: qpa.PRICING_ATTR_VALUE_TO
869: from qp_list_lines ql,qp_pricing_attributes qpa,qp_rltd_modifiers qrm
870: WHERE ql.list_line_id = qpa.list_line_id
871: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
872: and qrm.to_rltd_modifier_id = ql.list_line_id
873: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 1328: from qp_rltd_modifiers qprltd

1324: set qpl.qualification_ind=nvl(qualification_ind,0) + 1
1325: where qpl.list_header_id=p_list_header_id
1326: and exists (
1327: select 'X'
1328: from qp_rltd_modifiers qprltd
1329: where qprltd.to_rltd_modifier_id=qpl.list_line_id
1330: and rltd_modifier_grp_type<>'COUPON');
1331:
1332:

Line 1606: from qp_rltd_modifiers qprltd

1602: set qpl.qualification_ind=nvl(qualification_ind,0) + 1
1603: where qpl.list_line_id=p_list_line_id
1604: and exists (
1605: select 'X'
1606: from qp_rltd_modifiers qprltd
1607: where qprltd.to_rltd_modifier_id=p_list_line_id
1608: and rltd_modifier_grp_type<>'COUPON')
1609: returning qpl.qualification_ind into l_qualification_ind;
1610:

Line 1765: from qp_rltd_modifiers

1761: IF (l_pricing_phase_id = 1) THEN
1762: update qp_list_lines qpl
1763: set qpl.price_break_type_code = l_price_break_type
1764: where qpl.list_line_id in ( select to_rltd_modifier_id
1765: from qp_rltd_modifiers
1766: where from_rltd_modifier_id = p_list_line_id );
1767: IF (l_arithmetic_operator = 'UNIT_PRICE') THEN
1768: update qp_list_lines qpl
1769: set qpl.arithmetic_operator = 'UNIT_PRICE'

Line 1771: from qp_rltd_modifiers

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

Line 1780: from qp_rltd_modifiers

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

Line 1789: from qp_rltd_modifiers

1785: IF (l_arithmetic_operator = 'BLOCK_PRICE' and l_price_break_type = 'RANGE') THEN
1786: update qp_list_lines qpl
1787: set qpl.arithmetic_operator = 'BLOCK_PRICE'
1788: where qpl.list_line_id in ( select to_rltd_modifier_id
1789: from qp_rltd_modifiers
1790: where from_rltd_modifier_id = p_list_line_id )
1791: and qpl.arithmetic_operator not in ('BLOCK_PRICE', 'BREAKUNIT_PRICE');
1792: END IF;
1793:

Line 1815: from qp_rltd_modifiers

1811: ,expiration_period_start_date = i.expiration_period_start_date
1812: ,expiration_period_uom = i.expiration_period_uom
1813: ,number_expiration_periods = i.number_expiration_periods
1814: WHERE list_line_id in (select to_rltd_modifier_id
1815: from qp_rltd_modifiers
1816: where from_rltd_modifier_id = p_list_line_id);
1817:
1818: END LOOP;
1819: END IF;

Line 1888: from qp_rltd_modifiers qrm

1884: ,Product_attribute = i.Product_attribute
1885: ,Product_attr_value = i.Product_attr_value
1886: ,Product_uom_code = i.Product_Uom_Code
1887: WHERE list_line_id IN (select to_rltd_modifier_id
1888: from qp_rltd_modifiers qrm
1889: where from_rltd_modifier_id = p_list_line_id);
1890:
1891: END LOOP;
1892:

Line 2560: from qp_rltd_modifiers qpr,

2556: and qph.active_flag = 'Y'
2557: and rownum = 1
2558: union
2559: select 'Y'
2560: from qp_rltd_modifiers qpr,
2561: qp_list_lines qpl,
2562: qp_list_headers_b qph
2563: where qpl.list_line_id = p_list_line_id
2564: and qpr.to_rltd_modifier_id = p_list_line_id

Line 2661: from qp_rltd_modifiers qpr,

2657: and qph.active_flag = 'Y'
2658: and rownum = 1
2659: union
2660: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2661: from qp_rltd_modifiers qpr,
2662: qp_list_lines qpl,
2663: qp_pricing_attributes qpa,
2664: qp_list_headers_b qph
2665: where qpa.pricing_phase_id = p_old_pricing_phase_id

Line 2775: from qp_rltd_modifiers qpr,

2771: and qph.active_flag = 'Y'
2772: and rownum = 1
2773: union
2774: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2775: from qp_rltd_modifiers qpr,
2776: qp_list_lines qpl,
2777: qp_pricing_attributes qpa,
2778: qp_list_headers_b qph
2779: where qpa.pricing_phase_id = line_cursor.pricing_phase_id