DBA Data[Home] [Help]

VIEW: APPS.QPBV_PRODUCT_EXCLUSIONS

Source

View Text - Preformatted

SELECT LIST_LINE_ID ,EXCLUDER_FLAG ,PRODUCT_ATTRIBUTE_CONTEXT ,PRODUCT_ATTRIBUTE ,PRODUCT_ATTR_VALUE ,LIST_HEADER_ID ,PRICING_ATTRIBUTE_ID ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY , ORIG_SYS_HEADER_REF , ORIG_SYS_LINE_REF , ORIG_SYS_PRICING_ATTR_REF from qp_pricing_attributes WHERE excluder_flag = 'Y'
View Text - HTML Formatted

SELECT LIST_LINE_ID
, EXCLUDER_FLAG
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE
, LIST_HEADER_ID
, PRICING_ATTRIBUTE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_PRICING_ATTR_REF
FROM QP_PRICING_ATTRIBUTES
WHERE EXCLUDER_FLAG = 'Y'