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

VIEW: APPS.OE_ORDER_PRICE_ATTRIBS_V

Object Details
Object Name: OE_ORDER_PRICE_ATTRIBS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_ORDER_PRICE_ATTRIBS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_PRICE_ATTRIB_ID NUMBER
Yes System Generated ID
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
ORIG_SYS_ATTS_REF VARCHAR2 (50)
FLEX_TITLE VARCHAR2 (60) Yes Flex_name of the flex Structure to which the pricing_context belongs
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
LOCK_CONTROL NUMBER

Internal use only.
Query Text

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


SELECT ORDER_PRICE_ATTRIB_ID
,      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
,      ORIG_SYS_ATTS_REF
,      FLEX_TITLE
,      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
,      LOCK_CONTROL
FROM APPS.OE_ORDER_PRICE_ATTRIBS_V;

Dependencies

[top of page]

APPS.OE_ORDER_PRICE_ATTRIBS_V references the following:

SchemaAPPS
SynonymOE_ORDER_PRICE_ATTRIBS
APPS.OE_ORDER_PRICE_ATTRIBS_V is referenced by following:

SchemaAPPS
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code