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

VIEW: MTH.MTH_EQUIP_STATUSES#

Object Details
Object Name: MTH_EQUIP_STATUSES#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EQUIPMENT_FK_KEY NUMBER
Yes
SHIFT_WORKDAY_FK_KEY NUMBER

FROM_DATE DATE
Yes
TO_DATE DATE

STATUS VARCHAR2 (30) Yes
SYSTEM_FK_KEY NUMBER
Yes
USER_DIM1_FK_KEY NUMBER

USER_DIM2_FK_KEY NUMBER

USER_DIM3_FK_KEY NUMBER

USER_DIM4_FK_KEY NUMBER

USER_DIM5_FK_KEY NUMBER

USER_ATTR1 VARCHAR2 (150)
USER_ATTR2 VARCHAR2 (150)
USER_ATTR3 VARCHAR2 (150)
USER_ATTR4 VARCHAR2 (150)
USER_ATTR5 VARCHAR2 (150)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_SYSTEM_ID NUMBER
Yes
LAST_UPDATE_SYSTEM_ID NUMBER
Yes
CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
EXPECTED_UP_TIME NUMBER

STATUS_TYPE VARCHAR2 (30)
HOUR_FK_KEY NUMBER

READING_TIME DATE

Query Text

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


SELECT EQUIPMENT_FK_KEY
,      SHIFT_WORKDAY_FK_KEY
,      FROM_DATE
,      TO_DATE
,      STATUS
,      SYSTEM_FK_KEY
,      USER_DIM1_FK_KEY
,      USER_DIM2_FK_KEY
,      USER_DIM3_FK_KEY
,      USER_DIM4_FK_KEY
,      USER_DIM5_FK_KEY
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      EXPECTED_UP_TIME
,      STATUS_TYPE
,      HOUR_FK_KEY
,      READING_TIME
FROM MTH.MTH_EQUIP_STATUSES#;

Dependencies

[top of page]

MTH.MTH_EQUIP_STATUSES# references the following:

SchemaMTH
TableMTH_EQUIP_STATUSES
MTH.MTH_EQUIP_STATUSES# is referenced by following:

SchemaAPPS
SynonymMTH_EQUIP_STATUSES