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_MKT_SEGMENTS_V

Object Details

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

View Type

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

This public view is created for the general information about cells associated with campaigns.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAMPAIGN_ID	NUMBER		Yes	Identifier for the campaign.
CAMPAIGN_NAME	VARCHAR2	(240)	Yes	Name of the campaign
CAMPAIGN_SOURCE_CODE	VARCHAR2	(30)	Yes	Source code for the campaign
CAMPAIGN_START_DATE	DATE			Start date for the campaign
CAMPAIGN_END_DATE	DATE			End date for the campaign
CAMPAIGN_STATUS	VARCHAR2	(30)	Yes	Status of the campaign
MARKET_SEGMENT_ID	NUMBER		Yes	Identifier for the cell or territory or geo area associated with the campaign
MARKET_SEGMENT_NAME	VARCHAR2	(120)	Yes	Name of the cell , geo area or territory associated
SEGMENT_TYPE	VARCHAR2	(30)		Type of Segment
SEGMENT_NAME	VARCHAR2	(4000)		Name of the Segment type
EXCLUDE_FLAG	VARCHAR2	(1)		Flag indicates if the segment should be excluded from the set.
ELIGIBILITY_TYPE	VARCHAR2	(30)		Market Eligibility Type
ELIGIBILITY_NAME	VARCHAR2	(4000)		Name of the Market Eligibility Type
TERR_HIERARCHY_ID	NUMBER			Territory Hierarchy Id
HIERARCH_NAME	VARCHAR2	(0)		Name of the Territory Hierarchy

Query Text

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


SELECT CAMPAIGN_ID
,      CAMPAIGN_NAME
,      CAMPAIGN_SOURCE_CODE
,      CAMPAIGN_START_DATE
,      CAMPAIGN_END_DATE
,      CAMPAIGN_STATUS
,      MARKET_SEGMENT_ID
,      MARKET_SEGMENT_NAME
,      SEGMENT_TYPE
,      SEGMENT_NAME
,      EXCLUDE_FLAG
,      ELIGIBILITY_TYPE
,      ELIGIBILITY_NAME
,      TERR_HIERARCHY_ID
,      HIERARCH_NAME
FROM APPS.AMS_P_CAMPAIGN_MKT_SEGMENTS_V;

Dependencies

[top of page]

APPS.AMS_P_CAMPAIGN_MKT_SEGMENTS_V references the following:

APPS: AMS_ACT_MARKET_SEGMENTS; AMS_CAMPAIGNS_VL; AMS_CELLS_VL; AMS_UTILITY_PVT - show dependent code

APPS.AMS_P_CAMPAIGN_MKT_SEGMENTS_V is not referenced by any database object