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

Source

View Text - Preformatted


select RUN_ID RUN_ID, ORDER_ID ORDER_ID, LINE_ID LINE_ID, LINE_STATUS LINE_STATUS, SHIP_STATUS SHIP_STATUS, SO_LINE_NO SO_LINE_NO, TRANS_CNT TRANS_CNT, ACTUAL_SHIPDATE ACTUAL_SHIPDATE, REQUESTED_SHIPDATE REQUESTED_SHIPDATE, PROMISED_SHIPDATE PROMISED_SHIPDATE, SCHED_SHIPDATE SCHED_SHIPDATE, ACTUAL_DLVDATE ACTUAL_DLVDATE, REQUIRED_DLVDATE REQUIRED_DLVDATE, HOLD_EXPIRATION HOLD_EXPIRATION, EXPORT_DATE EXPORT_DATE, LINE_COMMENT LINE_COMMENT, SO_DETAIL_CATEGORY SO_DETAIL_CATEGORY, SO_DETAIL_ATTRIBUTE1 SO_DETAIL_ATTRIBUTE1, SO_DETAIL_ATTRIBUTE2 SO_DETAIL_ATTRIBUTE2, SO_DETAIL_ATTRIBUTE3 SO_DETAIL_ATTRIBUTE3, SO_DETAIL_ATTRIBUTE4 SO_DETAIL_ATTRIBUTE4, SO_DETAIL_ATTRIBUTE5 SO_DETAIL_ATTRIBUTE5, SO_DETAIL_ATTRIBUTE6 SO_DETAIL_ATTRIBUTE6, SO_DETAIL_ATTRIBUTE7 SO_DETAIL_ATTRIBUTE7, SO_DETAIL_ATTRIBUTE8 SO_DETAIL_ATTRIBUTE8, SO_DETAIL_ATTRIBUTE9 SO_DETAIL_ATTRIBUTE9, SO_DETAIL_ATTRIBUTE10 SO_DETAIL_ATTRIBUTE10, SO_DETAIL_ATTRIBUTE11 SO_DETAIL_ATTRIBUTE11, SO_DETAIL_ATTRIBUTE12 SO_DETAIL_ATTRIBUTE12, SO_DETAIL_ATTRIBUTE13 SO_DETAIL_ATTRIBUTE13, SO_DETAIL_ATTRIBUTE14 SO_DETAIL_ATTRIBUTE14, SO_DETAIL_ATTRIBUTE15 SO_DETAIL_ATTRIBUTE15, SO_DETAIL_ATTRIBUTE16 SO_DETAIL_ATTRIBUTE16, SO_DETAIL_ATTRIBUTE17 SO_DETAIL_ATTRIBUTE17, SO_DETAIL_ATTRIBUTE18 SO_DETAIL_ATTRIBUTE18, SO_DETAIL_ATTRIBUTE19 SO_DETAIL_ATTRIBUTE19, SO_DETAIL_ATTRIBUTE20 SO_DETAIL_ATTRIBUTE20, SO_DETAIL_ATTRIBUTE21 SO_DETAIL_ATTRIBUTE21, SO_DETAIL_ATTRIBUTE22 SO_DETAIL_ATTRIBUTE22, SO_DETAIL_ATTRIBUTE23 SO_DETAIL_ATTRIBUTE23, SO_DETAIL_ATTRIBUTE24 SO_DETAIL_ATTRIBUTE24, SO_DETAIL_ATTRIBUTE25 SO_DETAIL_ATTRIBUTE25, SO_DETAIL_ATTRIBUTE26 SO_DETAIL_ATTRIBUTE26, SO_DETAIL_ATTRIBUTE27 SO_DETAIL_ATTRIBUTE27, SO_DETAIL_ATTRIBUTE28 SO_DETAIL_ATTRIBUTE28, SO_DETAIL_ATTRIBUTE29 SO_DETAIL_ATTRIBUTE29, SO_DETAIL_ATTRIBUTE30 SO_DETAIL_ATTRIBUTE30, SHIP_METHOD_INT SHIP_METHOD_INT, SHIP_METHOD_EXT1 SHIP_METHOD_EXT1, SHIP_METHOD_EXT2 SHIP_METHOD_EXT2, SHIP_METHOD_EXT3 SHIP_METHOD_EXT3, SHIP_METHOD_EXT4 SHIP_METHOD_EXT4, SHIP_METHOD_EXT5 SHIP_METHOD_EXT5, BASE_CURRENCY_INT BASE_CURRENCY_INT, BASE_CURRENCY_EXT1 BASE_CURRENCY_EXT1, BASE_CURRENCY_EXT2 BASE_CURRENCY_EXT2, BASE_CURRENCY_EXT3 BASE_CURRENCY_EXT3, BASE_CURRENCY_EXT4 BASE_CURRENCY_EXT4, BASE_CURRENCY_EXT5 BASE_CURRENCY_EXT5, BILLING_CURRENCY_INT BILLING_CURRENCY_INT, BILLING_CURRENCY_EXT1 BILLING_CURRENCY_EXT1, BILLING_CURRENCY_EXT2 BILLING_CURRENCY_EXT2, BILLING_CURRENCY_EXT3 BILLING_CURRENCY_EXT3, BILLING_CURRENCY_EXT4 BILLING_CURRENCY_EXT4, BILLING_CURRENCY_EXT5 BILLING_CURRENCY_EXT5, HOLDREAS_CODE_INT HOLDREAS_CODE_INT, HOLDREAS_CODE_EXT1 HOLDREAS_CODE_EXT1, HOLDREAS_CODE_EXT2 HOLDREAS_CODE_EXT2, HOLDREAS_CODE_EXT3 HOLDREAS_CODE_EXT3, HOLDREAS_CODE_EXT4 HOLDREAS_CODE_EXT4, HOLDREAS_CODE_EXT5 HOLDREAS_CODE_EXT5, EXCHANGE_RATE EXCHANGE_RATE, SHIPTO_CUST_ID SHIPTO_CUST_ID, SHIPTO_CODE_INT SHIPTO_CODE_INT, SHIPTO_CODE_EXT1 SHIPTO_CODE_EXT1, SHIPTO_CODE_EXT2 SHIPTO_CODE_EXT2, SHIPTO_CODE_EXT3 SHIPTO_CODE_EXT3, SHIPTO_CODE_EXT4 SHIPTO_CODE_EXT4, SHIPTO_CODE_EXT5 SHIPTO_CODE_EXT5, SHIPTO_CUST_NAME SHIPTO_CUST_NAME, SHIPTO_ADDR1 SHIPTO_ADDR1, SHIPTO_ADDR2 SHIPTO_ADDR2, SHIPTO_ADDR3 SHIPTO_ADDR3, SHIPTO_ADDR4 SHIPTO_ADDR4, SHIPTO_POSTAL_CODE SHIPTO_POSTAL_CODE, SHIPTO_COUNTRY_CODE_INT SHIPTO_COUNTRY_CODE_INT, SHIPTO_COUNTRY_CODE_EXT1 SHIPTO_COUNTRY_CODE_EXT1, SHIPTO_COUNTRY_CODE_EXT2 SHIPTO_COUNTRY_CODE_EXT2, SHIPTO_COUNTRY_CODE_EXT3 SHIPTO_COUNTRY_CODE_EXT3, SHIPTO_COUNTRY_CODE_EXT4 SHIPTO_COUNTRY_CODE_EXT4, SHIPTO_COUNTRY_CODE_EXT5 SHIPTO_COUNTRY_CODE_EXT5, SHIPTO_STATE_CODE_INT SHIPTO_STATE_CODE_INT, SHIPTO_STATE_CODE_EXT1 SHIPTO_STATE_CODE_EXT1, SHIPTO_STATE_CODE_EXT2 SHIPTO_STATE_CODE_EXT2, SHIPTO_STATE_CODE_EXT3 SHIPTO_STATE_CODE_EXT3, SHIPTO_STATE_CODE_EXT4 SHIPTO_STATE_CODE_EXT4, SHIPTO_STATE_CODE_EXT5 SHIPTO_STATE_CODE_EXT5, SHIPTO_PROVINCE_CODE_INT SHIPTO_PROVINCE_CODE_INT, SHIPTO_PROVINCE_CODE_EXT1 SHIPTO_PROVINCE_CODE_EXT1, SHIPTO_PROVINCE_CODE_EXT2 SHIPTO_PROVINCE_CODE_EXT2, SHIPTO_PROVINCE_CODE_EXT3 SHIPTO_PROVINCE_CODE_EXT3, SHIPTO_PROVINCE_CODE_EXT4 SHIPTO_PROVINCE_CODE_EXT4, SHIPTO_PROVINCE_CODE_EXT5 SHIPTO_PROVINCE_CODE_EXT5, SHIPTO_COUNTY SHIPTO_COUNTY, SHIPTO_LAST_NAME SHIPTO_LAST_NAME, SHIPTO_FIRST_NAME SHIPTO_FIRST_NAME, SHIPTO_JOB_TITLE SHIPTO_JOB_TITLE, SHIPTO_AREA_CODE SHIPTO_AREA_CODE, SHIPTO_TELEPHONE SHIPTO_TELEPHONE, NET_WT NET_WT, TARE_WT TARE_WT, PALLET_WT PALLET_WT, FRTBILL_WT FRTBILL_WT, SHIPWT_UM_INT SHIPWT_UM_INT, SHIPWT_UM_EXT1 SHIPWT_UM_EXT1, SHIPWT_UM_EXT2 SHIPWT_UM_EXT2, SHIPWT_UM_EXT3 SHIPWT_UM_EXT3, SHIPWT_UM_EXT4 SHIPWT_UM_EXT4, SHIPWT_UM_EXT5 SHIPWT_UM_EXT5, SHIP_VOLUME SHIP_VOLUME, SHIPVOLUME_UM_INT SHIPVOLUME_UM_INT, SHIPVOLUME_UM_EXT1 SHIPVOLUME_UM_EXT1, SHIPVOLUME_UM_EXT2 SHIPVOLUME_UM_EXT2, SHIPVOLUME_UM_EXT3 SHIPVOLUME_UM_EXT3, SHIPVOLUME_UM_EXT4 SHIPVOLUME_UM_EXT4, SHIPVOLUME_UM_EXT5 SHIPVOLUME_UM_EXT5, ORDR_QTY1 ORDR_QTY1, SHIP_QTY1 SHIP_QTY1, ORDER_UM1_INT ORDER_UM1_INT, ORDER_UM1_EXT1 ORDER_UM1_EXT1, ORDER_UM1_EXT2 ORDER_UM1_EXT2, ORDER_UM1_EXT3 ORDER_UM1_EXT3, ORDER_UM1_EXT4 ORDER_UM1_EXT4, ORDER_UM1_EXT5 ORDER_UM1_EXT5, ORDR_QTY2 ORDR_QTY2, SHIP_QTY2 SHIP_QTY2, ORDER_UM2_INT ORDER_UM2_INT, ORDER_UM2_EXT1 ORDER_UM2_EXT1, ORDER_UM2_EXT2 ORDER_UM2_EXT2, ORDER_UM2_EXT3 ORDER_UM2_EXT3, ORDER_UM2_EXT4 ORDER_UM2_EXT4, ORDER_UM2_EXT5 ORDER_UM2_EXT5, ITEM_NO ITEM_NO, ITEM_DESC1 ITEM_DESC1, GENERIC_ITEM GENERIC_ITEM, LINE_DESC LINE_DESC, TO_WHSE TO_WHSE, TO_WHSE_NAME TO_WHSE_NAME, PRICEREAS_CODE_INT PRICEREAS_CODE_INT, PRICEREAS_CODE_EXT1 PRICEREAS_CODE_EXT1, PRICEREAS_CODE_EXT2 PRICEREAS_CODE_EXT2, PRICEREAS_CODE_EXT3 PRICEREAS_CODE_EXT3, PRICEREAS_CODE_EXT4 PRICEREAS_CODE_EXT4, PRICEREAS_CODE_EXT5 PRICEREAS_CODE_EXT5, PRICEREAS_DESC PRICEREAS_DESC, BASE_PRICE BASE_PRICE, NET_PRICE NET_PRICE, EXTENDED_PRICE EXTENDED_PRICE, LIST_PRICE LIST_PRICE, SYSTEM_PRICE SYSTEM_PRICE, NET_TAX NET_TAX, BILL_QTY BILL_QTY, FROM_WHSE FROM_WHSE, FROM_WHSE_NAME FROM_WHSE_NAME, FROM_WHSE_CONTACT FROM_WHSE_CONTACT, FROM_WHSE_PHONE FROM_WHSE_PHONE, FROM_WHSE_ADDR1 FROM_WHSE_ADDR1, FROM_WHSE_ADDR2 FROM_WHSE_ADDR2, FROM_WHSE_ADDR3 FROM_WHSE_ADDR3, FROM_WHSE_ADDR4 FROM_WHSE_ADDR4, FROM_WHSE_POSTAL_CODE FROM_WHSE_POSTAL_CODE, FROM_WHSE_COUNTRY_CODE_INT FROM_WHSE_COUNTRY_CODE_INT, FROM_WHSE_COUNTRY_CODE_EXT1 FROM_WHSE_COUNTRY_CODE_EXT1, FROM_WHSE_COUNTRY_CODE_EXT2 FROM_WHSE_COUNTRY_CODE_EXT2, FROM_WHSE_COUNTRY_CODE_EXT3 FROM_WHSE_COUNTRY_CODE_EXT3, FROM_WHSE_COUNTRY_CODE_EXT4 FROM_WHSE_COUNTRY_CODE_EXT4, FROM_WHSE_COUNTRY_CODE_EXT5 FROM_WHSE_COUNTRY_CODE_EXT5, FROM_WHSE_STATE_CODE_INT FROM_WHSE_STATE_CODE_INT, FROM_WHSE_STATE_CODE_EXT1 FROM_WHSE_STATE_CODE_EXT1, FROM_WHSE_STATE_CODE_EXT2 FROM_WHSE_STATE_CODE_EXT2, FROM_WHSE_STATE_CODE_EXT3 FROM_WHSE_STATE_CODE_EXT3, FROM_WHSE_STATE_CODE_EXT4 FROM_WHSE_STATE_CODE_EXT4, FROM_WHSE_STATE_CODE_EXT5 FROM_WHSE_STATE_CODE_EXT5, FROM_WHSE_PROVINCE_CODE_INT FROM_WHSE_PROVINCE_CODE_INT, FROM_WHSE_PROVINCE_CODE_EXT1 FROM_WHSE_PROVINCE_CODE_EXT1, FROM_WHSE_PROVINCE_CODE_EXT2 FROM_WHSE_PROVINCE_CODE_EXT2, FROM_WHSE_PROVINCE_CODE_EXT3 FROM_WHSE_PROVINCE_CODE_EXT3, FROM_WHSE_PROVINCE_CODE_EXT4 FROM_WHSE_PROVINCE_CODE_EXT4, FROM_WHSE_PROVINCE_CODE_EXT5 FROM_WHSE_PROVINCE_CODE_EXT5, FROM_WHSE_COUNTY FROM_WHSE_COUNTY, 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, LINE_STATUS_CODE LINE_STATUS_CODE from "GML"."GML_GPOAO_DETAILS"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, ORDER_ID ORDER_ID
, LINE_ID LINE_ID
, LINE_STATUS LINE_STATUS
, SHIP_STATUS SHIP_STATUS
, SO_LINE_NO SO_LINE_NO
, TRANS_CNT TRANS_CNT
, ACTUAL_SHIPDATE ACTUAL_SHIPDATE
, REQUESTED_SHIPDATE REQUESTED_SHIPDATE
, PROMISED_SHIPDATE PROMISED_SHIPDATE
, SCHED_SHIPDATE SCHED_SHIPDATE
, ACTUAL_DLVDATE ACTUAL_DLVDATE
, REQUIRED_DLVDATE REQUIRED_DLVDATE
, HOLD_EXPIRATION HOLD_EXPIRATION
, EXPORT_DATE EXPORT_DATE
, LINE_COMMENT LINE_COMMENT
, SO_DETAIL_CATEGORY SO_DETAIL_CATEGORY
, SO_DETAIL_ATTRIBUTE1 SO_DETAIL_ATTRIBUTE1
, SO_DETAIL_ATTRIBUTE2 SO_DETAIL_ATTRIBUTE2
, SO_DETAIL_ATTRIBUTE3 SO_DETAIL_ATTRIBUTE3
, SO_DETAIL_ATTRIBUTE4 SO_DETAIL_ATTRIBUTE4
, SO_DETAIL_ATTRIBUTE5 SO_DETAIL_ATTRIBUTE5
, SO_DETAIL_ATTRIBUTE6 SO_DETAIL_ATTRIBUTE6
, SO_DETAIL_ATTRIBUTE7 SO_DETAIL_ATTRIBUTE7
, SO_DETAIL_ATTRIBUTE8 SO_DETAIL_ATTRIBUTE8
, SO_DETAIL_ATTRIBUTE9 SO_DETAIL_ATTRIBUTE9
, SO_DETAIL_ATTRIBUTE10 SO_DETAIL_ATTRIBUTE10
, SO_DETAIL_ATTRIBUTE11 SO_DETAIL_ATTRIBUTE11
, SO_DETAIL_ATTRIBUTE12 SO_DETAIL_ATTRIBUTE12
, SO_DETAIL_ATTRIBUTE13 SO_DETAIL_ATTRIBUTE13
, SO_DETAIL_ATTRIBUTE14 SO_DETAIL_ATTRIBUTE14
, SO_DETAIL_ATTRIBUTE15 SO_DETAIL_ATTRIBUTE15
, SO_DETAIL_ATTRIBUTE16 SO_DETAIL_ATTRIBUTE16
, SO_DETAIL_ATTRIBUTE17 SO_DETAIL_ATTRIBUTE17
, SO_DETAIL_ATTRIBUTE18 SO_DETAIL_ATTRIBUTE18
, SO_DETAIL_ATTRIBUTE19 SO_DETAIL_ATTRIBUTE19
, SO_DETAIL_ATTRIBUTE20 SO_DETAIL_ATTRIBUTE20
, SO_DETAIL_ATTRIBUTE21 SO_DETAIL_ATTRIBUTE21
, SO_DETAIL_ATTRIBUTE22 SO_DETAIL_ATTRIBUTE22
, SO_DETAIL_ATTRIBUTE23 SO_DETAIL_ATTRIBUTE23
, SO_DETAIL_ATTRIBUTE24 SO_DETAIL_ATTRIBUTE24
, SO_DETAIL_ATTRIBUTE25 SO_DETAIL_ATTRIBUTE25
, SO_DETAIL_ATTRIBUTE26 SO_DETAIL_ATTRIBUTE26
, SO_DETAIL_ATTRIBUTE27 SO_DETAIL_ATTRIBUTE27
, SO_DETAIL_ATTRIBUTE28 SO_DETAIL_ATTRIBUTE28
, SO_DETAIL_ATTRIBUTE29 SO_DETAIL_ATTRIBUTE29
, SO_DETAIL_ATTRIBUTE30 SO_DETAIL_ATTRIBUTE30
, SHIP_METHOD_INT SHIP_METHOD_INT
, SHIP_METHOD_EXT1 SHIP_METHOD_EXT1
, SHIP_METHOD_EXT2 SHIP_METHOD_EXT2
, SHIP_METHOD_EXT3 SHIP_METHOD_EXT3
, SHIP_METHOD_EXT4 SHIP_METHOD_EXT4
, SHIP_METHOD_EXT5 SHIP_METHOD_EXT5
, BASE_CURRENCY_INT BASE_CURRENCY_INT
, BASE_CURRENCY_EXT1 BASE_CURRENCY_EXT1
, BASE_CURRENCY_EXT2 BASE_CURRENCY_EXT2
, BASE_CURRENCY_EXT3 BASE_CURRENCY_EXT3
, BASE_CURRENCY_EXT4 BASE_CURRENCY_EXT4
, BASE_CURRENCY_EXT5 BASE_CURRENCY_EXT5
, BILLING_CURRENCY_INT BILLING_CURRENCY_INT
, BILLING_CURRENCY_EXT1 BILLING_CURRENCY_EXT1
, BILLING_CURRENCY_EXT2 BILLING_CURRENCY_EXT2
, BILLING_CURRENCY_EXT3 BILLING_CURRENCY_EXT3
, BILLING_CURRENCY_EXT4 BILLING_CURRENCY_EXT4
, BILLING_CURRENCY_EXT5 BILLING_CURRENCY_EXT5
, HOLDREAS_CODE_INT HOLDREAS_CODE_INT
, HOLDREAS_CODE_EXT1 HOLDREAS_CODE_EXT1
, HOLDREAS_CODE_EXT2 HOLDREAS_CODE_EXT2
, HOLDREAS_CODE_EXT3 HOLDREAS_CODE_EXT3
, HOLDREAS_CODE_EXT4 HOLDREAS_CODE_EXT4
, HOLDREAS_CODE_EXT5 HOLDREAS_CODE_EXT5
, EXCHANGE_RATE EXCHANGE_RATE
, SHIPTO_CUST_ID SHIPTO_CUST_ID
, SHIPTO_CODE_INT SHIPTO_CODE_INT
, SHIPTO_CODE_EXT1 SHIPTO_CODE_EXT1
, SHIPTO_CODE_EXT2 SHIPTO_CODE_EXT2
, SHIPTO_CODE_EXT3 SHIPTO_CODE_EXT3
, SHIPTO_CODE_EXT4 SHIPTO_CODE_EXT4
, SHIPTO_CODE_EXT5 SHIPTO_CODE_EXT5
, SHIPTO_CUST_NAME SHIPTO_CUST_NAME
, SHIPTO_ADDR1 SHIPTO_ADDR1
, SHIPTO_ADDR2 SHIPTO_ADDR2
, SHIPTO_ADDR3 SHIPTO_ADDR3
, SHIPTO_ADDR4 SHIPTO_ADDR4
, SHIPTO_POSTAL_CODE SHIPTO_POSTAL_CODE
, SHIPTO_COUNTRY_CODE_INT SHIPTO_COUNTRY_CODE_INT
, SHIPTO_COUNTRY_CODE_EXT1 SHIPTO_COUNTRY_CODE_EXT1
, SHIPTO_COUNTRY_CODE_EXT2 SHIPTO_COUNTRY_CODE_EXT2
, SHIPTO_COUNTRY_CODE_EXT3 SHIPTO_COUNTRY_CODE_EXT3
, SHIPTO_COUNTRY_CODE_EXT4 SHIPTO_COUNTRY_CODE_EXT4
, SHIPTO_COUNTRY_CODE_EXT5 SHIPTO_COUNTRY_CODE_EXT5
, SHIPTO_STATE_CODE_INT SHIPTO_STATE_CODE_INT
, SHIPTO_STATE_CODE_EXT1 SHIPTO_STATE_CODE_EXT1
, SHIPTO_STATE_CODE_EXT2 SHIPTO_STATE_CODE_EXT2
, SHIPTO_STATE_CODE_EXT3 SHIPTO_STATE_CODE_EXT3
, SHIPTO_STATE_CODE_EXT4 SHIPTO_STATE_CODE_EXT4
, SHIPTO_STATE_CODE_EXT5 SHIPTO_STATE_CODE_EXT5
, SHIPTO_PROVINCE_CODE_INT SHIPTO_PROVINCE_CODE_INT
, SHIPTO_PROVINCE_CODE_EXT1 SHIPTO_PROVINCE_CODE_EXT1
, SHIPTO_PROVINCE_CODE_EXT2 SHIPTO_PROVINCE_CODE_EXT2
, SHIPTO_PROVINCE_CODE_EXT3 SHIPTO_PROVINCE_CODE_EXT3
, SHIPTO_PROVINCE_CODE_EXT4 SHIPTO_PROVINCE_CODE_EXT4
, SHIPTO_PROVINCE_CODE_EXT5 SHIPTO_PROVINCE_CODE_EXT5
, SHIPTO_COUNTY SHIPTO_COUNTY
, SHIPTO_LAST_NAME SHIPTO_LAST_NAME
, SHIPTO_FIRST_NAME SHIPTO_FIRST_NAME
, SHIPTO_JOB_TITLE SHIPTO_JOB_TITLE
, SHIPTO_AREA_CODE SHIPTO_AREA_CODE
, SHIPTO_TELEPHONE SHIPTO_TELEPHONE
, NET_WT NET_WT
, TARE_WT TARE_WT
, PALLET_WT PALLET_WT
, FRTBILL_WT FRTBILL_WT
, SHIPWT_UM_INT SHIPWT_UM_INT
, SHIPWT_UM_EXT1 SHIPWT_UM_EXT1
, SHIPWT_UM_EXT2 SHIPWT_UM_EXT2
, SHIPWT_UM_EXT3 SHIPWT_UM_EXT3
, SHIPWT_UM_EXT4 SHIPWT_UM_EXT4
, SHIPWT_UM_EXT5 SHIPWT_UM_EXT5
, SHIP_VOLUME SHIP_VOLUME
, SHIPVOLUME_UM_INT SHIPVOLUME_UM_INT
, SHIPVOLUME_UM_EXT1 SHIPVOLUME_UM_EXT1
, SHIPVOLUME_UM_EXT2 SHIPVOLUME_UM_EXT2
, SHIPVOLUME_UM_EXT3 SHIPVOLUME_UM_EXT3
, SHIPVOLUME_UM_EXT4 SHIPVOLUME_UM_EXT4
, SHIPVOLUME_UM_EXT5 SHIPVOLUME_UM_EXT5
, ORDR_QTY1 ORDR_QTY1
, SHIP_QTY1 SHIP_QTY1
, ORDER_UM1_INT ORDER_UM1_INT
, ORDER_UM1_EXT1 ORDER_UM1_EXT1
, ORDER_UM1_EXT2 ORDER_UM1_EXT2
, ORDER_UM1_EXT3 ORDER_UM1_EXT3
, ORDER_UM1_EXT4 ORDER_UM1_EXT4
, ORDER_UM1_EXT5 ORDER_UM1_EXT5
, ORDR_QTY2 ORDR_QTY2
, SHIP_QTY2 SHIP_QTY2
, ORDER_UM2_INT ORDER_UM2_INT
, ORDER_UM2_EXT1 ORDER_UM2_EXT1
, ORDER_UM2_EXT2 ORDER_UM2_EXT2
, ORDER_UM2_EXT3 ORDER_UM2_EXT3
, ORDER_UM2_EXT4 ORDER_UM2_EXT4
, ORDER_UM2_EXT5 ORDER_UM2_EXT5
, ITEM_NO ITEM_NO
, ITEM_DESC1 ITEM_DESC1
, GENERIC_ITEM GENERIC_ITEM
, LINE_DESC LINE_DESC
, TO_WHSE TO_WHSE
, TO_WHSE_NAME TO_WHSE_NAME
, PRICEREAS_CODE_INT PRICEREAS_CODE_INT
, PRICEREAS_CODE_EXT1 PRICEREAS_CODE_EXT1
, PRICEREAS_CODE_EXT2 PRICEREAS_CODE_EXT2
, PRICEREAS_CODE_EXT3 PRICEREAS_CODE_EXT3
, PRICEREAS_CODE_EXT4 PRICEREAS_CODE_EXT4
, PRICEREAS_CODE_EXT5 PRICEREAS_CODE_EXT5
, PRICEREAS_DESC PRICEREAS_DESC
, BASE_PRICE BASE_PRICE
, NET_PRICE NET_PRICE
, EXTENDED_PRICE EXTENDED_PRICE
, LIST_PRICE LIST_PRICE
, SYSTEM_PRICE SYSTEM_PRICE
, NET_TAX NET_TAX
, BILL_QTY BILL_QTY
, FROM_WHSE FROM_WHSE
, FROM_WHSE_NAME FROM_WHSE_NAME
, FROM_WHSE_CONTACT FROM_WHSE_CONTACT
, FROM_WHSE_PHONE FROM_WHSE_PHONE
, FROM_WHSE_ADDR1 FROM_WHSE_ADDR1
, FROM_WHSE_ADDR2 FROM_WHSE_ADDR2
, FROM_WHSE_ADDR3 FROM_WHSE_ADDR3
, FROM_WHSE_ADDR4 FROM_WHSE_ADDR4
, FROM_WHSE_POSTAL_CODE FROM_WHSE_POSTAL_CODE
, FROM_WHSE_COUNTRY_CODE_INT FROM_WHSE_COUNTRY_CODE_INT
, FROM_WHSE_COUNTRY_CODE_EXT1 FROM_WHSE_COUNTRY_CODE_EXT1
, FROM_WHSE_COUNTRY_CODE_EXT2 FROM_WHSE_COUNTRY_CODE_EXT2
, FROM_WHSE_COUNTRY_CODE_EXT3 FROM_WHSE_COUNTRY_CODE_EXT3
, FROM_WHSE_COUNTRY_CODE_EXT4 FROM_WHSE_COUNTRY_CODE_EXT4
, FROM_WHSE_COUNTRY_CODE_EXT5 FROM_WHSE_COUNTRY_CODE_EXT5
, FROM_WHSE_STATE_CODE_INT FROM_WHSE_STATE_CODE_INT
, FROM_WHSE_STATE_CODE_EXT1 FROM_WHSE_STATE_CODE_EXT1
, FROM_WHSE_STATE_CODE_EXT2 FROM_WHSE_STATE_CODE_EXT2
, FROM_WHSE_STATE_CODE_EXT3 FROM_WHSE_STATE_CODE_EXT3
, FROM_WHSE_STATE_CODE_EXT4 FROM_WHSE_STATE_CODE_EXT4
, FROM_WHSE_STATE_CODE_EXT5 FROM_WHSE_STATE_CODE_EXT5
, FROM_WHSE_PROVINCE_CODE_INT FROM_WHSE_PROVINCE_CODE_INT
, FROM_WHSE_PROVINCE_CODE_EXT1 FROM_WHSE_PROVINCE_CODE_EXT1
, FROM_WHSE_PROVINCE_CODE_EXT2 FROM_WHSE_PROVINCE_CODE_EXT2
, FROM_WHSE_PROVINCE_CODE_EXT3 FROM_WHSE_PROVINCE_CODE_EXT3
, FROM_WHSE_PROVINCE_CODE_EXT4 FROM_WHSE_PROVINCE_CODE_EXT4
, FROM_WHSE_PROVINCE_CODE_EXT5 FROM_WHSE_PROVINCE_CODE_EXT5
, FROM_WHSE_COUNTY FROM_WHSE_COUNTY
, 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
, LINE_STATUS_CODE LINE_STATUS_CODE
FROM "GML"."GML_GPOAO_DETAILS"