View: OE_DISCOUNTS_V

Product:	QP - Advanced Pricing
Description:	Obsolete
Implementation/DBA Data:	APPS.OE_DISCOUNTS_V

View Text

SELECT QLH.LIST_HEADER_ID DISCOUNT_ID
, QLH.CREATION_DATE CREATION_DATE
, QLH.CREATED_BY CREATED_BY
, QLH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QLH.LAST_UPDATED_BY LAST_UPDATED_BY
, QLH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QLH.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QLH.PROGRAM_ID PROGRAM_ID
, QLH.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QLH.REQUEST_ID REQUEST_ID
, QLHT.NAME
, DECODE(QL.MODIFIER_LEVEL_CODE
, 'LINE'
, 'LINE_ITEM'
, 'ORDER'
, 'ORDER_TOTAL'
, NULL) DISCOUNT_TYPE_CODE
, QQ.QUALIFIER_ATTR_VALUE PRICE_LIST_ID
, QL.AUTOMATIC_FLAG AUTOMATIC_DISCOUNT_FLAG
, QL.OVERRIDE_FLAG OVERRIDE_ALLOWED_FLAG
, QLH.GSA_INDICATOR GSA_INDICATOR
, QLH.PRORATE_FLAG PRORATE_FLAG
, DECODE(QL.MODIFIER_LEVEL_CODE
, 'ORDER'
, DECODE(QL.ARITHMETIC_OPERATOR
, '%'
, OPERAND
, NULL)
, NULL) PERCENT
, DECODE(QL.MODIFIER_LEVEL_CODE
, 'ORDER'
, DECODE(QL.ARITHMETIC_OPERATOR
, 'AMT'
, OPERAND
, NULL)
, NULL) AMOUNT
, QLH.START_DATE_ACTIVE START_DATE_ACTIVE
, QLH.END_DATE_ACTIVE END_DATE_ACTIVE
, QLHT.DESCRIPTION
, DECODE(QL.MODIFIER_LEVEL_CODE
, 'LINE'
, NULL
, 'ORDER'
, 'N'
, NULL) DISCOUNT_LINES_FLAG
, QLH.CONTEXT
, QLH.ATTRIBUTE1
, QLH.ATTRIBUTE2
, QLH.ATTRIBUTE3
, QLH.ATTRIBUTE4
, QLH.ATTRIBUTE5
, QLH.ATTRIBUTE6
, QLH.ATTRIBUTE7
, QLH.ATTRIBUTE8
, QLH.ATTRIBUTE9
, QLH.ATTRIBUTE10
, QLH.ATTRIBUTE11
, QLH.ATTRIBUTE12
, QLH.ATTRIBUTE13
, QLH.ATTRIBUTE14
, QLH.ATTRIBUTE15
, NULL MANUAL_PRICING_DISCOUNT_FLAG
FROM QP_LIST_HEADERS_B QLH
, QP_LIST_LINES QL
, QP_QUALIFIERS QQ
, QP_LIST_HEADERS_TL QLHT
WHERE QL.LIST_HEADER_ID = QLH.LIST_HEADER_ID
AND QLH.LIST_HEADER_ID = QLHT.LIST_HEADER_ID
AND QLH.LIST_HEADER_ID = QQ.LIST_HEADER_ID
AND QL.MODIFIER_LEVEL_CODE != 'LINEGROUP'
AND (QL.LIST_LINE_TYPE_CODE = 'DIS' OR QL.LIST_LINE_TYPE_CODE = 'PBH')
AND QP_VIEW_UTIL.ARE_THERE_BREAKS(QL.LIST_LINE_ID) = 'N'
AND QLH.LIST_TYPE_CODE = 'DLT'
AND QQ.QUALIFIER_CONTEXT = QP_VIEW_UTIL.GET_PRICE_LIST_CONTEXT
AND QQ.QUALIFIER_ATTRIBUTE = QP_VIEW_UTIL.GET_PRICE_LIST_ATTRIBUTE

Columns