eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ONT.OE_ORDER_HEADERS_ALL

Object Details

Object Name:	OE_ORDER_HEADERS_ALL
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_ORDER_HEADERS_ALL
Subobject Name:
Status:	VALID

OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_ORDER_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEADER_ID
OE_ORDER_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_NUMBER ORDER_TYPE_ID VERSION_NUMBER
OE_ORDER_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BLANKET_NUMBER
OE_ORDER_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOLD_TO_ORG_ID
OE_ORDER_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_ORG_ID
OE_ORDER_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_TO_ORG_ID
OE_ORDER_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_PO_NUMBER
OE_ORDER_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
OE_ORDER_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYS_DOCUMENT_REF ORDER_SOURCE_ID
OE_ORDER_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPEN_FLAG
OE_ORDER_HEADERS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_NUMBER ORDER_TYPE_ID

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	Not Used
EXPIRATION_DATE	DATE			Not Used
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 for the order
PRICING_DATE	DATE			Determines effective list and price modifiers
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)		Shipment Priority Code
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand Class
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 Used
SHIP_TOLERANCE_ABOVE	NUMBER			Over Shipment/Return Tolerance
SHIP_TOLERANCE_BELOW	NUMBER			Under Shipment/Return Tolerance
TRANSACTIONAL_CURR_CODE	VARCHAR2	(15)		Currency for the order
AGREEMENT_ID	NUMBER			Internal use only
TAX_POINT_CODE	VARCHAR2	(30)		For future use
CUST_PO_NUMBER	VARCHAR2	(50)		Customer Purchase Order 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_FROM_ORG_ID	NUMBER			Selling Organization
SOLD_TO_ORG_ID	NUMBER			Sold to customer
SHIP_FROM_ORG_ID	NUMBER			Ship From Organization Id - Warehouse
SHIP_TO_ORG_ID	NUMBER			Ship to Organization Id
INVOICE_TO_ORG_ID	NUMBER			Invoice To Organization ID
DELIVER_TO_ORG_ID	NUMBER			Deliver to Organization Id
SOLD_TO_CONTACT_ID	NUMBER			Customer contact
SHIP_TO_CONTACT_ID	NUMBER			Ship to Contact Id
INVOICE_TO_CONTACT_ID	NUMBER			Invoice To Contact ID
DELIVER_TO_CONTACT_ID	NUMBER			Deliver to Contact Id
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 ('N') or not ('Y')
BOOKED_FLAG	VARCHAR2	(1)	Yes	Indicates whether order is booked ('Y') or not ('N')
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, check, credit)
PAYMENT_AMOUNT	NUMBER			Stores amount of payment
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
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
CHANGE_SEQUENCE	VARCHAR2	(50)		It is sequence number in which changes will be applied. It will make sure that later changes are not over-written by previous order change.
DROP_SHIP_FLAG	VARCHAR2	(1)		No longer used.
CUSTOMER_PAYMENT_TERM_ID	NUMBER			No longer used.
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)		Shipping Instructions for Order
PACKING_INSTRUCTIONS	VARCHAR2	(2000)		Packing Instructions for Order
TP_CONTEXT	VARCHAR2	(30)		Descriptive Flexfield segment
TP_ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
FLOW_STATUS_CODE	VARCHAR2	(30)		Workflow status for the header
MARKETING_SOURCE_CODE_ID	NUMBER			Marketing Source Code Identifier, Foreign key reference to AMS_SOURCE_CODES
CREDIT_CARD_APPROVAL_DATE	DATE			The date on which credit card authorization was taken.
UPGRADED_FLAG	VARCHAR2	(1)		Denotes if this line is upgraded into R11i or newly created in R11i version.
CUSTOMER_PREFERENCE_SET_CODE	VARCHAR2	(30)		Indicates whether items on the order must ship/arrive together
BOOKED_DATE	DATE			Indicates the date when the order was booked
LOCK_CONTROL	NUMBER			Internal use only.
PRICE_REQUEST_CODE	VARCHAR2	(240)		Code identifies pricing transaction applied to Order Header
BATCH_ID	NUMBER			Internal Batch Identifier for orders imported in BULK mode.
XML_MESSAGE_ID	NUMBER			This is to store the unique id for each XML Message processed. This id will be used to get the Control Area Data which is stored in XML Gateway tables to send on the Outbound Message.
ACCOUNTING_RULE_DURATION	NUMBER	(15)		Number of accounting periods, across which revenue is recognized.
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield segment
BLANKET_NUMBER	NUMBER			Reference to Sales Agreement
SALES_DOCUMENT_TYPE_CODE	VARCHAR2	(30)		For Future Release
SOLD_TO_PHONE_ID	NUMBER			Phone Number of Sold to Customer
FULFILLMENT_SET_NAME	VARCHAR2	(30)		This will be used to store the name of the fulfillment set. The same will be used for creating system defined fulfillment sets.
LINE_SET_NAME	VARCHAR2	(30)		This will be used to hold the name of the Line Set. The same will be used for creating system defined line sets.
DEFAULT_FULFILLMENT_SET	VARCHAR2	(1)		This will be used to hold the header level preference value for the fulfillment set name.
TRANSACTION_PHASE_CODE	VARCHAR2	(30)		Indicates if Transaction is in negotitation or fulfillment phase
SALES_DOCUMENT_NAME	VARCHAR2	(240)		Stores Quote Name for Orders under negotiation.
QUOTE_NUMBER	NUMBER			This is populated for Orders under negotiation
QUOTE_DATE	DATE			Populated using defaulting rules.
USER_STATUS_CODE	VARCHAR2	(30)		User entered status
DRAFT_SUBMITTED_FLAG	VARCHAR2	(1)		Internal Use only
SOURCE_DOCUMENT_VERSION_NUMBER	NUMBER			Internal Use only
SOLD_TO_SITE_USE_ID	NUMBER			Customer Location
SUPPLIER_SIGNATURE	VARCHAR2	(240)		Supplier Name
SUPPLIER_SIGNATURE_DATE	DATE			Date when supplier signed on the document.
CUSTOMER_SIGNATURE	VARCHAR2	(240)		Customer Name
CUSTOMER_SIGNATURE_DATE	DATE			Date when customer signed on the document
MINISITE_ID	NUMBER			Mini Site ID for sales orders
END_CUSTOMER_ID	NUMBER			End customer Id
END_CUSTOMER_CONTACT_ID	NUMBER			Contact Id of the end customer
END_CUSTOMER_SITE_USE_ID	NUMBER			Site Use Id of the end customer
IB_OWNER	VARCHAR2	(60)		Install Base Owner
IB_CURRENT_LOCATION	VARCHAR2	(60)		Install Base current location
IB_INSTALLED_AT_LOCATION	VARCHAR2	(60)		Installed at location
ORDER_FIRMED_DATE	DATE			Demand firm date
INST_ID	NUMBER			used in RAC INSTANCE AFFINITY for context setting

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_FROM_ORG_ID
,      SOLD_TO_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
,      SALES_CHANNEL_CODE
,      FIRST_ACK_CODE
,      FIRST_ACK_DATE
,      LAST_ACK_CODE
,      LAST_ACK_DATE
,      ORDER_CATEGORY_CODE
,      CHANGE_SEQUENCE
,      DROP_SHIP_FLAG
,      CUSTOMER_PAYMENT_TERM_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      TP_CONTEXT
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      FLOW_STATUS_CODE
,      MARKETING_SOURCE_CODE_ID
,      CREDIT_CARD_APPROVAL_DATE
,      UPGRADED_FLAG
,      CUSTOMER_PREFERENCE_SET_CODE
,      BOOKED_DATE
,      LOCK_CONTROL
,      PRICE_REQUEST_CODE
,      BATCH_ID
,      XML_MESSAGE_ID
,      ACCOUNTING_RULE_DURATION
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      BLANKET_NUMBER
,      SALES_DOCUMENT_TYPE_CODE
,      SOLD_TO_PHONE_ID
,      FULFILLMENT_SET_NAME
,      LINE_SET_NAME
,      DEFAULT_FULFILLMENT_SET
,      TRANSACTION_PHASE_CODE
,      SALES_DOCUMENT_NAME
,      QUOTE_NUMBER
,      QUOTE_DATE
,      USER_STATUS_CODE
,      DRAFT_SUBMITTED_FLAG
,      SOURCE_DOCUMENT_VERSION_NUMBER
,      SOLD_TO_SITE_USE_ID
,      SUPPLIER_SIGNATURE
,      SUPPLIER_SIGNATURE_DATE
,      CUSTOMER_SIGNATURE
,      CUSTOMER_SIGNATURE_DATE
,      MINISITE_ID
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      IB_OWNER
,      IB_CURRENT_LOCATION
,      IB_INSTALLED_AT_LOCATION
,      ORDER_FIRMED_DATE
,      INST_ID
FROM ONT.OE_ORDER_HEADERS_ALL;

Dependencies

[top of page]

ONT.OE_ORDER_HEADERS_ALL does not reference any database object

ONT.OE_ORDER_HEADERS_ALL is referenced by following:

ONT: OE_ORDER_HEADERS_ALL#