[Home] [Help] [Dependency Information]
Object Name: | ZPB_OS_HIERARCHIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Open SQL Hierarchy Information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (240) | Hierarchy display name | |
EPB_ID | VARCHAR2 | (30) | Hierarchy name in the AW | |
HIER_TYPE | VARCHAR2 | (30) | LEVEL or VALUE based | |
OLAP_HIERARCHY_TABLE | VARCHAR2 | (60) | Name of olap table function view for hierarchy | |
HIERARCHY_ID | NUMBER | Yes | Primary key of zpb_hierarchies | |
DIMENSION_ID | NUMBER | Yes | Primary key of zpb_dimensions | |
DIMENSION_NAME | VARCHAR2 | (240) | Dimension name |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, EPB_ID
, HIER_TYPE
, OLAP_HIERARCHY_TABLE
, HIERARCHY_ID
, DIMENSION_ID
, DIMENSION_NAME
FROM APPS.ZPB_OS_HIERARCHIES_V;
|
|
|