[Home] [Help] [Dependency Information]
Object Name: | MTH_TAG_READINGS_T_STG |
---|---|
Object Type: | TABLE |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
Staging table to move device data in MTH_EQUIPMENTS_EXT_B
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
READ_TIME | DATE | Read time of the tag data for the given equipment | ||
TAG_DATA | VARCHAR2 | (255) | Tag data | |
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
EQUIPMENT_FK_KEY | NUMBER | Reference to equipment identifier | ||
WORKORDER_FK_KEY | NUMBER | Reference to Work Order identifier | ||
SEGMENT_FK_KEY | NUMBER | Reference to operation identifier | ||
SHIFT_WORKDAY_FK_KEY | NUMBER | Reference to shift workday identifier | ||
ITEM_FK_KEY | NUMBER | Reference to item identifier | ||
DB_COL | VARCHAR2 | (30) | Database column in which this attribute value is stored | |
RECIPE_VERSION | VARCHAR2 | (15) | Recipe version | |
RECIPE_NUM | VARCHAR2 | (30) | Recipe number |
Cut, paste (and edit) the following text to query this object:
SELECT READ_TIME
, TAG_DATA
, ATTR_GROUP_ID
, EQUIPMENT_FK_KEY
, WORKORDER_FK_KEY
, SEGMENT_FK_KEY
, SHIFT_WORKDAY_FK_KEY
, ITEM_FK_KEY
, DB_COL
, RECIPE_VERSION
, RECIPE_NUM
FROM MTH.MTH_TAG_READINGS_T_STG;
MTH.MTH_TAG_READINGS_T_STG does not reference any database object
MTH.MTH_TAG_READINGS_T_STG is referenced by following:
|
|
|