[Home] [Help] [Dependency Information]
Object Name: | XDP_ADAPTER_ADMIN_REQS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XDP.XDP_ADAPTER_ADMIN_REQS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
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 | (80) | Type of the request, i.e., suspend/resume, shutdown/startup, disconnect/connect. | |
REQUEST_DATE | DATE | Yes | Date/Time this request is scheduled to be processed | |
REQUESTED_BY_USER | VARCHAR2 | (40) | Stores the user incl. SYSTEM (internal) who submitted the job. Internal jobs cannot be modified by users | |
REQUEST_FREQUENCY | NUMBER | How often this request will be processed | ||
JOB_ID | NUMBER | Yes | Job ID of the Adapter administration request | |
THIS_DATE | DATE | Date this job started executing (from dba_jobs) | ||
NEXT_DATE | DATE | Yes | Date this job will next be executed (from dba_jobs) | |
LAST_DATE | DATE | Date that this job last successfully executed (from dba_jobs) | ||
FAILURES | NUMBER | How many times has this job started and failed since its last success (from dba_jobs) | ||
WHAT | VARCHAR2 | (4000) | Body of the anonymous PL/SQL block that the dba job executes. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, CHANNEL_NAME
, REQUEST_TYPE
, REQUEST_DATE
, REQUESTED_BY_USER
, REQUEST_FREQUENCY
, JOB_ID
, THIS_DATE
, NEXT_DATE
, LAST_DATE
, FAILURES
, WHAT
FROM APPS.XDP_ADAPTER_ADMIN_REQS_V;
APPS.XDP_ADAPTER_ADMIN_REQS_V is not referenced by any database object
|
|
|