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_JOURNAL_ENTRIES

Object Details

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

View Type

A Business Intelligence System view

General Ledger journal entries are groups of related journal lines that record debit and credit amounts to General Ledger accounts.

[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
LEDGER_NAME	VARCHAR2	(30)	Yes
JOURNAL_CATEGORY	VARCHAR2	(25)	Yes
JOURNAL_SOURCE	VARCHAR2	(25)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes
CURRENCY	VARCHAR2	(15)	Yes
_LA:BALANCE_TYPE	CHAR	(53)
EFFECTIVE_DATE	DATE		Yes
_LA:TAX_STATUS	CHAR	(53)
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
ENCUMBRANCE_TYPE	VARCHAR2	(30)
BUDGET_VERSION_ID	NUMBER	(15)
BUDGET_NAME	VARCHAR2	(15)
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
CONVERTED_JOURNAL_TOTAL_DR	NUMBER
CONVERTED_JOURNAL_TOTAL_CR	NUMBER
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE_CODE	VARCHAR2	(30)
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)	Yes
CURRENCY_CONVERSION_DATE	DATE
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
ORIGINATING_BAL_SEG_VALUE	VARCHAR2	(25)
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
,      CURRENCY
,      _LA:BALANCE_TYPE
,      EFFECTIVE_DATE
,      _LA:TAX_STATUS
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_TYPE
,      BUDGET_VERSION_ID
,      BUDGET_NAME
,      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
,      CONVERTED_JOURNAL_TOTAL_DR
,      CONVERTED_JOURNAL_TOTAL_CR
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      EXTERNAL_REFERENCE
,      PRIMARY_JOURNAL_ENTRY_ID
,      PRIMARY_JOURNAL_ENTRY_NAME
,      REVERSED_JOURNAL_ENTRY_ID
,      REVERSED_JOURNAL_ENTRY_NAME
,      DOCUMENT_NUMBER
,      ORIGINATING_BAL_SEG_VALUE
,      REFERENCE_DATE
,      POSTING_ACCT_SEQ_VALUE
,      CLOSE_ACCT_SEQ_VALUE
,      _DF
FROM APPS.GLFV_JOURNAL_ENTRIES;

Dependencies

[top of page]

APPS.GLFV_JOURNAL_ENTRIES references the following:

APPS: GL_ACCESS_SETS; GL_ACCESS_SET_ASSIGNMENTS; GL_ACCESS_SET_LEDGERS; GL_BUDGET_VERSIONS; GL_DAILY_CONVERSION_TYPES; 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_JOURNAL_ENTRIES is not referenced by any database object