VIEW: APPS.OE_DISCOUNT_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'