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

Object Details

Object Name:	GLFV_GL_BUDGETS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GLFV_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
LEDGER_NAME	VARCHAR2	(30)	Yes
_LA:STATUS	CHAR	(59)
DATE_CREATED	DATE		Yes
DATE_FROZEN	DATE
FIRST_BUDGET_PERIOD	VARCHAR2	(15)
LAST_BUDGET_PERIOD	VARCHAR2	(15)
LATEST_OPENED_YEAR	NUMBER	(15)
_LA:REQUIRE_BUDGET_JE_FLAG	CHAR	(68)
DESCRIPTION	VARCHAR2	(240)
_DF	CHAR	(30)

Query Text

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


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

Dependencies

[top of page]

APPS.GLFV_GL_BUDGETS references the following:

APPS: GL_BUDGETS; GL_BUDGET_VERSIONS; GL_LEDGERS

APPS.GLFV_GL_BUDGETS is not referenced by any database object