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

TABLE: CSI.CSI_I_PRICING_ATTRIBS

Object Details
Object Name: CSI_I_PRICING_ATTRIBS
Object Type: TABLE
Owner: CSI
FND Design Data: TableCSI.CSI_I_PRICING_ATTRIBS
Subobject Name:
Status: VALID


This table holds the Instance Pricing Attributes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_I_PRICING_ATTRIBS_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICING_ATTRIBUTE_ID
CSI_I_PRICING_ATTRIBS_U02 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_ID
ColumnPRICING_CONTEXT
CSI_I_PRICING_ATTRIBS_N02 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
PRICING_ATTRIBUTE_ID NUMBER
Yes Pricing Attribute Identifier
INSTANCE_ID NUMBER
Yes Instance Identifier
ACTIVE_START_DATE DATE

Activation Start Date
ACTIVE_END_DATE DATE

Activation End Date
PRICING_CONTEXT VARCHAR2 (30)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE1 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE2 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE3 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE4 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE5 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE6 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE7 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE8 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE9 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE10 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE11 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE12 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE13 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE14 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE15 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE16 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE17 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE18 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE19 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE20 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE21 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE22 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE23 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE24 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE25 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE26 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE27 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE28 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE29 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE30 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE31 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE32 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE33 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE34 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE35 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE36 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE37 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE38 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE39 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE40 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE41 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE42 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE43 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE44 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE45 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE46 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE47 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE48 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE49 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE50 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE51 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE52 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE53 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE54 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE55 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE56 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE57 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE58 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE59 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE60 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE61 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE62 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE63 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE64 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE65 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE66 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE67 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE68 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE69 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE70 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE71 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE72 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE73 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE74 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE75 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE76 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE77 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE78 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE79 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE80 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE81 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE82 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE83 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE84 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE85 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE86 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE87 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE88 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE89 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE90 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE91 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE92 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE93 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE94 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE95 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE96 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE97 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE98 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE99 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
PRICING_ATTRIBUTE100 VARCHAR2 (150)
Pricing Attribute Flexfield Columns
CONTEXT VARCHAR2 (30)
Standard DFF Columns
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Columns
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Columns
CREATED_BY NUMBER (15) Yes Standard WHO Columns
CREATION_DATE DATE
Yes Standard WHO Columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Columns
LAST_UPDATE_DATE DATE
Yes Standard WHO Columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Columns
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
SECURITY_GROUP_ID NUMBER

Security Group Identifier
MIGRATED_FLAG VARCHAR2 (1)
Flag indicating if the row is created as a part of migration.
Query Text

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


SELECT PRICING_ATTRIBUTE_ID
,      INSTANCE_ID
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      MIGRATED_FLAG
FROM CSI.CSI_I_PRICING_ATTRIBS;

Dependencies

[top of page]

CSI.CSI_I_PRICING_ATTRIBS does not reference any database object

CSI.CSI_I_PRICING_ATTRIBS is referenced by following:

SchemaCSI
ViewCSI_I_PRICING_ATTRIBS#