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

TABLE: CSI.CSI_CTR_READINGS_INTERFACE

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


This is the Open Interface table for Counter Readings Open Interface that contains different types of Counter Readings for the Counters. These readings could come from different sources identified by the Source_Transaction_Type. These readings are read in the ascending order of Value_TimeStamp and Counter_ID based on the input parameter Batch_Name and Source_Transaction_Date. Further processing is done by calling the Counter Readings API.
Scope: public
Product: CSI
Lifecycle: active
Display Name: CSI Counter Readings Interface
Category: BUSINESS_ENTITY CSI_COUNTER


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_CTR_READINGS_INTERFACE_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTER_INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
COUNTER_INTERFACE_ID NUMBER
Yes Internally generated primary key
PARALLEL_WORKER_ID NUMBER

Parallel worker identifier
BATCH_NAME VARCHAR2 (30) Yes Batch name
SOURCE_TRANSACTION_DATE DATE
Yes Source transaction date
PROCESS_STATUS VARCHAR2 (1)
Processing status
ERROR_TEXT VARCHAR2 (240)
Error messages
COUNTER_VALUE_ID NUMBER

Counter value identifier
COUNTER_ID NUMBER
Yes Counter identifier
VALUE_TIMESTAMP DATE
Yes Counter reading capture date
COUNTER_READING NUMBER

Counter readings
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
NET_READING NUMBER

Net readings
LIFE_TO_DATE_READING NUMBER

Life to date readings
AUTOMATIC_ROLLOVER_FLAG VARCHAR2 (1)
Flag indicating if the counter readings need to be rollovered automatically
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
DISABLED_FLAG VARCHAR2 (1)
Flag indicating if the counter reading is disabled
COMMENTS VARCHAR2 (1996)
Counter readings additional information
SECURITY_GROUP_ID NUMBER

Security Group Identifier
OBJECT_VERSION_NUMBER NUMBER

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
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
SOURCE_TRANSACTION_TYPE_ID NUMBER
Yes Source transaction type identifier
SOURCE_TRANSACTION_ID NUMBER
Yes Source transaction identifier
SOURCE_CODE VARCHAR2 (30)
Source type
SOURCE_LINE_ID NUMBER

Source line identifier
RESET_COUNTER_READING NUMBER

Reset counter reading
COUNTER_NAME VARCHAR2 (50)
Counter name
Query Text

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


SELECT COUNTER_INTERFACE_ID
,      PARALLEL_WORKER_ID
,      BATCH_NAME
,      SOURCE_TRANSACTION_DATE
,      PROCESS_STATUS
,      ERROR_TEXT
,      COUNTER_VALUE_ID
,      COUNTER_ID
,      VALUE_TIMESTAMP
,      COUNTER_READING
,      RESET_MODE
,      RESET_REASON
,      ADJUSTMENT_TYPE
,      ADJUSTMENT_READING
,      NET_READING
,      LIFE_TO_DATE_READING
,      AUTOMATIC_ROLLOVER_FLAG
,      INCLUDE_TARGET_RESETS
,      SOURCE_COUNTER_VALUE_ID
,      DISABLED_FLAG
,      COMMENTS
,      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
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      SOURCE_TRANSACTION_TYPE_ID
,      SOURCE_TRANSACTION_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      RESET_COUNTER_READING
,      COUNTER_NAME
FROM CSI.CSI_CTR_READINGS_INTERFACE;

Dependencies

[top of page]

CSI.CSI_CTR_READINGS_INTERFACE does not reference any database object

CSI.CSI_CTR_READINGS_INTERFACE is referenced by following:

SchemaAPPS
SynonymCSI_CTR_READINGS_INTERFACE