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: ViewSQLGL.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 Comments
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:

SchemaAPPS
SynonymFND_USER
SynonymGL_ACCESS_SETS
SynonymGL_ACCESS_SET_ASSIGNMENTS
TableGL_ACCESS_SET_LEDGERS
ViewGL_HR_EMPLOYEES_CURRENT_V
SynonymGL_JE_BATCHES
SynonymGL_JE_HEADERS
SynonymGL_JE_SEGMENT_VALUES
PL/SQL PackageGL_SECURITY_PKG - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code

APPS.GLBV_JOURNAL_BATCHES is not referenced by any database object