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

Object Details

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

View Type

A Business Intelligence System view

PSBFV_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)	Yes	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 this 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 description for this budget group
ROOT_PS_ACCOUNT_POS_SET_NAME	VARCHAR2	(100)	Yes	Account set name for the Personnel Services account set
ROOT_NPS_ACCOUNT_POS_SET_NAME	VARCHAR2	(100)	Yes	Account set name for the Non-Personnel Services account set
ROOT_SET_OF_BOOKS_NAME	VARCHAR2	(30)	Yes	Set of Books name for the root budget group
ROOT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code for the root budget group
_DF	CHAR	(28)		Descriptive Flexfield column
BUDGET_GROUP_ID	NUMBER	(20)	Yes	Budget group unique identifier
ROOT_BUDGET_GROUP_ID	NUMBER	(20)		Root budget group unique identifier
PS_ACCOUNT_POSITION_SET_ID	NUMBER	(15)		Personnel Services account set unique identifier
NPS_ACCOUNT_POSITION_SET_ID	NUMBER	(15)		Non-Personnel Services account set 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
,      ROOT_PS_ACCOUNT_POS_SET_NAME
,      ROOT_NPS_ACCOUNT_POS_SET_NAME
,      ROOT_SET_OF_BOOKS_NAME
,      ROOT_CURRENCY_CODE
,      _DF
,      BUDGET_GROUP_ID
,      ROOT_BUDGET_GROUP_ID
,      PS_ACCOUNT_POSITION_SET_ID
,      NPS_ACCOUNT_POSITION_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_BUDGET_GROUPS;

Dependencies

[top of page]

APPS.PSBFV_BUDGET_GROUPS references the following:

APPS: GL_SETS_OF_BOOKS; PSB_ACCOUNT_POSITION_SETS; PSB_BUDGET_GROUPS

APPS.PSBFV_BUDGET_GROUPS is not referenced by any database object