VIEW: APPS.OE_DISCOUNTS_V

Source

View Text - Preformatted

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 and QLHT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

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
AND QLHT.LANGUAGE = USERENV('LANG')