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_BUDGET_ASSIGNMENTS

Object Details

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

View Type

A Business Intelligence System view

General Ledger budget assignments are accounts associated with a budget organization.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
LEDGER_NAME	VARCHAR2	(30)	Yes
BUDGET_ORGANIZATION_ID	NUMBER	(15)	Yes	Budget version defining column
ACCOUNT_ID	NUMBER	(15)	Yes	Key flexfield combination defining column
_KF:ACCOUNT	CHAR	(17)
CURRENCY	VARCHAR2	(15)	Yes
_LA:ENTRY_TYPE	CHAR	(48)
_LA:AMOUNT_TYPE	CHAR	(49)
_LA:BOUNDARY	CHAR	(53)
FUNDING_BUDGET_ID	NUMBER	(15)
_LA:FUNDS_CHECK_LEVEL	CHAR	(66)
AUTO_ENCUMBRANCE_FLAG	VARCHAR2	(0)

Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      BUDGET_ORGANIZATION_ID
,      ACCOUNT_ID
,      _KF:ACCOUNT
,      CURRENCY
,      _LA:ENTRY_TYPE
,      _LA:AMOUNT_TYPE
,      _LA:BOUNDARY
,      FUNDING_BUDGET_ID
,      _LA:FUNDS_CHECK_LEVEL
,      AUTO_ENCUMBRANCE_FLAG
FROM APPS.GLBV_GL_BUDGET_ASSIGNMENTS;

Dependencies

[top of page]

APPS.GLBV_GL_BUDGET_ASSIGNMENTS references the following:

APPS: GL_BUDGET_ASSIGNMENTS; GL_BUDORG_BC_OPTIONS; GL_CODE_COMBINATIONS; GL_LEDGERS

APPS.GLBV_GL_BUDGET_ASSIGNMENTS is not referenced by any database object