[Home] [Help] [Dependency Information]
Object Name: | IEC_G_LIST_SUBSETS |
---|---|
Object Type: | TABLE |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Stores subset information for a particular list.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_G_LIST_SUBSETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LIST_SUBSET_ID |
IEC_G_LIST_SUBSETS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LIST_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_SUBSET_ID | NUMBER | (15) | Yes | Unique Identifier |
LIST_HEADER_ID | NUMBER | (15) | Yes | Foreign key to the AMS_LIST_HEADERS_ALL table. |
SUBSET_NAME | VARCHAR2 | (60) | Yes | Unique Name for the subset. |
QUANTUM | NUMBER | (10) | The designated quantum for the subset. | |
PRIORITY | NUMBER | Yes | Priority of subset used in release strategy. | |
STATUS_CODE | VARCHAR2 | (10) | Used for soft deletes. | |
DEFAULT_SUBSET_FLAG | VARCHAR2 | (1) | Flag indicates whether this subset represents the default set of list entries. The default set is the complement of the union of all other subsets defined for this list. | |
RELEASE_STRATEGY | VARCHAR2 | (30) | Release Strategy to use on this subset. | |
QUOTA | NUMBER | (10) | Assigned value of the quota for this subset. | |
QUOTA_RESET | NUMBER | (10) | Duration of time prior to resetting a subsets working quota. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Used for locking in HTML applications. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. | |
LOAD_PRIORITY | NUMBER | Load priority for this subset. | ||
LAST_CRITERIA_UPDATE_DATE | DATE | The last time the criteria of this subset was updated. | ||
READY_FLAG | VARCHAR2 | (1) | This flag indicates whether or not a subset is ready. |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_SUBSET_ID
, LIST_HEADER_ID
, SUBSET_NAME
, QUANTUM
, PRIORITY
, STATUS_CODE
, DEFAULT_SUBSET_FLAG
, RELEASE_STRATEGY
, QUOTA
, QUOTA_RESET
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, LOAD_PRIORITY
, LAST_CRITERIA_UPDATE_DATE
, READY_FLAG
FROM IEC.IEC_G_LIST_SUBSETS;
IEC.IEC_G_LIST_SUBSETS does not reference any database object
IEC.IEC_G_LIST_SUBSETS is referenced by following:
|
|
|