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

TABLE: CSL.CSL_CS_COUNTER_PROP_VALS_INQ

Object Details
Object Name: CSL_CS_COUNTER_PROP_VALS_INQ
Object Type: TABLE
Owner: CSL
Subobject Name:
Status: VALID


Inqueue table for CS_COUNTER_PROP_VALUES containing data uploaded by mobile clients


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSL_CS_COUNTER_PROP_VLS_INQ_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANID$$
ColumnCLID$$CS
ColumnSEQNO$$
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (240)
Mobile username refers to FND_USER
COUNTER_PROP_VALUE_ID NUMBER

Identifier of the counter property value.
COUNTER_VALUE_ID NUMBER

The identifier of the counter to which this value belongs.
COUNTER_PROPERTY_ID NUMBER

The identifier of the counter property.
PROPERTY_VALUE VARCHAR2 (240)
The value of the counter property.
VALUE_TIMESTAMP DATE

The date on which this counter property reading was taken, maybe different from the date on which the reading is entered in the system.
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_PROP_VALUE_ID
,      COUNTER_VALUE_ID
,      COUNTER_PROPERTY_ID
,      PROPERTY_VALUE
,      VALUE_TIMESTAMP
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
FROM CSL.CSL_CS_COUNTER_PROP_VALS_INQ;

Dependencies

[top of page]

CSL.CSL_CS_COUNTER_PROP_VALS_INQ does not reference any database object

CSL.CSL_CS_COUNTER_PROP_VALS_INQ is referenced by following:

SchemaAPPS
SynonymCSL_CS_COUNTER_PROP_VALS_INQ