[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_BLANKET_HEADERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_BLANKET_HEADERS_ALL
|
| Subobject Name: | |
| Status: | VALID |
(Attributes common between sales order and sales agreements)
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_BLANKET_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 HEADER_ID
|
| OE_BLANKET_HEADERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ORDER_NUMBER
ORDER_TYPE_ID
|
| OE_BLANKET_HEADERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOLD_TO_ORG_ID
|
| OE_BLANKET_HEADERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_ORG_ID
|
| OE_BLANKET_HEADERS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_TO_ORG_ID
|
| OE_BLANKET_HEADERS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUST_PO_NUMBER
|
| OE_BLANKET_HEADERS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORIG_SYS_DOCUMENT_REF
ORDER_SOURCE_ID
|
| OE_BLANKET_HEADERS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OPEN_FLAG
|
| OE_BLANKET_HEADERS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| OE_BLANKET_HEADERS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SALES_DOCUMENT_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HEADER_ID | NUMBER | Yes | Sales Agreement Header Identifier | |
| ORG_ID | NUMBER | Operating Unit which performed this transaction | ||
| ORDER_TYPE_ID | NUMBER | Yes | Sales Agreement Transaction Type identifier | |
| ORDER_NUMBER | NUMBER | Yes | User-Visibile number of the sales agreement | |
| VERSION_NUMBER | NUMBER | Yes | 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 the 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 | 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 | 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 | |
| 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 | |
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segement | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segement | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segement | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segement | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segement | |
| CANCELLED_FLAG | VARCHAR2 | (1) | Not used | |
| OPEN_FLAG | VARCHAR2 | (1) | Yes | Not Used |
| BOOKED_FLAG | VARCHAR2 | (1) | Yes | 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) | Yes | Sales Agreement Category Code |
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Not Used | |
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Not Used | |
| CUSTOMER_PAYMENT_TERM_ID | NUMBER | Not Used | ||
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping Instructions for Sales Agreement | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions for 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. | ||
| PRICE_REQUEST_CODE | VARCHAR2 | (240) | Not Used | |
| BATCH_ID | NUMBER | Not Used | ||
| XML_MESSAGE_ID | NUMBER | Not Used | ||
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | Not Used | |
| BLANKET_NUMBER | NUMBER | Not Used | ||
| SALES_DOCUMENT_TYPE_CODE | VARCHAR2 | (30) | For Future release | |
| 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. | ||
| ORDER_FIRMED_DATE | DATE | Order Firmed Date | ||
| INST_ID | NUMBER | RAC INSTANCE AFFINITY for context setting |
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
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, 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
, BLANKET_NUMBER
, SALES_DOCUMENT_TYPE_CODE
, 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
, ORDER_FIRMED_DATE
, INST_ID
FROM ONT.OE_BLANKET_HEADERS_ALL;
ONT.OE_BLANKET_HEADERS_ALL does not reference any database object
ONT.OE_BLANKET_HEADERS_ALL is referenced by following:
ONT
OE_BLANKET_HEADERS_ALL#
|
|
|
|