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

TABLE: MTH.MTH_TAG_READINGS_T_STG

Object Details
Object Name: MTH_TAG_READINGS_T_STG
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_TAG_READINGS_T_STG
Subobject Name:
Status: VALID


Staging table to move device data in MTH_EQUIPMENTS_EXT_B


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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 (32)
Recipe number
HOUR_FK_KEY NUMBER

Reference to hour
Query Text

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
,      HOUR_FK_KEY
FROM MTH.MTH_TAG_READINGS_T_STG;

Dependencies

[top of page]

MTH.MTH_TAG_READINGS_T_STG does not reference any database object

MTH.MTH_TAG_READINGS_T_STG is referenced by following:

SchemaAPPS
Materialized ViewMTH_SHIFT_REFERENCE_MV
SchemaMTH
ViewMTH_TAG_READINGS_T_STG#