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

VIEW: APPS.EAM_CFR_COUNTER_READINGS_V

Object Details
Object Name: EAM_CFR_COUNTER_READINGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEAM.EAM_CFR_COUNTER_READINGS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
COUNTER_VALUE_ID NUMBER

Internally generated primary key
COUNTER_NAME VARCHAR2 (80) Yes Counter name
COUNTER_DESCRIPTION VARCHAR2 (240)
Counter description
INITIAL_READING NUMBER

Initial reading
READING_TYPE NUMBER

Reading type
READING_TYPE_DISP VARCHAR2 (80) Yes Reading type description
UOM_CODE VARCHAR2 (3)
Unit of measure code
DIRECTION VARCHAR2 (1)
Direction
DIRECTION_DISP VARCHAR2 (80) Yes Direction Description
COUNTER_TYPE VARCHAR2 (30)
Counter type
ROLLOVER_LAST_READING NUMBER

Rollover last reading
ROLLOVER_FIRST_READING NUMBER

Rollover first reading
CUSTOMER_VIEW VARCHAR2 (1)
Customer view flag
FILTER_TYPE VARCHAR2 (30)
Filter type
FILTER_TIME_UOM VARCHAR2 (30)
Filter time UOM
GROUP_ID NUMBER

Counter group identifier
COUNTER_ID NUMBER
Yes Counter identifier
VALUE_TIMESTAMP DATE

Counter reading capture date
COUNTER_READING NUMBER

Counter reading
RESET_MODE VARCHAR2 (30)
Counter reset type
RESET_REASON VARCHAR2 (255)
Reason for resetting the counter readings
ADJUSTMENT_TYPE VARCHAR2 (30)
Counter adjustment type
ADJUSTMENT_READING NUMBER

Counter adjustment readings
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER (15)
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
COMMENTS VARCHAR2 (2000)
Counter readings additional information
LIFE_TO_DATE_READING NUMBER

Life to date readings
NET_READING NUMBER

Net readings
DISABLED_FLAG VARCHAR2 (1)
Flag indicating if the counter reading is disabled
AUTOMATIC_ROLLOVER_FLAG VARCHAR2 (1)
Flag indicating if the counter readings need to be rollovered automatically
TRANSACTION_ID NUMBER

Counter readings transaction identifier
INCLUDE_TARGET_RESETS VARCHAR2 (1)
Flag indicating if the counter readings need to include target counters
SOURCE_COUNTER_VALUE_ID NUMBER

Source counter value identifier
READING_BEFORE_RESET NUMBER

Reading Before Reset
READING_AFTER_RESET NUMBER

Reading After Reset
Query Text

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


SELECT COUNTER_VALUE_ID
,      COUNTER_NAME
,      COUNTER_DESCRIPTION
,      INITIAL_READING
,      READING_TYPE
,      READING_TYPE_DISP
,      UOM_CODE
,      DIRECTION
,      DIRECTION_DISP
,      COUNTER_TYPE
,      ROLLOVER_LAST_READING
,      ROLLOVER_FIRST_READING
,      CUSTOMER_VIEW
,      FILTER_TYPE
,      FILTER_TIME_UOM
,      GROUP_ID
,      COUNTER_ID
,      VALUE_TIMESTAMP
,      COUNTER_READING
,      RESET_MODE
,      RESET_REASON
,      ADJUSTMENT_TYPE
,      ADJUSTMENT_READING
,      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
,      COMMENTS
,      LIFE_TO_DATE_READING
,      NET_READING
,      DISABLED_FLAG
,      AUTOMATIC_ROLLOVER_FLAG
,      TRANSACTION_ID
,      INCLUDE_TARGET_RESETS
,      SOURCE_COUNTER_VALUE_ID
,      READING_BEFORE_RESET
,      READING_AFTER_RESET
FROM APPS.EAM_CFR_COUNTER_READINGS_V;

Dependencies

[top of page]

APPS.EAM_CFR_COUNTER_READINGS_V references the following:

SchemaAPPS
PL/SQL PackageCSI_COUNTER_READINGS_PVT - show dependent code
ViewCSI_COUNTER_READINGS_V
ViewCSI_LOOKUPS

APPS.EAM_CFR_COUNTER_READINGS_V is not referenced by any database object