eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

FA_TRX_REFERENCES stores information about inter-asset transactions where two or more dependent transactions are performed at one time Oracle Assets inserts rows in this table and in FA_TRANSACTION_HEADERS each time you perform such a transaction.

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

Name	Datatype	Length	Mandatory	Comments
TRX_REFERENCE_ID	NUMBER	(15)	Yes	Unique transaction reference identification number
TRANSACTION_TYPE	VARCHAR2	(30)		Indicates type of transaction
SRC_TRANSACTION_SUBTYPE	VARCHAR2	(30)		Further detail of the transaction type for source asset
DEST_TRANSACTION_SUBTYPE	VARCHAR2	(30)		Further detail of the transaction type for destination asset
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the book in which the transactions occurred
SRC_ASSET_ID	NUMBER	(15)	Yes	Source asset on which the transaction occurred
SRC_TRANSACTION_HEADER_ID	NUMBER	(15)	Yes	Identifies the source transaction
DEST_ASSET_ID	NUMBER	(15)	Yes	Destination asset on which the transaction occurred
DEST_TRANSACTION_HEADER_ID	NUMBER	(15)	Yes	Identifies the destination transaction
MEMBER_ASSET_ID	NUMBER	(15)		Group member asset on which the transaction occurred
MEMBER_TRANSACTION_HEADER_ID	NUMBER	(15)		Identifies the group member transaction
SRC_AMORTIZATION_START_DATE	DATE			Amortization start date for the source asset transaction
DEST_AMORTIZATION_START_DATE	DATE			Amortization start date for the destination asset transaction
RESERVE_TRANSFER_AMOUNT	NUMBER			Reserve amount transferred between assets
SRC_EXPENSE_AMOUNT	NUMBER			Amount entered for catchup depreciation expense on the source asset transaction
DEST_EXPENSE_AMOUNT	NUMBER			Amount entered for catchup depreciation expense on the destination asset transaction
SRC_EOFY_RESERVE	NUMBER			Amount entered for the prior fiscal year's reserve for the source asset
DEST_EOFY_RESERVE	NUMBER			Amount entered for the prior fiscal year's reserve for the destination asset
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
EVENT_ID	NUMBER	(15)		Invoice transaction internal identifier
INVOICE_TRANSACTION_ID	NUMBER	(15)		Invoice transaction internal identifier

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:

FA: FA_TRX_REFERENCES#