[Home] [Help] [Dependency Information]
Object Name: | ZPB_HIER_MEMBERS |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
FND Design Data: | ZPB.ZPB_HIER_MEMBERS |
Subobject Name: | |
Status: | VALID |
This table is used to cache the Hierarchy Members of a given Business Area
ZPB.ZPB_HIER_MEMBERS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_HIER_MEMBERS_N1 | NORMAL | NONUNIQUE |
BUSINESS_AREA_ID
LOGICAL_DIM_ID DIMENSION_ID PARENT_INCLUDE_TYPE CHILD_INCLUDE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_AREA_ID | NUMBER | (10) | Yes | Business Area ID |
DIMENSION_ID | NUMBER | (9) | Yes | Dimension ID |
HIERARCHY_ID | NUMBER | (9) | Yes | Hierarchy ID |
VERSION_ID | NUMBER | (9) | Version ID | |
PARENT_ID | VARCHAR2 | (32) | Yes | Parent ID |
CHILD_ID | VARCHAR2 | (32) | Yes | Child ID |
PARENT_DEPTH | NUMBER | Yes | Parent Depth | |
CHILD_DEPTH | NUMBER | Yes | Child Depth | |
PARENT_GROUP | VARCHAR2 | (30) | Parent Group | |
CHILD_GROUP | VARCHAR2 | (30) | Child Group | |
DISPLAY_ORDER | NUMBER | Display Order | ||
PARENT_INCLUDE_TYPE | VARCHAR2 | (1) | Yes | Parent Include Type |
CHILD_INCLUDE_TYPE | VARCHAR2 | (1) | Yes | Child Include Type |
LOGICAL_DIM_ID | NUMBER | Yes | Logical Dimension ID |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_AREA_ID
, DIMENSION_ID
, HIERARCHY_ID
, VERSION_ID
, PARENT_ID
, CHILD_ID
, PARENT_DEPTH
, CHILD_DEPTH
, PARENT_GROUP
, CHILD_GROUP
, DISPLAY_ORDER
, PARENT_INCLUDE_TYPE
, CHILD_INCLUDE_TYPE
, LOGICAL_DIM_ID
FROM ZPB.ZPB_HIER_MEMBERS;
ZPB.ZPB_HIER_MEMBERS does not reference any database object
ZPB.ZPB_HIER_MEMBERS is referenced by following:
|
|
|