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_BUDGET_JOURNAL_BATCHES

Object Details

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

View Type

A Business Intelligence System view

Budget journal batches are groups of journal entries that represent the estimated results of future financial operations.

[View Source]

Columns

Name	Datatype	Length	Mandatory
JOURNAL_BATCH_ID	NUMBER	(15)	Yes
JOURNAL_BATCH_NAME	VARCHAR2	(100)	Yes
LEDGER_ID	NUMBER
LEDGER_NAME	CHAR	(8)
_LA:BATCH_STATUS	CHAR	(67)
PERIOD_NAME	VARCHAR2	(15)
DATE_POSTED	DATE
DATE_CREATED	DATE
DESCRIPTION	VARCHAR2	(240)
_LA:FUNDS_CHECK_STATUS	CHAR	(87)
_LA:APPROVAL_STATUS	CHAR	(89)
CONTROL_TOTAL	NUMBER
ENTERED_BATCH_TOTAL_DR	NUMBER
ENTERED_BATCH_TOTAL_CR	NUMBER
APPROVER_EMPLOYEE_ID	NUMBER	(15)
APPROVER	VARCHAR2	(240)
POSTED_BY_ID	NUMBER	(15)
POSTED_BY	VARCHAR2	(100)
_DF	CHAR	(44)

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
,      PERIOD_NAME
,      DATE_POSTED
,      DATE_CREATED
,      DESCRIPTION
,      _LA:FUNDS_CHECK_STATUS
,      _LA:APPROVAL_STATUS
,      CONTROL_TOTAL
,      ENTERED_BATCH_TOTAL_DR
,      ENTERED_BATCH_TOTAL_CR
,      APPROVER_EMPLOYEE_ID
,      APPROVER
,      POSTED_BY_ID
,      POSTED_BY
,      _DF
FROM APPS.GLFV_BUDGET_JOURNAL_BATCHES;

Dependencies

[top of page]

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