DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ZPB_OS_LEVELS_V

Object Details
Object Name: ZPB_OS_LEVELS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Open SQL Level Information


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEVEL_NAME VARCHAR2 (240)
Level display name
HIERARCHY_NAME VARCHAR2 (240)
Display name of hierarchy to which this level belongs to
DIMENSION_NAME VARCHAR2 (240)
Display name of dimension to which this level belongs to
LEVEL_GID NUMBER

Global Unique Identified - used by OLAPI queries
OLAP_TABLE_COLUMN_NAME VARCHAR2 (60) Yes Name of column in olap table function that stores parent at this level for each member
LEVEL_ID NUMBER
Yes Primary key of zpb_levels
HIERARCHY_ID NUMBER
Yes Primary key of zpb_hierarchies
DIMENSION_ID NUMBER
Yes Primary key of zpb_dimensions
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEVEL_NAME
,      HIERARCHY_NAME
,      DIMENSION_NAME
,      LEVEL_GID
,      OLAP_TABLE_COLUMN_NAME
,      LEVEL_ID
,      HIERARCHY_ID
,      DIMENSION_ID
FROM APPS.ZPB_OS_LEVELS_V;

Dependencies

[top of page]

APPS.ZPB_OS_LEVELS_V references the following:

SchemaAPPS
SynonymZPB_COLUMNS
SynonymZPB_HIER_LEVEL
ViewZPB_LEVELS_VL
ViewZPB_OS_DIMENSIONS_V
ViewZPB_OS_HIERARCHIES_V

APPS.ZPB_OS_LEVELS_V is not referenced by any database object