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_STANDARD_BALANCES

Object Details

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

View Type

A Business Intelligence System view

General Ledger standard balances are standard actual, budget, and encumbrance balances for detail and summary accounts.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
LEDGER_NAME	VARCHAR2	(30)	Yes
ACCOUNT_ID	NUMBER	(15)	Yes	Key flexfield combination defining column
_KF:ACCOUNT	CHAR	(17)
_LA:SUMMARY_FLAG	CHAR	(92)
CURRENCY	VARCHAR2	(15)	Yes
CURRENCY_TYPE	VARCHAR2	(80)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes
BALANCE_TYPE	VARCHAR2	(240)
BUDGET_VERSION_ID	NUMBER	(15)
BUDGET_NAME	VARCHAR2	(15)
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
ENCUMBRANCE_TYPE	VARCHAR2	(30)
PERIOD_TO_DATE_DR	NUMBER
PERIOD_TO_DATE_CR	NUMBER
QUARTER_TO_DATE_DR	NUMBER
QUARTER_TO_DATE_CR	NUMBER
YEAR_TO_DATE_DR	NUMBER
YEAR_TO_DATE_CR	NUMBER
PROJECT_TO_DATE_DR	NUMBER
PROJECT_TO_DATE_CR	NUMBER
BEGINNING_BALANCE_DR	NUMBER
BEGINNING_BALANCE_CR	NUMBER
CONVERTED_PERIOD_TO_DATE_DR	NUMBER
CONVERTED_PERIOD_TO_DATE_CR	NUMBER
CONVERTED_YEAR_TO_DATE_DR	NUMBER
CONVERTED_YEAR_TO_DATE_CR	NUMBER
CONVERTED_QUARTER_TO_DATE_DR	NUMBER
CONVERTED_QUARTER_TO_DATE_CR	NUMBER
CONVERTED_PROJECT_TO_DATE_DR	NUMBER
CONVERTED_PROJECT_TO_DATE_CR	NUMBER
CONVERTED_BEGINNING_BALANCE_DR	NUMBER
CONVERTED_BEGINNING_BALANCE_CR	NUMBER

Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      ACCOUNT_ID
,      _KF:ACCOUNT
,      _LA:SUMMARY_FLAG
,      CURRENCY
,      CURRENCY_TYPE
,      PERIOD_NAME
,      BALANCE_TYPE
,      BUDGET_VERSION_ID
,      BUDGET_NAME
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_TYPE
,      PERIOD_TO_DATE_DR
,      PERIOD_TO_DATE_CR
,      QUARTER_TO_DATE_DR
,      QUARTER_TO_DATE_CR
,      YEAR_TO_DATE_DR
,      YEAR_TO_DATE_CR
,      PROJECT_TO_DATE_DR
,      PROJECT_TO_DATE_CR
,      BEGINNING_BALANCE_DR
,      BEGINNING_BALANCE_CR
,      CONVERTED_PERIOD_TO_DATE_DR
,      CONVERTED_PERIOD_TO_DATE_CR
,      CONVERTED_YEAR_TO_DATE_DR
,      CONVERTED_YEAR_TO_DATE_CR
,      CONVERTED_QUARTER_TO_DATE_DR
,      CONVERTED_QUARTER_TO_DATE_CR
,      CONVERTED_PROJECT_TO_DATE_DR
,      CONVERTED_PROJECT_TO_DATE_CR
,      CONVERTED_BEGINNING_BALANCE_DR
,      CONVERTED_BEGINNING_BALANCE_CR
FROM APPS.GLBV_GL_STANDARD_BALANCES;

Dependencies

[top of page]

APPS.GLBV_GL_STANDARD_BALANCES references the following:

APPS: GL_BALANCES; GL_BUDGET_VERSIONS; GL_CODE_COMBINATIONS; GL_ENCUMBRANCE_TYPES; GL_LEDGERS; GL_LOOKUPS

APPS.GLBV_GL_STANDARD_BALANCES is not referenced by any database object