[Home] [Help] [Dependency Information]
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 |
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.
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|