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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

BISFV_BUSINESS_PLANS is is the full view which duplicates all the columns and expands lookups and foreign keys for the table BIS_BUSINESS_PLANS.
Full views are used as a one-stop template for building up ad-hoc queries; the user retains only thos columns fothe view which are pertinent to the report.

[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)		Current Plan Flag
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.BISFV_BUSINESS_PLANS;

Dependencies

[top of page]

APPS.BISFV_BUSINESS_PLANS references the following:

APPS: BIS_BUSINESS_PLANS; BIS_BUSINESS_PLANS_TL

APPS.BISFV_BUSINESS_PLANS is referenced by following:

APPS: BIS_BUSINESS_PLAN_PVT - show dependent code