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

Object Details

Object Name:	PSBBV_BUDGET_GROUPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSBBV_BUDGET_GROUPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PSBBV_BUDGET_GROUPS displays the budget groups.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_GROUP_SHORT_NAME	VARCHAR2	(20)	Yes	Budget group short name
ROOT_SHORT_NAME	VARCHAR2	(20)		Root budget group short name
BUDGET_GROUP_NAME	VARCHAR2	(80)	Yes	Budget group name
START_EFFECTIVE_DATE	DATE		Yes	Effective start date
END_EFFECTIVE_DATE	DATE			Effective end date
BUDGET_GROUP_NUM_PROPOSED_YRS	NUMBER			Number of years to calculate for budget group
ROOT_BUDGET_GROUP	VARCHAR2	(1)		Flag indicates if this is a root budget group
FREEZE_HIERARCHY_FLAG	VARCHAR2	(1)		Flag indicates if this budget group hierarchy is frozen
BUDGET_GROUP_DESCRIPTION	VARCHAR2	(240)		Budget group description
NARRATIVE_DESCRIPTION	VARCHAR2	(2000)		Extended budget group description
BUDGET_GROUP_ID	NUMBER	(20)	Yes	Budget group unique identifier
ROOT_BUDGET_GROUP_ID	NUMBER	(20)		Root budget group unique identifier
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column

Query Text

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


SELECT BUDGET_GROUP_SHORT_NAME
,      ROOT_SHORT_NAME
,      BUDGET_GROUP_NAME
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      BUDGET_GROUP_NUM_PROPOSED_YRS
,      ROOT_BUDGET_GROUP
,      FREEZE_HIERARCHY_FLAG
,      BUDGET_GROUP_DESCRIPTION
,      NARRATIVE_DESCRIPTION
,      BUDGET_GROUP_ID
,      ROOT_BUDGET_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBBV_BUDGET_GROUPS;

Dependencies

[top of page]

APPS.PSBBV_BUDGET_GROUPS references the following:

APPS: PSB_BUDGET_GROUPS

APPS.PSBBV_BUDGET_GROUPS is not referenced by any database object