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

VIEW: APPS.ZPB_LAB_VIEWS_V

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


This view returns UI labels for all shared views of the current business area. FND_GLOBAL.USER_ID and userenv('Lang') must be set. To select only views of certain types, bind the OBJECT_TYPE column to a subset of the following values: 'SHARED_VIEW_DATA' - BP instance views, 'SHARED_VIEW_CALC - controlled calculation views.


[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_AW_NAME VARCHAR2 (30)
Object name in the workspace
OBJECT_SHORT_LABEL VARCHAR2 (255)
Short Label of Object
OBJECT_LONG_LABEL VARCHAR2 (255)
Object Long Label
OBJECT_PLURAL_SHORT_LABEL VARCHAR2 (255)
Object Plural Short Label
OBJECT_PLURAL_LONG_LABEL VARCHAR2 (255)
Object Plural Long Label
OBJECT_SHAR_CWM_NAME VARCHAR2 (60)
CWM name of object in the shared workspace
OBJECT_CWM_NAME VARCHAR2 (60)
CWM name of object in the personal workspace
OBJECT_TYPE VARCHAR2 (64)
Type of measure (SHARED_DATA, SHARED_CALC, SHARED_WRITE_SECURITY etc)
OBJECT_INSTANCE_ID NUMBER

Object's Instance ID
Query Text

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


SELECT OBJECT_AW_NAME
,      OBJECT_SHORT_LABEL
,      OBJECT_LONG_LABEL
,      OBJECT_PLURAL_SHORT_LABEL
,      OBJECT_PLURAL_LONG_LABEL
,      OBJECT_SHAR_CWM_NAME
,      OBJECT_CWM_NAME
,      OBJECT_TYPE
,      OBJECT_INSTANCE_ID
FROM APPS.ZPB_LAB_VIEWS_V;

Dependencies

[top of page]

APPS.ZPB_LAB_VIEWS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymZPB_CUBES
ViewZPB_CURRENT_USER_V
SynonymZPB_MEASURES

APPS.ZPB_LAB_VIEWS_V is not referenced by any database object