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: JL.JL_BR_CUSTOMER_TRX_EXTS#

Source

View Text - Preformatted


select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, LEGAL_PROCESS_CODE LEGAL_PROCESS_CODE, LEGAL_PROCESS_SOURCE_IND LEGAL_PROCESS_SOURCE_IND, VEHICLE_PLATE_STATE_CODE VEHICLE_PLATE_STATE_CODE, VEHICLE_ANTT_INSCRIPTION VEHICLE_ANTT_INSCRIPTION, TOWING_VEH_PLATE_NUMBER TOWING_VEH_PLATE_NUMBER, TOWING_VEH_PLATE_STATE_CODE TOWING_VEH_PLATE_STATE_CODE, TOWING_VEH_ANTT_INSCRIPTION TOWING_VEH_ANTT_INSCRIPTION, SEAL_NUMBER SEAL_NUMBER, ELECTRONIC_INV_WEB_ADDRESS ELECTRONIC_INV_WEB_ADDRESS, ELECTRONIC_INV_STATUS ELECTRONIC_INV_STATUS, ELECTRONIC_INV_ACCESS_KEY ELECTRONIC_INV_ACCESS_KEY, ELECTRONIC_INV_PROTOCOL#1 ELECTRONIC_INV_PROTOCOL, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, WAGON_CODE WAGON_CODE, FERRY_CODE FERRY_CODE, ELECTRONIC_INV_ACCESS_KEY_ID ELECTRONIC_INV_ACCESS_KEY_ID, TOWING_VEH_PLATE_NUMBER2 TOWING_VEH_PLATE_NUMBER2, TOWING_VEH_PLATE_STATE_CODE2 TOWING_VEH_PLATE_STATE_CODE2, TOWING_VEH_PLATE_NUMBER3 TOWING_VEH_PLATE_NUMBER3, TOWING_VEH_PLATE_STATE_CODE3 TOWING_VEH_PLATE_STATE_CODE3, TOWING_VEH_PLATE_NUMBER4 TOWING_VEH_PLATE_NUMBER4, TOWING_VEH_PLATE_STATE_CODE4 TOWING_VEH_PLATE_STATE_CODE4, TOWING_VEH_PLATE_NUMBER5 TOWING_VEH_PLATE_NUMBER5, TOWING_VEH_PLATE_STATE_CODE5 TOWING_VEH_PLATE_STATE_CODE5, SRV_EXEC_DATE SRV_EXEC_DATE from "JL"."JL_BR_CUSTOMER_TRX_EXTS"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, LEGAL_PROCESS_CODE LEGAL_PROCESS_CODE
, LEGAL_PROCESS_SOURCE_IND LEGAL_PROCESS_SOURCE_IND
, VEHICLE_PLATE_STATE_CODE VEHICLE_PLATE_STATE_CODE
, VEHICLE_ANTT_INSCRIPTION VEHICLE_ANTT_INSCRIPTION
, TOWING_VEH_PLATE_NUMBER TOWING_VEH_PLATE_NUMBER
, TOWING_VEH_PLATE_STATE_CODE TOWING_VEH_PLATE_STATE_CODE
, TOWING_VEH_ANTT_INSCRIPTION TOWING_VEH_ANTT_INSCRIPTION
, SEAL_NUMBER SEAL_NUMBER
, ELECTRONIC_INV_WEB_ADDRESS ELECTRONIC_INV_WEB_ADDRESS
, ELECTRONIC_INV_STATUS ELECTRONIC_INV_STATUS
, ELECTRONIC_INV_ACCESS_KEY ELECTRONIC_INV_ACCESS_KEY
, ELECTRONIC_INV_PROTOCOL#1 ELECTRONIC_INV_PROTOCOL
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, WAGON_CODE WAGON_CODE
, FERRY_CODE FERRY_CODE
, ELECTRONIC_INV_ACCESS_KEY_ID ELECTRONIC_INV_ACCESS_KEY_ID
, TOWING_VEH_PLATE_NUMBER2 TOWING_VEH_PLATE_NUMBER2
, TOWING_VEH_PLATE_STATE_CODE2 TOWING_VEH_PLATE_STATE_CODE2
, TOWING_VEH_PLATE_NUMBER3 TOWING_VEH_PLATE_NUMBER3
, TOWING_VEH_PLATE_STATE_CODE3 TOWING_VEH_PLATE_STATE_CODE3
, TOWING_VEH_PLATE_NUMBER4 TOWING_VEH_PLATE_NUMBER4
, TOWING_VEH_PLATE_STATE_CODE4 TOWING_VEH_PLATE_STATE_CODE4
, TOWING_VEH_PLATE_NUMBER5 TOWING_VEH_PLATE_NUMBER5
, TOWING_VEH_PLATE_STATE_CODE5 TOWING_VEH_PLATE_STATE_CODE5
, SRV_EXEC_DATE SRV_EXEC_DATE
FROM "JL"."JL_BR_CUSTOMER_TRX_EXTS"