eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CSL.CSL_CS_COUNTER_VALUES_INQ

Object Details

Object Name:	CSL_CS_COUNTER_VALUES_INQ
Object Type:	TABLE
Owner:	CSL
Subobject Name:
Status:	VALID

Inqueue table for CS_COUNTER_VALUES containing data uploaded by mobile clients

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSL_CS_COUNTER_VALUES_INQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANID$$ CLID$$CS SEQNO$$

Columns

Name	Datatype	Length	Comments
CLID$$CS	VARCHAR2	(240)	Mobile username refers to FND_USER
COUNTER_VALUE_ID	NUMBER		The identifier of the counter value.
COUNTER_ID	NUMBER		The identifier of the counter to which this value belongs.
VALUE_TIMESTAMP	DATE		The date on which this counter reading was taken (maybe different from the date on which the reading is enterd in the system).
COUNTER_READING	NUMBER		The counter reading.
RESET_FLAG	VARCHAR2	(1)	Indicates whether this counter reading is a reset reading or not.
RESET_REASON	VARCHAR2	(255)	Mandatory only if the RESET_FLAG = 'Y'.
PRE_RESET_LAST_RDG	NUMBER		Mandatory only if the RESET_FLAG = 'Y'. Will be defaulted from the ROLLOVER_LAST_READING for that counter.
POST_RESET_FIRST_RDG	NUMBER		Mandatory only if the RESET_FLAG = 'Y'. Will be defaulted from the ROLLOVER_FIRST_READING for that counter.
MISC_READING_TYPE	VARCHAR2	(30)	A lookup for different types of miscellaneous readings.
MISC_READING	NUMBER		Valid and mandatory only if MISC_READING_TYPE IS NOT NULL.
DMLTYPE$$	VARCHAR2	(1)	DML code
SEQNO$$	NUMBER	(10)	Oracle Lite sequence number
TRANID$$	NUMBER	(10)	Transaction id
VERSION$$	NUMBER	(10)	Record version

Query Text

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


SELECT CLID$$CS
,      COUNTER_VALUE_ID
,      COUNTER_ID
,      VALUE_TIMESTAMP
,      COUNTER_READING
,      RESET_FLAG
,      RESET_REASON
,      PRE_RESET_LAST_RDG
,      POST_RESET_FIRST_RDG
,      MISC_READING_TYPE
,      MISC_READING
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
FROM CSL.CSL_CS_COUNTER_VALUES_INQ;

Dependencies

[top of page]

CSL.CSL_CS_COUNTER_VALUES_INQ does not reference any database object

CSL.CSL_CS_COUNTER_VALUES_INQ is referenced by following:

CSL: CSL_CS_COUNTER_VALUES_INQ#