DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GLBV_GL_AVERAGE_BALANCES

Object Details
Object Name: GLBV_GL_AVERAGE_BALANCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GLBV_GL_AVERAGE_BALANCES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


General Ledger average balances are average daily balances for detail and summary balance sheet accounts in sets of books with average balances enabled. Only actual daily balances are maintained.


[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 (75)
CURRENCY VARCHAR2 (15) Yes
CURRENCY_TYPE VARCHAR2 (80) Yes
CONVERTED_FROM_CURRENCY VARCHAR2 (15)
PERIOD_NAME VARCHAR2 (15) Yes
ACCOUNTING_DATE DATE
Yes
END_OF_DAY NUMBER

PERIOD_AVERAGE_TO_DATE NUMBER

QUARTER_AVERAGE_TO_DATE NUMBER

YEAR_AVERAGE_TO_DATE 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
,      CONVERTED_FROM_CURRENCY
,      PERIOD_NAME
,      ACCOUNTING_DATE
,      END_OF_DAY
,      PERIOD_AVERAGE_TO_DATE
,      QUARTER_AVERAGE_TO_DATE
,      YEAR_AVERAGE_TO_DATE
FROM APPS.GLBV_GL_AVERAGE_BALANCES;

Dependencies

[top of page]

APPS.GLBV_GL_AVERAGE_BALANCES references the following:

SchemaAPPS
SynonymFND_CURRENCIES
SynonymGL_CODE_COMBINATIONS
SynonymGL_DAILY_BALANCES
SynonymGL_DATE_PERIOD_MAP
SynonymGL_LEDGERS
ViewGL_LOOKUPS

APPS.GLBV_GL_AVERAGE_BALANCES is not referenced by any database object