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.BEN_PLAN_DESIGN_HGRID_VW

Object Details

Object Name:	BEN_PLAN_DESIGN_HGRID_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_PLAN_DESIGN_HGRID_VW
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

BEN_PLAN_DESIGN_HGRID_VW display the plan design information in a hierarchical format for the Plan Copy module.

[View Source]

Columns

Name	Datatype	Length	Comments
COPY_ENTITY_RESULT_ID	NUMBER		copy_entity_result_id
COPY_ENTITY_TXN_ID	NUMBER	(15)	copy_entity_txn_id
NUMBER_OF_COPIES	NUMBER		number_of_copies
OBJECT_VERSION_NUMBER	NUMBER		object_version_number
PARENT_ENTITY_RESULT_ID	NUMBER		parent_entity_result_id
TABLE_ROUTE_ID	NUMBER	(15)	table_route_id
NAME	VARCHAR2	(600)	name
TYPE	VARCHAR2	(5)	type
SELECTION_DISABLED_FLAG	VARCHAR2	(1)	selection_disabled_flag
CSS_STYLE	VARCHAR2	(16)	css_style
MIRROR_ENTITY_RESULT_ID	NUMBER		mirror_entity_result_id
INFORMATION8	VARCHAR2	(30)	information8

Query Text

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


SELECT COPY_ENTITY_RESULT_ID
,      COPY_ENTITY_TXN_ID
,      NUMBER_OF_COPIES
,      OBJECT_VERSION_NUMBER
,      PARENT_ENTITY_RESULT_ID
,      TABLE_ROUTE_ID
,      NAME
,      TYPE
,      SELECTION_DISABLED_FLAG
,      CSS_STYLE
,      MIRROR_ENTITY_RESULT_ID
,      INFORMATION8
FROM APPS.BEN_PLAN_DESIGN_HGRID_VW;

Dependencies

[top of page]

APPS.BEN_PLAN_DESIGN_HGRID_VW references the following:

APPS: BEN_COPY_ENTITY_RESULTS; PQH_TABLE_ROUTE_VL

APPS.BEN_PLAN_DESIGN_HGRID_VW is referenced by following:

PUBLIC: BEN_PLAN_DESIGN_HGRID_VW