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_SETS_OF_BOOKS

Object Details

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

View Type

A Business Intelligence System view

General Ledger sets of books are accounting organizations. Each set of books is defined by a particular functional currency, charts of accounts, and accounting calendar.

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEDGER_ID	NUMBER	(15)	Yes
LEDGER_NAME	VARCHAR2	(30)	Yes
LEDGER_SHORT_NAME	VARCHAR2	(20)	Yes
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
CHART_OF_ACCOUNTS_NAME	VARCHAR2	(30)	Yes
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Yes
ACCOUNTING_CALENDAR	VARCHAR2	(15)	Yes
FUTURE_PERIODS	NUMBER	(15)	Yes
LATEST_OPENED_PERIOD	VARCHAR2	(15)
LATEST_OPENED_ENCUMBRANCE_YEAR	NUMBER	(15)
DESCRIPTION	VARCHAR2	(240)
_LA:REPORTING_BOOKS_TYPE	CHAR	(59)
_LA:ALLOW_SUSPENSE_FLAG	CHAR	(54)
_LA:BALANCE_INTERCO_JE_FLAG	CHAR	(61)
_LA:ENABLE_AVERAGE_BAL_FLAG	CHAR	(61)
_LA:ENABLE_BUDGET_CTRL_FLAG	CHAR	(62)
_LA:REQUIRE_BUDGET_JE_FLAG	CHAR	(61)
_LA:ENABLE_JE_APPROVAL_FLAG	CHAR	(56)
_LA:ENABLE_JE_TAX_FLAG	CHAR	(58)
_LA:CONSOLIDATION_BOOK_FLAG	CHAR	(58)
_LA:TRANSLATE_EOD_FLAG	CHAR	(51)
_LA:TRANSLATE_QATD_FLAG	CHAR	(52)
_LA:TRANSLATE_YATD_FLAG	CHAR	(52)
_LA:ROUNDING_IMBALANCE_FLAG	CHAR	(62)
_DF	CHAR	(29)

Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      LEDGER_SHORT_NAME
,      CHART_OF_ACCOUNTS_ID
,      CHART_OF_ACCOUNTS_NAME
,      FUNCTIONAL_CURRENCY
,      ACCOUNTING_CALENDAR
,      FUTURE_PERIODS
,      LATEST_OPENED_PERIOD
,      LATEST_OPENED_ENCUMBRANCE_YEAR
,      DESCRIPTION
,      _LA:REPORTING_BOOKS_TYPE
,      _LA:ALLOW_SUSPENSE_FLAG
,      _LA:BALANCE_INTERCO_JE_FLAG
,      _LA:ENABLE_AVERAGE_BAL_FLAG
,      _LA:ENABLE_BUDGET_CTRL_FLAG
,      _LA:REQUIRE_BUDGET_JE_FLAG
,      _LA:ENABLE_JE_APPROVAL_FLAG
,      _LA:ENABLE_JE_TAX_FLAG
,      _LA:CONSOLIDATION_BOOK_FLAG
,      _LA:TRANSLATE_EOD_FLAG
,      _LA:TRANSLATE_QATD_FLAG
,      _LA:TRANSLATE_YATD_FLAG
,      _LA:ROUNDING_IMBALANCE_FLAG
,      _DF
FROM APPS.GLFV_GL_SETS_OF_BOOKS;

Dependencies

[top of page]

APPS.GLFV_GL_SETS_OF_BOOKS references the following:

APPS: FND_ID_FLEX_STRUCTURES_TL; GL_LEDGERS

APPS.GLFV_GL_SETS_OF_BOOKS is not referenced by any database object