View: AMS_P_OFFER_PRODUCTS_V

Product:	AMS - Marketing
Description:	This public view returns the products associated with a marketing offers.
Implementation/DBA Data:	APPS.AMS_P_OFFER_PRODUCTS_V

View Text

SELECT AAP.ACTIVITY_PRODUCT_ID
, AAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AAP.MASTER_OBJECT_ID CAMPAIGN_ID
, QPL.DESCRIPTION
, OFF.STATUS_CODE
, OFF.STATUS_DATE
, OFF.OFFER_CODE
, OFF.START_DATE
, OFF.END_DATE
, OFF.OFFER_TYPE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_OFFER_TYPE'
, OFF.OFFER_TYPE)
, AAP.LEVEL_TYPE_CODE
, AAP.LEVEL_TYPE
, AAP.CATEGORY_ID
, AAP.CATEGORY_NAME
, AAP.CATEGORY_SET_ID
, AAP.CATEGORY_SET_NAME
, AAP.ORGANIZATION_ID
, AAP.INVENTORY_ITEM_ID
, AAP.INVENTORY_ITEM_NUMBER
, AAP.INVENTORY_ITEM_DESCRIPTION
, AAP.EXCLUDED_FLAG
FROM AMS_ACT_OFFERS OFF
, QP_LIST_HEADERS_VL QPL
, AMS_ACT_PRODUCTS_V AAP
WHERE OFF.ACTIVITY_OFFER_ID = AAP.MASTER_OBJECT_ID
AND AAP.MASTER_OBJECT_TYPE = 'OFFR'
AND OFF.QP_LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND ( OFF.END_DATE IS NULL OR OFF.END_DATE > SYSDATE )

Columns