DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OE_CRM_ORDER_HEADERS_V

Object Details
Object Name: OE_CRM_ORDER_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_CRM_ORDER_HEADERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Order Header Identifier
ORG_ID NUMBER

Operating Unit which performed this transaction
ORDER_TYPE_ID NUMBER
Yes Order Transaction Type Identifier
ORDER_NUMBER NUMBER
Yes User-visible number of the order
VERSION_NUMBER NUMBER
Yes Version number
EXPIRATION_DATE DATE

Expiration date
ORDER_SOURCE_ID NUMBER

Source of the order
SOURCE_DOCUMENT_TYPE_ID NUMBER

Indicates the source of the order
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Original document reference for the order in external system
SOURCE_DOCUMENT_ID NUMBER

Source Order Header Identifier
ORDERED_DATE DATE

Ordered date
REQUEST_DATE DATE

Request date
PRICING_DATE DATE

Determines effective list and price modifiers
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Shipment Priority Code
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand class code
PRICE_LIST_ID NUMBER

Price list Identification for the order
TAX_EXEMPT_FLAG VARCHAR2 (1)
It will decide the tax handling for the order. Possible values can be S - Standard, E - Exempt, R - Required
TAX_EXEMPT_NUMBER VARCHAR2 (80)
The Tax exemption Number
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
The reason code for Tax exemption
CONVERSION_RATE NUMBER

Rate of the currency conversion
CONVERSION_TYPE_CODE VARCHAR2 (30)
Currency conversion type
CONVERSION_RATE_DATE DATE

Date of the currency conversion
PARTIAL_SHIPMENTS_ALLOWED VARCHAR2 (1)
Not in use
SHIP_TOLERANCE_ABOVE NUMBER

Ship above tolerance
SHIP_TOLERANCE_BELOW NUMBER

Ship below tolerance
TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
Currency code for transaction
AGREEMENT_ID NUMBER

Agreement ID for internal use only
TAX_POINT_CODE VARCHAR2 (30)
Tax code for future use
CUST_PO_NUMBER VARCHAR2 (50)
Customer purchase number
INVOICING_RULE_ID NUMBER (15)
Invoicing rule used by AR for generating Invoice
ACCOUNTING_RULE_ID NUMBER (15)
Accounting rule used by AR for generating Invoice
PAYMENT_TERM_ID NUMBER (15)
Payment terms
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping method to be used to ship the order
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Freight Carrier Code
FOB_POINT_CODE VARCHAR2 (30)
FOB point code
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms Code
SOLD_TO_ORG_ID NUMBER

Sold to customer
SOLD_FROM_ORG_ID NUMBER

Selling organization
SHIP_FROM_ORG_ID NUMBER

Ship from organization
SHIP_TO_ORG_ID NUMBER

Ship to organization
INVOICE_TO_ORG_ID NUMBER

Invoice to organization
DELIVER_TO_ORG_ID NUMBER

Delivery to origanization
SOLD_TO_CONTACT_ID NUMBER

Customer contact
SHIP_TO_CONTACT_ID NUMBER

Ship to contact
INVOICE_TO_CONTACT_ID NUMBER

Invoice to contact
DELIVER_TO_CONTACT_ID NUMBER

Delivery to contact
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated row.
PROGRAM_ID NUMBER

Concurrent program that last updated row.
PROGRAM_UPDATE_DATE DATE

Last date changed by concurrent program
REQUEST_ID NUMBER

Concurrent request that last changed row
CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
Reserved for country-specific functionality.
CANCELLED_FLAG VARCHAR2 (1)
Cancelled Flag
OPEN_FLAG VARCHAR2 (1) Yes Indicates whether the order has been closed or not
BOOKED_FLAG VARCHAR2 (1) Yes Booked flag
SALESREP_ID NUMBER (15)
Sales representative Identification
RETURN_REASON_CODE VARCHAR2 (30)
This column stores return reason code for a return order, and is for defaulting to a return line
ORDER_DATE_TYPE_CODE VARCHAR2 (30)
Order date type code
EARLIEST_SCHEDULE_LIMIT NUMBER

Limit in number of days earlier than the requested date when the item can be shipped
LATEST_SCHEDULE_LIMIT NUMBER

Limit in number of days later than the requested date when the item can be shipped
PAYMENT_TYPE_CODE VARCHAR2 (30)
Stores type of payment for orders,cash,credit and check
PAYMENT_AMOUNT NUMBER

Stores payment amount
CHECK_NUMBER VARCHAR2 (50)
Stores check number if payment type is Check
CREDIT_CARD_CODE VARCHAR2 (80)
Stores credit card name if payment type is Credit Card
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
Stores credit card holder name if payment type is Credit Card
CREDIT_CARD_NUMBER VARCHAR2 (80)
Stores credit card number if payment type is Credit Card
CREDIT_CARD_EXPIRATION_DATE DATE

Stores credit card expiration date if payment type is Credit Card
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
Stores credit card approval code if payment type is Credit Card
CREDIT_CARD_APPROVAL_DATE DATE

Stores credit card approval date if payment type is Credit Card
SALES_CHANNEL_CODE VARCHAR2 (30)
Sales channel through which order was placed
FIRST_ACK_CODE VARCHAR2 (30)
Initial acknowledgment code for oubound EDI transaction
FIRST_ACK_DATE DATE

Initial acknowledgment date for oubound EDI transaction
LAST_ACK_CODE VARCHAR2 (30)
Latest acknowledgment code for oubound EDI transaction
LAST_ACK_DATE DATE

Latest acknowledgment date for oubound EDI transaction
ORDER_CATEGORY_CODE VARCHAR2 (30) Yes Order category code
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions for Order
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions for Order
Query Text

Cut, paste (and edit) the following text to query this object:


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 APPS.OE_CRM_ORDER_HEADERS_V;

Dependencies

[top of page]

APPS.OE_CRM_ORDER_HEADERS_V references the following:

SchemaAPPS
SynonymOE_ORDER_HEADERS

APPS.OE_CRM_ORDER_HEADERS_V is not referenced by any database object