APPS.OE_CRM_ORDER_HEADERS_V
[Home] [Help]
| Product: | ONT - Order Management |
|---|---|
| Description: | Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table. |
| Implementation/DBA Data: |
APPS.OE_CRM_ORDER_HEADERS_V
|
SELECT HEADER_ID
, ORG_ID
, ORDER_TYPE_ID
, ORDER_NUMBER
, VERSION_NUMBER
, EXPIRATION_DATE
, ORDER_SOURCE_ID
, SOURCE_DOCUMENT_TYPE_ID
, ORIG_SYS_DOCUMENT_REF
, SOURCE_DOCUMENT_ID
, ORDERED_DATE
, REQUEST_DATE
, PRICING_DATE
, SHIPMENT_PRIORITY_CODE
, DEMAND_CLASS_CODE
, PRICE_LIST_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, CONVERSION_RATE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE
, PARTIAL_SHIPMENTS_ALLOWED
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, TRANSACTIONAL_CURR_CODE
, AGREEMENT_ID
, TAX_POINT_CODE
, CUST_PO_NUMBER
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, PAYMENT_TERM_ID
, SHIPPING_METHOD_CODE
, FREIGHT_CARRIER_CODE
, FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID
, DELIVER_TO_ORG_ID
, SOLD_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, CANCELLED_FLAG
, OPEN_FLAG
, BOOKED_FLAG
, SALESREP_ID
, RETURN_REASON_CODE
, ORDER_DATE_TYPE_CODE
, EARLIEST_SCHEDULE_LIMIT
, LATEST_SCHEDULE_LIMIT
, PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT
, CHECK_NUMBER
, CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE
, CREDIT_CARD_APPROVAL_DATE
, SALES_CHANNEL_CODE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_CODE
, LAST_ACK_DATE
, ORDER_CATEGORY_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
FROM OE_ORDER_HEADERS