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

Object Details

Object Name:	GLBV_GL_BUDGETS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GLBV_GL_BUDGETS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

General Ledger budgets are a collection of estimated amounts for a range of accounting periods.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget version defining column
BUDGET_NAME	VARCHAR2	(15)	Yes	Budget name
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
DATE_CREATED	CHAR	(59)
DATE_FROZEN	DATE		Yes
FIRST_BUDGET_PERIOD	DATE
LAST_BUDGET_PERIOD	VARCHAR2	(15)
LATEST_OPENED_YEAR	VARCHAR2	(15)
DESCRIPTION	NUMBER	(15)
_LA:STATUS	CHAR	(68)
_LA:REQUIRE_BUDGET_JE_FLAG	VARCHAR2	(240)

Query Text

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


SELECT BUDGET_VERSION_ID
,      BUDGET_NAME
,      LEDGER_ID
,      DATE_CREATED
,      DATE_FROZEN
,      FIRST_BUDGET_PERIOD
,      LAST_BUDGET_PERIOD
,      LATEST_OPENED_YEAR
,      DESCRIPTION
,      _LA:STATUS
,      _LA:REQUIRE_BUDGET_JE_FLAG
FROM APPS.GLBV_GL_BUDGETS;

Dependencies

[top of page]

APPS.GLBV_GL_BUDGETS references the following:

APPS: GL_BUDGETS; GL_BUDGET_VERSIONS

APPS.GLBV_GL_BUDGETS is not referenced by any database object