APPS.QP_PRC_UTIL dependencies on QP_LIST_LINES

Line 514: , QP_LIST_LINES QPLL

510: /*
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'

Line 527: ,QP_LIST_LINES QPLL

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'
531: AND QPQ.QUALIFIER_ATTRIBUTE IN (G_CUSTOMER_PO_NAME

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