[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTER_PROPERTIES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTER_PROPERTIES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
A supplementary view used to simplify forms coding. This view will show the translated name and description based on the user preferred language. This view will also show all the counter properties that are associated to the counter instance.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTER_PROPERTY_ID | NUMBER | Yes | Counter property identifier | |
NAME | VARCHAR2 | (50) | Yes | Counter property name |
DESCRIPTION | VARCHAR2 | (240) | Counter property description | |
COUNTER_ID | NUMBER | Yes | Counter identifier | |
PROPERTY_DATA_TYPE | VARCHAR2 | (30) | Yes | Property data type |
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 | ||
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 | |
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
MIGRATED_FLAG | VARCHAR2 | (1) | Flag to indicate if this is a migrated record | |
PROPERTY_LOV_TYPE | VARCHAR2 | (30) | Property LOV type | |
SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
CREATED_FROM_CTR_PROP_TMPL_ID | NUMBER | Created from counter property identifier |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_PROPERTY_ID
, NAME
, DESCRIPTION
, COUNTER_ID
, PROPERTY_DATA_TYPE
, IS_NULLABLE
, DEFAULT_VALUE
, MINIMUM_VALUE
, MAXIMUM_VALUE
, UOM_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, MIGRATED_FLAG
, PROPERTY_LOV_TYPE
, SECURITY_GROUP_ID
, CREATED_FROM_CTR_PROP_TMPL_ID
FROM APPS.CSI_COUNTER_PROPERTIES_VL;
|
|
|