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: GML.GML_GASNO_ORDERS#

Source

View Text - Preformatted


select RUN_ID RUN_ID, ORDER_ID ORDER_ID, ORDER_STATUS ORDER_STATUS, CUSTPO_NO CUSTPO_NO, ORDER_NO ORDER_NO, SO_ORGN_CODE SO_ORGN_CODE, ORDER_COMMENT ORDER_COMMENT, SO_DATE SO_DATE, SO_HEADER_CATEGORY SO_HEADER_CATEGORY, SO_HEADER_ATTRIBUTE1 SO_HEADER_ATTRIBUTE1, SO_HEADER_ATTRIBUTE2 SO_HEADER_ATTRIBUTE2, SO_HEADER_ATTRIBUTE3 SO_HEADER_ATTRIBUTE3, SO_HEADER_ATTRIBUTE4 SO_HEADER_ATTRIBUTE4, SO_HEADER_ATTRIBUTE5 SO_HEADER_ATTRIBUTE5, SO_HEADER_ATTRIBUTE6 SO_HEADER_ATTRIBUTE6, SO_HEADER_ATTRIBUTE7 SO_HEADER_ATTRIBUTE7, SO_HEADER_ATTRIBUTE8 SO_HEADER_ATTRIBUTE8, SO_HEADER_ATTRIBUTE9 SO_HEADER_ATTRIBUTE9, SO_HEADER_ATTRIBUTE10 SO_HEADER_ATTRIBUTE10, SO_HEADER_ATTRIBUTE11 SO_HEADER_ATTRIBUTE11, SO_HEADER_ATTRIBUTE12 SO_HEADER_ATTRIBUTE12, SO_HEADER_ATTRIBUTE13 SO_HEADER_ATTRIBUTE13, SO_HEADER_ATTRIBUTE14 SO_HEADER_ATTRIBUTE14, SO_HEADER_ATTRIBUTE15 SO_HEADER_ATTRIBUTE15, SO_HEADER_ATTRIBUTE16 SO_HEADER_ATTRIBUTE16, SO_HEADER_ATTRIBUTE17 SO_HEADER_ATTRIBUTE17, SO_HEADER_ATTRIBUTE18 SO_HEADER_ATTRIBUTE18, SO_HEADER_ATTRIBUTE19 SO_HEADER_ATTRIBUTE19, SO_HEADER_ATTRIBUTE20 SO_HEADER_ATTRIBUTE20, SO_HEADER_ATTRIBUTE21 SO_HEADER_ATTRIBUTE21, SO_HEADER_ATTRIBUTE22 SO_HEADER_ATTRIBUTE22, SO_HEADER_ATTRIBUTE23 SO_HEADER_ATTRIBUTE23, SO_HEADER_ATTRIBUTE24 SO_HEADER_ATTRIBUTE24, SO_HEADER_ATTRIBUTE25 SO_HEADER_ATTRIBUTE25, SO_HEADER_ATTRIBUTE26 SO_HEADER_ATTRIBUTE26, SO_HEADER_ATTRIBUTE27 SO_HEADER_ATTRIBUTE27, SO_HEADER_ATTRIBUTE28 SO_HEADER_ATTRIBUTE28, SO_HEADER_ATTRIBUTE29 SO_HEADER_ATTRIBUTE29, SO_HEADER_ATTRIBUTE30 SO_HEADER_ATTRIBUTE30, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORDER_STATUS_CODE ORDER_STATUS_CODE from "GML"."GML_GASNO_ORDERS"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, ORDER_ID ORDER_ID
, ORDER_STATUS ORDER_STATUS
, CUSTPO_NO CUSTPO_NO
, ORDER_NO ORDER_NO
, SO_ORGN_CODE SO_ORGN_CODE
, ORDER_COMMENT ORDER_COMMENT
, SO_DATE SO_DATE
, SO_HEADER_CATEGORY SO_HEADER_CATEGORY
, SO_HEADER_ATTRIBUTE1 SO_HEADER_ATTRIBUTE1
, SO_HEADER_ATTRIBUTE2 SO_HEADER_ATTRIBUTE2
, SO_HEADER_ATTRIBUTE3 SO_HEADER_ATTRIBUTE3
, SO_HEADER_ATTRIBUTE4 SO_HEADER_ATTRIBUTE4
, SO_HEADER_ATTRIBUTE5 SO_HEADER_ATTRIBUTE5
, SO_HEADER_ATTRIBUTE6 SO_HEADER_ATTRIBUTE6
, SO_HEADER_ATTRIBUTE7 SO_HEADER_ATTRIBUTE7
, SO_HEADER_ATTRIBUTE8 SO_HEADER_ATTRIBUTE8
, SO_HEADER_ATTRIBUTE9 SO_HEADER_ATTRIBUTE9
, SO_HEADER_ATTRIBUTE10 SO_HEADER_ATTRIBUTE10
, SO_HEADER_ATTRIBUTE11 SO_HEADER_ATTRIBUTE11
, SO_HEADER_ATTRIBUTE12 SO_HEADER_ATTRIBUTE12
, SO_HEADER_ATTRIBUTE13 SO_HEADER_ATTRIBUTE13
, SO_HEADER_ATTRIBUTE14 SO_HEADER_ATTRIBUTE14
, SO_HEADER_ATTRIBUTE15 SO_HEADER_ATTRIBUTE15
, SO_HEADER_ATTRIBUTE16 SO_HEADER_ATTRIBUTE16
, SO_HEADER_ATTRIBUTE17 SO_HEADER_ATTRIBUTE17
, SO_HEADER_ATTRIBUTE18 SO_HEADER_ATTRIBUTE18
, SO_HEADER_ATTRIBUTE19 SO_HEADER_ATTRIBUTE19
, SO_HEADER_ATTRIBUTE20 SO_HEADER_ATTRIBUTE20
, SO_HEADER_ATTRIBUTE21 SO_HEADER_ATTRIBUTE21
, SO_HEADER_ATTRIBUTE22 SO_HEADER_ATTRIBUTE22
, SO_HEADER_ATTRIBUTE23 SO_HEADER_ATTRIBUTE23
, SO_HEADER_ATTRIBUTE24 SO_HEADER_ATTRIBUTE24
, SO_HEADER_ATTRIBUTE25 SO_HEADER_ATTRIBUTE25
, SO_HEADER_ATTRIBUTE26 SO_HEADER_ATTRIBUTE26
, SO_HEADER_ATTRIBUTE27 SO_HEADER_ATTRIBUTE27
, SO_HEADER_ATTRIBUTE28 SO_HEADER_ATTRIBUTE28
, SO_HEADER_ATTRIBUTE29 SO_HEADER_ATTRIBUTE29
, SO_HEADER_ATTRIBUTE30 SO_HEADER_ATTRIBUTE30
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORDER_STATUS_CODE ORDER_STATUS_CODE
FROM "GML"."GML_GASNO_ORDERS"