VIEW: GML.OP_ORDR_DTL_INTERFACE#

Source

View Text - Preformatted

select OI_LINE_ID OI_LINE_ID, OI_ORDER_ID OI_ORDER_ID, ERROR_CODE ERROR_CODE, ERROR_DESC ERROR_DESC, 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, ORDER_SOURCE_ID ORDER_SOURCE_ID, LINE_NO LINE_NO, LINE_COMMENT LINE_COMMENT, LINE_ACTION LINE_ACTION, FROM_WHSE FROM_WHSE, CUST_LINE_NO CUST_LINE_NO, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, SHIPTO_CUST_ADDR_ID SHIPTO_CUST_ADDR_ID, SHIPTO_CUST_ID SHIPTO_CUST_ID, SHIPTO_CUST_NAME SHIPTO_CUST_NAME, SHIPTO_ADDR1 SHIPTO_ADDR1, SHIPTO_ADDR2 SHIPTO_ADDR2, SHIPTO_ADDR3 SHIPTO_ADDR3, SHIPTO_ADDR4 SHIPTO_ADDR4, SHIPTO_CITY SHIPTO_CITY, SHIPTO_POSTAL_CODE SHIPTO_POSTAL_CODE, SHIPTO_COUNTY SHIPTO_COUNTY, SHIPTO_COUNTRY SHIPTO_COUNTRY, SHIPTO_STATE SHIPTO_STATE, SHIPTO_PROVINCE SHIPTO_PROVINCE, 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_PHONE_NUMBER SHIPTO_PHONE_NUMBER, BILLING_CURRENCY BILLING_CURRENCY, BASE_CURRENCY BASE_CURRENCY, CONVERSION_TYPE CONVERSION_TYPE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, FRTBILL_MTHD FRTBILL_MTHD, EMBARKATION_PORT EMBARKATION_PORT, DEBARKATION_PORT DEBARKATION_PORT, TERMS_CODE TERMS_CODE, FOB_CODE FOB_CODE, SHIPPER_CODE SHIPPER_CODE, SHIP_MTHD SHIP_MTHD, SCHED_SHIPDATE SCHED_SHIPDATE, REQUIRED_DLVDATE REQUIRED_DLVDATE, REQUESTED_DLVDATE REQUESTED_DLVDATE, COA_REQUIRED COA_REQUIRED, LINE_DESC LINE_DESC, GENERIC_ITEM GENERIC_ITEM, ITEM_NO ITEM_NO, QC_GRADE_WANTED QC_GRADE_WANTED, NET_PRICE NET_PRICE, PRICEREAS_CODE PRICEREAS_CODE, PRICE_UM PRICE_UM, ORDER_QTY1 ORDER_QTY1, ORDER_UM1 ORDER_UM1, ORDER_QTY2 ORDER_QTY2, ORDER_UM2 ORDER_UM2 from "GML"."OP_ORDR_DTL_INTERFACE"

View Text - HTML Formatted

SELECT OI_LINE_ID OI_LINE_ID
, OI_ORDER_ID OI_ORDER_ID
, ERROR_CODE ERROR_CODE
, ERROR_DESC ERROR_DESC
, 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
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, LINE_NO LINE_NO
, LINE_COMMENT LINE_COMMENT
, LINE_ACTION LINE_ACTION
, FROM_WHSE FROM_WHSE
, CUST_LINE_NO CUST_LINE_NO
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, SHIPTO_CUST_ADDR_ID SHIPTO_CUST_ADDR_ID
, SHIPTO_CUST_ID SHIPTO_CUST_ID
, SHIPTO_CUST_NAME SHIPTO_CUST_NAME
, SHIPTO_ADDR1 SHIPTO_ADDR1
, SHIPTO_ADDR2 SHIPTO_ADDR2
, SHIPTO_ADDR3 SHIPTO_ADDR3
, SHIPTO_ADDR4 SHIPTO_ADDR4
, SHIPTO_CITY SHIPTO_CITY
, SHIPTO_POSTAL_CODE SHIPTO_POSTAL_CODE
, SHIPTO_COUNTY SHIPTO_COUNTY
, SHIPTO_COUNTRY SHIPTO_COUNTRY
, SHIPTO_STATE SHIPTO_STATE
, SHIPTO_PROVINCE SHIPTO_PROVINCE
, 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_PHONE_NUMBER SHIPTO_PHONE_NUMBER
, BILLING_CURRENCY BILLING_CURRENCY
, BASE_CURRENCY BASE_CURRENCY
, CONVERSION_TYPE CONVERSION_TYPE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, FRTBILL_MTHD FRTBILL_MTHD
, EMBARKATION_PORT EMBARKATION_PORT
, DEBARKATION_PORT DEBARKATION_PORT
, TERMS_CODE TERMS_CODE
, FOB_CODE FOB_CODE
, SHIPPER_CODE SHIPPER_CODE
, SHIP_MTHD SHIP_MTHD
, SCHED_SHIPDATE SCHED_SHIPDATE
, REQUIRED_DLVDATE REQUIRED_DLVDATE
, REQUESTED_DLVDATE REQUESTED_DLVDATE
, COA_REQUIRED COA_REQUIRED
, LINE_DESC LINE_DESC
, GENERIC_ITEM GENERIC_ITEM
, ITEM_NO ITEM_NO
, QC_GRADE_WANTED QC_GRADE_WANTED
, NET_PRICE NET_PRICE
, PRICEREAS_CODE PRICEREAS_CODE
, PRICE_UM PRICE_UM
, ORDER_QTY1 ORDER_QTY1
, ORDER_UM1 ORDER_UM1
, ORDER_QTY2 ORDER_QTY2
, ORDER_UM2 ORDER_UM2
FROM "GML"."OP_ORDR_DTL_INTERFACE"