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


TABLE: CSI.CSI_COUNTER_PROPERTIES_B

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


CSI_COUNTER_PROPERTIES_B holds the user defined properties that is associated to the counter instance. A counter instance may or may not have a counter properties.
The property lov type if entered are validated against the 'CSI_CTR_PROPERTY_LOV_TYPE' lookups.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_COUNTER_PROPERTIES_B_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTER_PROPERTY_ID
CSI_COUNTER_PROPERTIES_B_N01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTER_ID
Columns
Name Datatype Length Mandatory Comments
COUNTER_PROPERTY_ID NUMBER
Yes Counter property identifier
COUNTER_ID NUMBER
Yes Counter identifier
PROPERTY_DATA_TYPE VARCHAR2 (30) Yes Property data type
PROPERTY_LOV_TYPE VARCHAR2 (30)
Property LOV type
CREATED_FROM_CTR_PROP_TMPL_ID NUMBER

Created from counter property identifier
IS_NULLABLE VARCHAR2 (1)
Nullable flag indicator
DEFAULT_VALUE VARCHAR2 (240)
Property default value
MINIMUM_VALUE VARCHAR2 (240)
Property minimum value
MAXIMUM_VALUE VARCHAR2 (240)
Property maximum value
UOM_CODE VARCHAR2 (3)
Unit of Measure Code
START_DATE_ACTIVE DATE

Activation start date
END_DATE_ACTIVE DATE

Activation end date
SECURITY_GROUP_ID NUMBER

Security group identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
MIGRATED_FLAG VARCHAR2 (1)
Flag to indicate if this is a migrated record
Query Text

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


SELECT COUNTER_PROPERTY_ID
,      COUNTER_ID
,      PROPERTY_DATA_TYPE
,      PROPERTY_LOV_TYPE
,      CREATED_FROM_CTR_PROP_TMPL_ID
,      IS_NULLABLE
,      DEFAULT_VALUE
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      UOM_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MIGRATED_FLAG
FROM CSI.CSI_COUNTER_PROPERTIES_B;

Dependencies

[top of page]

CSI.CSI_COUNTER_PROPERTIES_B does not reference any database object

CSI.CSI_COUNTER_PROPERTIES_B is referenced by following:

SchemaAPPS
SynonymCSI_COUNTER_PROPERTIES_B