eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OE_DISCOUNT_CUSTOMERS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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