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: FTE_BATCH_JOBS_V

Product:	FTE - Transportation Execution
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT JOB_ID
, FTE_XML_TRANS_UTIL.GETMESSAGE(CREATED_BY
, JOB_STATUS_CODE)
, SUPPLIER_ID
, TO_CHAR(COMPLETION_DATE
, 'YYYY-MM-DD HH24:MI:SS')
, SHIPPER_REFERENCE_NUMBER
, SOURCE_CODE
, TRANSACTION_SEQUENCE
FROM FTE_BATCH_JOBS

Columns

Name
JOB_ID
JOB_STATUS_CODE
SUPPLIER_ID
JOB_PROCESSED_DATE
SHIPPER_REFERENCE_NUMBER
SOURCE_CODE
TRANSACTION_SEQUENCE