[Home] [Help] [Dependency Information]
Object Name: | MTL_INTERFACE_PROC_CONTROLS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_INTERFACE_PROC_CONTROLS |
Subobject Name: | |
Status: | VALID |
MTL_INTERFACE_PROC_CONTROLS is seeded with the list of
background transaction processes Oracle Manufacturing supports. These
background processes can have user- determined process intervals and
for some you may decide the number of transaction rows
each worker processes at a time. The PROCESS_STATUS column tells if
the corresponding background process is active.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_CODE | NUMBER | Yes | Code name for the background process | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
PROCESS_STATUS | NUMBER | Yes | Process status which specifies if the background process is active or inactive | |
PROCESS_INTERVAL | NUMBER | Yes | Process interval at which the background process polls the interface table | |
MANAGER_PRIORITY | NUMBER | Yes | Concurrent process priority for the manager of the background process (not currently used) | |
WORKER_PRIORITY | NUMBER | Yes | Concurrent process priority for the workers launched by the background process (not currently used) | |
WORKER_ROWS | NUMBER | Yes | Maximum number of rows assigned to a worker | |
PROCESSING_TIMEOUT | NUMBER | Interval of time after which errored out rows will be processed again by the background process. This is used only by WIP managers. | ||
PROCESS_NAME | VARCHAR2 | (10) | Yes | Background process name |
PROCESS_APP_SHORT_NAME | VARCHAR2 | (3) | Application short name of the background process |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROCESS_STATUS
, PROCESS_INTERVAL
, MANAGER_PRIORITY
, WORKER_PRIORITY
, WORKER_ROWS
, PROCESSING_TIMEOUT
, PROCESS_NAME
, PROCESS_APP_SHORT_NAME
FROM INV.MTL_INTERFACE_PROC_CONTROLS;
INV.MTL_INTERFACE_PROC_CONTROLS does not reference any database object
INV.MTL_INTERFACE_PROC_CONTROLS is referenced by following:
|
|
|