[Home] [Help] [Dependency Information]

TABLE: FA.FA_TRX_REFERENCES

Object Details

Object Name:	FA_TRX_REFERENCES
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_TRX_REFERENCES
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_TRX_REFERENCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRX_REFERENCE_ID
FA_TRX_REFERENCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE MEMBER_ASSET_ID
FA_TRX_REFERENCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEMBER_TRANSACTION_HEADER_ID
FA_TRX_REFERENCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SRC_TRANSACTION_HEADER_ID
FA_TRX_REFERENCES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEST_TRANSACTION_HEADER_ID

Columns

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 does not reference any database object

FA.FA_TRX_REFERENCES is referenced by following:

APPS

FA_TRX_REFERENCES