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: ICX.ICX_POR_BATCH_JOBS#

Object Details

Object Name:	ICX_POR_BATCH_JOBS#
Object Type:	VIEW
Owner:	ICX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
JOB_NUMBER	NUMBER		Yes
SUPPLIER_ID	NUMBER		Yes
SUPPLIER_FILE_NAME	VARCHAR2	(500)
EXCHANGE_FILE_NAME	VARCHAR2	(500)
ITEMS_LOADED	NUMBER		Yes
ITEMS_FAILED	NUMBER		Yes
JOB_STATUS	VARCHAR2	(240)	Yes
SUBMISSION_DATETIME	DATE		Yes
START_DATETIME	DATE
COMPLETION_DATETIME	DATE
FAILURE_MESSAGE	VARCHAR2	(4000)
HOST_IP_ADDRESS	VARCHAR2	(15)
EXCHANGE_OPERATOR_NAME	VARCHAR2	(255)
JOB_TYPE	VARCHAR2	(40)
SYSTEM_FAILURE_MESSAGE	VARCHAR2	(4000)
LANGUAGE	VARCHAR2	(4)
PRICES_LOADED	NUMBER
PRICES_FAILED	NUMBER
EXCHANGE_OPERATOR_ID	NUMBER
MAX_FAILED_LINES	NUMBER
LOAD_SUPPLIER_ID	NUMBER
HEADERS_LOADED	NUMBER
HEADERS_FAILED	NUMBER
TIMEZONE	VARCHAR2	(30)
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
REQUEST_ID	NUMBER
DESCRIPTION	VARCHAR2	(4000)
LAST_UPDATE_LOGIN	NUMBER

Query Text

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


SELECT JOB_NUMBER
,      SUPPLIER_ID
,      SUPPLIER_FILE_NAME
,      EXCHANGE_FILE_NAME
,      ITEMS_LOADED
,      ITEMS_FAILED
,      JOB_STATUS
,      SUBMISSION_DATETIME
,      START_DATETIME
,      COMPLETION_DATETIME
,      FAILURE_MESSAGE
,      HOST_IP_ADDRESS
,      EXCHANGE_OPERATOR_NAME
,      JOB_TYPE
,      SYSTEM_FAILURE_MESSAGE
,      LANGUAGE
,      PRICES_LOADED
,      PRICES_FAILED
,      EXCHANGE_OPERATOR_ID
,      MAX_FAILED_LINES
,      LOAD_SUPPLIER_ID
,      HEADERS_LOADED
,      HEADERS_FAILED
,      TIMEZONE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      DESCRIPTION
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_BATCH_JOBS#;

Dependencies

[top of page]

ICX.ICX_POR_BATCH_JOBS# references the following:

ICX: ICX_POR_BATCH_JOBS

ICX.ICX_POR_BATCH_JOBS# is referenced by following:

APPS: ICX_POR_BATCH_JOBS