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]

TABLE: AMS.AMS_LIST_SELECT_ACTIONS

Object Details

Object Name:	AMS_LIST_SELECT_ACTIONS
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_LIST_SELECT_ACTIONS
Subobject Name:
Status:	VALID

AMS_LIST_SELECT_ACTIONS associates selection criteria to a target list. These criteria can be a Discoverer workbook, a cell or a previously generated list. Further the user can perform inclusions and exclusions between the different selection criteria. Oracle Marketing list generation engine uses this information to generate the target list.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_LIST_SELECT_ACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_SELECT_ACTION_ID
AMS_LIST_SELECT_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_USED_BY_ID ARC_ACTION_USED_BY ARC_INCL_OBJECT_FROM INCL_OBJECT_ID
AMS_LIST_SELECT_ACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_ACTION_USED_BY ACTION_USED_BY_ID
AMS_LIST_SELECT_ACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCL_OBJECT_ID ARC_INCL_OBJECT_FROM

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_SELECT_ACTION_ID	NUMBER		Yes	Unique Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
LIST_HEADER_ID	NUMBER			Foreign key to AMS_LIST_HEADERS_ALL table.
ORDER_NUMBER	NUMBER	(15)	Yes	Order in which rules are processed
LIST_ACTION_TYPE	VARCHAR2	(30)	Yes	Action Type Of List, either Include or Exclude or Intersect.
INCL_OBJECT_NAME	VARCHAR2	(254)		Name of Object to be included.
ARC_INCL_OBJECT_FROM	VARCHAR2	(30)	Yes	Object to be included from, either Diwb or List or Cell.
INCL_OBJECT_ID	NUMBER			Foreign Key to include object table.
INCL_OBJECT_WB_SHEET	VARCHAR2	(254)		Sheet name of included workbook.
INCL_OBJECT_WB_OWNER	NUMBER	(15)		Owner of included workbook.
INCL_OBJECT_CELL_CODE	VARCHAR2	(30)		cell code of included object.
RANK	NUMBER	(15)		Used to rank the action during deduplication process.
NO_OF_ROWS_AVAILABLE	NUMBER	(15)		Number of rows available.
NO_OF_ROWS_REQUESTED	NUMBER	(15)		Number of rows requested.
NO_OF_ROWS_USED	NUMBER	(15)		Number of rows used.
DISTRIBUTION_PCT	NUMBER	(15)		Percentage of rows requested.
RESULT_TEXT	VARCHAR2	(4000)		stores the result of action during processing.
DESCRIPTION	VARCHAR2	(4000)		Query name or description of action
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ARC_ACTION_USED_BY	VARCHAR2	(30)		System Arc Qualifer. Valid values are LIST and MODL
ACTION_USED_BY_ID	NUMBER			Value of List header Id in case if The arc_action_used_by is LIST.
INCL_CONTROL_GROUP	VARCHAR2	(1)		Whether to include control Group Entries in List
NO_OF_ROWS_TARGETED	NUMBER			Used by Data Mining Targets
NO_OF_ROWS_DUPLICATES	NUMBER			Number of duplicate rows.
RUNNING_TOTAL	NUMBER			Running total of number of rows satisfying current criteria.
DELTA	NUMBER			Used to store the difference between adjacent selection criteria.

Query Text

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


SELECT LIST_SELECT_ACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      LIST_HEADER_ID
,      ORDER_NUMBER
,      LIST_ACTION_TYPE
,      INCL_OBJECT_NAME
,      ARC_INCL_OBJECT_FROM
,      INCL_OBJECT_ID
,      INCL_OBJECT_WB_SHEET
,      INCL_OBJECT_WB_OWNER
,      INCL_OBJECT_CELL_CODE
,      RANK
,      NO_OF_ROWS_AVAILABLE
,      NO_OF_ROWS_REQUESTED
,      NO_OF_ROWS_USED
,      DISTRIBUTION_PCT
,      RESULT_TEXT
,      DESCRIPTION
,      SECURITY_GROUP_ID
,      ARC_ACTION_USED_BY
,      ACTION_USED_BY_ID
,      INCL_CONTROL_GROUP
,      NO_OF_ROWS_TARGETED
,      NO_OF_ROWS_DUPLICATES
,      RUNNING_TOTAL
,      DELTA
FROM AMS.AMS_LIST_SELECT_ACTIONS;

Dependencies

[top of page]

AMS.AMS_LIST_SELECT_ACTIONS does not reference any database object

AMS.AMS_LIST_SELECT_ACTIONS is referenced by following:

APPS: AMS_LIST_SELECT_ACTIONS