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: AMS.AMS_LIST_SELECT_ACTIONS#

Object Details

Object Name:	AMS_LIST_SELECT_ACTIONS#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LIST_SELECT_ACTION_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
LIST_HEADER_ID	NUMBER
ORDER_NUMBER	NUMBER	(15)	Yes
LIST_ACTION_TYPE	VARCHAR2	(30)	Yes
INCL_OBJECT_NAME	VARCHAR2	(254)
ARC_INCL_OBJECT_FROM	VARCHAR2	(30)	Yes
INCL_OBJECT_ID	NUMBER
INCL_OBJECT_WB_SHEET	VARCHAR2	(254)
INCL_OBJECT_WB_OWNER	NUMBER	(15)
INCL_OBJECT_CELL_CODE	VARCHAR2	(30)
RANK	NUMBER	(15)
NO_OF_ROWS_AVAILABLE	NUMBER	(15)
NO_OF_ROWS_REQUESTED	NUMBER	(15)
NO_OF_ROWS_USED	NUMBER	(15)
DISTRIBUTION_PCT	NUMBER	(15)
RESULT_TEXT	VARCHAR2	(4000)
DESCRIPTION	VARCHAR2	(4000)
SECURITY_GROUP_ID	NUMBER
ARC_ACTION_USED_BY	VARCHAR2	(30)
ACTION_USED_BY_ID	NUMBER
INCL_CONTROL_GROUP	VARCHAR2	(1)
NO_OF_ROWS_TARGETED	NUMBER
NO_OF_ROWS_DUPLICATES	NUMBER
RUNNING_TOTAL	NUMBER
DELTA	NUMBER
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
FROM AMS.AMS_LIST_SELECT_ACTIONS#;

Dependencies

[top of page]

AMS.AMS_LIST_SELECT_ACTIONS# references the following:

AMS: AMS_LIST_SELECT_ACTIONS

AMS.AMS_LIST_SELECT_ACTIONS# is referenced by following:

APPS: AMS_LIST_SELECT_ACTIONS; AMS_LIST_SELECT_ACTIONS+