APPS.QP_PRC_UTIL dependencies on QP_LIST_HEADERS

Line 362: P.LINE_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS

358: P.LIST_LINE_ID , -- CHANGE FROM DISCOUNT_LINE TO LIST_LINE_ID
359: P.AUTOMATIC_FLAG ,
360: P.OPERAND , -- CHANGE PERCENT TO OPERAND
361: P.HEADER_ID , --
362: P.LINE_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
363: D.NAME
364: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
365: WHERE P.LINE_ID = p_line_id
366: AND P.LIST_HEADER_ID = D.LIST_HEADER_ID;

Line 364: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D

360: P.OPERAND , -- CHANGE PERCENT TO OPERAND
361: P.HEADER_ID , --
362: P.LINE_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
363: D.NAME
364: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
365: WHERE P.LINE_ID = p_line_id
366: AND P.LIST_HEADER_ID = D.LIST_HEADER_ID;
367: -- QP END
368: CURSOR l_hdr_adj_csr IS

Line 374: P.HEADER_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS

370: P.LIST_HEADER_ID , --QP CHANGE FROM DISCOUNT_ID TO LIST_HEADER_ID
371: P.LIST_LINE_ID , -- CHANGE FROM DISCOUNT_LINE_ID TO LIST_LINE_ID
372: P.AUTOMATIC_FLAG ,
373: P.OPERAND , -- CHANGE PERCENT TO OPERAN
374: P.HEADER_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
375: D.NAME
376: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
377: WHERE HEADER_ID = p_header_id
378: AND LINE_ID IS NULL

Line 376: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D

372: P.AUTOMATIC_FLAG ,
373: P.OPERAND , -- CHANGE PERCENT TO OPERAN
374: P.HEADER_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
375: D.NAME
376: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
377: WHERE HEADER_ID = p_header_id
378: AND LINE_ID IS NULL
379: AND P.DISCOUNT_ID = D.LIST_HEADER_ID;
380: -- QP END

Line 515: , QP_LIST_HEADERS QPLH

511: CURSOR used_entities IS
512: SELECT DISTINCT QPPA.PRODUCT_ATTRIBUTE
513: FROM QP_PRICING_ATTRIBUTES QPPA
514: , QP_LIST_LINES QPLL
515: , QP_LIST_HEADERS QPLH
516: WHERE QPLL.LIST_LINE_ID = QPPA.LIST_LINE_ID
517: AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
518: AND QPLH.AUTOMATIC_FLAG = 'Y'
519: AND QPPA.PRODUCT_ATTRIBUTE IN (G_ITEM_NAME

Line 526: ,QP_LIST_HEADERS QPLH

522: ,G_ITEM_CATEGORY_CONTEXT)
523: UNION
524: SELECT DISTINCT QPQ.QUALIFIER_ATTRIBUTE
525: FROM QP_QUALIFIERS QPQ
526: ,QP_LIST_HEADERS QPLH
527: ,QP_LIST_LINES QPLL
528: WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
529: AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
530: AND QPLH.AUTOMATIC_FLAG = 'Y'

Line 745: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ

741: OPEN l_discount_csr FOR
742: SELECT QPH.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPH.NAME,
743: DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
744: '%',NVL(QPL.OPERAND,0))
745: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ
746: WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
747: AND QPH.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
748: AND QPQ.QUALIFIER_CONTEXT = G_PRICE_LIST_CONTEXT
749: AND QPQ.QUALIFIER_ATTRIBUTE =G_PRICE_LIST_NAME

Line 813: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ

809: OPEN l_discount_csr FOR
810: SELECT QPH.LIST_HEADER_ID,QPL.LIST_LINE_ID, QPH.NAME,
811: DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
812: '%',NVL(QPL.OPERAND,0))
813: FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ
814: WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
815: AND QPH.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
816: AND QPQ.QUALIFIER_CONTEXT = G_PRICE_LIST_CONTEXT
817: AND QPQ.QUALIFIER_ATTRIBUTE =G_PRICE_LIST_NAME

Line 2232: FROM QP_LIST_HEADERS

2228:
2229:
2230: SELECT ROUNDING_FACTOR
2231: INTO l_rounding_factor
2232: FROM QP_LIST_HEADERS
2233: WHERE LIST_HEADER_ID = p_price_list_id;
2234: --END QP
2235: -- Initialize local variable holding adjustment total
2236: