[Home] [Help] [Dependency Information]
Object Name: | AMS_LIST_SELECT_ACTIONS# |
---|---|
Object Type: | VIEW |
Owner: | AMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|