eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ZPB.ZPB_BUSINESS_AREAS

Object Details

Object Name:	ZPB_BUSINESS_AREAS
Object Type:	TABLE
Owner:	ZPB
Subobject Name:
Status:	VALID

Stores the different Business Areas in EPB

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZPB_BUSINESS_AREAS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_AREA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_AREA_ID	NUMBER	(10)	Yes	Business Area ID
DATA_AW	VARCHAR2	(30)	Yes	Name of dimension dimension view
ANNOTATION_AW	VARCHAR2	(30)	Yes	Name of annotation AW
BUSAREA_CREATED_BY	NUMBER	(15)	Yes	(Shadow) user who created the Business Area
REFRESH_DATE	DATE			Date last refreshed
REFRESHED_BY	NUMBER	(15)		(Shadow) user who last refreshed the Business Area
PUBLISH_DATE	DATE			Date last published
PUBLISHED_BY	NUMBER	(15)		(Shadow) user who last published the Business Area
SNAPSHOT_OBJECT_ID	NUMBER	(9)		Stores the snapshot ID for FEM dimension snapshot support
SNAPSHOT_OBJ_DEF_ID	NUMBER	(9)		Stores the snapshot definition ID for FEM dimension snapshot support
BISM_FOLDER_VERSION	NUMBER			Stores bi folder version
LAST_AW_UPDATE	DATE
STATUS	VARCHAR2	(1)
CREATION_DATE	DATE		Yes	Date Created
CREATED_BY	NUMBER	(15)	Yes	User who created the Business Area
LAST_UPDATE_LOGIN	NUMBER	(15)		Login ID of session that last updated the table
LAST_UPDATE_DATE	DATE		Yes	Date of last update
LAST_UPDATED_BY	NUMBER	(15)	Yes	User who last updated

Query Text

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


SELECT BUSINESS_AREA_ID
,      DATA_AW
,      ANNOTATION_AW
,      BUSAREA_CREATED_BY
,      REFRESH_DATE
,      REFRESHED_BY
,      PUBLISH_DATE
,      PUBLISHED_BY
,      SNAPSHOT_OBJECT_ID
,      SNAPSHOT_OBJ_DEF_ID
,      BISM_FOLDER_VERSION
,      LAST_AW_UPDATE
,      STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM ZPB.ZPB_BUSINESS_AREAS;

Dependencies

[top of page]

ZPB.ZPB_BUSINESS_AREAS does not reference any database object

ZPB.ZPB_BUSINESS_AREAS is referenced by following:

APPS: ZPB_BUSINESS_AREAS