VIEW: GML.OP_ORDR_HDR_INTERFACE#

Source

View Text - Preformatted

select OI_ORDER_ID OI_ORDER_ID, PROCESS_FLAG PROCESS_FLAG, 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, ORDER_TYPE_CODE ORDER_TYPE_CODE, CUSTPO_NO CUSTPO_NO, CUSTPO_DATE CUSTPO_DATE, ORDER_NO ORDER_NO, ORGN_CODE ORGN_CODE, ORDER_COMMENT ORDER_COMMENT, SO_ACTION SO_ACTION, FROM_WHSE FROM_WHSE, 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, BILLTO_CUST_ADDR_ID BILLTO_CUST_ADDR_ID, BILLTO_CUST_ID BILLTO_CUST_ID, BILLTO_CUST_NAME BILLTO_CUST_NAME, BILLTO_ADDR1 BILLTO_ADDR1, BILLTO_ADDR2 BILLTO_ADDR2, BILLTO_ADDR3 BILLTO_ADDR3, BILLTO_ADDR4 BILLTO_ADDR4, BILLTO_CITY BILLTO_CITY, BILLTO_POSTAL_CODE BILLTO_POSTAL_CODE, BILLTO_COUNTY BILLTO_COUNTY, BILLTO_COUNTRY BILLTO_COUNTRY, BILLTO_STATE BILLTO_STATE, BILLTO_PROVINCE BILLTO_PROVINCE, BILLTO_LAST_NAME BILLTO_LAST_NAME, BILLTO_FIRST_NAME BILLTO_FIRST_NAME, BILLTO_JOB_TITLE BILLTO_JOB_TITLE, BILLTO_AREA_CODE BILLTO_AREA_CODE, BILLTO_PHONE_NUMBER BILLTO_PHONE_NUMBER, 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, SOLDTO_CUST_ADDR_ID SOLDTO_CUST_ADDR_ID, SOLDTO_CUST_ID SOLDTO_CUST_ID, SOLDTO_CUST_NAME SOLDTO_CUST_NAME, SOLDTO_ADDR1 SOLDTO_ADDR1, SOLDTO_ADDR2 SOLDTO_ADDR2, SOLDTO_ADDR3 SOLDTO_ADDR3, SOLDTO_ADDR4 SOLDTO_ADDR4, SOLDTO_CITY SOLDTO_CITY, SOLDTO_POSTAL_CODE SOLDTO_POSTAL_CODE, SOLDTO_COUNTY SOLDTO_COUNTY, SOLDTO_COUNTRY SOLDTO_COUNTRY, SOLDTO_STATE SOLDTO_STATE, SOLDTO_PROVINCE SOLDTO_PROVINCE, SOLDTO_LAST_NAME SOLDTO_LAST_NAME, SOLDTO_FIRST_NAME SOLDTO_FIRST_NAME, SOLDTO_JOB_TITLE SOLDTO_JOB_TITLE, SOLDTO_AREA_CODE SOLDTO_AREA_CODE, SOLDTO_PHONE_NUMBER SOLDTO_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 from "GML"."OP_ORDR_HDR_INTERFACE"

View Text - HTML Formatted

SELECT OI_ORDER_ID OI_ORDER_ID
, PROCESS_FLAG PROCESS_FLAG
, 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
, ORDER_TYPE_CODE ORDER_TYPE_CODE
, CUSTPO_NO CUSTPO_NO
, CUSTPO_DATE CUSTPO_DATE
, ORDER_NO ORDER_NO
, ORGN_CODE ORGN_CODE
, ORDER_COMMENT ORDER_COMMENT
, SO_ACTION SO_ACTION
, FROM_WHSE FROM_WHSE
, 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
, BILLTO_CUST_ADDR_ID BILLTO_CUST_ADDR_ID
, BILLTO_CUST_ID BILLTO_CUST_ID
, BILLTO_CUST_NAME BILLTO_CUST_NAME
, BILLTO_ADDR1 BILLTO_ADDR1
, BILLTO_ADDR2 BILLTO_ADDR2
, BILLTO_ADDR3 BILLTO_ADDR3
, BILLTO_ADDR4 BILLTO_ADDR4
, BILLTO_CITY BILLTO_CITY
, BILLTO_POSTAL_CODE BILLTO_POSTAL_CODE
, BILLTO_COUNTY BILLTO_COUNTY
, BILLTO_COUNTRY BILLTO_COUNTRY
, BILLTO_STATE BILLTO_STATE
, BILLTO_PROVINCE BILLTO_PROVINCE
, BILLTO_LAST_NAME BILLTO_LAST_NAME
, BILLTO_FIRST_NAME BILLTO_FIRST_NAME
, BILLTO_JOB_TITLE BILLTO_JOB_TITLE
, BILLTO_AREA_CODE BILLTO_AREA_CODE
, BILLTO_PHONE_NUMBER BILLTO_PHONE_NUMBER
, 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
, SOLDTO_CUST_ADDR_ID SOLDTO_CUST_ADDR_ID
, SOLDTO_CUST_ID SOLDTO_CUST_ID
, SOLDTO_CUST_NAME SOLDTO_CUST_NAME
, SOLDTO_ADDR1 SOLDTO_ADDR1
, SOLDTO_ADDR2 SOLDTO_ADDR2
, SOLDTO_ADDR3 SOLDTO_ADDR3
, SOLDTO_ADDR4 SOLDTO_ADDR4
, SOLDTO_CITY SOLDTO_CITY
, SOLDTO_POSTAL_CODE SOLDTO_POSTAL_CODE
, SOLDTO_COUNTY SOLDTO_COUNTY
, SOLDTO_COUNTRY SOLDTO_COUNTRY
, SOLDTO_STATE SOLDTO_STATE
, SOLDTO_PROVINCE SOLDTO_PROVINCE
, SOLDTO_LAST_NAME SOLDTO_LAST_NAME
, SOLDTO_FIRST_NAME SOLDTO_FIRST_NAME
, SOLDTO_JOB_TITLE SOLDTO_JOB_TITLE
, SOLDTO_AREA_CODE SOLDTO_AREA_CODE
, SOLDTO_PHONE_NUMBER SOLDTO_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
FROM "GML"."OP_ORDR_HDR_INTERFACE"