View: AMS_OFFER_PRODUCTS_V

Product:	AMS - Marketing
Description:	Offer Products
Implementation/DBA Data:	APPS.AMS_OFFER_PRODUCTS_V

View Text

SELECT DISTINCT QPH.LIST_HEADER_ID
, ITM.INVENTORY_ITEM_ID
, ITM.CONCATENATED_SEGMENTS
, 'PRODUCT'
FROM QP_PRICING_ATTRIBUTES QP
, QP_LIST_LINES QPLN
, QP_LIST_HEADERS QPH
, MTL_SYSTEM_ITEMS_VL ITM
WHERE QPH.LIST_HEADER_ID = QPLN.LIST_HEADER_ID
AND QPLN.LIST_LINE_ID = QP.LIST_LINE_ID
AND QP.PRODUCT_ATTR_VALUE = ITM.INVENTORY_ITEM_ID
AND QP.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'
AND QP.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' UNION ALL SELECT DISTINCT QPH.LIST_HEADER_ID
, CAT.CATEGORY_ID
, CAT.CATEGORY_CONCAT_SEGS
, 'FAMILY'
FROM QP_PRICING_ATTRIBUTES QP
, QP_LIST_LINES QPLN
, QP_LIST_HEADERS QPH
, MTL_CATEGORIES_V CAT
WHERE QPH.LIST_HEADER_ID = QPLN.LIST_HEADER_ID
AND QPLN.LIST_LINE_ID = QP.LIST_LINE_ID
AND QP.PRODUCT_ATTR_VALUE = CAT.CATEGORY_ID
AND QP.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE2'
AND QP.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'

Columns