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

VIEW: APPS.ZPB_LEVELS_VL

Object Details
Object Name: ZPB_LEVELS_VL
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.


Translation view for zpb_levels


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEVEL_ID NUMBER
Yes Primary key of zpb_levels
DIMENSION_ID NUMBER
Yes Primary key of zpb_dimensions
NAME VARCHAR2 (240)
Level short display name
EPB_ID VARCHAR2 (30)
Level id in the AW
PERS_CWM_NAME VARCHAR2 (240)
BiBeans name for the personal level
SHAR_CWM_NAME VARCHAR2 (60)
BiBeans name for the shared level
PERS_LEVEL_FLAG VARCHAR2 (3)
True if this is a user defined level
LONG_NAME VARCHAR2 (240)
Level display long name
PLURAL_NAME VARCHAR2 (240)
Level display plural name
PLURAL_LONG_NAME VARCHAR2 (240)
Level display plural long name
CREATED_BY NUMBER (15) Yes Bookkeeping Column
CREATION_DATE DATE

Bookkeeping Column
LAST_UPDATED_BY NUMBER (15)
Bookkeeping Column
LAST_UPDATE_DATE DATE

Bookkeeping Column
LAST_UPDATE_LOGIN NUMBER (15)
Bookkeeping Column
Query Text

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


SELECT LEVEL_ID
,      DIMENSION_ID
,      NAME
,      EPB_ID
,      PERS_CWM_NAME
,      SHAR_CWM_NAME
,      PERS_LEVEL_FLAG
,      LONG_NAME
,      PLURAL_NAME
,      PLURAL_LONG_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ZPB_LEVELS_VL;

Dependencies

[top of page]

APPS.ZPB_LEVELS_VL references the following:

SchemaAPPS
SynonymZPB_LEVELS
SynonymZPB_LEVELS_TL
APPS.ZPB_LEVELS_VL is referenced by following:

SchemaAPPS
Package BodyZPB_DEBUG - show dependent code
ViewZPB_LAB_DIMLEVELS_SCOPE_V
ViewZPB_LAB_LEVELS_SCOPE_V
ViewZPB_LAB_LEVELS_V
ViewZPB_MD_LABELS_V
ViewZPB_OS_LEVELS_V