[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_BATCH_JOBS# |
---|---|
Object Type: | VIEW |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|