[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_PRICE_ATTS_IFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_PRICE_ATTS_IFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
This is a multi-org Interface table to populate OE_ORDER_PRICE_ATTRIBS. This table stores pricing attributes information that is imported from a feeder system into Oracle Order Management using Order Import.For more information on Order Import refer to the Oracle Manufacturing APIs and Open Interfaces Manual.
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Pricing Attributes Interface
Category: BUSINESS_ENTITY ONT_SALES_ORDER
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_PRICE_ATTS_IFACE_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
|
| OE_PRICE_ATTS_IFACE_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
ORIG_SYS_SHIPMENT_REF
SOLD_TO_ORG_ID
SOLD_TO_ORG
ORIG_SYS_ATTS_REF
CHANGE_SEQUENCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORDER_SOURCE_ID | NUMBER | Order Source | ||
| ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original System Document | |
| ORIG_SYS_LINE_REF | VARCHAR2 | (50) | ORIGINAL System Line | |
| ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Shipment Reference of the Original Order | |
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Change Sequence | |
| CHANGE_REQUEST_CODE | VARCHAR2 | (30) | Change request Code | |
| ORG_ID | NUMBER | OPERATing Unit | ||
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | 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 | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE11 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE12 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE13 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE14 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE15 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE16 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE17 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE18 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE19 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE20 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE21 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE22 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE23 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE24 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE25 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE26 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE27 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE28 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE29 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE30 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE31 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE32 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE33 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE34 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE35 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE36 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE37 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE38 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE39 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE40 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE41 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE42 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE43 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE44 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE45 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE46 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE47 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE48 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE49 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE50 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE51 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE52 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE53 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE54 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE55 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE56 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE57 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE58 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE59 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE60 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE61 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE62 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE63 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE64 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE65 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE66 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE67 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE68 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE69 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE70 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE71 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE72 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE73 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE74 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE75 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE76 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE77 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE78 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE79 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE80 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE81 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE82 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE83 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE84 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE85 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE86 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE87 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE88 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE89 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE90 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE91 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE92 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE93 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE94 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE95 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE96 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE97 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE98 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE99 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE100 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| 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 | |
| OPERATION_CODE | VARCHAR2 | (30) | Operation Code | |
| ERROR_FLAG | VARCHAR2 | (1) | Error Flag | |
| STATUS_FLAG | VARCHAR2 | (1) | Status Flag | |
| INTERFACE_STATUS | VARCHAR2 | (1000) | Interface Status | |
| FLEX_TITLE | VARCHAR2 | (60) | Flex name of the flex structure to which the pricing context belongs | |
| ORIG_SYS_ATTS_REF | VARCHAR2 | (50) | To identified the data in the OE_PRICE_ATTS_IFACE_ALL table. To support the Order Import Functionality. | |
| ORDER_PRICE_ATTRIB_ID | NUMBER | Foreign Key to OE_ORDER_PRICE_ATTRIBS table, only applicable for delete operation. | ||
| OVERRIDE_FLAG | VARCHAR2 | (1) | Only Applicable to "Asked For" promotion in which a modifier is sent in as a pricing attribute. | |
| SOLD_TO_ORG | VARCHAR2 | (360) | Sold to Org | |
| SOLD_TO_ORG_ID | NUMBER | Sold to Org Id |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, CHANGE_SEQUENCE
, CHANGE_REQUEST_CODE
, ORG_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, PRICING_ATTRIBUTE16
, PRICING_ATTRIBUTE17
, PRICING_ATTRIBUTE18
, PRICING_ATTRIBUTE19
, PRICING_ATTRIBUTE20
, PRICING_ATTRIBUTE21
, PRICING_ATTRIBUTE22
, PRICING_ATTRIBUTE23
, PRICING_ATTRIBUTE24
, PRICING_ATTRIBUTE25
, PRICING_ATTRIBUTE26
, PRICING_ATTRIBUTE27
, PRICING_ATTRIBUTE28
, PRICING_ATTRIBUTE29
, PRICING_ATTRIBUTE30
, PRICING_ATTRIBUTE31
, PRICING_ATTRIBUTE32
, PRICING_ATTRIBUTE33
, PRICING_ATTRIBUTE34
, PRICING_ATTRIBUTE35
, PRICING_ATTRIBUTE36
, PRICING_ATTRIBUTE37
, PRICING_ATTRIBUTE38
, PRICING_ATTRIBUTE39
, PRICING_ATTRIBUTE40
, PRICING_ATTRIBUTE41
, PRICING_ATTRIBUTE42
, PRICING_ATTRIBUTE43
, PRICING_ATTRIBUTE44
, PRICING_ATTRIBUTE45
, PRICING_ATTRIBUTE46
, PRICING_ATTRIBUTE47
, PRICING_ATTRIBUTE48
, PRICING_ATTRIBUTE49
, PRICING_ATTRIBUTE50
, PRICING_ATTRIBUTE51
, PRICING_ATTRIBUTE52
, PRICING_ATTRIBUTE53
, PRICING_ATTRIBUTE54
, PRICING_ATTRIBUTE55
, PRICING_ATTRIBUTE56
, PRICING_ATTRIBUTE57
, PRICING_ATTRIBUTE58
, PRICING_ATTRIBUTE59
, PRICING_ATTRIBUTE60
, PRICING_ATTRIBUTE61
, PRICING_ATTRIBUTE62
, PRICING_ATTRIBUTE63
, PRICING_ATTRIBUTE64
, PRICING_ATTRIBUTE65
, PRICING_ATTRIBUTE66
, PRICING_ATTRIBUTE67
, PRICING_ATTRIBUTE68
, PRICING_ATTRIBUTE69
, PRICING_ATTRIBUTE70
, PRICING_ATTRIBUTE71
, PRICING_ATTRIBUTE72
, PRICING_ATTRIBUTE73
, PRICING_ATTRIBUTE74
, PRICING_ATTRIBUTE75
, PRICING_ATTRIBUTE76
, PRICING_ATTRIBUTE77
, PRICING_ATTRIBUTE78
, PRICING_ATTRIBUTE79
, PRICING_ATTRIBUTE80
, PRICING_ATTRIBUTE81
, PRICING_ATTRIBUTE82
, PRICING_ATTRIBUTE83
, PRICING_ATTRIBUTE84
, PRICING_ATTRIBUTE85
, PRICING_ATTRIBUTE86
, PRICING_ATTRIBUTE87
, PRICING_ATTRIBUTE88
, PRICING_ATTRIBUTE89
, PRICING_ATTRIBUTE90
, PRICING_ATTRIBUTE91
, PRICING_ATTRIBUTE92
, PRICING_ATTRIBUTE93
, PRICING_ATTRIBUTE94
, PRICING_ATTRIBUTE95
, PRICING_ATTRIBUTE96
, PRICING_ATTRIBUTE97
, PRICING_ATTRIBUTE98
, PRICING_ATTRIBUTE99
, PRICING_ATTRIBUTE100
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OPERATION_CODE
, ERROR_FLAG
, STATUS_FLAG
, INTERFACE_STATUS
, FLEX_TITLE
, ORIG_SYS_ATTS_REF
, ORDER_PRICE_ATTRIB_ID
, OVERRIDE_FLAG
, SOLD_TO_ORG
, SOLD_TO_ORG_ID
FROM ONT.OE_PRICE_ATTS_IFACE_ALL;
ONT.OE_PRICE_ATTS_IFACE_ALL does not reference any database object
ONT.OE_PRICE_ATTS_IFACE_ALL is referenced by following:
APPS
OE_PRICE_ATTS_IFACE_ALL
OE_PRICE_ATTS_INTERFACE
|
|
|
|