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


TABLE: MTH.MTH_EXT_ATTR_T_STG

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


Staging table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ATTR_GROUP_ID NUMBER

Attribute group identifier
ATTR_NAME VARCHAR2 (150)
Internal name for the Attribute
ATTR_VALUE VARCHAR2 (150)
Attribute data
GROUP_ID NUMBER

Row identifier for a group of rows in error table
DB_COL VARCHAR2 (30)
Database column in which this attribute value is stored
UNIQUE_KEY_FLAG VARCHAR2 (3)
Determines if this attribute is part of Unique key
Query Text

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


SELECT ATTR_GROUP_ID
,      ATTR_NAME
,      ATTR_VALUE
,      GROUP_ID
,      DB_COL
,      UNIQUE_KEY_FLAG
FROM MTH.MTH_EXT_ATTR_T_STG;

Dependencies

[top of page]

MTH.MTH_EXT_ATTR_T_STG does not reference any database object

MTH.MTH_EXT_ATTR_T_STG is referenced by following:

SchemaMTH
ViewMTH_EXT_ATTR_T_STG#