[Home] [Help] [Dependency Information]
Object Name: | ENI_VSET_HRCHY_TEMP |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is a staging table used to store the Value-Set hierarchy, downwards from the user-specified TOP NODE. This table is used while migrating a user's Value-Set hierarchy to a Catalog.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENI_VSET_HRCHY_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
HRCHY_FLAG
CHILD_CODE PARENT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHILD_CODE | VARCHAR2 | (150) | This contains the Code for the Child Catalog Category | |
PARENT_CODE | VARCHAR2 | (150) | This contains the Code for the Parent Catalog Category | |
HRCHY_FLAG | VARCHAR2 | (1) | Indicates The Hierarchy Flag | |
CHILD_VALUE_ID | NUMBER | The Child Catalog Category Identifier | ||
SUMMARY_FLAG | VARCHAR2 | (1) | The Summary Flag | |
ENABLED_FLAG | VARCHAR2 | (1) | The Enabled Flag | |
START_DATE_ACTIVE | DATE | The Start Date Active | ||
END_DATE_ACTIVE | DATE | The End Date Active |
Cut, paste (and edit) the following text to query this object:
SELECT CHILD_CODE
, PARENT_CODE
, HRCHY_FLAG
, CHILD_VALUE_ID
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM ENI.ENI_VSET_HRCHY_TEMP;
ENI.ENI_VSET_HRCHY_TEMP does not reference any database object
ENI.ENI_VSET_HRCHY_TEMP is referenced by following:
|
|
|