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

VIEW: MTH.MTH_ASSET_STG#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSET_PK VARCHAR2 (300) Yes
ASSET_NUMBER VARCHAR2 (30) Yes
ASSET_GROUP VARCHAR2 (240) Yes
MAINTENANCE_ORG_CODE VARCHAR2 (3) Yes
SYSTEM_FK VARCHAR2 (120) Yes
ASSET_DESCRIPTION VARCHAR2 (240)
SERIAL_NUMBER VARCHAR2 (30)
ASSET_CATEGORY VARCHAR2 (240)
OWNING_DEPARTMENT VARCHAR2 (240)
ASSET_CRITICALITY VARCHAR2 (30)
ACTIVE_FLAG VARCHAR2 (30)
MAINTAINABLE_FLAG VARCHAR2 (1)
MTTR NUMBER

MTBF NUMBER

ASSET_LOCATION VARCHAR2 (30)
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

PROCESSING_FLAG NUMBER

ASSET_GROUP_ID NUMBER
Yes
Query Text

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


SELECT ASSET_PK
,      ASSET_NUMBER
,      ASSET_GROUP
,      MAINTENANCE_ORG_CODE
,      SYSTEM_FK
,      ASSET_DESCRIPTION
,      SERIAL_NUMBER
,      ASSET_CATEGORY
,      OWNING_DEPARTMENT
,      ASSET_CRITICALITY
,      ACTIVE_FLAG
,      MAINTAINABLE_FLAG
,      MTTR
,      MTBF
,      ASSET_LOCATION
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      PROCESSING_FLAG
,      ASSET_GROUP_ID
FROM MTH.MTH_ASSET_STG#;

Dependencies

[top of page]

MTH.MTH_ASSET_STG# references the following:

SchemaMTH
TableMTH_ASSET_STG
MTH.MTH_ASSET_STG# is referenced by following:

SchemaAPPS
SynonymMTH_ASSET_STG