VIEW: APPS.OE_CRM_ORDER_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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