Product: | QP - Advanced Pricing |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.OE_DISCOUNT_LINES_V |
SELECT QL.LIST_LINE_ID DISCOUNT_LINE_ID
, 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_HEADER_ID DISCOUNT_ID
, NULL CUSTOMER_ITEM_ID
, TO_NUMBER(QP_VIEW_UTIL.GET_ENTITY_ID(QL.LIST_LINE_ID)) ENTITY_ID
, QP_VIEW_UTIL.GET_ENTITY_VALUE(QL.LIST_LINE_ID) ENTITY_VALUE
, DECODE(QP_VIEW_UTIL.ARE_THERE_BREAKS(QL.LIST_LINE_ID)
, 'N'
, DECODE(QL.ARITHMETIC_OPERATOR
, '%'
, OPERAND
, NULL)
, NULL) PERCENT
, DECODE(QP_VIEW_UTIL.ARE_THERE_BREAKS(QL.LIST_LINE_ID)
, 'N'
, DECODE(QL.ARITHMETIC_OPERATOR
, 'AMT'
, OPERAND
, NULL)
, NULL) AMOUNT
, DECODE(QP_VIEW_UTIL.ARE_THERE_BREAKS(QL.LIST_LINE_ID)
, 'N'
, DECODE(QL.ARITHMETIC_OPERATOR
, 'NEWPRICE'
, OPERAND
, NULL)
, NULL) PRICE
, 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
WHERE (QL.LIST_LINE_TYPE_CODE = 'DIS' OR QL.LIST_LINE_TYPE_CODE = 'PBH')
AND QL.MODIFIER_LEVEL_CODE = 'LINE'
AND QP_VIEW_UTIL.ARE_THERE_BREAKS(QL.LIST_LINE_ID) = 'N'