[Home] [Help] [Dependency Information]
Object Name: | MSC_ATP_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_ATP_PARAMETERS |
Subobject Name: | |
Status: | VALID |
ATP related parameters storage
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRE_ALLOC_HASH_SIZE | NUMBER | Hash Area Size for ATP Pre-allocation | ||
PRE_ALLOC_SORT_SIZE | NUMBER | Sort Area Size for ATP Pre-allocation | ||
PRE_ALLOC_PARALLEL_DEGREE | NUMBER | Degree of parallelism for ATP Pre-allocation | ||
CREATION_DATE | DATE | Yes | Record creation date | |
CREATED_BY | NUMBER | Yes | Record Creation userid | |
LAST_UPDATE_DATE | DATE | Yes | Last update date for record | |
LAST_UPDATE_BY | NUMBER | Yes | Last update userid for record | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Last update login for record | |
ITEM_HIER_INIT_EXTENT | NUMBER | ITEM_HIER_INIT_EXTENT | ||
ITEM_HIER_NEXT_EXTENT | NUMBER | ITEM_HIER_NEXT_EXTENT | ||
ITEM_HIER_PCT_INCREASE | NUMBER | ITEM_HIER_PCT_INCREASE | ||
ITEM_HIER_INDX_INIT_EXTENT | NUMBER | ITEM_HIER_INDX_INIT_EXTENT | ||
ITEM_HIER_INDX_NEXT_EXTENT | NUMBER | ITEM_HIER_INDX_NEXT_EXTENT | ||
ITEM_HIER_INDX_PCT_INCREASE | NUMBER | ITEM_HIER_INDX_PCT_INCREASE | ||
RES_HIER_INIT_EXTENT | NUMBER | RES_HIER_INIT_EXTENT | ||
RES_HIER_NEXT_EXTENT | NUMBER | RES_HIER_NEXT_EXTENT | ||
RES_HIER_INDX_INIT_EXTENT | NUMBER | RES_HIER_INDX_INIT_EXTENT | ||
RES_HIER_INDX_NEXT_EXTENT | NUMBER | RES_HIER_INDX_NEXT_EXTENT | ||
RES_HIER_PCT_INCREASE | NUMBER | RES_HIER_PCT_INCREASE | ||
RES_HIER_INDX_PCT_INCREASE | NUMBER | RES_HIER_INDX_PCT_INCREASE |
Cut, paste (and edit) the following text to query this object:
SELECT PRE_ALLOC_HASH_SIZE
, PRE_ALLOC_SORT_SIZE
, PRE_ALLOC_PARALLEL_DEGREE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, LAST_UPDATE_LOGIN
, ITEM_HIER_INIT_EXTENT
, ITEM_HIER_NEXT_EXTENT
, ITEM_HIER_PCT_INCREASE
, ITEM_HIER_INDX_INIT_EXTENT
, ITEM_HIER_INDX_NEXT_EXTENT
, ITEM_HIER_INDX_PCT_INCREASE
, RES_HIER_INIT_EXTENT
, RES_HIER_NEXT_EXTENT
, RES_HIER_INDX_INIT_EXTENT
, RES_HIER_INDX_NEXT_EXTENT
, RES_HIER_PCT_INCREASE
, RES_HIER_INDX_PCT_INCREASE
FROM MSC.MSC_ATP_PARAMETERS;
MSC.MSC_ATP_PARAMETERS does not reference any database object
MSC.MSC_ATP_PARAMETERS is referenced by following:
|
|
|