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

Source

View Text - Preformatted


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

View Text - HTML Formatted

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