[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 |