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

TABLE: QA.QA_DEVICE_INFO

Object Details
Object Name: QA_DEVICE_INFO
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_DEVICE_INFO
Subobject Name:
Status: VALID


QA_DEVICE_INFO stores the setup information for devices. Each device is uniquely identified by the Device Name and Sensor Alias combination.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DEVICE_ID NUMBER
Yes Unique Device Identifier
DEVICE_NAME VARCHAR2 (256) Yes Device Name
DESCRIPTION VARCHAR2 (250) Yes Device Description
SENSOR_ALIAS VARCHAR2 (256) Yes Sensor Alias
PULL_FREQUENCY NUMBER

Data pull frequency
ELAPSED_TIME NUMBER
Yes Acceptable elapsed time range.
OVERRIDE_FLAG NUMBER
Yes Device data override flag
ENABLED_FLAG NUMBER
Yes Device enabled indicator flag
CREATED_BY NUMBER
Yes Standard who column.
CREATION_DATE DATE
Yes Standard who column.
LAST_UPDATE_DATE DATE
Yes Standard who column.
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column.
LAST_UPDATED_BY NUMBER
Yes Standard who column.
Query Text

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


SELECT DEVICE_ID
,      DEVICE_NAME
,      DESCRIPTION
,      SENSOR_ALIAS
,      PULL_FREQUENCY
,      ELAPSED_TIME
,      OVERRIDE_FLAG
,      ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM QA.QA_DEVICE_INFO;

Dependencies

[top of page]

QA.QA_DEVICE_INFO does not reference any database object

QA.QA_DEVICE_INFO is referenced by following:

SchemaAPPS
SynonymQA_DEVICE_INFO