[Home] [Help]
[Dependency Information]
| Object Name: | MTH_TIME_HIERARCHY_STG |
|---|---|
| Object Type: | TABLE |
| Owner: | MTH |
| FND Design Data: | MTH.MTH_TIME_HIERARCHY_STG
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | ![]() |
|---|---|
| PCT Free: | |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HIERARCHY_NAME | VARCHAR2 | (100) | Yes | |
| CHILD_FK | VARCHAR2 | (100) | Yes | |
| PARENT_FK | VARCHAR2 | (100) | Yes | |
| LEVEL_NUMBER_OF_CHILD | NUMBER | Yes | ||
| SYSTEM_FK | VARCHAR2 | (120) | ||
| PROCESSING_FLAG | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_NAME
, CHILD_FK
, PARENT_FK
, LEVEL_NUMBER_OF_CHILD
, SYSTEM_FK
, PROCESSING_FLAG
FROM MTH.MTH_TIME_HIERARCHY_STG;
MTH.MTH_TIME_HIERARCHY_STG does not reference any database object
MTH.MTH_TIME_HIERARCHY_STG is referenced by following:
MTH
MTH_TIME_HIERARCHY_STG#
|
|
|
|