View: AMS_P_CAMPAIGN_PRODUCTS_V

Product:	AMS - Marketing
Description:	This public view returns products / product categories associated to marketing campaigns.
Implementation/DBA Data:	APPS.AMS_P_CAMPAIGN_PRODUCTS_V

View Text

SELECT AAP.ACTIVITY_PRODUCT_ID
, AAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AAP.MASTER_OBJECT_ID CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.STATUS_CODE CAMPAIGN_STATUS_CODE
, CAM.STATUS_DATE CAMPAIGN_STATUS_DATE
, CAM.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, CAM.ACTUAL_EXEC_START_DATE ACTUAL_START_DATE
, CAM.ACTUAL_EXEC_END_DATE ACTUAL_END_DATE
, CAM.CAMPAIGN_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_CAMPAIGNS_VL CAM
, AMS_ACT_PRODUCTS_V AAP
WHERE CAM.CAMPAIGN_ID = AAP.MASTER_OBJECT_ID
AND AAP.MASTER_OBJECT_TYPE = 'CAMP'
AND CAM.STATUS_CODE = 'ACTIVE'
AND CAM.ACTIVE_FLAG = 'Y'
AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'

Columns