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

TABLE: MTH.MTH_ITEM_CATEGORIES_STG

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

Staging table for MTH_ITEM_CATEGORIES_D

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CATEGORY_PK VARCHAR2 (120) Yes Category identifier
SYSTEM_FK VARCHAR2 (120)
Reference to source system
CATEGORY_NAME VARCHAR2 (240) Yes Item Category name
DESCRIPTION VARCHAR2 (240)
Category description
EBS_CATEGORY_ID NUMBER

Oracle E-business suite item category identifier
USER_ATTR1 VARCHAR2 (150)
User-defined attribute
USER_ATTR2 VARCHAR2 (150)
User-defined attribute
USER_ATTR3 VARCHAR2 (150)
User-defined attribute
USER_ATTR4 VARCHAR2 (150)
User-defined attribute
USER_ATTR5 VARCHAR2 (150)
User-defined attribute
USER_MEASURE1 NUMBER

User-defined measure
USER_MEASURE2 NUMBER

User-defined measure
USER_MEASURE3 NUMBER

User-defined measure
USER_MEASURE4 NUMBER

User-defined measure
USER_MEASURE5 NUMBER

User-defined measure
PROCESSING_FLAG NUMBER

SEGMENT1 VARCHAR2 (40)
SEGMENT2 VARCHAR2 (40)
SEGMENT3 VARCHAR2 (40)
SEGMENT4 VARCHAR2 (40)
SEGMENT5 VARCHAR2 (40)
SEGMENT6 VARCHAR2 (40)
SEGMENT7 VARCHAR2 (40)
SEGMENT8 VARCHAR2 (40)
SEGMENT9 VARCHAR2 (40)
SEGMENT10 VARCHAR2 (40)
SEGMENT11 VARCHAR2 (40)
SEGMENT12 VARCHAR2 (40)
SEGMENT13 VARCHAR2 (40)
SEGMENT14 VARCHAR2 (40)
SEGMENT15 VARCHAR2 (40)
SEGMENT16 VARCHAR2 (40)
SEGMENT17 VARCHAR2 (40)
SEGMENT18 VARCHAR2 (40)
SEGMENT19 VARCHAR2 (40)
SEGMENT20 VARCHAR2 (40)
Query Text

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


SELECT CATEGORY_PK
,      SYSTEM_FK
,      CATEGORY_NAME
,      DESCRIPTION
,      EBS_CATEGORY_ID
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      PROCESSING_FLAG
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
FROM MTH.MTH_ITEM_CATEGORIES_STG;

Dependencies

[top of page]

MTH.MTH_ITEM_CATEGORIES_STG does not reference any database object

MTH.MTH_ITEM_CATEGORIES_STG is referenced by following:

SchemaMTH
ViewMTH_ITEM_CATEGORIES_STG#