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]

VIEW: APPS.ZPB_DC_OBJECTS_UTIL_V

Object Details

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

Provides advanced users with ability to easily find information about a worksheets.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Object Id for the worksheet Object
BUSINESS_PROCESS_ID	NUMBER		Yes	Business Process Id of the worksheet object
BP_NAME	VARCHAR2	(300)	Yes	Business Process Name of the worksheet
INSTANCE_DESCRIPTION	VARCHAR2	(300)		Description associated with the Business Process
TEMPLATE_ID	NUMBER		Yes	Template id for the worksheet
TEMPLATE_NAME	VARCHAR2	(680)	Yes	Template or Worksheet Name
USER_ID	NUMBER		Yes	User id of the user who this worksheet belongs to
USER_NAME	VARCHAR2	(100)	Yes	User name of the user this worksheet belongs to

Query Text

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


SELECT OBJECT_ID
,      BUSINESS_PROCESS_ID
,      BP_NAME
,      INSTANCE_DESCRIPTION
,      TEMPLATE_ID
,      TEMPLATE_NAME
,      USER_ID
,      USER_NAME
FROM APPS.ZPB_DC_OBJECTS_UTIL_V;

Dependencies

[top of page]

APPS.ZPB_DC_OBJECTS_UTIL_V references the following:

APPS: FND_USER; ZPB_ANALYSIS_CYCLES; ZPB_ANALYSIS_CYCLE_INSTANCES; ZPB_DC_OBJECTS

APPS.ZPB_DC_OBJECTS_UTIL_V is not referenced by any database object