[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_COUNTERS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CSI.CSI_COUNTERS_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
A supplementary view used to simplify forms coding. This view language contains the attributes of the instantiated counters that is associated to the Item Instance or the Service Contract Lines.
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 counters.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COUNTER_ID | NUMBER | Yes | Auto generate internal primary key | |
| GROUP_ID | NUMBER | Group Identifier | ||
| NAME | VARCHAR2 | (80) | Yes | Counter name |
| DESCRIPTION | VARCHAR2 | (240) | Counter 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 | ||
| CREATED_FROM_COUNTER_TMPL_ID | NUMBER | Counter template ID to which this counter is copied | ||
| COMMENTS | VARCHAR2 | (1996) | Counter additional information | |
| INITIAL_READING_DATE | DATE | Counter Initial Reading Date | ||
| 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. | |
| COUNTER_TEMPLATE_NAME | VARCHAR2 | (80) | Counter name without the counter id suffix |
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
, CREATED_FROM_COUNTER_TMPL_ID
, COMMENTS
, INITIAL_READING_DATE
, TIME_BASED_MANUAL_ENTRY
, EAM_REQUIRED_FLAG
, COUNTER_TEMPLATE_NAME
FROM APPS.CSI_COUNTERS_VL;
APPS
CSI_COUNTERS_B
CSI_COUNTERS_TL
APPS
AHL_COMPLETIONS_PVT
- show dependent code
AHL_COMPLEX_MX_PVT
- show dependent code
AHL_FLEET_UTIL_HISTORY_PVT
- show dependent code
AHL_MM_MTL_MGT_PVT
- show dependent code
AHL_PRD_DF_PVT
- show dependent code
AHL_PRD_PRINT_PVT
- show dependent code
AHL_RA_ANALYSER_PVT
- show dependent code
AHL_REPORT_UTILS_PVT
- show dependent code
AHL_UC_UTILIZATION_PVT
- show dependent code
AHL_UMP_PROCESSUNIT_PVT
- show dependent code
AHL_UMP_SMRINSTANCE_PVT
- show dependent code
AHL_UMP_UNITMAINT_PVT
- show dependent code
AHL_WARRANTY_CONTRACTS_PVT
- show dependent code
CSI_COUNTERS_BC_V
CSI_COUNTERS_V
CSI_COUNTER_PVT
- show dependent code
CSI_COUNTER_READINGS_PVT
- show dependent code
CSI_COUNTER_READINGS_V
CSI_COUNTER_TEMPLATE_PVT
- show dependent code
CSI_COUNTER_VALUES_V
CSI_CP_COUNTERS_V
CSI_CTR_ESTIMATE_METHODS_V
CSI_CTR_INTERFACE_PUB
- show dependent code
CSI_CTR_RELATIONSHIPS_V
MTL_BILLING_RULE_LINES_V
OKL_UBB_PVT
- show dependent code
OKL_VSS_WF
- show dependent code
QA_PLAN_ELEMENT_API
- show dependent code
|
|
|
|