DBA Data[Home] [Help]

VIEW: APPS.QPBV_PRODUCTS

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')