VIEW: APPS.QP_PRICE_BOOK_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT pa.RowId ROW_ID, pa.PRICE_BOOK_ATTRIBUTE_ID, pa.PRICE_BOOK_LINE_DET_ID, pa.PRICE_BOOK_LINE_ID, pa.PRICE_BOOK_HEADER_ID, pa.CREATION_DATE , pa.CREATED_BY , pa.LAST_UPDATE_DATE , pa.LAST_UPDATED_BY , pa.LAST_UPDATE_LOGIN , pa.PRICING_PROD_CONTEXT, pa.PRICING_PROD_ATTRIBUTE, pa.COMPARISON_OPERATOR_CODE, pa.PRICING_PROD_ATTR_VALUE_FROM, pa.PRICING_ATTR_VALUE_TO, pa.PRICING_PROD_ATTR_DATATYPE, pa.ATTRIBUTE_TYPE, QP_Price_Book_Util.get_context_name(pa.PRICING_PROD_CONTEXT,'PRICING_ATTRIBUTE') CONTEXT_NAME, QP_Price_Book_Util.get_attribute_name(pa.PRICING_PROD_CONTEXT, pa.PRICING_PROD_ATTRIBUTE,'PRICING_ATTRIBUTE') ATTRIBUTE_NAME, QP_Price_Book_Util.get_attribute_value_common('PRICING_ATTRIBUTE',pa.PRICING_PROD_CONTEXT, pa.PRICING_PROD_ATTRIBUTE, pa.PRICING_PROD_ATTR_VALUE_FROM, pa.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_NAME, QP_Price_Book_Util.get_attribute_value_common('PRICING_ATTRIBUTE',pa.PRICING_PROD_CONTEXT,pa.PRICING_PROD_ATTRIBUTE, pa.PRICING_ATTR_VALUE_TO, pa.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_TO_NAME, QP_Price_Book_Util.value_to_meaning(pa.COMPARISON_OPERATOR_CODE,'COMPARISON_OPERATOR_FWK') COMPARISON_OPERATOR_NAME FROM QP_PRICE_BOOK_ATTRIBUTES pa

View Text - HTML Formatted

SELECT PA.ROWID ROW_ID
, PA.PRICE_BOOK_ATTRIBUTE_ID
, PA.PRICE_BOOK_LINE_DET_ID
, PA.PRICE_BOOK_LINE_ID
, PA.PRICE_BOOK_HEADER_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.PRICING_PROD_CONTEXT
, PA.PRICING_PROD_ATTRIBUTE
, PA.COMPARISON_OPERATOR_CODE
, PA.PRICING_PROD_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, PA.PRICING_PROD_ATTR_DATATYPE
, PA.ATTRIBUTE_TYPE
, QP_PRICE_BOOK_UTIL.GET_CONTEXT_NAME(PA.PRICING_PROD_CONTEXT
, 'PRICING_ATTRIBUTE') CONTEXT_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_NAME(PA.PRICING_PROD_CONTEXT
, PA.PRICING_PROD_ATTRIBUTE
, 'PRICING_ATTRIBUTE') ATTRIBUTE_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_VALUE_COMMON('PRICING_ATTRIBUTE'
, PA.PRICING_PROD_CONTEXT
, PA.PRICING_PROD_ATTRIBUTE
, PA.PRICING_PROD_ATTR_VALUE_FROM
, PA.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_NAME
, QP_PRICE_BOOK_UTIL.GET_ATTRIBUTE_VALUE_COMMON('PRICING_ATTRIBUTE'
, PA.PRICING_PROD_CONTEXT
, PA.PRICING_PROD_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_TO
, PA.COMPARISON_OPERATOR_CODE) ATTRIBUTE_VALUE_TO_NAME
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(PA.COMPARISON_OPERATOR_CODE
, 'COMPARISON_OPERATOR_FWK') COMPARISON_OPERATOR_NAME
FROM QP_PRICE_BOOK_ATTRIBUTES PA