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_ACT_MKT_SEGMENTS_VL

Object Details

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

View Type

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

AMS_ACT_MARKET_SEGEMENTS_VL is a view on the base and translation tables that contains the translated data ( segment name, cell name ) based on the current language.

[View Source]

Columns

Name	Datatype	Length	Comments
ACTIVITY_MARKET_SEGMENT_ID	NUMBER		Unique Identifier.
MARKET_SEGMENT_ID	NUMBER		Identifier of Marketing Segment.
ACT_MARKET_SEGMENT_USED_BY_ID	NUMBER		Unique activity code used across systems.
ARC_ACT_MARKET_SEGMENT_USED_BY	VARCHAR2	(30)	Unique activity type used across systems.
OBJECT_VERSION_NUMBER	NUMBER	(9)	This column is used for locking purposes.
MARKET_SEGMENT_NAME	VARCHAR2	(2000)	Name of the Market Segment
SEGMENT_TYPE	VARCHAR2	(30)	Segment Type.
SEGMENT_NAME	VARCHAR2	(4000)	Segment Name.
EXCLUDE_FLAG	VARCHAR2	(1)	Flag indicates whether to include or exclude this segment
ELIGIBILITY_TYPE	VARCHAR2	(30)	Market Eligibility Type
ELIGIBILITY_NAME	VARCHAR2	(4000)	Meaning of the Market Eligibility
TERR_HIERARCHY_ID	NUMBER		Identifier for the Teritory Hierarchy
HIERARCHY_NAME	VARCHAR2	(2000)	Name of the Territory Hierarchy

Query Text

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


SELECT ACTIVITY_MARKET_SEGMENT_ID
,      MARKET_SEGMENT_ID
,      ACT_MARKET_SEGMENT_USED_BY_ID
,      ARC_ACT_MARKET_SEGMENT_USED_BY
,      OBJECT_VERSION_NUMBER
,      MARKET_SEGMENT_NAME
,      SEGMENT_TYPE
,      SEGMENT_NAME
,      EXCLUDE_FLAG
,      ELIGIBILITY_TYPE
,      ELIGIBILITY_NAME
,      TERR_HIERARCHY_ID
,      HIERARCHY_NAME
FROM APPS.AMS_ACT_MKT_SEGMENTS_VL;

Dependencies

[top of page]

APPS.AMS_ACT_MKT_SEGMENTS_VL references the following:

APPS: AMS_ACT_MARKET_SEGMENTS; AMS_CELLS_VL; AMS_GEOAREA_SCR_V; AMS_TERR_V; AMS_UTILITY_PVT - show dependent code; JTF_LOC_TYPES_VL; JTF_TERR_ALL

APPS.AMS_ACT_MKT_SEGMENTS_VL is referenced by following:

APPS: OZF_PRICELIST_PVT - show dependent code