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

VIEW: APPS.ZPB_OS_TABLES_V

Object Details
Object Name: ZPB_OS_TABLES_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 column information for one or more tables (olap dimension tables or olap fact tables) in a particular business area. Before executing this query the following environment variable should be initialized:sys_context('ZPB_CONTEXT', 'business_area_id').


[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_ID NUMBER
Yes Primary key of zpb_tables
TABLE_NAME VARCHAR2 (60)
Name of the olap dimension or fact table
COLUMN_NAME VARCHAR2 (60) Yes Name of the olap fact or dimension table column
COLUMN_TYPE VARCHAR2 (30)
Column Type
Query Text

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


SELECT TABLE_ID
,      TABLE_NAME
,      COLUMN_NAME
,      COLUMN_TYPE
FROM APPS.ZPB_OS_TABLES_V;

Dependencies

[top of page]

APPS.ZPB_OS_TABLES_V references the following:

SchemaAPPS
SynonymZPB_COLUMNS
SynonymZPB_TABLES

APPS.ZPB_OS_TABLES_V is not referenced by any database object