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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: IEX.IEX_XML_REQUEST_HISTORIES#

Object Details

Object Name:	IEX_XML_REQUEST_HISTORIES#
Object Type:	VIEW
Owner:	IEX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
XML_REQUEST_ID	NUMBER	(10)	Yes
QUERY_TEMP_ID	NUMBER	(10)	Yes
STATUS	VARCHAR2	(40)	Yes
DOCUMENT	BLOB	(4000)
XMLDATA	CLOB	(4000)
METHOD	VARCHAR2	(10)
DESTINATION	VARCHAR2	(2000)
OBJECT_TYPE	VARCHAR2	(100)
OBJECT_ID	NUMBER	(15)
VIEW_BY	VARCHAR2	(20)
RESOURCE_ID	NUMBER
PARTY_ID	NUMBER	(15)
CUST_ACCOUNT_ID	NUMBER	(15)
CUST_SITE_USE_ID	NUMBER	(15)
DELINQUENCY_ID	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
HTML_DOCUMENT	BLOB	(4000)
SUBJECT	VARCHAR2	(4000)
REQUEST_ID	NUMBER
WORKER_ID	NUMBER
CONFIRMATION_MODE	VARCHAR2	(10)
CONC_REQUEST_ID	NUMBER
LANGUAGE	VARCHAR2	(10)
TERRITORY	VARCHAR2	(10)
PRINTER_URI	VARCHAR2	(240)
JOB_ID	NUMBER
SJOB_ID	VARCHAR2	(240)
JOB_URI	VARCHAR2	(240)
FAILURE_REASON	VARCHAR2	(240)
ORG_ID	NUMBER
DOCUMENT_TYPE	VARCHAR2	(240)
ADDT_QUERY_TEMP_ID	NUMBER
ADDT_XMLDATA	CLOB	(4000)
ADDT_STATUS	VARCHAR2	(75)
ADDT_HTML_DOCUMENT	BLOB	(4000)
ADDT_DOCUMENT	BLOB	(4000)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT XML_REQUEST_ID
,      QUERY_TEMP_ID
,      STATUS
,      DOCUMENT
,      XMLDATA
,      METHOD
,      DESTINATION
,      OBJECT_TYPE
,      OBJECT_ID
,      VIEW_BY
,      RESOURCE_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      CUST_SITE_USE_ID
,      DELINQUENCY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      HTML_DOCUMENT
,      SUBJECT
,      REQUEST_ID
,      WORKER_ID
,      CONFIRMATION_MODE
,      CONC_REQUEST_ID
,      LANGUAGE
,      TERRITORY
,      PRINTER_URI
,      JOB_ID
,      SJOB_ID
,      JOB_URI
,      FAILURE_REASON
,      ORG_ID
,      DOCUMENT_TYPE
,      ADDT_QUERY_TEMP_ID
,      ADDT_XMLDATA
,      ADDT_STATUS
,      ADDT_HTML_DOCUMENT
,      ADDT_DOCUMENT
FROM IEX.IEX_XML_REQUEST_HISTORIES#;

Dependencies

[top of page]

IEX.IEX_XML_REQUEST_HISTORIES# references the following:

IEX: IEX_XML_REQUEST_HISTORIES

IEX.IEX_XML_REQUEST_HISTORIES# is referenced by following:

APPS: IEX_XML_REQUEST_HISTORIES