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

TABLE: ASO.ASO_PRICE_ATTRIBUTES

Object Details
Object Name: ASO_PRICE_ATTRIBUTES
Object Type: TABLE
Owner: ASO
FND Design Data: TableASO.ASO_PRICE_ATTRIBUTES
Subobject Name:
Status: VALID


This table stores information on qualifiers and pricing attributes, which the corresponding price adjustment line qualified for.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASO_PRICE_ATTRIBUTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_ATTRIBUTE_ID
ASO_PRICE_ATTRIBUTES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUOTE_HEADER_ID
ASO_PRICE_ATTRIBUTES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUOTE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
PRICE_ATTRIBUTE_ID NUMBER
Yes Unique Identifier
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
QUOTE_HEADER_ID NUMBER
Yes foreign key from quote headers
QUOTE_LINE_ID NUMBER

Quote Line Identifier
FLEX_TITLE VARCHAR2 (60)
Flex Title
PRICING_CONTEXT VARCHAR2 (30) Yes Pricing Descriptive Flex Field
PRICING_ATTRIBUTE1 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE2 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE3 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE4 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE5 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE6 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE7 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE8 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE9 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE10 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE11 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE12 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE13 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE14 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE15 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE16 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE17 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE18 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE19 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE20 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE21 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE22 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE23 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE24 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE25 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE26 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE27 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE28 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE29 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE30 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE31 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE32 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE33 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE34 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE35 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE36 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE37 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE38 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE39 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE40 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE41 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE42 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE43 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE44 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE45 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE46 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE47 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE48 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE49 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE50 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE51 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE52 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE53 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE54 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE55 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE56 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE57 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE58 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE59 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE60 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE61 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE62 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE63 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE64 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE65 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE66 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE67 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE68 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE69 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE70 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE71 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE72 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE73 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE74 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE75 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE76 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE77 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE78 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE79 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE80 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE81 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE82 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE83 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE84 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE85 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE86 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE87 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE88 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE89 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE90 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE91 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE92 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE93 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE94 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE95 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE96 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE97 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE98 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE99 VARCHAR2 (240)
Pricing Descriptive Flex Field
PRICING_ATTRIBUTE100 VARCHAR2 (240)
Pricing Descriptive Flex Field
CONTEXT VARCHAR2 (30)
Descriptive Flex Field
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
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Used in hosted environments
OVERRIDE_FLAG VARCHAR2 (1)
This flag tell whether we can override the values or not
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
Query Text

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


SELECT PRICE_ATTRIBUTE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      QUOTE_HEADER_ID
,      QUOTE_LINE_ID
,      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
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      OVERRIDE_FLAG
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM ASO.ASO_PRICE_ATTRIBUTES;

Dependencies

[top of page]

ASO.ASO_PRICE_ATTRIBUTES does not reference any database object

ASO.ASO_PRICE_ATTRIBUTES is referenced by following:

SchemaASO
ViewASO_PRICE_ATTRIBUTES#