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 96: from qp_list_lines

92: insert into qp_list_header_phases
93: (list_header_id, pricing_phase_id)
94: (
95: select distinct list_header_id , pricing_phase_id
96: from qp_list_lines
97: where pricing_phase_id > 1
98: and qualification_ind in (2,6,8,10,12,14,22,28,30)
99: and list_header_id = p_List_Header_ID);
100:

Line 248: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines

244: END IF;
245: IF p_list_line_id IS NOT NULL THEN
246: SELECT ListHeaders.ACTIVE_FLAG
247: INTO l_active_flag
248: FROM QP_LIST_HEADERS_B ListHeaders, QP_LIST_LINES ListLines
249: WHERE ListHeaders.LIST_HEADER_ID = ListLines.LIST_HEADER_ID AND
250: ListLines.LIST_LINE_ID = p_list_line_id AND
251: rownum = 1;
252: END IF;

Line 497: FROM QP_LIST_LINES qll,

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

Line 507: QP_LIST_LINES

503: AND qll.list_line_type_code = p_list_line_type_code;
504:
505: CURSOR C_CHECK_FOR_PARENT(p_list_line_id number) IS
506: select 'FOUND' from
507: QP_LIST_LINES
508: WHERE LIST_LINE_ID = P_LIST_LINE_ID;
509:
510: l_parent varchar2(30);
511:

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

1246:
1247: BEGIN
1248: SELECT list_header_id
1249: INTO l_list_header_id
1250: FROM qp_list_lines
1251: WHERE list_line_id = p_list_line_id;
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: l_list_header_id := 0;

Line 1289: FROM qp_list_lines

1285:
1286: CURSOR list_lines_cur (a_list_header_id NUMBER)
1287: IS
1288: SELECT list_line_id, qualification_ind
1289: FROM qp_list_lines
1290: WHERE list_header_id = a_list_header_id;
1291:
1292: l_dummy number;
1293: l_list_type_code varchar2(30);

Line 1311: update qp_list_lines qpl

1307: WHEN OTHERS THEN
1308: NULL;
1309: END;
1310:
1311: update qp_list_lines qpl
1312: set qpl.qualification_ind = 0
1313: where qpl.list_header_id=p_list_header_id;
1314:
1315: update qp_list_lines qpl

Line 1315: update qp_list_lines qpl

1311: update qp_list_lines qpl
1312: set qpl.qualification_ind = 0
1313: where qpl.list_header_id=p_list_header_id;
1314:
1315: update qp_list_lines qpl
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'

Line 1345: update qp_list_lines qpl

1341: End; --End of bug 2337578
1342:
1343:
1344: IF l_dummy > 0 THEN --Qualifiers exist
1345: update qp_list_lines qpl
1346: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1347: where qpl.list_header_id=p_list_header_id;
1348: END IF;
1349:

Line 1353: update qp_list_lines qpl

1349:
1350: ELSE -- for other list_type_codes
1351:
1352: -- Header level qualifiers
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: and exists (
1357: select 'X'

Line 1363: update qp_list_lines qpl

1359: where q.list_header_id=qpl.list_header_id
1360: and q.list_line_id = -1);
1361:
1362: -- Line level qualifiers
1363: update qp_list_lines qpl
1364: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1365: where qpl.list_header_id=p_list_header_id
1366: and exists (
1367: select 'X'

Line 1375: update qp_list_lines qpl

1371:
1372: END IF; --If list_type_code is 'PRL or 'AGR'
1373:
1374: -- If Product Attributes exist
1375: update qp_list_lines qpl
1376: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1377: where qpl.list_header_id=p_list_header_id
1378: and exists (
1379: select /*+ no_unnest */ 'X' --5612361

Line 1385: update qp_list_lines qpl

1381: where qpprod.list_line_id = qpl.list_line_id
1382: and qpprod.excluder_flag = 'N');
1383:
1384: -- If Pricing Attributes exist
1385: update qp_list_lines qpl
1386: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1387: where qpl.list_header_id=p_list_header_id
1388: and exists (
1389: select 'X'

Line 1412: FROM QP_LIST_LINES

1408: --5612361
1409:
1410: UPDATE QP_PRICING_ATTRIBUTES A
1411: SET QUALIFICATION_IND = (SELECT QUALIFICATION_IND
1412: FROM QP_LIST_LINES
1413: where A.LIST_LINE_ID = LIST_LINE_ID
1414: and LIST_HEADER_ID = p_list_header_id)
1415: WHERE LIST_LINE_ID in
1416: (SELECT /*+ cardinality(QP_LIST_LINES 1) */ LIST_LINE_ID

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

1412: FROM QP_LIST_LINES
1413: where A.LIST_LINE_ID = LIST_LINE_ID
1414: and LIST_HEADER_ID = p_list_header_id)
1415: WHERE LIST_LINE_ID in
1416: (SELECT /*+ cardinality(QP_LIST_LINES 1) */ LIST_LINE_ID
1417: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);
1418:
1419: EXCEPTION
1420:

Line 1417: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);

1413: where A.LIST_LINE_ID = LIST_LINE_ID
1414: and LIST_HEADER_ID = p_list_header_id)
1415: WHERE LIST_LINE_ID in
1416: (SELECT /*+ cardinality(QP_LIST_LINES 1) */ LIST_LINE_ID
1417: FROM QP_LIST_LINES WHERE LIST_HEADER_ID = p_list_header_id);
1418:
1419: EXCEPTION
1420:
1421: WHEN FND_API.G_EXC_ERROR THEN

Line 1582: from qp_list_lines

1578: select list_type_code, list_header_id
1579: into l_list_type_code, l_list_header_id
1580: from qp_list_headers_vl
1581: where list_header_id = (select list_header_id
1582: from qp_list_lines
1583: where list_line_id = p_list_line_id);
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: NULL;

Line 1589: update qp_list_lines qpl

1585: WHEN OTHERS THEN
1586: NULL;
1587: END;
1588:
1589: update qp_list_lines qpl
1590: set qpl.qualification_ind = 0
1591: where qpl.list_line_id=p_list_line_id;
1592:
1593: update qp_list_lines qpl

Line 1593: update qp_list_lines qpl

1589: update qp_list_lines qpl
1590: set qpl.qualification_ind = 0
1591: where qpl.list_line_id=p_list_line_id;
1592:
1593: update qp_list_lines qpl
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'

Line 1624: update qp_list_lines qpl

1620: End; --End of bug 2337578
1621:
1622:
1623: IF l_dummy > 0 THEN --Qualifiers exist
1624: update qp_list_lines qpl
1625: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1626: where qpl.list_line_id=p_list_line_id
1627: returning qpl.qualification_ind into l_qualification_ind;
1628: END IF;

Line 1633: update qp_list_lines qpl

1629:
1630: ELSE -- for other list_type_codes
1631:
1632: -- Header level qualifiers
1633: update qp_list_lines qpl
1634: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1635: where qpl.list_line_id=p_list_line_id
1636: and exists (
1637: select 'X'

Line 1644: update qp_list_lines qpl

1640: and q.list_line_id = -1)
1641: returning qpl.qualification_ind into l_qualification_ind;
1642:
1643: -- Line level qualifiers
1644: update qp_list_lines qpl
1645: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1646: where qpl.list_line_id=p_list_line_id
1647: and exists (
1648: select 'X'

Line 1657: update qp_list_lines qpl

1653:
1654: END IF; --If list_type_code is 'PRL or 'AGR'
1655:
1656: -- If Product Attributes exist
1657: update qp_list_lines qpl
1658: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1659: where qpl.list_line_id=p_list_line_id
1660: and exists (
1661: select 'X'

Line 1668: update qp_list_lines qpl

1664: and qpprod.excluder_flag = 'N')
1665: returning qpl.qualification_ind into l_qualification_ind;
1666:
1667: -- If Pricing Attributes exist
1668: update qp_list_lines qpl
1669: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1670: where qpl.list_line_id=p_list_line_id
1671: and exists (
1672: select 'X'

Line 1737: FROM qp_list_lines a

1733: ,a.expiration_period_start_date
1734: ,a.expiration_period_uom
1735: ,a.number_expiration_periods
1736: ,a.rebate_transaction_type_code
1737: FROM qp_list_lines a
1738: WHERE a.list_line_id = p_list_line_id;
1739:
1740: BEGIN
1741:

Line 1750: from qp_list_lines

1746: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1747:
1748: select price_break_type_code,pricing_phase_id, arithmetic_operator -- 4936019
1749: into l_price_break_type,l_pricing_phase_id, l_arithmetic_operator -- 4936019
1750: from qp_list_lines
1751: where list_line_id = p_list_line_id;
1752:
1753: IF (l_pricing_phase_id = 1) THEN
1754: update qp_list_lines qpl

Line 1754: update qp_list_lines qpl

1750: from qp_list_lines
1751: where list_line_id = p_list_line_id;
1752:
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 );

Line 1760: update qp_list_lines qpl

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

Line 1769: update qp_list_lines qpl

1765: and qpl.arithmetic_operator <> 'UNIT_PRICE';
1766: END IF;
1767:
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 )

Line 1778: update qp_list_lines qpl

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

Line 1789: UPDATE qp_list_lines

1785:
1786: ELSE
1787: FOR i in pbh_details_csr
1788: LOOP
1789: UPDATE qp_list_lines
1790: SET modifier_level_code = i.modifier_level_code
1791: ,automatic_flag = i.automatic_flag
1792: ,override_flag = i.override_flag
1793: ,Print_on_invoice_flag = i.Print_on_invoice_flag

Line 1862: from qp_list_lines where

1858: BEGIN
1859:
1860: /* select list_line_type_code
1861: into l_list_line_type_code
1862: from qp_list_lines where
1863: list_line_id = p_list_line_id; */
1864:
1865: --IF l_list_line_type_code = 'PBH' THEN
1866:

Line 1918: FROM QP_LIST_LINES WHERE list_line_id = p_list_line_id;

1914:
1915: /*
1916: Cursor C_pricing_attr(p_list_line_id number) IS
1917: SELECT *
1918: FROM QP_LIST_LINES WHERE list_line_id = p_list_line_id;
1919: */
1920:
1921: BEGIN
1922:

Line 1928: l_List_Header_ID, l_Pricing_Phase_ID FROM QP_LIST_LINES

1924: IF (p_List_Line_ID IS NOT NULL OR
1925: p_List_Line_ID <> FND_API.G_MISS_NUM) THEN
1926:
1927: SELECT LIST_HEADER_ID, PRICING_PHASE_ID INTO
1928: l_List_Header_ID, l_Pricing_Phase_ID FROM QP_LIST_LINES
1929: WHERE LIST_LINE_ID = p_List_Line_ID;
1930:
1931:
1932: -- open c_Pricing_Attr(p_list_line_id); LOOP

Line 2004: into l_rltd from qp_list_lines LL

2000: IF p_parent_line_id IS NOT NULL OR
2001: p_parent_line_id <> FND_API.G_MISS_NUM THEN
2002:
2003: select decode(LL.list_line_type_code, 'PRG','Y','N')
2004: into l_rltd from qp_list_lines LL
2005: where LL.list_line_id = p_parent_line_id;
2006:
2007: END IF;
2008: ELSE NULL;

Line 2347: from qp_list_lines

2343: )
2344: is
2345: cursor c_mod_level is
2346: select distinct modifier_level_code modifier_level
2347: from qp_list_lines
2348: where list_header_id = p_list_header_id;
2349:
2350: cursor c_qual_grp_no is
2351: select distinct qualifier_grouping_no qualifier_grouping_no

Line 2540: from qp_list_lines qpl,

2536: and product_attribute = p_product_attribute
2537: and product_attr_value = p_product_attr_value
2538: and not exists (
2539: select 'Y'
2540: from qp_list_lines qpl,
2541: qp_list_headers_b qph
2542: where qpl.list_line_id = p_list_line_id
2543: and qpl.modifier_level_code = 'LINEGROUP'
2544: and qph.list_header_id = p_list_header_id

Line 2550: qp_list_lines qpl,

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

Line 2563: from qp_list_lines qpl,

2559: and qph.list_header_id = qpl.list_header_id
2560: and rownum = 1
2561: union
2562: select 'Y'
2563: from qp_list_lines qpl,
2564: qp_list_headers_b qph
2565: where qpl.list_line_id = p_list_line_id
2566: and qpl.list_line_type_code in ('OID', 'PRG', 'RLTD')
2567: and qph.list_header_id = p_list_header_id

Line 2638: qp_list_lines qpl,

2634: and product_attr_value = l_product_attr_value
2635: and not exists (
2636: select 'Y'
2637: from qp_pricing_attributes qpa,
2638: qp_list_lines qpl,
2639: qp_list_headers_b qph
2640: where qpa.pricing_phase_id = p_old_pricing_phase_id
2641: and qpa.product_attribute = l_product_attribute
2642: and qpa.product_attr_value = l_product_attr_value

Line 2651: qp_list_lines qpl,

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

Line 2666: from qp_list_lines qpl,

2662: and qph.active_flag = 'Y'
2663: and rownum = 1
2664: union
2665: select 'Y'
2666: from qp_list_lines qpl,
2667: qp_pricing_attributes qpa,
2668: qp_list_headers_b qph
2669: where qpa.pricing_phase_id = p_old_pricing_phase_id
2670: and qpa.product_attribute = l_product_attribute

Line 2700: from qp_list_lines qpl,

2696: select distinct qpl.list_line_id,
2697: qpl.pricing_phase_id,
2698: qpa.product_attribute,
2699: qpa.product_attr_value
2700: from qp_list_lines qpl,
2701: qp_pricing_attributes qpa
2702: where qpl.list_header_id = p_list_header_id
2703: and qpa.list_line_id = qpl.list_line_id;
2704:

Line 2752: qp_list_lines qpl,

2748: and product_attr_value = line_cursor.product_attr_value
2749: and not exists (
2750: select 'Y'
2751: from qp_pricing_attributes qpa,
2752: qp_list_lines qpl,
2753: qp_list_headers_b qph
2754: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2755: and qpa.product_attribute = line_cursor.product_attribute
2756: and qpa.product_attr_value = line_cursor.product_attr_value

Line 2765: qp_list_lines qpl,

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

Line 2780: from qp_list_lines qpl,

2776: and qph.active_flag = 'Y'
2777: and rownum = 1
2778: union
2779: select 'Y'
2780: from qp_list_lines qpl,
2781: qp_pricing_attributes qpa,
2782: qp_list_headers_b qph
2783: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2784: and qpa.product_attribute = line_cursor.product_attribute