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

VIEW: FA.FA_JOURNAL_ENTRIES#

Object Details
Object Name: FA_JOURNAL_ENTRIES#
Object Type: VIEW
Owner: FA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CJE_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
PERIOD_COUNTER NUMBER
Yes
ADDITION_BATCH_ID NUMBER (15)
ADJUSTMENT_BATCH_ID NUMBER (15)
DEPRECIATION_BATCH_ID NUMBER (15)
RECLASS_BATCH_ID NUMBER (15)
RETIREMENT_BATCH_ID NUMBER (15)
REVAL_BATCH_ID NUMBER (15)
TRANSFER_BATCH_ID NUMBER (15)
CIP_ADDITION_BATCH_ID NUMBER (15)
CIP_ADJUSTMENT_BATCH_ID NUMBER (15)
CIP_RECLASS_BATCH_ID NUMBER (15)
CIP_RETIREMENT_BATCH_ID NUMBER (15)
CIP_REVAL_BATCH_ID NUMBER (15)
CIP_TRANSFER_BATCH_ID NUMBER (15)
DEPRN_ADJUSTMENT_BATCH_ID NUMBER (15)
JE_STATUS VARCHAR2 (1) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
ADDITION_GROUP_ID NUMBER (15)
ADJUSTMENT_GROUP_ID NUMBER (15)
DEPRECIATION_GROUP_ID NUMBER (15)
RECLASS_GROUP_ID NUMBER (15)
RETIREMENT_GROUP_ID NUMBER (15)
REVAL_GROUP_ID NUMBER (15)
TRANSFER_GROUP_ID NUMBER (15)
CIP_ADDITION_GROUP_ID NUMBER (15)
CIP_ADJUSTMENT_GROUP_ID NUMBER (15)
CIP_DEPRECIATION_GROUP_ID NUMBER (15)
CIP_RECLASS_GROUP_ID NUMBER (15)
CIP_RETIREMENT_GROUP_ID NUMBER (15)
CIP_REVAL_GROUP_ID NUMBER (15)
CIP_TRANSFER_GROUP_ID NUMBER (15)
DEPRN_ADJUSTMENT_GROUP_ID NUMBER (15)
DEFERRED_DEPRN_GROUP_ID NUMBER (15)
DEFERRED_DEPRN_BATCH_ID NUMBER (15)
Query Text

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


SELECT CJE_ID
,      SET_OF_BOOKS_ID
,      BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      ADDITION_BATCH_ID
,      ADJUSTMENT_BATCH_ID
,      DEPRECIATION_BATCH_ID
,      RECLASS_BATCH_ID
,      RETIREMENT_BATCH_ID
,      REVAL_BATCH_ID
,      TRANSFER_BATCH_ID
,      CIP_ADDITION_BATCH_ID
,      CIP_ADJUSTMENT_BATCH_ID
,      CIP_RECLASS_BATCH_ID
,      CIP_RETIREMENT_BATCH_ID
,      CIP_REVAL_BATCH_ID
,      CIP_TRANSFER_BATCH_ID
,      DEPRN_ADJUSTMENT_BATCH_ID
,      JE_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ADDITION_GROUP_ID
,      ADJUSTMENT_GROUP_ID
,      DEPRECIATION_GROUP_ID
,      RECLASS_GROUP_ID
,      RETIREMENT_GROUP_ID
,      REVAL_GROUP_ID
,      TRANSFER_GROUP_ID
,      CIP_ADDITION_GROUP_ID
,      CIP_ADJUSTMENT_GROUP_ID
,      CIP_DEPRECIATION_GROUP_ID
,      CIP_RECLASS_GROUP_ID
,      CIP_RETIREMENT_GROUP_ID
,      CIP_REVAL_GROUP_ID
,      CIP_TRANSFER_GROUP_ID
,      DEPRN_ADJUSTMENT_GROUP_ID
,      DEFERRED_DEPRN_GROUP_ID
,      DEFERRED_DEPRN_BATCH_ID
FROM FA.FA_JOURNAL_ENTRIES#;

Dependencies

[top of page]

FA.FA_JOURNAL_ENTRIES# references the following:

SchemaFA
TableFA_JOURNAL_ENTRIES
FA.FA_JOURNAL_ENTRIES# is referenced by following:

SchemaAPPS
SynonymFA_JOURNAL_ENTRIES