DBA Data[Home] [Help]

APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on QP_LIST_HEADERS_B

Line 2061: , QP_LIST_HEADERS_B QH

2057: , LDETS.adjustment_amount -- ADJUSTED_AMOUNT_PER_PQTY
2058: , 1 -- LOCK_CONTROL
2059: FROM QP_LDETS_v LDETS
2060: , QP_PREQ_LINES_TMP QLINE
2061: , QP_LIST_HEADERS_B QH
2062: WHERE LDETS.list_header_id = QH.list_header_id
2063: AND LDETS.process_code = QP_PREQ_GRP.G_STATUS_NEW
2064: AND QLINE.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
2065: AND QLINE.process_status <> 'NOT_VALID'