[Home] [Help]
View: XDP_ADAPTER_ADMIN_REQS_V
View Text
SELECT XAA.REQUEST_ID
, XAA.CHANNEL_NAME
, (SELECT MEANING
FROM XDP_ADAPTER_TYPE_REQ_TYPES_V
WHERE LOOKUP_CODE = XAA.REQUEST_TYPE
AND ADAPTER_TYPE = XAR.ADAPTER_TYPE) REQUEST_TYPE
, XAA.REQUEST_DATE
, XAA.REQUESTED_BY_USER
, XAA.REQUEST_FREQUENCY
, XAA.JOB_ID
, DJ.THIS_DATE
, DJ.NEXT_DATE
, DJ.LAST_DATE
, DJ.FAILURES
, DJ.WHAT
FROM XDP_ADAPTER_ADMIN_REQS XAA
, DBA_JOBS DJ
, XDP_ADAPTER_REG XAR
WHERE XAA.JOB_ID = DJ.JOB
AND XAR.CHANNEL_NAME = XAA.CHANNEL_NAME
Columns
Name |
REQUEST_ID |
CHANNEL_NAME |
REQUEST_TYPE |
REQUEST_DATE |
REQUESTED_BY_USER |
REQUEST_FREQUENCY |
JOB_ID |
THIS_DATE |
NEXT_DATE |
LAST_DATE |
FAILURES |
WHAT |