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

VIEW: JL.JL_BR_JOURNALS_ALL#

Object Details
Object Name: JL_BR_JOURNALS_ALL#
Object Type: VIEW
Owner: JL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANS_ID NUMBER (15) Yes
BATCH_ID NUMBER (15)
PERIOD_SET_NAME VARCHAR2 (15) Yes
INSTALLMENT NUMBER (15) Yes
APPLICATION_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
ORG_ID NUMBER (15)
PERIOD_NAME VARCHAR2 (15) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
PERSONNEL_ID NUMBER (15) Yes
TRANS_CURRENCY_CODE VARCHAR2 (15) Yes
BATCH_NAME VARCHAR2 (50)
ACCOUNTING_DATE DATE
Yes
TRANS_NUM VARCHAR2 (50) Yes
TRANS_DATE DATE
Yes
TRANS_DESCRIPTION VARCHAR2 (80) Yes
TRANS_VALUE_SIGN VARCHAR2 (1)
TRANS_VALUE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
JOURNAL_BALANCE_FLAG VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT TRANS_ID
,      BATCH_ID
,      PERIOD_SET_NAME
,      INSTALLMENT
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      PERIOD_NAME
,      CODE_COMBINATION_ID
,      PERSONNEL_ID
,      TRANS_CURRENCY_CODE
,      BATCH_NAME
,      ACCOUNTING_DATE
,      TRANS_NUM
,      TRANS_DATE
,      TRANS_DESCRIPTION
,      TRANS_VALUE_SIGN
,      TRANS_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      JOURNAL_BALANCE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM JL.JL_BR_JOURNALS_ALL#;

Dependencies

[top of page]

JL.JL_BR_JOURNALS_ALL# references the following:

SchemaJL
TableJL_BR_JOURNALS_ALL
JL.JL_BR_JOURNALS_ALL# is referenced by following:

SchemaAPPS
SynonymJL_BR_JOURNALS
SynonymJL_BR_JOURNALS_ALL