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

Object Details

Object Name:	BISBV_BUSINESS_PLANS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIS.BISBV_BUSINESS_PLANS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

BISBV_BUSINESS_PLANS is is the business view which currently provides an exact copy of the table BIS_BUSINESS_PLANS.
The BIS_BUSINESS_PLANS table is a simple listing of business plans.
A business plan in this context is one of possibly many scenarios which set performance targets to particular values anticipated under that scenario.
Business Views are intended to provide a consistent interface for ad-hoc queries by providing simple table joins for over-normalized data and plain english column names for hard to undertand columns.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Business plan ID
SHORT_NAME	VARCHAR2	(30)	Yes	Short Name for the business plan
NAME	VARCHAR2	(80)	Yes	Business Plan Name
DESCRIPTION	VARCHAR2	(240)		Description for the business plan
VERSION_NO	NUMBER		Yes	Version Number
CURRENT_PLAN_FLAG	VARCHAR2	(1)		XXXXXX
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT PLAN_ID
,      SHORT_NAME
,      NAME
,      DESCRIPTION
,      VERSION_NO
,      CURRENT_PLAN_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.BISBV_BUSINESS_PLANS;

Dependencies

[top of page]

APPS.BISBV_BUSINESS_PLANS references the following:

APPS: BIS_BUSINESS_PLANS; BIS_BUSINESS_PLANS_TL

APPS.BISBV_BUSINESS_PLANS is referenced by following:

APPS: BIS_INDICATOR_REGION_PVT - show dependent code; BIS_INDICATOR_REGION_UI_PVT - show dependent code; BIS_PMV_PARAMETERS_PVT - show dependent code; BIS_PORTLET_PMREGION - show dependent code; BSC_BIS_WRAPPER_PVT - show dependent code; GL_BIS_ALERTS_PKG - show dependent code; HRI_PARAMETERS - show dependent code; HR_PARAMETER_HRMNPSUM - show dependent code; MRP_PARAMETER_MRPEPPS - show dependent code; MRP_PARAMETER_MRPFSETA - show dependent code