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_INV_API_TRX_LINES_T#

Source

View Text - Preformatted


select TRX_LINE_ID TRX_LINE_ID, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTRIBUTE4 INDUSTRY_ATTRIBUTE4, INDUSTRY_ATTRIBUTE5 INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7 INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8 INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9 INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10 INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11 INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE14 INDUSTRY_ATTRIBUTE14, INDUSTRY_ATTRIBUTE15 INDUSTRY_ATTRIBUTE15, INDUSTRY_ATTRIBUTE16 INDUSTRY_ATTRIBUTE16, INDUSTRY_ATTRIBUTE17 INDUSTRY_ATTRIBUTE17, INDUSTRY_ATTRIBUTE18 INDUSTRY_ATTRIBUTE18, INDUSTRY_ATTRIBUTE19 INDUSTRY_ATTRIBUTE19, INDUSTRY_ATTRIBUTE20 INDUSTRY_ATTRIBUTE20, INDUSTRY_ATTRIBUTE21 INDUSTRY_ATTRIBUTE21, INDUSTRY_ATTRIBUTE22 INDUSTRY_ATTRIBUTE22, INDUSTRY_ATTRIBUTE23 INDUSTRY_ATTRIBUTE23, INDUSTRY_ATTRIBUTE24 INDUSTRY_ATTRIBUTE24, INDUSTRY_ATTRIBUTE25 INDUSTRY_ATTRIBUTE25, INDUSTRY_ATTRIBUTE26 INDUSTRY_ATTRIBUTE26, INDUSTRY_ATTRIBUTE27 INDUSTRY_ATTRIBUTE27, INDUSTRY_ATTRIBUTE28 INDUSTRY_ATTRIBUTE28, INDUSTRY_ATTRIBUTE29 INDUSTRY_ATTRIBUTE29, INDUSTRY_ATTRIBUTE30 INDUSTRY_ATTRIBUTE30, 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, TRX_HEADER_ID TRX_HEADER_ID, SRV_EXEC_DATE SRV_EXEC_DATE from "JL"."JL_BR_INV_API_TRX_LINES_T"

View Text - HTML Formatted

SELECT TRX_LINE_ID TRX_LINE_ID
, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4 INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5 INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7 INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8 INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9 INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10 INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11 INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14 INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15 INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16 INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17 INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18 INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19 INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20 INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21 INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22 INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23 INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24 INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25 INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26 INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27 INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28 INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29 INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30 INDUSTRY_ATTRIBUTE30
, 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
, TRX_HEADER_ID TRX_HEADER_ID
, SRV_EXEC_DATE SRV_EXEC_DATE
FROM "JL"."JL_BR_INV_API_TRX_LINES_T"