[Home] [Help]
[Dependency Information]
| Object Name: | CNDIHY_PARENTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VALUE_ID | NUMBER | (15) | Yes | Child node unique identifier |
| PARENT_VALUE_ID | NUMBER | (15) | Parent node unique identifier (for the rooted subtree defined by ROOT_NODE) | |
| DIM_HIERARCHY_ID | NUMBER | (15) | Yes | Period effective hierarchy unique identifier |
| ROOT_NODE | NUMBER | (15) | Yes | Root node of the sub-tree containing this parent-child relationship |
Cut, paste (and edit) the following text to query this object:
SELECT VALUE_ID
, PARENT_VALUE_ID
, DIM_HIERARCHY_ID
, ROOT_NODE
FROM APPS.CNDIHY_PARENTS_V;
APPS
CN_DIM_EXPLOSION
CN_HIERARCHY_EDGES
APPS
CNDIHY_HIERARCHY_PKG
- show dependent code
|
|
|
|