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_BATCHES

Object Details

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

View Type

A Business Intelligence System view

General Ledger journal batches are groups of related journal entries which share the same General Ledger period.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
JOURNAL_BATCH_ID	NUMBER	(15)	Yes	Journal entry batch defining column
JOURNAL_BATCH_NAME	VARCHAR2	(100)	Yes	Name of journal entry batch
LEDGER_ID	NUMBER			Added for backward compatibility
LEDGER_NAME	CHAR	(8)		Added for backward compatibility
_LA:BATCH_STATUS	CHAR	(61)
_LA:BALANCE_TYPE	CHAR	(64)
PERIOD_NAME	VARCHAR2	(15)
DATE_POSTED	DATE
DATE_CREATED	DATE
DESCRIPTION	VARCHAR2	(240)
_LA:AVERAGE_JOURNAL_FLAG	CHAR	(74)
_LA:FUNDS_CHECK_STATUS	CHAR	(81)
_LA:APPROVAL_STATUS	CHAR	(83)
CONTROL_TOTAL	NUMBER
ENTERED_BATCH_TOTAL_DR	NUMBER
ENTERED_BATCH_TOTAL_CR	NUMBER
CONVERTED_BATCH_TOTAL_DR	NUMBER
CONVERTED_BATCH_TOTAL_CR	NUMBER
PRIMARY_JOURNAL_BATCH_ID	NUMBER
PRIMARY_JOURNAL_BATCH_NAME	CHAR	(8)
APPROVER_EMPLOYEE_ID	NUMBER	(15)		User who approved the journal batch
APPROVER	VARCHAR2	(240)		Name of the user who approved the journal batch
POSTED_BY_ID	NUMBER	(15)		User who posted the journal batch
POSTED_BY	VARCHAR2	(100)		Name of the user who posted the journal batch
_DF	CHAR	(38)

Query Text

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


SELECT JOURNAL_BATCH_ID
,      JOURNAL_BATCH_NAME
,      LEDGER_ID
,      LEDGER_NAME
,      _LA:BATCH_STATUS
,      _LA:BALANCE_TYPE
,      PERIOD_NAME
,      DATE_POSTED
,      DATE_CREATED
,      DESCRIPTION
,      _LA:AVERAGE_JOURNAL_FLAG
,      _LA:FUNDS_CHECK_STATUS
,      _LA:APPROVAL_STATUS
,      CONTROL_TOTAL
,      ENTERED_BATCH_TOTAL_DR
,      ENTERED_BATCH_TOTAL_CR
,      CONVERTED_BATCH_TOTAL_DR
,      CONVERTED_BATCH_TOTAL_CR
,      PRIMARY_JOURNAL_BATCH_ID
,      PRIMARY_JOURNAL_BATCH_NAME
,      APPROVER_EMPLOYEE_ID
,      APPROVER
,      POSTED_BY_ID
,      POSTED_BY
,      _DF
FROM APPS.GLFV_JOURNAL_BATCHES;

Dependencies

[top of page]

APPS.GLFV_JOURNAL_BATCHES references the following:

APPS: FND_USER; GL_ACCESS_SETS; GL_ACCESS_SET_ASSIGNMENTS; GL_ACCESS_SET_LEDGERS; GL_HR_EMPLOYEES_CURRENT_V; GL_JE_BATCHES; GL_JE_HEADERS; GL_JE_SEGMENT_VALUES; GL_SECURITY_PKG - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code

APPS.GLFV_JOURNAL_BATCHES is not referenced by any database object