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_ENCUMB_JOURNAL_ENTRIES

Object Details

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

View Type

A Business Intelligence System view

Encumb 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_NAME	VARCHAR2	(100)	Yes	Journal entry header name
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
LEDGER_NAME	VARCHAR2	(30)	Yes
JOURNAL_CATEGORY	VARCHAR2	(25)	Yes
JOURNAL_SOURCE	VARCHAR2	(25)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes
EFFECTIVE_DATE	DATE		Yes
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
ENCUMBRANCE_TYPE	VARCHAR2	(30)	Yes
JOURNAL_BATCH_ID	NUMBER	(15)
JOURNAL_BATCH_NAME	VARCHAR2	(100)	Yes
REVERSAL_DATE	DATE
REVERSAL_PERIOD	VARCHAR2	(15)
_LA:REVERSE_STATUS_FLAG	CHAR	(64)
_LA:REVERSAL_METHOD	CHAR	(102)
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)
PRIMARY_JOURNAL_ENTRY_NAME	VARCHAR2	(100)
REVERSED_JOURNAL_ENTRY_ID	NUMBER	(15)
REVERSED_JOURNAL_ENTRY_NAME	VARCHAR2	(100)
DOCUMENT_NUMBER	NUMBER
REFERENCE_DATE	DATE
POSTING_ACCT_SEQ_VALUE	NUMBER
CLOSE_ACCT_SEQ_VALUE	NUMBER
_DF	CHAR	(27)

Query Text

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


SELECT JOURNAL_ENTRY_ID
,      JOURNAL_ENTRY_NAME
,      LEDGER_ID
,      LEDGER_NAME
,      JOURNAL_CATEGORY
,      JOURNAL_SOURCE
,      PERIOD_NAME
,      EFFECTIVE_DATE
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_TYPE
,      JOURNAL_BATCH_ID
,      JOURNAL_BATCH_NAME
,      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
,      PRIMARY_JOURNAL_ENTRY_NAME
,      REVERSED_JOURNAL_ENTRY_ID
,      REVERSED_JOURNAL_ENTRY_NAME
,      DOCUMENT_NUMBER
,      REFERENCE_DATE
,      POSTING_ACCT_SEQ_VALUE
,      CLOSE_ACCT_SEQ_VALUE
,      _DF
FROM APPS.GLFV_ENCUMB_JOURNAL_ENTRIES;

Dependencies

[top of page]

APPS.GLFV_ENCUMB_JOURNAL_ENTRIES references the following:

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

APPS.GLFV_ENCUMB_JOURNAL_ENTRIES is not referenced by any database object