View: AMS_PRODUCT_OFFERS_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_PRODUCT_OFFERS_V

View Text

SELECT QLH.NAME
, QLH.DESCRIPTION
, QLH.ASK_FOR_FLAG REQUEST_ONLY
, QLH.ACTIVE_FLAG
, OFFR.OFFER_TYPE
, OFFR.REUSABLE
, OZF_UTILITY_PVT.GET_LOOKUP_MEANING('OZF_OFFER_TYPE'
, OFFR.OFFER_TYPE) OFFER_TYPE_MEANING
, QLH.START_DATE_ACTIVE
, QLH.END_DATE_ACTIVE
, QLL.OPERAND
, QLL.PRODUCT_PRECEDENCE
, QPA.PRODUCT_ATTR_VALUE PRODUCT_ID
, DECODE(OFFR.OFFER_TYPE
, 'OFF_INVOICE'
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.ARITHMETIC_OPERATOR
, 'ARITHMETIC_OPERATOR')
, NULL) OPERATOR
, QP_QP_FORM_PRICING_ATTR.GET_PRICING_PHASE(QLL.PRICING_PHASE_ID) PHASE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.INCOMPATIBILITY_GRP_CODE
, 'INCOMPATIBILITY_GROUPS') INCOMPATIBILITY
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.MODIFIER_LEVEL_CODE
, 'MODIFIER_LEVEL_CODE') DISCOUNT_LEVEL
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.LIST_LINE_TYPE_CODE
, 'LIST_LINE_TYPE_CODE') LINE_TYPE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.PRICE_BREAK_TYPE_CODE
, 'PRICE_BREAK_TYPE_CODE') PRICE_BREAK
, AMS_UTILITY_PVT.GET_UOM_NAME(QPA.PRODUCT_UOM_CODE) UNIT_OF_MEASURE
FROM QP_LIST_HEADERS_VL QLH
, OZF_OFFERS OFFR
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
WHERE QLH.LIST_HEADER_ID = OFFR.QP_LIST_HEADER_ID
AND QLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND NVL(QLL.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(QLH.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND QPA.EXCLUDER_FLAG = 'N' ORDER BY QLH.NAME

Columns