eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: INV.MTL_INTERFACE_PROC_CONTROLS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

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

Query Text

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;

Dependencies

[top of page]

INV.MTL_INTERFACE_PROC_CONTROLS does not reference any database object

INV.MTL_INTERFACE_PROC_CONTROLS is referenced by following:

APPS: MTL_INTERFACE_PROC_CONTROLS