eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.XDP_ADAPTER_ADMIN_REQS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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