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

TABLE: AP.AP_CHECKRUN_CONC_PROCESSES_ALL

Object Details
Object Name: AP_CHECKRUN_CONC_PROCESSES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_CHECKRUN_CONC_PROCESSES_ALL
Subobject Name:
Status: VALID


AP_CHECKRUN_CONC_PROCESSES_ALL is a temporary table that contains
records for payment batches with concurrent
requests in process. Your Oracle Payables
application creates a row in the table for a payment batch
when it submits the concurrent request for the batch.
.
When you select a payment batch to modify,
format, confirm, cancel, or restart, the
system checks if there is a record in the table for
the batch. If a record exists, the system checks the status
of the concurrent request. If the status of the request is
Pending, Running, or Inactive (indicating that the
request may start running at some later time), the system does not
allow you to perform any action on the payment batch. If
the concurrent request is completed, the system allows you to
proceed and deletes the existing record for the payment batch.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CHECKRUN_NAME VARCHAR2 (255) Yes Name of payment batch
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).
PROGRAM VARCHAR2 (30) Yes Name of program or report in process or pending
ORG_ID NUMBER (15)
Organization identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHECKRUN_NAME
,      REQUEST_ID
,      PROGRAM
,      ORG_ID
FROM AP.AP_CHECKRUN_CONC_PROCESSES_ALL;

Dependencies

[top of page]

AP.AP_CHECKRUN_CONC_PROCESSES_ALL does not reference any database object

AP.AP_CHECKRUN_CONC_PROCESSES_ALL is referenced by following:

SchemaAPPS
SynonymAP_CHECKRUN_CONC_PROCESSES
SynonymAP_CHECKRUN_CONC_PROCESSES_ALL