eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_P_CAMPAIGN_PRODUCTS_V

Object Details

Object Name:	AMS_P_CAMPAIGN_PRODUCTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_P_CAMPAIGN_PRODUCTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is created to store the information about the products which are associated with the campaign

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_PRODUCT_ID	NUMBER		Yes	Unique identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes
CAMPAIGN_ID	NUMBER		Yes	Identifier of the campaign this product is associated with.
CAMPAIGN_NAME	VARCHAR2	(240)	Yes	Name of the campaign this product is associated with.
CAMPAIGN_STATUS_CODE	VARCHAR2	(30)	Yes	Status code of the campaign
CAMPAIGN_STATUS_DATE	DATE		Yes	Date when the campaign's status was last updated
CAMPAIGN_SOURCE_CODE	VARCHAR2	(30)	Yes	Source code of the campaign this product is associated with
ACTUAL_START_DATE	DATE			Actual execution start date for campaign
ACTUAL_END_DATE	DATE			Actual execution end date for campaign
CAMPAIGN_TYPE	VARCHAR2	(30)		Type of the campaign this product is associated with.
LEVEL_TYPE_CODE	VARCHAR2	(30)		Stores the level type code for this product.
LEVEL_TYPE	VARCHAR2	(80)		Level type for this product.
CATEGORY_ID	NUMBER			Identifier of the Category of the product
CATEGORY_NAME	VARCHAR2	(163)		Name of the Category of the product
CATEGORY_SET_ID	NUMBER			Identifier of the category set of this product
CATEGORY_SET_NAME	VARCHAR2	(30)		Name of the category set of this product
ORGANIZATION_ID	NUMBER	(32)		Stores the organization id that this product belongs to.
INVENTORY_ITEM_ID	NUMBER	(38)		Unique key that stores the inventory item id
INVENTORY_ITEM_NUMBER	VARCHAR2	(40)		Inventory Item number of the product
INVENTORY_ITEM_DESCRIPTION	VARCHAR2	(240)		Description of the item
EXCLUDED_FLAG	VARCHAR2	(1)		Flag to indicate if the specified product is to be included or excluded.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTIVITY_PRODUCT_ID
,      OBJECT_VERSION_NUMBER
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      CAMPAIGN_STATUS_CODE
,      CAMPAIGN_STATUS_DATE
,      CAMPAIGN_SOURCE_CODE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      CAMPAIGN_TYPE
,      LEVEL_TYPE_CODE
,      LEVEL_TYPE
,      CATEGORY_ID
,      CATEGORY_NAME
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NUMBER
,      INVENTORY_ITEM_DESCRIPTION
,      EXCLUDED_FLAG
FROM APPS.AMS_P_CAMPAIGN_PRODUCTS_V;

Dependencies

[top of page]

APPS.AMS_P_CAMPAIGN_PRODUCTS_V references the following:

APPS: AMS_ACT_PRODUCTS_V; AMS_CAMPAIGNS_VL

APPS.AMS_P_CAMPAIGN_PRODUCTS_V is not referenced by any database object