[Home] [Help] [Dependency Information]
Object Name: | AMS_EVENT_MARKET_SEGMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_EVENT_MARKET_SEGMENTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_MARKET_SEGMENT_ID | NUMBER | Yes | Unique identifier | |
ACT_MARKET_SEGMENT_USED_BY_ID | NUMBER | Yes | Unique identifier | |
ARC_ACT_MARKET_SEGMENT_USED_BY | VARCHAR2 | (30) | Yes | Unique segment name used across systems |
MARKET_SEGMENT_ID | NUMBER | Yes | Unique identifier | |
MARKET_SEGMENT_NAME | VARCHAR2 | (120) | Yes | Name of the segment |
MARKET_SEGMENT_DESCRIPTION | VARCHAR2 | (4000) | Description of the market segment | |
MARKET_SEGMENT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate this segment's state |
ORIGINAL_SIZE | NUMBER | (15) | Size of the segment when created |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_MARKET_SEGMENT_ID
, ACT_MARKET_SEGMENT_USED_BY_ID
, ARC_ACT_MARKET_SEGMENT_USED_BY
, MARKET_SEGMENT_ID
, MARKET_SEGMENT_NAME
, MARKET_SEGMENT_DESCRIPTION
, MARKET_SEGMENT_FLAG
, ORIGINAL_SIZE
FROM APPS.AMS_EVENT_MARKET_SEGMENTS_V;
APPS.AMS_EVENT_MARKET_SEGMENTS_V is not referenced by any database object
|
|
|