SELECT PRODUCT_ATTRIBUTE_CONTEXT ,PRODUCT_ATTRIBUTE ,PRODUCT_ATTR_VALUE ,PRODUCT_UOM_CODE ,LIST_LINE_ID ,LIST_HEADER_ID ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,ORIG_SYS_HEADER_REF , ORIG_SYS_LINE_REF from qp_pricing_attributes WHERE excluder_flag = 'N' and (pricing_attribute_context is null or pricing_attribute_context = 'VOLUME')
SELECT PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE
, LIST_LINE_ID
, LIST_HEADER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
FROM QP_PRICING_ATTRIBUTES
WHERE EXCLUDER_FLAG = 'N'
AND (PRICING_ATTRIBUTE_CONTEXT IS NULL OR PRICING_ATTRIBUTE_CONTEXT = 'VOLUME')
|
|
|