[Home] [Help] [Dependency Information]
Object Name: | XDP_ADAPTER_ADMIN_REQS |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_ADAPTER_ADMIN_REQS |
Subobject Name: | |
Status: | VALID |
XDP_ADAPTER_ADMIN_REQS is used to define maintenance requests for an adapter. The allowable requests are STARTUP, SHUTDOWN, SUSPEND, RESUME, DISCONNECT and CONNECT. You can also schedule periodical maintenance requests by specifying the request frequency.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_ADAPTER_ADMIN_REQS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | A unique id for this request | |
CHANNEL_NAME | VARCHAR2 | (40) | Yes | Adapter instance for which the request is submitted |
REQUEST_TYPE | VARCHAR2 | (40) | Yes | Type of the request, i.e., suspend/resume, shutdown/startup, disconnect/connect. |
FE_ID | NUMBER | Not Used | ||
REQUEST_STATUS | VARCHAR2 | (40) | Not Used | |
REQUEST_DATE | DATE | Yes | Date/Time this request is scheduled to be processed | |
REQUEST_TIMEZONE | VARCHAR2 | (3) | Not Used | |
REQUEST_PRIORITY | NUMBER | Not Used | ||
REQUESTED_BY_USER | VARCHAR2 | (40) | Stores the user incl. SYSTEM (internal) who submitted the job. Internal jobs cannot be modified by users | |
REQUEST_PROCESSED_DATE | DATE | Not Used | ||
REQUEST_FREQUENCY | NUMBER | How often this request will be processed | ||
ERROR_REF_ID | NUMBER | Not Used | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
JOB_ID | NUMBER | Yes | Job ID of the Adapter administration request |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, CHANNEL_NAME
, REQUEST_TYPE
, FE_ID
, REQUEST_STATUS
, REQUEST_DATE
, REQUEST_TIMEZONE
, REQUEST_PRIORITY
, REQUESTED_BY_USER
, REQUEST_PROCESSED_DATE
, REQUEST_FREQUENCY
, ERROR_REF_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, JOB_ID
FROM XDP.XDP_ADAPTER_ADMIN_REQS;
XDP.XDP_ADAPTER_ADMIN_REQS does not reference any database object
XDP.XDP_ADAPTER_ADMIN_REQS is referenced by following:
|
|
|