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_ENCUMB_JOURNAL_ENTRIES

Object Details

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

View Type

A Business Intelligence System view

Encumbrance journal entries are groups of journal lines that represent commitments, obligations, and other planned expenditures.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
JOURNAL_ENTRY_ID	NUMBER	(15)	Yes	Journal entry header defining column
JOURNAL_ENTRY_NAME	VARCHAR2	(100)	Yes	Journal entry header name
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
JOURNAL_CATEGORY	VARCHAR2	(25)	Yes
JOURNAL_SOURCE	VARCHAR2	(25)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes
EFFECTIVE_DATE	DATE		Yes
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
JOURNAL_BATCH_ID	NUMBER	(15)
REVERSAL_DATE	DATE
REVERSAL_PERIOD	VARCHAR2	(15)
_LA:REVERSE_STATUS_FLAG	CHAR	(74)
_LA:REVERSAL_METHOD	CHAR	(112)
DESCRIPTION	VARCHAR2	(240)
CONTROL_TOTAL	NUMBER
ENTERED_JOURNAL_TOTAL_DR	NUMBER
ENTERED_JOURNAL_TOTAL_CR	NUMBER
EXTERNAL_REFERENCE	VARCHAR2	(80)
PRIMARY_JOURNAL_ENTRY_ID	NUMBER	(15)
REVERSED_JOURNAL_ENTRY_ID	NUMBER	(15)
DOCUMENT_NUMBER	NUMBER
REFERENCE_DATE	DATE
POSTING_ACCT_SEQ_VALUE	NUMBER
CLOSE_ACCT_SEQ_VALUE	NUMBER

Query Text

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


SELECT JOURNAL_ENTRY_ID
,      JOURNAL_ENTRY_NAME
,      LEDGER_ID
,      JOURNAL_CATEGORY
,      JOURNAL_SOURCE
,      PERIOD_NAME
,      EFFECTIVE_DATE
,      ENCUMBRANCE_TYPE_ID
,      JOURNAL_BATCH_ID
,      REVERSAL_DATE
,      REVERSAL_PERIOD
,      _LA:REVERSE_STATUS_FLAG
,      _LA:REVERSAL_METHOD
,      DESCRIPTION
,      CONTROL_TOTAL
,      ENTERED_JOURNAL_TOTAL_DR
,      ENTERED_JOURNAL_TOTAL_CR
,      EXTERNAL_REFERENCE
,      PRIMARY_JOURNAL_ENTRY_ID
,      REVERSED_JOURNAL_ENTRY_ID
,      DOCUMENT_NUMBER
,      REFERENCE_DATE
,      POSTING_ACCT_SEQ_VALUE
,      CLOSE_ACCT_SEQ_VALUE
FROM APPS.GLBV_ENCUMB_JOURNAL_ENTRIES;

Dependencies

[top of page]

APPS.GLBV_ENCUMB_JOURNAL_ENTRIES references the following:

APPS: GL_ACCESS_SETS; GL_ACCESS_SET_ASSIGNMENTS; GL_ACCESS_SET_LEDGERS; GL_JE_CATEGORIES; GL_JE_HEADERS; GL_JE_SEGMENT_VALUES; GL_JE_SOURCES; GL_SECURITY_PKG - show dependent code

APPS.GLBV_ENCUMB_JOURNAL_ENTRIES is not referenced by any database object