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

VIEW: FA.FA_TRX_REFERENCES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRX_REFERENCE_ID NUMBER (15) Yes
TRANSACTION_TYPE VARCHAR2 (30)
SRC_TRANSACTION_SUBTYPE VARCHAR2 (30)
DEST_TRANSACTION_SUBTYPE VARCHAR2 (30)
BOOK_TYPE_CODE VARCHAR2 (15) Yes
SRC_ASSET_ID NUMBER (15) Yes
SRC_TRANSACTION_HEADER_ID NUMBER (15) Yes
DEST_ASSET_ID NUMBER (15) Yes
DEST_TRANSACTION_HEADER_ID NUMBER (15) Yes
MEMBER_ASSET_ID NUMBER (15)
MEMBER_TRANSACTION_HEADER_ID NUMBER (15)
SRC_AMORTIZATION_START_DATE DATE

DEST_AMORTIZATION_START_DATE DATE

RESERVE_TRANSFER_AMOUNT NUMBER

SRC_EXPENSE_AMOUNT NUMBER

DEST_EXPENSE_AMOUNT NUMBER

SRC_EOFY_RESERVE NUMBER

DEST_EOFY_RESERVE NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
EVENT_ID NUMBER (15)
INVOICE_TRANSACTION_ID NUMBER (15)
Query Text

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


SELECT TRX_REFERENCE_ID
,      TRANSACTION_TYPE
,      SRC_TRANSACTION_SUBTYPE
,      DEST_TRANSACTION_SUBTYPE
,      BOOK_TYPE_CODE
,      SRC_ASSET_ID
,      SRC_TRANSACTION_HEADER_ID
,      DEST_ASSET_ID
,      DEST_TRANSACTION_HEADER_ID
,      MEMBER_ASSET_ID
,      MEMBER_TRANSACTION_HEADER_ID
,      SRC_AMORTIZATION_START_DATE
,      DEST_AMORTIZATION_START_DATE
,      RESERVE_TRANSFER_AMOUNT
,      SRC_EXPENSE_AMOUNT
,      DEST_EXPENSE_AMOUNT
,      SRC_EOFY_RESERVE
,      DEST_EOFY_RESERVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EVENT_ID
,      INVOICE_TRANSACTION_ID
FROM FA.FA_TRX_REFERENCES#;

Dependencies

[top of page]

FA.FA_TRX_REFERENCES# references the following:

SchemaFA
TableFA_TRX_REFERENCES
FA.FA_TRX_REFERENCES# is referenced by following:

SchemaAPPS
SynonymFA_TRX_REFERENCES