VIEW: APPS.QPBV_PRICING_ATTRIBUTES

Source

View Text - Preformatted

SELECT pa.LIST_LINE_ID ,pa.EXCLUDER_FLAG ,pa.PRODUCT_ATTRIBUTE_CONTEXT ,pa.PRODUCT_ATTRIBUTE ,pa.PRODUCT_ATTR_VALUE ,pa.PRICING_ATTRIBUTE_CONTEXT ,pa.PRICING_ATTRIBUTE ,pa.PRICING_ATTR_VALUE_FROM ,pa.PRICING_ATTR_VALUE_TO ,pa.LIST_HEADER_ID ,pa.PRICING_PHASE_ID ,pa.QUALIFICATION_IND ,pa.PRODUCT_UOM_CODE ,pa.COMPARISON_OPERATOR_CODE ,pa.PRICING_ATTRIBUTE_ID ,pa.CREATION_DATE ,pa.CREATED_BY ,pa.LAST_UPDATE_DATE ,pa.LAST_UPDATED_BY ,pa.ORIG_SYS_HEADER_REF ,pa.ORIG_SYS_LINE_REF , pa.ORIG_SYS_PRICING_ATTR_REF from qp_pricing_attributes pa WHERE pa.pricing_attribute_context is not null and pa.excluder_flag = 'N'

View Text - HTML Formatted

SELECT PA.LIST_LINE_ID
, PA.EXCLUDER_FLAG
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, PA.LIST_HEADER_ID
, PA.PRICING_PHASE_ID
, PA.QUALIFICATION_IND
, PA.PRODUCT_UOM_CODE
, PA.COMPARISON_OPERATOR_CODE
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.ORIG_SYS_HEADER_REF
, PA.ORIG_SYS_LINE_REF
, PA.ORIG_SYS_PRICING_ATTR_REF
FROM QP_PRICING_ATTRIBUTES PA
WHERE PA.PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
AND PA.EXCLUDER_FLAG = 'N'