Product: | QP - Advanced Pricing |
---|---|
Description: | List of price breaks in agreements |
Implementation/DBA Data: | APPS.QP_AGR_PRICE_BREAK_LINES_V |
SELECT QP_PRICE_LIST_PVT.GET_PRICE_BREAK_LOW(QL.LIST_LINE_ID) PRICE_BREAK_LOW
, QP_PRICE_LIST_PVT.GET_PRICE_BREAK_HIGH(QL.LIST_LINE_ID) PRICE_BREAK_HIGH
, QRM.TO_RLTD_MODIFIER_ID PRICE_BREAK_LINE_ID
, QRM.FROM_RLTD_MODIFIER_ID PRICE_LIST_LINE_ID
, 'QUANTITY' METHOD_TYPE_CODE
, QL.CREATION_DATE CREATION_DATE
, QL.CREATED_BY CREATED_BY
, QL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QL.LAST_UPDATED_BY LAST_UPDATED_BY
, QL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QL.PROGRAM_ID PROGRAM_ID
, QL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QL.REQUEST_ID REQUEST_ID
, QL.LIST_PRICE PRICE
, QP_PRICE_LIST_PVT.GET_PRODUCT_UOM_CODE(QL.LIST_LINE_ID) UNIT_CODE
, QL.START_DATE_ACTIVE START_DATE_ACTIVE
, QL.END_DATE_ACTIVE END_DATE_ACTIVE
, QL.CONTEXT
, QL.ATTRIBUTE1
, QL.ATTRIBUTE2
, QL.ATTRIBUTE3
, QL.ATTRIBUTE4
, QL.ATTRIBUTE5
, QL.ATTRIBUTE6
, QL.ATTRIBUTE7
, QL.ATTRIBUTE8
, QL.ATTRIBUTE9
, QL.ATTRIBUTE10
, QL.ATTRIBUTE11
, QL.ATTRIBUTE12
, QL.ATTRIBUTE13
, QL.ATTRIBUTE14
, QL.ATTRIBUTE15
FROM QP_LIST_LINES QL
, QP_RLTD_MODIFIERS QRM
WHERE QL.LIST_LINE_TYPE_CODE = 'PLL'
AND QL.LIST_LINE_ID = QRM.TO_RLTD_MODIFIER_ID