[Home] [Help] [Dependency Information]
Object Name: | AR_CONC_PROCESS_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CONC_PROCESS_REQUESTS |
Subobject Name: | |
Status: | VALID |
The AR_CONC_PROCESS_REQUESTS table contains a list of Oracle Receivables AutoInvoice and Customer Merge concurrent requests that are or should be currently running. Because the AutoInvoice and Customer Merge programs can run multiple instances at the same time, the information in this table tells these programs which requests are current. For example, AutoInvoice might encounter an error or terminate abnormally. The corresponding row is marked with the request that is not current. A new run of AutoInvoice will mark that row again.
.
The primary key for this table is REQUEST_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CONC_PROCESS_REQUESTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONCURRENT_PROGRAM_NAME | VARCHAR2 | (30) | Yes | Name of concurrent process |
REQUEST_ID | NUMBER | (15) | Yes | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT CONCURRENT_PROGRAM_NAME
, REQUEST_ID
FROM AR.AR_CONC_PROCESS_REQUESTS;
AR.AR_CONC_PROCESS_REQUESTS does not reference any database object
AR.AR_CONC_PROCESS_REQUESTS is referenced by following:
|
|
|