VIEW: ONT.OE_ORDER_HEADERS_ALL#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, ORG_ID ORG_ID, ORDER_TYPE_ID ORDER_TYPE_ID, ORDER_NUMBER ORDER_NUMBER, VERSION_NUMBER VERSION_NUMBER, EXPIRATION_DATE EXPIRATION_DATE, ORDER_SOURCE_ID ORDER_SOURCE_ID, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, ORDERED_DATE ORDERED_DATE, REQUEST_DATE REQUEST_DATE, PRICING_DATE PRICING_DATE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, PRICE_LIST_ID PRICE_LIST_ID, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE_DATE CONVERSION_RATE_DATE, PARTIAL_SHIPMENTS_ALLOWED PARTIAL_SHIPMENTS_ALLOWED, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE, AGREEMENT_ID AGREEMENT_ID, TAX_POINT_CODE TAX_POINT_CODE, CUST_PO_NUMBER CUST_PO_NUMBER, INVOICING_RULE_ID INVOICING_RULE_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FOB_POINT_CODE FOB_POINT_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, CONTEXT CONTEXT, 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, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, CANCELLED_FLAG CANCELLED_FLAG, OPEN_FLAG OPEN_FLAG, BOOKED_FLAG BOOKED_FLAG, SALESREP_ID SALESREP_ID, RETURN_REASON_CODE RETURN_REASON_CODE, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE, EARLIEST_SCHEDULE_LIMIT EARLIEST_SCHEDULE_LIMIT, LATEST_SCHEDULE_LIMIT LATEST_SCHEDULE_LIMIT, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, CHECK_NUMBER CHECK_NUMBER, CREDIT_CARD_CODE CREDIT_CARD_CODE, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, FIRST_ACK_CODE FIRST_ACK_CODE, FIRST_ACK_DATE FIRST_ACK_DATE, LAST_ACK_CODE LAST_ACK_CODE, LAST_ACK_DATE LAST_ACK_DATE, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE, CHANGE_SEQUENCE CHANGE_SEQUENCE, DROP_SHIP_FLAG DROP_SHIP_FLAG, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, TP_CONTEXT TP_CONTEXT, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, FLOW_STATUS_CODE FLOW_STATUS_CODE, MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID, CREDIT_CARD_APPROVAL_DATE CREDIT_CARD_APPROVAL_DATE, UPGRADED_FLAG UPGRADED_FLAG, CUSTOMER_PREFERENCE_SET_CODE CUSTOMER_PREFERENCE_SET_CODE, BOOKED_DATE BOOKED_DATE, LOCK_CONTROL LOCK_CONTROL, PRICE_REQUEST_CODE PRICE_REQUEST_CODE, BATCH_ID BATCH_ID, XML_MESSAGE_ID XML_MESSAGE_ID, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, BLANKET_NUMBER BLANKET_NUMBER, SALES_DOCUMENT_TYPE_CODE SALES_DOCUMENT_TYPE_CODE, SOLD_TO_PHONE_ID SOLD_TO_PHONE_ID, FULFILLMENT_SET_NAME FULFILLMENT_SET_NAME, LINE_SET_NAME LINE_SET_NAME, DEFAULT_FULFILLMENT_SET DEFAULT_FULFILLMENT_SET, TRANSACTION_PHASE_CODE TRANSACTION_PHASE_CODE, SALES_DOCUMENT_NAME SALES_DOCUMENT_NAME, QUOTE_NUMBER QUOTE_NUMBER, QUOTE_DATE QUOTE_DATE, USER_STATUS_CODE USER_STATUS_CODE, DRAFT_SUBMITTED_FLAG DRAFT_SUBMITTED_FLAG, SOURCE_DOCUMENT_VERSION_NUMBER SOURCE_DOCUMENT_VERSION_NUMBER, SOLD_TO_SITE_USE_ID SOLD_TO_SITE_USE_ID, SUPPLIER_SIGNATURE SUPPLIER_SIGNATURE, SUPPLIER_SIGNATURE_DATE SUPPLIER_SIGNATURE_DATE, CUSTOMER_SIGNATURE CUSTOMER_SIGNATURE, CUSTOMER_SIGNATURE_DATE CUSTOMER_SIGNATURE_DATE, MINISITE_ID MINISITE_ID, END_CUSTOMER_ID END_CUSTOMER_ID, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID, IB_OWNER IB_OWNER, IB_CURRENT_LOCATION IB_CURRENT_LOCATION, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION, ORDER_FIRMED_DATE ORDER_FIRMED_DATE, INST_ID INST_ID from "ONT"."OE_ORDER_HEADERS_ALL"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, ORG_ID ORG_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, ORDER_NUMBER ORDER_NUMBER
, VERSION_NUMBER VERSION_NUMBER
, EXPIRATION_DATE EXPIRATION_DATE
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, ORDERED_DATE ORDERED_DATE
, REQUEST_DATE REQUEST_DATE
, PRICING_DATE PRICING_DATE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, PRICE_LIST_ID PRICE_LIST_ID
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, PARTIAL_SHIPMENTS_ALLOWED PARTIAL_SHIPMENTS_ALLOWED
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE
, AGREEMENT_ID AGREEMENT_ID
, TAX_POINT_CODE TAX_POINT_CODE
, CUST_PO_NUMBER CUST_PO_NUMBER
, INVOICING_RULE_ID INVOICING_RULE_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FOB_POINT_CODE FOB_POINT_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, CONTEXT CONTEXT
, 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
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, CANCELLED_FLAG CANCELLED_FLAG
, OPEN_FLAG OPEN_FLAG
, BOOKED_FLAG BOOKED_FLAG
, SALESREP_ID SALESREP_ID
, RETURN_REASON_CODE RETURN_REASON_CODE
, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, EARLIEST_SCHEDULE_LIMIT EARLIEST_SCHEDULE_LIMIT
, LATEST_SCHEDULE_LIMIT LATEST_SCHEDULE_LIMIT
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, CHECK_NUMBER CHECK_NUMBER
, CREDIT_CARD_CODE CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, FIRST_ACK_CODE FIRST_ACK_CODE
, FIRST_ACK_DATE FIRST_ACK_DATE
, LAST_ACK_CODE LAST_ACK_CODE
, LAST_ACK_DATE LAST_ACK_DATE
, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, TP_CONTEXT TP_CONTEXT
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_ATTRIBUTE15
, FLOW_STATUS_CODE FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, CREDIT_CARD_APPROVAL_DATE CREDIT_CARD_APPROVAL_DATE
, UPGRADED_FLAG UPGRADED_FLAG
, CUSTOMER_PREFERENCE_SET_CODE CUSTOMER_PREFERENCE_SET_CODE
, BOOKED_DATE BOOKED_DATE
, LOCK_CONTROL LOCK_CONTROL
, PRICE_REQUEST_CODE PRICE_REQUEST_CODE
, BATCH_ID BATCH_ID
, XML_MESSAGE_ID XML_MESSAGE_ID
, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, BLANKET_NUMBER BLANKET_NUMBER
, SALES_DOCUMENT_TYPE_CODE SALES_DOCUMENT_TYPE_CODE
, SOLD_TO_PHONE_ID SOLD_TO_PHONE_ID
, FULFILLMENT_SET_NAME FULFILLMENT_SET_NAME
, LINE_SET_NAME LINE_SET_NAME
, DEFAULT_FULFILLMENT_SET DEFAULT_FULFILLMENT_SET
, TRANSACTION_PHASE_CODE TRANSACTION_PHASE_CODE
, SALES_DOCUMENT_NAME SALES_DOCUMENT_NAME
, QUOTE_NUMBER QUOTE_NUMBER
, QUOTE_DATE QUOTE_DATE
, USER_STATUS_CODE USER_STATUS_CODE
, DRAFT_SUBMITTED_FLAG DRAFT_SUBMITTED_FLAG
, SOURCE_DOCUMENT_VERSION_NUMBER SOURCE_DOCUMENT_VERSION_NUMBER
, SOLD_TO_SITE_USE_ID SOLD_TO_SITE_USE_ID
, SUPPLIER_SIGNATURE SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE SUPPLIER_SIGNATURE_DATE
, CUSTOMER_SIGNATURE CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE CUSTOMER_SIGNATURE_DATE
, MINISITE_ID MINISITE_ID
, END_CUSTOMER_ID END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID
, IB_OWNER IB_OWNER
, IB_CURRENT_LOCATION IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION
, ORDER_FIRMED_DATE ORDER_FIRMED_DATE
, INST_ID INST_ID
FROM "ONT"."OE_ORDER_HEADERS_ALL"