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

TABLE: ONT.OE_BLANKET_HEADERS_HIST

Object Details
Object Name: OE_BLANKET_HEADERS_HIST
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_BLANKET_HEADERS_HIST
Subobject Name:
Status: VALID


Primary for storing Revisions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_BLANKET_HEADERS_HIST_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_PO_NUMBER
OE_BLANKET_HEADERS_HIST_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnVERSION_NUMBER
OE_BLANKET_HEADERS_HIST_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHIST_CREATION_DATE
ColumnHEADER_ID
OE_BLANKET_HEADERS_HIST_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_NUMBER
ColumnORDER_TYPE_ID
ColumnVERSION_NUMBER
OE_BLANKET_HEADERS_HIST_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE_ACTIVE
OE_BLANKET_HEADERS_HIST_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_DATE_ACTIVE
OE_BLANKET_HEADERS_HIST_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnON_HOLD_FLAG
OE_BLANKET_HEADERS_HIST_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOLD_TO_ORG_ID
OE_BLANKET_HEADERS_HIST_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_ORG_ID
OE_BLANKET_HEADERS_HIST_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_TO_ORG_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

Sales Agreement Header Identifier
HIST_CREATION_DATE DATE

Standard Who Column
ORG_ID NUMBER

Operating Unit which performed this transaction
ORDER_TYPE_ID NUMBER

Sales Agreement Transaction type identifier
ORDER_NUMBER NUMBER

User-Visible number of the sales agreement
VERSION_NUMBER NUMBER

Revision number of the sales agreement
EXPIRATION_DATE DATE

Not Used
ORDER_SOURCE_ID NUMBER

Not used
SOURCE_DOCUMENT_TYPE_ID NUMBER

Indicates the source of the sales agreement
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Not used
SOURCE_DOCUMENT_ID NUMBER

Source Sales Agreement Header Identifier
ORDERED_DATE DATE

Not used
REQUEST_DATE DATE

Not used
PRICING_DATE DATE

Not used
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Not Used
DEMAND_CLASS_CODE VARCHAR2 (30)
Not used
PRICE_LIST_ID NUMBER

Price List identification for the sales agreement
TAX_EXEMPT_FLAG VARCHAR2 (1)
Not Used
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Not used
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Not used
CONVERSION_RATE NUMBER

Not used
CONVERSION_TYPE_CODE VARCHAR2 (30)
Currency conversion type
CONVERSION_RATE_DATE DATE

Not used
PARTIAL_SHIPMENTS_ALLOWED VARCHAR2 (1)
Not used
SHIP_TOLERANCE_ABOVE NUMBER

Not used
SHIP_TOLERANCE_BELOW NUMBER

Not used
TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
Currency for the sales agreement
AGREEMENT_ID NUMBER

Not used
TAX_POINT_CODE VARCHAR2 (30)
Not used
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 sales agreement
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Not used
FOB_POINT_CODE VARCHAR2 (30)
Not used
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms code
SOLD_FROM_ORG_ID NUMBER

Not Used
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

Not used
INVOICE_TO_CONTACT_ID NUMBER

Not used
DELIVER_TO_CONTACT_ID NUMBER

Not used
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_DATE DATE

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

Not Used
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
ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexfield Segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield Segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
Reserved for country-specific functionality
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield Segment
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)
Not Used
OPEN_FLAG VARCHAR2 (1)
Not Used
BOOKED_FLAG VARCHAR2 (1)
Not Used
SALESREP_ID NUMBER (15)
Sales Representative Identification
RETURN_REASON_CODE VARCHAR2 (30)
Not Used
ORDER_DATE_TYPE_CODE VARCHAR2 (30)
Not Used
EARLIEST_SCHEDULE_LIMIT NUMBER

Not Used
LATEST_SCHEDULE_LIMIT NUMBER

Not Used
PAYMENT_TYPE_CODE VARCHAR2 (30)
Not Used
PAYMENT_AMOUNT NUMBER

Not Used
CHECK_NUMBER VARCHAR2 (50)
Not Used
CREDIT_CARD_CODE VARCHAR2 (80)
Not Used
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
Not Used
CREDIT_CARD_NUMBER VARCHAR2 (80)
Not Used
CREDIT_CARD_EXPIRATION_DATE DATE

Not Used
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
Not Used
SALES_CHANNEL_CODE VARCHAR2 (30)
Not Used
FIRST_ACK_CODE VARCHAR2 (30)
Not Used
FIRST_ACK_DATE DATE

Not Used
LAST_ACK_CODE VARCHAR2 (30)
Not Used
LAST_ACK_DATE DATE

Not Used
ORDER_CATEGORY_CODE VARCHAR2 (30)
Sales Agreement Category Code
CHANGE_SEQUENCE VARCHAR2 (50)
Not Used
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions for the Sales Agreement
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions for the Sales Agreement
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

Not Used
CREDIT_CARD_APPROVAL_DATE DATE

Not Used
UPGRADED_FLAG VARCHAR2 (1)
Not Used
CUSTOMER_PREFERENCE_SET_CODE VARCHAR2 (30)
Not Used
BOOKED_DATE DATE

Not Used
LOCK_CONTROL NUMBER

Internal Use Only
REASON_CODE VARCHAR2 (30)
Not Used
HIST_COMMENTS VARCHAR2 (2000)
Not Used
HIST_TYPE_CODE VARCHAR2 (30)
Not Used
HIST_CREATED_BY NUMBER

Not Used
RESPONSIBILITY_ID NUMBER
Yes Not Used
PRICE_REQUEST_CODE VARCHAR2 (240)
Not Used
ACCOUNTING_RULE_DURATION NUMBER (15)
Not Used
ITEM_RELATIONSHIP_TYPE NUMBER

Not Used
BLANKET_NUMBER NUMBER

Not Used
START_DATE_ACTIVE DATE

Activation Date of the Sales Agreement
END_DATE_ACTIVE DATE

Expiration Date of the Sales Agreement
ON_HOLD_FLAG VARCHAR2 (1)
Disallow New Releases. Possible Values: Y/N
BLANKET_MAX_AMOUNT NUMBER

Maximum Currency amount allowed for Sales Agreement
BLANKET_MIN_AMOUNT NUMBER

Minimum Currency amount allowed for Sales Agreement
ENFORCE_PRICE_LIST_FLAG VARCHAR2 (1)
Defaulting source for flag of same name on OE_BLANEKT_LINE
OVERRIDE_AMOUNT_FLAG VARCHAR2 (1)
Allow Override of min and max amounts on this sales agreement
RELEASED_AMOUNT NUMBER

Current released currency amount
RETURNED_AMOUNT NUMBER

Current returned currency amount.
REVISION_CHANGE_REASON_CODE VARCHAR2 (30)
Stored revision code for sales agreement revision
REVISION_CHANGE_COMMENTS VARCHAR2 (2000)
Stored comments for sales agreement revision
REVISION_CHANGE_DATE DATE

Date revision occurred.
ENFORCE_ACCOUNTING_RULE_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
ENFORCE_INVOICING_RULE_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
ENFORCE_SHIP_TO_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
ENFORCE_INVOICE_TO_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
ENFORCE_FREIGHT_TERM_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
ENFORCE_SHIPPING_METHOD_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
ENFORCE_PAYMENT_TERM_FLAG VARCHAR2 (1) Yes Defaulting source for flag,of same name on OE_BLANKET_LINES
SALES_DOCUMENT_TYPE_CODE VARCHAR2 (30)
Defaulting source for flag,of same name on OE_BLANKET_LINES
FULFILLED_AMOUNT NUMBER

Current fulfilled currency amount
SALES_DOCUMENT_NAME VARCHAR2 (240)
Stores Quote Name for Orders under negotiation.
TRANSACTION_PHASE_CODE VARCHAR2 (30)
Indicates if Transaction is in negotitation or fulfillment phase.
USER_STATUS_CODE VARCHAR2 (30)
User entered status
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
SOLD_TO_SITE_USE_ID NUMBER

Customer Location
DRAFT_SUBMITTED_FLAG VARCHAR2 (1)
Internal Use only
SOURCE_DOCUMENT_VERSION_NUMBER NUMBER

Internal Use only
QUOTE_NUMBER NUMBER

This is populated for Orders under negotiation
QUOTE_DATE DATE

Populated using defaulting rules.
NEW_PRICE_LIST_ID NUMBER

New price list ID
NEW_MODIFIER_LIST_ID NUMBER

Pricing Modifier list id
DEFAULT_DISCOUNT_PERCENT NUMBER

Pricing Modifier related discount percent amount
DEFAULT_DISCOUNT_AMOUNT NUMBER

Pricing Modifier related discount amount
AUDIT_FLAG VARCHAR2 (1)
Audit flag
VERSION_FLAG VARCHAR2 (1)
Version flag
PHASE_CHANGE_FLAG VARCHAR2 (1)
Phase Change Flag
REASON_ID NUMBER

Reason Id
ORDER_FIRMED_DATE DATE

Order Firmed Date
INST_ID NUMBER

RAC INSTANCE AFFINITY for context setting
Query Text

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


SELECT HEADER_ID
,      HIST_CREATION_DATE
,      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
,      ATTRIBUTE16
,      ATTRIBUTE17
,      GLOBAL_ATTRIBUTE_CATEGORY
,      ATTRIBUTE18
,      ATTRIBUTE19
,      GLOBAL_ATTRIBUTE1
,      ATTRIBUTE20
,      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
,      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
,      REASON_CODE
,      HIST_COMMENTS
,      HIST_TYPE_CODE
,      HIST_CREATED_BY
,      RESPONSIBILITY_ID
,      PRICE_REQUEST_CODE
,      ACCOUNTING_RULE_DURATION
,      ITEM_RELATIONSHIP_TYPE
,      BLANKET_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ON_HOLD_FLAG
,      BLANKET_MAX_AMOUNT
,      BLANKET_MIN_AMOUNT
,      ENFORCE_PRICE_LIST_FLAG
,      OVERRIDE_AMOUNT_FLAG
,      RELEASED_AMOUNT
,      RETURNED_AMOUNT
,      REVISION_CHANGE_REASON_CODE
,      REVISION_CHANGE_COMMENTS
,      REVISION_CHANGE_DATE
,      ENFORCE_ACCOUNTING_RULE_FLAG
,      ENFORCE_INVOICING_RULE_FLAG
,      ENFORCE_SHIP_TO_FLAG
,      ENFORCE_INVOICE_TO_FLAG
,      ENFORCE_FREIGHT_TERM_FLAG
,      ENFORCE_SHIPPING_METHOD_FLAG
,      ENFORCE_PAYMENT_TERM_FLAG
,      SALES_DOCUMENT_TYPE_CODE
,      FULFILLED_AMOUNT
,      SALES_DOCUMENT_NAME
,      TRANSACTION_PHASE_CODE
,      USER_STATUS_CODE
,      SUPPLIER_SIGNATURE
,      SUPPLIER_SIGNATURE_DATE
,      CUSTOMER_SIGNATURE
,      CUSTOMER_SIGNATURE_DATE
,      SOLD_TO_SITE_USE_ID
,      DRAFT_SUBMITTED_FLAG
,      SOURCE_DOCUMENT_VERSION_NUMBER
,      QUOTE_NUMBER
,      QUOTE_DATE
,      NEW_PRICE_LIST_ID
,      NEW_MODIFIER_LIST_ID
,      DEFAULT_DISCOUNT_PERCENT
,      DEFAULT_DISCOUNT_AMOUNT
,      AUDIT_FLAG
,      VERSION_FLAG
,      PHASE_CHANGE_FLAG
,      REASON_ID
,      ORDER_FIRMED_DATE
,      INST_ID
FROM ONT.OE_BLANKET_HEADERS_HIST;

Dependencies

[top of page]

ONT.OE_BLANKET_HEADERS_HIST does not reference any database object

ONT.OE_BLANKET_HEADERS_HIST is referenced by following:

SchemaONT
ViewOE_BLANKET_HEADERS_HIST#