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

VIEW: MTH.MTH_PLANTS_STG#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLANT_PK VARCHAR2 (120) Yes
CURRENCY_CODE VARCHAR2 (3) Yes
SOURCE NUMBER
Yes
PLANT_NAME VARCHAR2 (100) Yes
FROM_DATE DATE
Yes
GRAVEYARD_SHIFT_FLAG NUMBER
Yes
PRODUCTION_SITE VARCHAR2 (1) Yes
EFFECTIVE_DATE DATE
Yes
TO_DATE DATE

ADDRESS VARCHAR2 (240)
CITY VARCHAR2 (50)
STATE VARCHAR2 (50)
ZIP_CODE VARCHAR2 (10)
COUNTRY VARCHAR2 (50)
IDEAL_TEMPERATURE NUMBER

E_GRID_ZONE VARCHAR2 (10)
POWER_RATING_UOM NUMBER

AREA NUMBER

HEAD_COUNT 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

Query Text

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


SELECT PLANT_PK
,      CURRENCY_CODE
,      SOURCE
,      PLANT_NAME
,      FROM_DATE
,      GRAVEYARD_SHIFT_FLAG
,      PRODUCTION_SITE
,      EFFECTIVE_DATE
,      TO_DATE
,      ADDRESS
,      CITY
,      STATE
,      ZIP_CODE
,      COUNTRY
,      IDEAL_TEMPERATURE
,      E_GRID_ZONE
,      POWER_RATING_UOM
,      AREA
,      HEAD_COUNT
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM MTH.MTH_PLANTS_STG#;

Dependencies

[top of page]

MTH.MTH_PLANTS_STG# references the following:

SchemaMTH
TableMTH_PLANTS_STG
MTH.MTH_PLANTS_STG# is referenced by following:

SchemaAPPS
SynonymMTH_PLANTS_STG