[Home] [Help] [Dependency Information]
Object Name: | AD_PARALLEL_UPDATES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | AD.AD_PARALLEL_UPDATES |
Subobject Name: | |
Status: | VALID |
One row per parallel script
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_PARALLEL_UPDATES_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | UPDATE_ID |
AD_PARALLEL_UPDATES_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
OWNER
TABLE_NAME SCRIPT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UPDATE_ID | NUMBER | Yes | Sequence-generated ID for this update | |
UPDATE_TYPE | NUMBER | Yes | Type of parallel update | |
OWNER | VARCHAR2 | (30) | Yes | Schema that owns the table to be updated |
TABLE_NAME | VARCHAR2 | (30) | Yes | Name of the table to be processed |
SCRIPT_NAME | VARCHAR2 | (30) | Yes | Name of the script that is performing the update |
OBJECT_ID | NUMBER | Yes | Object ID for the table, from sys.obj$ | |
DB_BLOCK_SIZE | NUMBER | Yes | Database block size in bytes | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
ID_COLUMN | VARCHAR2 | (30) | Name of the column holding unique IDs | |
AVG_ROW_LEN | NUMBER | Average length of a row in the table | ||
NUM_WORKERS | NUMBER | Number of workers used for updates. | ||
INITIALIZED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether table has been initialized. |
Cut, paste (and edit) the following text to query this object:
SELECT UPDATE_ID
, UPDATE_TYPE
, OWNER
, TABLE_NAME
, SCRIPT_NAME
, OBJECT_ID
, DB_BLOCK_SIZE
, CREATION_DATE
, ID_COLUMN
, AVG_ROW_LEN
, NUM_WORKERS
, INITIALIZED_FLAG
FROM APPLSYS.AD_PARALLEL_UPDATES;
APPLSYS.AD_PARALLEL_UPDATES does not reference any database object
APPLSYS.AD_PARALLEL_UPDATES is referenced by following:
|
|
|