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.

[Home] [Help]

View: XDP_ADAPTER_ADMIN_REQS_V

Product:	XDP - Provisioning
Description:	Adapter specific pending jobs
Implementation/DBA Data:	APPS.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