DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GLBV_JOURNAL_LINES

Object Details
Object Name: GLBV_JOURNAL_LINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GLBV_JOURNAL_LINES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


General Ledger journal lines record debit or credit amounts to General Ledger accounts, or use formulas for 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
JOURNAL_LINE_NUMBER NUMBER (15) Yes Journal entry line number
LEDGER_ID NUMBER (15) Yes
ACCOUNT_ID NUMBER (15) Yes
PERIOD_NAME VARCHAR2 (15) Yes
EFFECTIVE_DATE DATE
Yes
ENTERED_DR NUMBER

ENTERED_CR NUMBER

CONVERTED_DR NUMBER

CONVERTED_CR NUMBER

DESCRIPTION VARCHAR2 (240)
STAT_AMOUNT NUMBER

SUBLEDGER_DOCUMENT_NUMBER NUMBER

REFERENCE_1 VARCHAR2 (240)
REFERENCE_2 VARCHAR2 (240)
REFERENCE_3 VARCHAR2 (240)
REFERENCE_4 VARCHAR2 (240)
REFERENCE_5 VARCHAR2 (240)
REFERENCE_6 VARCHAR2 (240)
REFERENCE_7 VARCHAR2 (240)
REFERENCE_8 VARCHAR2 (240)
REFERENCE_9 VARCHAR2 (240)
REFERENCE_10 VARCHAR2 (240)
Query Text

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


SELECT JOURNAL_ENTRY_ID
,      JOURNAL_ENTRY_NAME
,      JOURNAL_LINE_NUMBER
,      LEDGER_ID
,      ACCOUNT_ID
,      PERIOD_NAME
,      EFFECTIVE_DATE
,      ENTERED_DR
,      ENTERED_CR
,      CONVERTED_DR
,      CONVERTED_CR
,      DESCRIPTION
,      STAT_AMOUNT
,      SUBLEDGER_DOCUMENT_NUMBER
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      REFERENCE_6
,      REFERENCE_7
,      REFERENCE_8
,      REFERENCE_9
,      REFERENCE_10
FROM APPS.GLBV_JOURNAL_LINES;

Dependencies

[top of page]

APPS.GLBV_JOURNAL_LINES references the following:

SchemaAPPS
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES

APPS.GLBV_JOURNAL_LINES is not referenced by any database object