View: OE_DISCOUNT_CUSTOMERS_V

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

View Text

SELECT MAX(A.QUALIFIER_GROUPING_NO) DISCOUNT_CUSTOMER_ID
, MAX(A.CREATION_DATE) CREATION_DATE
, MAX(A.CREATED_BY) CREATED_BY
, MAX(A.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, MAX(A.LAST_UPDATED_BY) LAST_UPDATED_BY
, MAX(A.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
, MAX(A.PROGRAM_APPLICATION_ID) PROGRAM_APPLICATION_ID
, MAX(A.PROGRAM_ID) PROGRAM_ID
, MAX(A.PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE
, MAX(A.REQUEST_ID) REQUEST_ID
, MAX(A.CONTEXT) CONTEXT
, MAX(A.ATTRIBUTE1) ATTRIBUTE1
, MAX(A.ATTRIBUTE2) ATTRIBUTE2
, MAX(A.ATTRIBUTE3) ATTRIBUTE3
, MAX(A.ATTRIBUTE4) ATTRIBUTE4
, MAX(A.ATTRIBUTE5) ATTRIBUTE5
, MAX(A.ATTRIBUTE6) ATTRIBUTE6
, MAX(A.ATTRIBUTE7) ATTRIBUTE7
, MAX(A.ATTRIBUTE8) ATTRIBUTE8
, MAX(A.ATTRIBUTE9) ATTRIBUTE9
, MAX(A.ATTRIBUTE10) ATTRIBUTE10
, MAX(A.ATTRIBUTE11) ATTRIBUTE11
, MAX(A.ATTRIBUTE12) ATTRIBUTE12
, MAX(A.ATTRIBUTE13) ATTRIBUTE13
, MAX(A.ATTRIBUTE14) ATTRIBUTE14
, MAX(A.ATTRIBUTE15) ATTRIBUTE15
, MAX(START_DATE_ACTIVE) START_DATE_ACTIVE
, MAX(END_DATE_ACTIVE) END_DATE_ACTIVE
, A.LIST_HEADER_ID DISCOUNT_ID
, MAX(DECODE(A.QUALIFIER_ATTRIBUTE
, QP_UTIL.GET_CUST_CLASS_ATTRIB
, A.QUALIFIER_ATTR_VALUE)) CUSTOMER_CLASS_CODE
, TO_NUMBER(MAX(DECODE(A.QUALIFIER_ATTRIBUTE
, QP_UTIL.GET_SOLD_TO_ATTRIB
, A.QUALIFIER_ATTR_VALUE))) SOLD_TO_ORG_ID
, TO_NUMBER(MAX(DECODE(A.QUALIFIER_ATTRIBUTE
, QP_UTIL.GET_SITE_USE_ATTRIB
, A.QUALIFIER_ATTR_VALUE))) SITE_ORG_ID
FROM QP_QUALIFIERS A
WHERE A.QUALIFIER_CONTEXT = QP_UTIL.GET_CUST_CONTEXT
AND A.QUALIFIER_ATTRIBUTE IN (QP_UTIL.GET_CUST_CLASS_ATTRIB
, QP_UTIL.GET_SOLD_TO_ATTRIB
, QP_UTIL.GET_SITE_USE_ATTRIB ) GROUP BY LIST_HEADER_ID
, QUALIFIER_GROUPING_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE

Columns