VIEW: APPS.QP_PRICE_BOOK_LINE_DETAILS_V

Source

View Text - Preformatted

SELECT L.RowId ROW_ID, L.PRICE_BOOK_LINE_DET_ID, L.PRICE_BOOK_LINE_ID, L.PRICE_BOOK_HEADER_ID, L.LIST_HEADER_ID , L.LIST_LINE_ID, L.LIST_LINE_NO , L.MODIFIER_OPERAND , L.MODIFIER_APPLICATION_METHOD , L.LIST_PRICE , L.ADJUSTMENT_AMOUNT , L.ADJUSTED_NET_PRICE , L.LIST_LINE_TYPE_CODE , L.PRICE_BREAK_TYPE_CODE , L.CREATION_DATE , L.CREATED_BY , L.LAST_UPDATE_DATE , L.LAST_UPDATED_BY , L.LAST_UPDATE_LOGIN , QP_Price_Book_Util.get_list_name(L.LIST_HEADER_ID) LIST_NAME, QP_Price_Book_Util.value_to_meaning(L.LIST_LINE_TYPE_CODE,'LIST_LINE_TYPE_CODE') LIST_LINE_TYPE, QP_Price_Book_Util.value_to_meaning(L.PRICE_BREAK_TYPE_CODE,'PRICE_BREAK_TYPE_CODE') PRICE_BREAK_TYPE , QP_Price_Book_Util.value_to_meaning(L.MODIFIER_APPLICATION_METHOD,'ARITHMETIC_OPERATOR') APPLICATION_METHOD_NAME FROM QP_PRICE_BOOK_LINE_DETAILS L

View Text - HTML Formatted

SELECT L.ROWID ROW_ID
, L.PRICE_BOOK_LINE_DET_ID
, L.PRICE_BOOK_LINE_ID
, L.PRICE_BOOK_HEADER_ID
, L.LIST_HEADER_ID
, L.LIST_LINE_ID
, L.LIST_LINE_NO
, L.MODIFIER_OPERAND
, L.MODIFIER_APPLICATION_METHOD
, L.LIST_PRICE
, L.ADJUSTMENT_AMOUNT
, L.ADJUSTED_NET_PRICE
, L.LIST_LINE_TYPE_CODE
, L.PRICE_BREAK_TYPE_CODE
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, QP_PRICE_BOOK_UTIL.GET_LIST_NAME(L.LIST_HEADER_ID) LIST_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(L.LIST_LINE_TYPE_CODE
, 'LIST_LINE_TYPE_CODE') LIST_LINE_TYPE
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(L.PRICE_BREAK_TYPE_CODE
, 'PRICE_BREAK_TYPE_CODE') PRICE_BREAK_TYPE
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(L.MODIFIER_APPLICATION_METHOD
, 'ARITHMETIC_OPERATOR') APPLICATION_METHOD_NAME
FROM QP_PRICE_BOOK_LINE_DETAILS L