VIEW: APPS.QP_PRICE_BOOK_BREAK_LINES_V

Source

View Text - Preformatted

SELECT pbk.RowId ROW_ID, pbk.PRICE_BOOK_BREAK_LINE_ID, pbk.PRICE_BOOK_HEADER_ID, pbk.PRICE_BOOK_LINE_ID, pbk.PRICE_BOOK_LINE_DET_ID, pbk.CREATION_DATE , pbk.CREATED_BY , pbk.LAST_UPDATE_DATE , pbk.LAST_UPDATED_BY , pbk.LAST_UPDATE_LOGIN , pbk.PRICING_CONTEXT, pbk.PRICING_ATTRIBUTE, pbk.COMPARISON_OPERATOR_CODE, pbk.PRICING_ATTR_VALUE_FROM, pbk.PRICING_ATTR_VALUE_TO, pbk.PRICING_ATTRIBUTE_DATATYPE, pbk.OPERAND, pbk.APPLICATION_METHOD, pbk.RECURRING_VALUE, QP_Price_Book_Util.get_context_name(pbk.PRICING_CONTEXT,'PRICING_ATTRIBUTE') CONTEXT_NAME, QP_Price_Book_Util.get_attribute_name(pbk.PRICING_CONTEXT, pbk.PRICING_ATTRIBUTE,'PRICING_ATTRIBUTE') ATTRIBUTE_NAME, QP_Price_Book_Util.get_attribute_value_common('PRICING_ATTRIBUTE',pbk.PRICING_CONTEXT, pbk.PRICING_ATTRIBUTE, pbk.PRICING_ATTR_VALUE_FROM,pbk.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_NAME, QP_Price_Book_Util.get_attribute_value_common('PRICING_ATTRIBUTE',pbk.PRICING_CONTEXT, pbk.PRICING_ATTRIBUTE, pbk.PRICING_ATTR_VALUE_TO,pbk.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_TO_NAME, QP_Price_Book_Util.value_to_meaning(pbk.COMPARISON_OPERATOR_CODE,'COMPARISON_OPERATOR_FWK') COMPARISON_OPERATOR_NAME , QP_Price_Book_Util.value_to_meaning(pbk.APPLICATION_METHOD,'ARITHMETIC_OPERATOR') APPLICATION_METHOD_NAME FROM QP_PRICE_BOOK_BREAK_LINES pbk

View Text - HTML Formatted

SELECT PBK.ROWID ROW_ID
, PBK.PRICE_BOOK_BREAK_LINE_ID
, PBK.PRICE_BOOK_HEADER_ID
, PBK.PRICE_BOOK_LINE_ID
, PBK.PRICE_BOOK_LINE_DET_ID
, PBK.CREATION_DATE
, PBK.CREATED_BY
, PBK.LAST_UPDATE_DATE
, PBK.LAST_UPDATED_BY
, PBK.LAST_UPDATE_LOGIN
, PBK.PRICING_CONTEXT
, PBK.PRICING_ATTRIBUTE
, PBK.COMPARISON_OPERATOR_CODE
, PBK.PRICING_ATTR_VALUE_FROM
, PBK.PRICING_ATTR_VALUE_TO
, PBK.PRICING_ATTRIBUTE_DATATYPE
, PBK.OPERAND
, PBK.APPLICATION_METHOD
, PBK.RECURRING_VALUE
, QP_PRICE_BOOK_UTIL.GET_CONTEXT_NAME(PBK.PRICING_CONTEXT
, 'PRICING_ATTRIBUTE') CONTEXT_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_NAME(PBK.PRICING_CONTEXT
, PBK.PRICING_ATTRIBUTE
, 'PRICING_ATTRIBUTE') ATTRIBUTE_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_VALUE_COMMON('PRICING_ATTRIBUTE'
, PBK.PRICING_CONTEXT
, PBK.PRICING_ATTRIBUTE
, PBK.PRICING_ATTR_VALUE_FROM
, PBK.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_VALUE_COMMON('PRICING_ATTRIBUTE'
, PBK.PRICING_CONTEXT
, PBK.PRICING_ATTRIBUTE
, PBK.PRICING_ATTR_VALUE_TO
, PBK.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_TO_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(PBK.COMPARISON_OPERATOR_CODE
, 'COMPARISON_OPERATOR_FWK') COMPARISON_OPERATOR_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(PBK.APPLICATION_METHOD
, 'ARITHMETIC_OPERATOR') APPLICATION_METHOD_NAME
FROM QP_PRICE_BOOK_BREAK_LINES PBK