[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTER_TEMPLATE_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTER_TEMPLATE_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 setup information for a counter template that will be used during the counter instantiation process.
This view will show the translated name and description based on the user preferred language and help them identify what counter type, reading type, UOM and if a rollover is permitted to the counter template.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTER_ID | NUMBER | Yes | Auto generate internal primary key | |
GROUP_ID | NUMBER | Group Identifier | ||
NAME | VARCHAR2 | (80) | Yes | Counter template name |
DESCRIPTION | VARCHAR2 | (240) | Counter template description | |
COUNTER_TYPE | VARCHAR2 | (30) | Counter Type | |
INITIAL_READING | NUMBER | Counter Initial Reading | ||
STEP_VALUE | NUMBER | Step Value | ||
TOLERANCE_PLUS | NUMBER | Tolerance Plus % | ||
TOLERANCE_MINUS | NUMBER | Tolerance Minus % | ||
UOM_CODE | VARCHAR2 | (3) | Unit of Measure Code | |
DERIVE_COUNTER_ID | NUMBER | Derive Counter ID | ||
DERIVE_FUNCTION | VARCHAR2 | (30) | Derive Function | |
DERIVE_PROPERTY_ID | NUMBER | Derive Property ID | ||
VALID_FLAG | VARCHAR2 | (1) | Indicator to check if the formula counter and derived filters are valid | |
FORMULA_INCOMPLETE_FLAG | VARCHAR2 | (1) | Indicator to check if formula is complete | |
FORMULA_TEXT | VARCHAR2 | (1996) | Text for the Formula Counter Type | |
ROLLOVER_LAST_READING | NUMBER | Rollover from value | ||
ROLLOVER_FIRST_READING | NUMBER | Rollover to value | ||
USAGE_ITEM_ID | NUMBER | Usage Item Identifier | ||
CTR_VAL_MAX_SEQ_NO | NUMBER | Yes | Counter value maximum sequence no | |
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 | |
ATTRIBUTE16 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE21 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE22 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE23 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE24 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE25 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE26 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE27 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE28 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE29 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE30 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
MIGRATED_FLAG | VARCHAR2 | (1) | Indicator flag to check if this record is a migrated record | |
CUSTOMER_VIEW | VARCHAR2 | (1) | Customer view indicator | |
DIRECTION | VARCHAR2 | (1) | Counter direction | |
FILTER_TYPE | VARCHAR2 | (30) | Counter filter type | |
FILTER_READING_COUNT | NUMBER | Filter reading count | ||
FILTER_TIME_UOM | VARCHAR2 | (30) | Filter time UOM code | |
ESTIMATION_ID | NUMBER | Estimation identifier | ||
READING_TYPE | NUMBER | Counter reading type | ||
AUTOMATIC_ROLLOVER | VARCHAR2 | (1) | Automatic rollover flag | |
DEFAULT_USAGE_RATE | NUMBER | Default usage rate | ||
USE_PAST_READING | NUMBER | Use past reading | ||
USED_IN_SCHEDULING | VARCHAR2 | (1) | Used in scheduling | |
DEFAULTED_GROUP_ID | NUMBER | Internally generated counter group ID | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier | ||
COMMENTS | VARCHAR2 | (1996) | Counter additional information | |
INITIAL_READING_DATE | DATE | Counter Initial Reading Date | ||
ASSOCIATION_TYPE | VARCHAR2 | (30) | Association Type | |
TIME_BASED_MANUAL_ENTRY | VARCHAR2 | (1) | Indicator to allow user to enter readings for Time Based Counter | |
EAM_REQUIRED_FLAG | VARCHAR2 | (1) | Indicator if the counter/meter is a failure counter/meter. |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_ID
, GROUP_ID
, NAME
, DESCRIPTION
, COUNTER_TYPE
, INITIAL_READING
, STEP_VALUE
, TOLERANCE_PLUS
, TOLERANCE_MINUS
, UOM_CODE
, DERIVE_COUNTER_ID
, DERIVE_FUNCTION
, DERIVE_PROPERTY_ID
, VALID_FLAG
, FORMULA_INCOMPLETE_FLAG
, FORMULA_TEXT
, ROLLOVER_LAST_READING
, ROLLOVER_FIRST_READING
, USAGE_ITEM_ID
, CTR_VAL_MAX_SEQ_NO
, 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
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
, MIGRATED_FLAG
, CUSTOMER_VIEW
, DIRECTION
, FILTER_TYPE
, FILTER_READING_COUNT
, FILTER_TIME_UOM
, ESTIMATION_ID
, READING_TYPE
, AUTOMATIC_ROLLOVER
, DEFAULT_USAGE_RATE
, USE_PAST_READING
, USED_IN_SCHEDULING
, DEFAULTED_GROUP_ID
, SECURITY_GROUP_ID
, COMMENTS
, INITIAL_READING_DATE
, ASSOCIATION_TYPE
, TIME_BASED_MANUAL_ENTRY
, EAM_REQUIRED_FLAG
FROM APPS.CSI_COUNTER_TEMPLATE_VL;
|
|
|