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_LIST_LINES

Line 104: from qp_list_lines

100: insert into qp_list_header_phases
101: (list_header_id, pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)
102: (
103: select distinct list_header_id , pricing_phase_id,'N'
104: from qp_list_lines
105: where pricing_phase_id > 1
106: and qualification_ind in (2,6,8,10,12,14,22,28,30)
107: and list_header_id = p_List_Header_ID);
108:

Line 256: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines

252: END IF;
253: IF p_list_line_id IS NOT NULL THEN
254: SELECT ListHeaders.ACTIVE_FLAG
255: INTO l_active_flag
256: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines
257: WHERE ListHeaders.LIST_HEADER_ID = ListLines.LIST_HEADER_ID AND
258: ListLines.LIST_LINE_ID = p_list_line_id AND
259: rownum = 1;
260: END IF;

Line 505: FROM QP_LIST_LINES qll,

501: Cursor C_pbh_children(p_list_line_id number
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'

Line 515: QP_LIST_LINES

511: AND qll.list_line_type_code = p_list_line_type_code;
512:
513: CURSOR C_CHECK_FOR_PARENT(p_list_line_id number) IS
514: select 'FOUND' from
515: QP_LIST_LINES
516: WHERE LIST_LINE_ID = P_LIST_LINE_ID;
517:
518: l_parent varchar2(30);
519:

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 1258: FROM qp_list_lines

1254:
1255: BEGIN
1256: SELECT list_header_id
1257: INTO l_list_header_id
1258: FROM qp_list_lines
1259: WHERE list_line_id = p_list_line_id;
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: l_list_header_id := 0;

Line 1297: FROM qp_list_lines

1293:
1294: CURSOR list_lines_cur (a_list_header_id NUMBER)
1295: IS
1296: SELECT list_line_id, qualification_ind
1297: FROM qp_list_lines
1298: WHERE list_header_id = a_list_header_id;
1299:
1300: l_dummy number;
1301: l_list_type_code varchar2(30);

Line 1319: update qp_list_lines qpl

1315: WHEN OTHERS THEN
1316: NULL;
1317: END;
1318:
1319: update qp_list_lines qpl
1320: set qpl.qualification_ind = 0
1321: where qpl.list_header_id=p_list_header_id;
1322:
1323: update qp_list_lines qpl

Line 1323: update qp_list_lines qpl

1319: update qp_list_lines qpl
1320: set qpl.qualification_ind = 0
1321: where qpl.list_header_id=p_list_header_id;
1322:
1323: update qp_list_lines qpl
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'

Line 1353: update qp_list_lines qpl

1349: End; --End of bug 2337578
1350:
1351:
1352: IF l_dummy > 0 THEN --Qualifiers exist
1353: update qp_list_lines qpl
1354: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1355: where qpl.list_header_id=p_list_header_id;
1356: END IF;
1357:

Line 1361: update qp_list_lines qpl

1357:
1358: ELSE -- for other list_type_codes
1359:
1360: -- Header level qualifiers
1361: update qp_list_lines qpl
1362: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1363: where qpl.list_header_id=p_list_header_id
1364: and exists (
1365: select 'X'

Line 1371: update qp_list_lines qpl

1367: where q.list_header_id=qpl.list_header_id
1368: and q.list_line_id = -1);
1369:
1370: -- Line level qualifiers
1371: update qp_list_lines qpl
1372: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1373: where qpl.list_header_id=p_list_header_id
1374: and exists (
1375: select 'X'

Line 1383: update qp_list_lines qpl

1379:
1380: END IF; --If list_type_code is 'PRL or 'AGR'
1381:
1382: -- If Product Attributes exist
1383: update qp_list_lines qpl
1384: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1385: where qpl.list_header_id=p_list_header_id
1386: and exists (
1387: select /*+ no_unnest */ 'X' --5612361

Line 1393: update qp_list_lines qpl

1389: where qpprod.list_line_id = qpl.list_line_id
1390: and qpprod.excluder_flag = 'N');
1391:
1392: -- If Pricing Attributes exist
1393: update qp_list_lines qpl
1394: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1395: where qpl.list_header_id=p_list_header_id
1396: and exists (
1397: select 'X'

Line 1420: FROM QP_LIST_LINES

1416: --5612361
1417:
1418: UPDATE QP_PRICING_ATTRIBUTES A
1419: SET QUALIFICATION_IND = (SELECT QUALIFICATION_IND
1420: FROM QP_LIST_LINES
1421: where A.LIST_LINE_ID = LIST_LINE_ID
1422: and LIST_HEADER_ID = p_list_header_id)
1423: WHERE LIST_LINE_ID in
1424: (SELECT /*+ cardinality(QP_LIST_LINES 1) */ LIST_LINE_ID

Line 1424: (SELECT /+ cardinality(QP_LIST_LINES 1) / LIST_LINE_ID

1420: FROM QP_LIST_LINES
1421: where A.LIST_LINE_ID = LIST_LINE_ID
1422: and LIST_HEADER_ID = p_list_header_id)
1423: WHERE LIST_LINE_ID in
1424: (SELECT /*+ cardinality(QP_LIST_LINES 1) */ LIST_LINE_ID
1425: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);
1426:
1427: EXCEPTION
1428:

Line 1425: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);

1421: where A.LIST_LINE_ID = LIST_LINE_ID
1422: and LIST_HEADER_ID = p_list_header_id)
1423: WHERE LIST_LINE_ID in
1424: (SELECT /*+ cardinality(QP_LIST_LINES 1) */ LIST_LINE_ID
1425: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);
1426:
1427: EXCEPTION
1428:
1429: WHEN FND_API.G_EXC_ERROR THEN

Line 1590: from qp_list_lines

1586: select list_type_code, list_header_id
1587: into l_list_type_code, l_list_header_id
1588: from qp_list_headers_vl
1589: where list_header_id = (select list_header_id
1590: from qp_list_lines
1591: where list_line_id = p_list_line_id);
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: NULL;

Line 1597: update qp_list_lines qpl

1593: WHEN OTHERS THEN
1594: NULL;
1595: END;
1596:
1597: update qp_list_lines qpl
1598: set qpl.qualification_ind = 0
1599: where qpl.list_line_id=p_list_line_id;
1600:
1601: update qp_list_lines qpl

Line 1601: update qp_list_lines qpl

1597: update qp_list_lines qpl
1598: set qpl.qualification_ind = 0
1599: where qpl.list_line_id=p_list_line_id;
1600:
1601: update qp_list_lines qpl
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'

Line 1632: update qp_list_lines qpl

1628: End; --End of bug 2337578
1629:
1630:
1631: IF l_dummy > 0 THEN --Qualifiers exist
1632: update qp_list_lines qpl
1633: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1634: where qpl.list_line_id=p_list_line_id
1635: returning qpl.qualification_ind into l_qualification_ind;
1636: END IF;

Line 1641: update qp_list_lines qpl

1637:
1638: ELSE -- for other list_type_codes
1639:
1640: -- Header level qualifiers
1641: update qp_list_lines qpl
1642: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1643: where qpl.list_line_id=p_list_line_id
1644: and exists (
1645: select 'X'

Line 1652: update qp_list_lines qpl

1648: and q.list_line_id = -1)
1649: returning qpl.qualification_ind into l_qualification_ind;
1650:
1651: -- Line level qualifiers
1652: update qp_list_lines qpl
1653: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1654: where qpl.list_line_id=p_list_line_id
1655: and exists (
1656: select 'X'

Line 1665: update qp_list_lines qpl

1661:
1662: END IF; --If list_type_code is 'PRL or 'AGR'
1663:
1664: -- If Product Attributes exist
1665: update qp_list_lines qpl
1666: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1667: where qpl.list_line_id=p_list_line_id
1668: and exists (
1669: select 'X'

Line 1676: update qp_list_lines qpl

1672: and qpprod.excluder_flag = 'N')
1673: returning qpl.qualification_ind into l_qualification_ind;
1674:
1675: -- If Pricing Attributes exist
1676: update qp_list_lines qpl
1677: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1678: where qpl.list_line_id=p_list_line_id
1679: and exists (
1680: select 'X'

Line 1745: FROM qp_list_lines a

1741: ,a.expiration_period_start_date
1742: ,a.expiration_period_uom
1743: ,a.number_expiration_periods
1744: ,a.rebate_transaction_type_code
1745: FROM qp_list_lines a
1746: WHERE a.list_line_id = p_list_line_id;
1747:
1748: BEGIN
1749:

Line 1758: from qp_list_lines

1754: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1755:
1756: select price_break_type_code,pricing_phase_id, arithmetic_operator -- 4936019
1757: into l_price_break_type,l_pricing_phase_id, l_arithmetic_operator -- 4936019
1758: from qp_list_lines
1759: where list_line_id = p_list_line_id;
1760:
1761: IF (l_pricing_phase_id = 1) THEN
1762: update qp_list_lines qpl

Line 1762: update qp_list_lines qpl

1758: from qp_list_lines
1759: where list_line_id = p_list_line_id;
1760:
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 );

Line 1768: update qp_list_lines qpl

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'
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 )

Line 1777: update qp_list_lines qpl

1773: and qpl.arithmetic_operator <> 'UNIT_PRICE';
1774: END IF;
1775:
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 )

Line 1786: update qp_list_lines qpl

1782: and qpl.arithmetic_operator <> 'BLOCK_PRICE';
1783: END IF;
1784:
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 )

Line 1797: UPDATE qp_list_lines

1793:
1794: ELSE
1795: FOR i in pbh_details_csr
1796: LOOP
1797: UPDATE qp_list_lines
1798: SET modifier_level_code = i.modifier_level_code
1799: ,automatic_flag = i.automatic_flag
1800: ,override_flag = i.override_flag
1801: ,Print_on_invoice_flag = i.Print_on_invoice_flag

Line 1870: from qp_list_lines where

1866: BEGIN
1867:
1868: /* select list_line_type_code
1869: into l_list_line_type_code
1870: from qp_list_lines where
1871: list_line_id = p_list_line_id; */
1872:
1873: --IF l_list_line_type_code = 'PBH' THEN
1874:

Line 1926: FROM QP_LIST_LINES WHERE list_line_id = p_list_line_id;

1922:
1923: /*
1924: Cursor C_pricing_attr(p_list_line_id number) IS
1925: SELECT *
1926: FROM QP_LIST_LINES WHERE list_line_id = p_list_line_id;
1927: */
1928:
1929: BEGIN
1930:

Line 1936: l_List_Header_ID, l_Pricing_Phase_ID FROM QP_LIST_LINES

1932: IF (p_List_Line_ID IS NOT NULL OR
1933: p_List_Line_ID <> FND_API.G_MISS_NUM) THEN
1934:
1935: SELECT LIST_HEADER_ID, PRICING_PHASE_ID INTO
1936: l_List_Header_ID, l_Pricing_Phase_ID FROM QP_LIST_LINES
1937: WHERE LIST_LINE_ID = p_List_Line_ID;
1938:
1939:
1940: -- open c_Pricing_Attr(p_list_line_id); LOOP

Line 2012: into l_rltd from qp_list_lines LL

2008: IF p_parent_line_id IS NOT NULL OR
2009: p_parent_line_id <> FND_API.G_MISS_NUM THEN
2010:
2011: select decode(LL.list_line_type_code, 'PRG','Y','N')
2012: into l_rltd from qp_list_lines LL
2013: where LL.list_line_id = p_parent_line_id;
2014:
2015: END IF;
2016: ELSE NULL;

Line 2358: from qp_list_lines

2354: )
2355: is
2356: cursor c_mod_level is
2357: select distinct modifier_level_code modifier_level
2358: from qp_list_lines
2359: where list_header_id = p_list_header_id;
2360:
2361: cursor c_qual_grp_no is
2362: select distinct qualifier_grouping_no qualifier_grouping_no

Line 2551: from qp_list_lines qpl,

2547: and product_attribute = p_product_attribute
2548: and product_attr_value = p_product_attr_value
2549: and not exists (
2550: select 'Y'
2551: from qp_list_lines qpl,
2552: qp_list_headers_b qph
2553: where qpl.list_line_id = p_list_line_id
2554: and qpl.modifier_level_code = 'LINEGROUP'
2555: and qph.list_header_id = p_list_header_id

Line 2561: qp_list_lines qpl,

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
2565: and qpr.rltd_modifier_grp_type = 'BENEFIT'

Line 2574: from qp_list_lines qpl,

2570: and qph.list_header_id = qpl.list_header_id
2571: and rownum = 1
2572: union
2573: select 'Y'
2574: from qp_list_lines qpl,
2575: qp_list_headers_b qph
2576: where qpl.list_line_id = p_list_line_id
2577: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')
2578: and qph.list_header_id = p_list_header_id

Line 2649: qp_list_lines qpl,

2645: and product_attr_value = l_product_attr_value
2646: and not exists (
2647: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2648: from qp_pricing_attributes qpa,
2649: qp_list_lines qpl,
2650: qp_list_headers_b qph
2651: where qpa.pricing_phase_id = p_old_pricing_phase_id
2652: and qpa.product_attribute = l_product_attribute
2653: and qpa.product_attr_value = l_product_attr_value

Line 2662: qp_list_lines qpl,

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
2666: and qpa.product_attribute = l_product_attribute

Line 2677: from qp_list_lines qpl,

2673: and qph.active_flag = 'Y'
2674: and rownum = 1
2675: union
2676: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2677: from qp_list_lines qpl,
2678: qp_pricing_attributes qpa,
2679: qp_list_headers_b qph
2680: where qpa.pricing_phase_id = p_old_pricing_phase_id
2681: and qpa.product_attribute = l_product_attribute

Line 2711: from qp_list_lines qpl,

2707: select distinct qpl.list_line_id,
2708: qpl.pricing_phase_id,
2709: qpa.product_attribute,
2710: qpa.product_attr_value
2711: from qp_list_lines qpl,
2712: qp_pricing_attributes qpa
2713: where qpl.list_header_id = p_list_header_id
2714: and qpa.list_line_id = qpl.list_line_id;
2715:

Line 2763: qp_list_lines qpl,

2759: and product_attr_value = line_cursor.product_attr_value
2760: and not exists (
2761: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2762: from qp_pricing_attributes qpa,
2763: qp_list_lines qpl,
2764: qp_list_headers_b qph
2765: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2766: and qpa.product_attribute = line_cursor.product_attribute
2767: and qpa.product_attr_value = line_cursor.product_attr_value

Line 2776: qp_list_lines qpl,

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
2780: and qpa.product_attribute = line_cursor.product_attribute

Line 2791: from qp_list_lines qpl,

2787: and qph.active_flag = 'Y'
2788: and rownum = 1
2789: union
2790: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2791: from qp_list_lines qpl,
2792: qp_pricing_attributes qpa,
2793: qp_list_headers_b qph
2794: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2795: and qpa.product_attribute = line_cursor.product_attribute