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

VIEW: APPS.ZPB_BUSAREA_HIERARCHIES_VL

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

View Type

A Business Intelligence System view


Translates the names of hierarchies for a business area version


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
VERSION_ID NUMBER (10) Yes Business Area Version ID. Foreign key to ZPB_BUSAREA_VERSIONS
HIERARCHY_ID NUMBER (9) Yes Hierarchy ID. Foreign Key to FEM_HIERARCHIES
DIMENSION_ID NUMBER (10) Yes Dimension ID in FEM_XDIM_DIMENSIONS table
LOGICAL_DIM_ID NUMBER (9) Yes
HIERARCHY_TYPE VARCHAR2 (80) Yes Hierarchy type (Level-based or Value-based)
MULTI_TOP_FLAG VARCHAR2 (1) Yes Is the hierarchy Multi-top
NAME VARCHAR2 (150) Yes Hierarchy Name
DESCRIPTION VARCHAR2 (255)
Description
CREATED_BY NUMBER
Yes Who column
CREATION_DATE DATE
Yes Who column
LAST_UPDATED_BY NUMBER
Yes Who column
LAST_UPDATE_DATE DATE
Yes Who column
LAST_UPDATE_LOGIN NUMBER

Who column
Query Text

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


SELECT ROW_ID
,      VERSION_ID
,      HIERARCHY_ID
,      DIMENSION_ID
,      LOGICAL_DIM_ID
,      HIERARCHY_TYPE
,      MULTI_TOP_FLAG
,      NAME
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ZPB_BUSAREA_HIERARCHIES_VL;

Dependencies

[top of page]

APPS.ZPB_BUSAREA_HIERARCHIES_VL references the following:

SchemaAPPS
SynonymFEM_HIERARCHIES
ViewFEM_LOOKUP_VALUES_VL
ViewFEM_OBJECT_CATALOG_VL
SynonymZPB_BUSAREA_HIERARCHIES
APPS.ZPB_BUSAREA_HIERARCHIES_VL is referenced by following:

SchemaAPPS
Package BodyZPB_BUSAREA_VAL - show dependent code