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

VIEW: MTH.MTH_EQUIP_ENTITIES_MST#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ENTITY_PK_KEY NUMBER
Yes
ENTITY_PK VARCHAR2 (120) Yes
ENTITY_NAME VARCHAR2 (100) Yes
ENTITY_TYPE VARCHAR2 (30) Yes
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

SYSTEM_FK_KEY NUMBER
Yes
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)
PLANT_FK_KEY NUMBER

PRODUCTION_ENTITY VARCHAR2 (1)
BUSINESS_FUNCTION VARCHAR2 (100)
DESCRIPTION VARCHAR2 (240)
STATUS VARCHAR2 (30)
Query Text

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


SELECT ENTITY_PK_KEY
,      ENTITY_PK
,      ENTITY_NAME
,      ENTITY_TYPE
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      SYSTEM_FK_KEY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      PLANT_FK_KEY
,      PRODUCTION_ENTITY
,      BUSINESS_FUNCTION
,      DESCRIPTION
,      STATUS
FROM MTH.MTH_EQUIP_ENTITIES_MST#;

Dependencies

[top of page]

MTH.MTH_EQUIP_ENTITIES_MST# references the following:

SchemaMTH
TableMTH_EQUIP_ENTITIES_MST
MTH.MTH_EQUIP_ENTITIES_MST# is referenced by following:

SchemaAPPS
SynonymMTH_EQUIP_ENTITIES_MST