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_JOURNAL_BATCHES

Object Details

Object Name:	GLBV_JOURNAL_BATCHES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GLBV_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
JOURNAL_BATCH_ID	NUMBER	(15)	Yes
JOURNAL_BATCH_NAME	VARCHAR2	(100)	Yes
LEDGER_ID	NUMBER
_LA:BATCH_STATUS	CHAR	(60)
_LA:BALANCE_TYPE	CHAR	(63)
PERIOD_NAME	VARCHAR2	(15)
DATE_POSTED	DATE
DATE_CREATED	DATE
DESCRIPTION	VARCHAR2	(240)
_LA:AVERAGE_JOURNAL_FLAG	CHAR	(73)
_LA:FUNDS_CHECK_STATUS	CHAR	(80)
_LA:APPROVAL_STATUS	CHAR	(82)
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
APPROVER_EMPLOYEE_ID	NUMBER	(15)
APPROVER	VARCHAR2	(240)
POSTED_BY_ID	NUMBER	(15)
POSTED_BY	VARCHAR2	(100)

Query Text

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


SELECT JOURNAL_BATCH_ID
,      JOURNAL_BATCH_NAME
,      LEDGER_ID
,      _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
,      APPROVER_EMPLOYEE_ID
,      APPROVER
,      POSTED_BY_ID
,      POSTED_BY
FROM APPS.GLBV_JOURNAL_BATCHES;

Dependencies

[top of page]

APPS.GLBV_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.GLBV_JOURNAL_BATCHES is not referenced by any database object