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


TABLE: ONT.OE_ORDER_PRICE_ATTRIBS

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


This table stores pricing attributes and asked for promotions, deals and coupon number entered by the user.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_ORDER_PRICE_ATTRIBS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_PRICE_ATTRIB_ID
OE_ORDER_PRICE_ATTRIBS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
OE_ORDER_PRICE_ATTRIBS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Order Header Id
LINE_ID NUMBER

Line Id
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) Yes 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
FLEX_TITLE VARCHAR2 (60) Yes Flex_name of the flex Structure to which the pricing_context belongs
ORDER_PRICE_ATTRIB_ID NUMBER
Yes System Generated ID
OVERRIDE_FLAG VARCHAR2 (1)
Override the search engine selection for Asked for promotion/deals
LOCK_CONTROL NUMBER

Internal use only.
ORIG_SYS_ATTS_REF VARCHAR2 (50)
Org system attribute reference.
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
,      LINE_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
,      FLEX_TITLE
,      ORDER_PRICE_ATTRIB_ID
,      OVERRIDE_FLAG
,      LOCK_CONTROL
,      ORIG_SYS_ATTS_REF
,      INST_ID
FROM ONT.OE_ORDER_PRICE_ATTRIBS;

Dependencies

[top of page]

ONT.OE_ORDER_PRICE_ATTRIBS does not reference any database object

ONT.OE_ORDER_PRICE_ATTRIBS is referenced by following:

SchemaONT
ViewOE_ORDER_PRICE_ATTRIBS#